MCQ Question for Class 12 Computer Science Chapter 3 Database Concepts

Check the below NCERT MCQ Class 12 Computer Science Chapter 3 Database Concepts with Answers available with PDF free download. MCQ Questions for Class 12 Computer Science with Answers were prepared based on the latest syllabus and examination pattern issued by CBSE, NCERT and KVS. Our teachers have provided below Database Concepts Class 12 Computer Science MCQs Questions with answers which will help students to revise and get more marks in exams

Database Concepts Class 12 Computer Science MCQ Questions with Answers

Refer below for MCQ Class 12 Computer Science Chapter 3 Database Concepts with solutions. Solve questions and compare with the answers provided below

Question. In files, there is a key associated with each record which is used to differentiate among different records. For every file, there is atleast one set of keys that is unique. Such a key is called
(a) unique key
(b) prime attribute
(c) index key
(d) primary key

Question. Which of the following is not a DBMS?
(a) MS-Word
(b) MySQL
(c) Oracle
(d) Microsoft SQL Server

Question. The total number of rows in a table is called
(a) domain
(b) tuple
(c) field
(d) cardinality

Question. Which of the following is the drawback of DBMS?
(a) Improvement in data
(b) Backup and recovery
(c) Complexity
(d) Maintenance of data integrity

Question. DBMS stands for
(a) Database Microsoft System
(b) Database Migration System
(c) Database Management System
(d) None of the above

Question. If we delete an attribute of a table
(a) degree increases
(b) cardinality increases
(c) degree and cardinality increase
(d) degree decreases

Question. A table can have ………… primary key(s).
(a) 1
(b) 2
(c) 3
(d) multiple 

Question. Software that is used to create , manipulate , maintain a relational database management system is called 
(a) documentation software
(b) spreadsheet software
(c) RDBMS
(d) designing software

Question. Which of the following component of database system consists of various secondary storage devices on which data is stored?
(a) Hardware
(b) User
(c) Data
(d) Software 

Question. In a relational data model, a data structure that organises the information about a single topic into rows and columns is
(a) block
(b) record
(c) tuple
(d) table 

Question. Tables can be linked by
(a) primary key
(b) candidate key
(c) alternate key
(d) foreign key

Question. Raj wants to make EmpNo and PFNo columns of his table as the primary key. Is it possible?
(a) Yes
(b) No
(c) Yes , possible as a comination of columns
(d) None of the above

Question. The total number of columns in a table is called
(a) cardinality
(b) degree
(c) spreadsheet
(d) relation

Question. An attribute whose value is derived from the primary key of some other table.
(A) Primary key
(B) Foreign key
(C) Alternate key
(D) None of these

Question. Each table comprises of ______ and ________ .
(A) rows, columns
(B) data, information
(C) database, table
(D) None of these

Question. How many rules were laid down by E.F Codd?
(A) 10
(B) 11
(C) 12
(D) 13

Question. A field of a table is termed as __________.
(A) Row
(B) Attribute
(C) Key
(D) Tuple

Question. A RDBMS must comply with at least _______ rules.
(A) 4
(B) 5
(C) 6
(D) 7

Question. The attributes which have all the properties of primary key
(A) Foreign key
(B) Alternate key
(C) Candidate key
(D) Both (a) and (c)

Question. Which of the following was the first network database?
(A) SYSTEM 2000
(B) DBTG CODASYL
(C) SYSTEM CODASYL
(D) DBTG 2000

Question. Which of the following are used in data definition?
(a) DML
(b) DDL
(c) TCL
(d) None of these

Question. The design of the database is known as what?
(A) Attribute
(B) database schema
(C) obstruction
(D) database oriented

Question. A relational database is a collection of
(A) Attributes
(B) Tables
(C) Records
(D) Fields

Question. ____________ refers to the attribute that can uniquely identify tuples within the relation.
(A) Foreign key
(B) Consolidate key
(C) Alternate Key
(D) Primary key

Question. An Alternate key can be defined as
(A) An attribute which is a primary key
(B) An attribute which is not a primary key
(C) A candidate key
(D) None of these

Question. Consider a table with following structure: Employee(Emp_id, Emp_name, Dept, Desig, basic) In this table which attribute can be used as a primary key?
(a) Emp_id
(b) Emp_name
(c) Dept
(d) Desig

Question. A tuple in RDBMS is referred to _________ of a table.
(A) Record
(B) Field
(C) Table
(D) Key

Assertion and Reason Based MCQs

