In this page we have given CBSE Board Class 12 Computer Science with Python Book Chapter Databases Concepts and SQL MCQ Question and Answer. All the questions below are important for our CBSE Champs.
- Board – CBSE.
- Class – 12
- Subject- Computer Science with Python.
- Topic- MCQ.
- Number of MCQ- 54.
1.) It is a collection of related information that is organised in such a way that supports for easy access.
a.) Database
b.) Directory
c.) Dictionary
d.) All of these
Ans – a.) Database
2.) DBMS stands for
a.) Data Managing System
b.) Database Multiplier System
c.) Database Management System
d.) Data Mining System
Ans – c.) Database Management System
3.) The program specially designed for creating connections between the user and program, and to store the data in an organized manner.
a.) MS Excel
b.) Python
c.) DBMS
d.) MS Outlook
Ans – c.) DBMS
4.) The data model which was based on first order predicate logic.
a.) Logical
b.) Inter relational
c.) Relational
d.) Structural
Ans – c.) Relational
5.) The First Order Predicate Logic was formulated and proposed by Codd in
a.) 1947
b.) 1992
c.) 1969
d.) 2006
Ans – c.) 1969
6.) In …………………… model, database is represented as collection of related tables.
a.) Logical
b.) Tabular
c.) Relational
d.) Structural
Ans – c.) Relational
7.) These are formed by using rows and columns
a) Boxes
b) Tables
c) Squares
d) None of these
8.) A ……………………. (horizontal subset) of a table represents a tuple or record, while ……………… (vertical subset) of a table represents an attribute.
a.) row, column
b.) top, bottom
c.) left, right
d.) None of these
Ans – a.) row, column
9.) In database, it means a table in which data are organized in the form of rows and columns.
a.) relation
b.) structural
c.) tabular
d.) logical
Ans – a.) relation
10.) The original set of atomic values used to model data.
a.) Domain
b.) Numeric
c.) String
d.) Variable
Ans – a.) Domain
11.) It is the horizontal subset/information in a table.
a.) Tuple
b.) Row
c.) Column
d.) None of these
Ans – a.) Tuple
12.) Tuple is also known as ……………….. which gives particular information of the relation (table).
a.) Field
b.) Record
c.) Directory
d.) Dictionary
Ans – b.) Record
13.) These are the important part of a relational database and a vital part of the structure of a table.
a.) Key
b.) Lock
c.) Tuple
d.) Domain
Ans – a.) Key
14.) It is the column or set of columns that uniquely identifies a row within a table
a.) Candidate Key
b.) Primary Key
c.) Alternate Key
d.) Master Key
Ans – b.) Primary Key
15.) These are the set of fields (columns with unique values) in the relation that are eligible to act as a primary key
a.) Candidate Key
b.) Primary Key
c.) Alternate Key
d.) Master Key
Ans – a.) Candidate Key
16.) Out of the candidate keys, after selecting a key as primary key, the remaining keys are to be termed as …………………
a.) Candidate Key
b.) Primary Key
c.) Alternate Key
d.) Foreign key
Ans – c.) Alternate Key
17.) It is a field (or a collection of fields) in one table that uniquely identifies a row of another table.
a.) Candidate Key
b.) Primary Key
c.) Alternate Key
d.) Foreign Key
Ans – d) Foreign Key
18.) It is the number of attributes (columns) in a table.
a.) Degree
b.) Cardinality
c.) Roman
d.) All of these
Ans – a.) Degree
19.) It is the number of rows (tuples) in a table.
a.) Degree
b.) Cardinality
c.) Roman
d.) All of these
Ans- b.) Cardinality
20.) This is the standard language which is used for accessing databases.
a.) MS Excel
b.) Python
c.) Structured Query Language (SQL)
d.) MS Outlook
Ans – c.) Structured Query Language (SQL)
21.) The language whose purpose is sued to create table, manage data and manipulation.
a.) MS Excel
b.) Python
c.) Structured Query Language (SQL)
d.) MS Outlook
Ans – c.) Structured Query Language (SQL)
22.) The abbreviation of DDL is
a.) Data Defining Language b.) Data Declaring Language
c.) Data Defined Language
d.) Data Definition Language or Data Description Language
Ans – d.) Data Definition Language or Data Description Language
23.) CREATE, TABLE, ALTER, and DROP TABLE are some of the …………………. statements.
a.) DDL
b.) DML
c.) DEL
d.) DSL
Ans – a.) DDL
24.) It is the standard for commands which defines the different structure in a database.
a.) DSL
b.) DML
c.) DDL
d.) DBL
Ans – c.) DDL
25.) DML stands for
a.) Data and Multiplication Language
b.) Data Manipulation Language
c.) Data Maintaining Language d.) None of these
Ans- b.) Data Manipulation Language
26.) SELECT, UPDATE, DELETE, and INSERT are some ………………….. statements
a.) DSL
b.) DCL
c.) DML
d.) DEL
Ans – c.) DML
27.) The statements which are used for accessing and manipulating data in existing tables.
a.) DDL
b.) DML
c.) DEL
d.) DSL
Ans – b.) DML
28.) The ……………….. of a value associates a fixed set of properties with the value.
a.) Data types
b.) Integers
c.) Variables
d.) Strings
Ans – a.) Data types
29.) Each value that is manipulated by SQL database has
a.) Float
b.) String
c.) Data types
d.) All of these
Ans – c.) Data types
30.) The data types stores character (alphanumeric) data, which are words and free-form text.
a.) Character
b) Number
c) Symbol
d) None of these
Ans –
31.) CHAR, VARCHAR, VARCHAR2 are some examples of ………………………. data types.
a.) Character
b) Number
c) Symbol
d) None of these
Ans- a.) Character
32.) It is used for storing fix length character strings.
a.) CHAR
b.) VARCHAR
c.) VARCHAR2
d.) CHARAC
Ans – a.) CHAR
33.) If we declare data type as …………………, then it will occupy space for NULL values.
a.) CHAR
b.) VARCHAR
c.) VARCHAR2
d.) CHARAC
Ans – a.) CHAR
34.) It is a variable character string and can have maximum 200 characters.
a.) VARCHAR2
b.) CHAR
c.) VARCHAR1
d.) VARCHAR
Ans – d.) VARCHAR
35.) It is used to store variable length character strings.
a.) VARCHAR2
b.) CHAR
c.) VARCHAR1
d.) VARCHAR
Ans – a.) VARCHAR2
36.) It can store upto 4000 bytes of characters.
a.) VARCHAR2
b.) CHAR
c.) VARCHAR1
d.) VARCHAR
Ans – a.) VARCHAR2
37.) The datatypes which are mainly used to store number with or without fraction part.
a.) alphanumeric
b.) alphabet
c.) numeric
d.) none of these
Ans – c.) numeric
38.) This data type is used for storing integers (negative, positive, floating) of upto 38 digits of precision.
a.) number
b.) alphabet
c.) character
d.) alphanumeric
Ans – a.) number
39.) The data types that have fixed precision and scale.
a.) number
b.) decimal and numeric
c.) int/integer
d.) float
Ans- b.) decimal and numeric
40.) It is the integer data type in SQL.
a.) number
b.) decimal and numeric
c.) int
d.) float
Ans – c.) int
41.) This data type is used to store number with fraction part (real numbers)
a.) int/integer
b.) float
c.) decimal and numeric
d.) number
Ans – b.) float
42.) It is used to store valid date values, which is ranging from January 1,4712 BC to December 31, 9999 AD.
a.) Date
b.) Year
c.) Time
d.) Month
Ans – a.) Date
43.) The date formats are
a.) YYYY-MM-DD
b.) DD/MON/YY
C.) DD-MON-YYYY
d.) All of these
Ans – d.) All of these
44.) It is a combination of set of operands and set of operators.
a.) Geogebra
b.) Algebra
c.) Geometry
d.) None of these
Ans – b.) Algebra
45.) We can form ……………………. expressions by applying operators to operands.
a.) algebraic
b.) facial
c.) geometric
d.) geogebraic
Ans – a.) algebraic
46.) It consists of a set of operations that takes one or two relations as input and produces new relation as output.
a.) Irrelational
b.) Conditional
c.) Relational
d.) None of these
Ans – c.) Relational
47.) Selection, Projection, Union, Cartesian Product are the …………………….. in relational algebra
a.) Operation
b.) functions
c.) features
d.) types
Ans – a.) Operation
48.) In relational algebra, this returns those tuples (records) in a relation that fulfil a condition
(Produce table containing subset of rows)
a.) Selection
b.) deletion
c.) rejection
d.) formation
Ans – a.) Selection
49.) In relational algebra, it returns those column un a relation that given in the attribute list
(Produce table containing subset of columns)
a.) Selection
b.) Cartesian
c.) Union
d.) Projection
Ans- d.) Projection
50.) This operator is used to combine two or more tables.
a.) Cartesian
b.) Projection
c.) Selection
d.) Union
Ans – d.) Union
51.) In the …………………… operation, duplicate records will be automatically removed from the resultant table.
a.) Projection
b.) Union
c.) Cartesian
d.) Selection
Ans – b.) Union
52.) SQL ……………….. are used to relate information in different tables.
a.) Joins
b.) copies
c.) deletes
d.) connects
Ans – a.) Joins
53.) Cartesian product is a binary operation and is denoted by
a.) ( c )
b.) ©
c.) (x)
d.) (cp)
Ans – c.) (x)
54.) The product that returns a number of rows equal to number of rows in the first table multiply by number of rows in the second table.
a.) Projection
b.) Selection
c.) Union
d.) Cartesian
Ans – d.) Cartesian