Database Management System (DBMS) MCQs
NEB Class 12 Computer Science Database Management System (DBMS) MCQs.
Multiple Choice Questions (Tick the best options)
1. A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
Answer
a) Tables
2. The term is used to refer to a row.
a) Attribute
b) Tuple
c) Field
d) Instance
Answer
b) Tuple
3. The term attribute refers to a of a table.
a) Record
b) Column
c) Tuple
d) Key
Answer
b) Column
4. CREATE TABLE employee (name VARCHAR, id INTEGER What type of statement is this?
a) DML
b) DDL
c) View
d) Integrity constraint
Answer
b) DDL
5. In the given query which of the keyword has to be inserted?
INSERT INTO employee (4,Alok,2000)
a) Table
b) values
c) Relation
d) Field
Answer
b) values
6. In the normal form, a composite attribute is converted to individua] attributes.
a) First
b) Second
c) Third
d) Fourth
Answer
a) First
7. with SQL, how do you select all the record from a table named"persons" where the value of column "First name "end with "a"?
a) SELECT * FROM Persons WHERE FirstName="a’
b) SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
c) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
d) SELECT * FROM Persons WHERE FirstName=’%a%’
Answer
c) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
8. The UPDATE SQL clause can
a) update only one row at a time
b) update more than one row at a time
c) delete more than one row at a time
d) delete only one row at a time
Answer
b) update more than one row at a time
9. Which SQL keyword is used to retrieve a maximum value?
a) MOST
b) TOP
c) MAX
d) UPPER
Answer
c) MAX
10. Which of the following is not a DDL command?
a) UPDATE
b) TRUNCATE
c) ALTER
d) None of the Mentioned
Answer
a) UPDATE
Ans:
1(a) 2(b) 3(b) 4(b) 5(b) 6(a) 7(c) 8(b) 9(c) 10(a)