Directions : In the following questions, A statement of Assertion (A) is followed by a statement of
Reason (R). Mark the correct choice as.
(A) Both A and R are true and R is the correct explanation for A.
(B) Both A and R are true and R is not correct explanation for A.
(C) A is true but R is false.
(D) A is false but R is true.

Question. Assertion (A): A referential integrity is a system of rules of DBMS.
Reason (R): It ensures that user don’t accidently delete or change related data.

Question. Assertion (A): The keyword DISTINCT is used with SELECT command.
Reason (R): DISTINCT keyword eliminates duplicate rows.

Question. Assertion (A): CHAR and VARCHAR both are used to store integer values.
Reason (R): CHAR is fixed length and VARCHAR is of variable length.

Question. Assertion (A): In hierarchical model, searching for a record is very time consuming.
Reason (R): The data is organised in a tree structure

Question. Assertion (A): The columns that are not PRIMARY should have FOREIGN KEY constraint.
Reason (R): Referential integrity is ensured through FOREIGN KEY.

Question. Assertion (A): Indexes can be created at the time of table creation.
Reason (R): By default indexes are in descending order.

Question. Assertion (A): Recording of relationship implementation in network model is very complex since pointers are used.
Reason (R): DBTG codasyl was the first network database.

Question. Assertion (A): TCL stands for Transaction Control Language.
Reason (R): These commands perform retrieval, insertion, deletion and modification etc. on databases.

Question. Assertion (A): Cartesian product is a Cross Join
Reason(R): An SQL Join query joins tables on condition basis.

Question. Assertion (A): A database consists of a number of tables.
Reason (R): Each table comprises of rows and records.

Question. Assertion (A): INSERT command is an SQL command.
Reason (R): NOT NULL constraint ensures that a column cannot have a NULL value.

Question. Assertion (A): The data in a table once added can be modified later.
Reason (R): ALTER TABLE command is used to modify table structure.

Question. Assertion (A): UNIQUE constraint holds same value for the column.
Reason (R): There can be multiple UNIQUE constraints.

Case Based MCQs :

Anita has created a table “Players” to store the details of players who play in her sports academy. She has planned to create the following table with columns :
PlayerId, PlayerName , Game, Type , AadharNo

Answer the following questions, which based on the given information.

Question. Which column(s) can act as candidate key?
(a) Only PlayerId
(b) Only AadharNo
(c) Both (a) and (b)
(d) Type

Question. What is the degree of the table?
(a) 1
(b) 2
(c) 3
(d) 5

Question. Which column can she make the primary key?
(a) PlayerId
(b) PlayerName
(c) Game
(d) Type

Question. What will be the cardinality of the table, if two columns are added to the table?
(a) 7
(b) 6
(c) 4
(d) None of these

Question. Which column is the foreign key in the table?
(a) PlayerName
(b) Type
(c) Game
(d) None of these

Mr. Sharma is a new user of database systems. He has created a table storing the details of staff in his  office. He is confused about some of the terms related to tables and databases. Help him solving his confusions.

Question. An attribute which can uniquely identify tuples of the table but is not defined as primary key of the table is called 
(a) primary key
(b) alternate key
(c) forign key
(d) None of these

Question. What is the cardinality of the table?
(a) 2
(b) 3
(c) 4
(d) 1

Question. The vertical set storing the departments under the heading “Dept” is called
(a) field
(b) attribute
(c) column
(d) All of these

Question. A tuple carries
(a) a single value
(b) double values
(c) a row of multiple values as a record
(d) None of the above

Question. Can “StaffName” column serve as primary key?
(a) No
(b) Yes, only if it stores non-blank and distinct names
(c) Yes, only if it stores only distinct names
(d) Yes

Case-based MCQs

Attempt any 4 sub-parts from each question. Each subpart carries 1 mark.
I. Mr. Sumit Agarwal is the owner of his parental firm Ramdas Gopal das & Sons which deals in the wholesale business of spices.
He wants to maintain records of spices available in their shop and generate bills when someone purchases any spices from the shop. They want to create a database to keep track of all the spices in the shop and the spices purchased by customers.

Question. To add records in the table which of the following SQL statement is used?
(A) ADD
(B) SELECT
(C) INSERT
(D) INSERT INTO

Question. Which is the correct SQL statement to create the table?
(A) CREATE TABLE spice(scode integer, sname char(25), price decimal, stock integer)
(B) CREATE spice(scode integer, sname char(25), price decimal, stock integer)
(C) CREATE TABLE spice(scode , sname , price, stock)
(D) SELECT TABLE spice(scode integer, sname char(25), price decimal, stock integer)

Question. To add a new column exp_date in the existing table the statement is
(A) ALTER TABLE spice ADD (exp_date date)
(B) UPDATE TABLE spice ADD (exp_date date)
(C) MODIFY spice ADD (exp_date date)
(D) ALTER TABLE spice MODIFY (exp_date date)

Question. To create an index on name of spices in the existing table, the command is
(A) ALTER TABLE spice ADD INDEX spice_idx (sname)
(B) CREATE INDEX spice_idxON spice (sname)
(C) CREATE TABLE spice (INDEX spice_idx (sname))
(D) Both (a) and (b)

Question. To view the table structure of the above crated table the command is
(A) SELECT spice
(B) DESC spice
(C) DESCRIBE spice
(D) Both (b) and (c)

II. Consider the table STUDENT with following details.

Question. View all records other than ‘12A’ class
(A) SELECT DISTINCT CLASS FROM STUDENT
(B) SELECT CLASS FROM STUDENT WHERE (CLASS NOT = ‘Science’)
(C) SELECT * FROM STUDENT WHERE CLASS NOT IN (‘Science’)
(D) None of these

Question. Command to select all Science students from the table STUDENT
(A) SELECT * FROM STUDENT
(B) SELECT STREAM FROM STUDENT WHERE STREAM= ‘Science’
(C) SELECT * FROM STUDENT WHERE STREAM = ‘Science’
(D) SELECT NAME FROM STUDENT WHERE STREAM = ‘Science’

Question. Modify the marks of Aastha as 85.5
(A) ALTER TABLE STUDENT SET MARKS = 85.5 WHERE NAME = ‘Aastha’
(B) UPDATE STUDENT SET MARKS = 85.5 WHERE NAME=’Aastha’
(C) UPDATE TABLE STUDENT SET MARKS = 85.5 WHERE NAME=’Aastha’
(D) ALTER STUDENT SET MARKS=85.5 WHERE NAME = Aastha’

Question. Add a record of new student ‘Geeta’ of ‘Commerce’ stream in class ‘12B’ and her marks is ‘78.9’.
(A) INSERT INTO STUDENT VALUES (‘Geeta’, ‘Commerce’, ‘12B’, 78.9)
(B) INSERT INTO STUDENT VALUES (7, ‘Geeta’, ‘Commerce’, ‘12B’, 78.9)
(C) INSERT INTO STUDENT VALUES (‘Geeta’, ‘Commerce’, 78.9, ‘12B’)
(D) INSERT INTO STUDENT VALUES (7, ‘Geeta’, ‘Commerce’, 78.9, ‘12B’)

Question. Delete records that belongs to ‘Humanities’ stream
(A) DELETE FROM STUDENT WHERE STREAM = ‘Humanities’
(B) DROP FROM STUDENT WHERE STREAM = ‘Humanities’
(C) DROP TABLE STUDENT WHERE STREAM = ‘Humanities’
(D) None of these

III. Consider the following SQL command:
CREATE TABLE MEMBER
( MEM_ID INTEGER NOT NULL,
NAME CHAR(15) NOT NULL,
DATE_JOIN DATE,
SEX CHAR(1) CHECK (SEX= ‘M’ OR SEX = ‘F’),
ADDRESS VARCHAR(100) NOT NULL,
PH_NO CHAR(15),
PRIMARY KEY (MEM_NO),
INDEX MEM_IDX (DATE_JOIN)
);
Now answer the following questions:

Question. The INDEX command in above example will
(A) Create an index on field DATE_JOIN
(B) Create an index namely MEM_IDX
(C) Both (a) and (b)
(D) None of the above

Question. NOT NULL ensures that
(A) Column cannot have blank value
(B) Column will not accept any value
(C) Column has a fixed value
(D) Column has a unique value

Question. The ______ constraint ensures that the value entered specifies a certain condition.
(A) NOT NULL
(B) NULL
(C) CHECK
(D) All of these

Question. By default format of date entered is
(A) DD-MM-YY
(B) MM-DD-YY
(C) YYYY-MM-DD
(D) DD-MM-YYYY

Question. PRIMAY KEY in above example ensures that
(A) MEM_ID is entered primarily
(B) MEM_ID will hold a uniquely identified value
(C) MEM_ID will not remain blank
(D) All of these