10 Previous Year MCQ of DBMS

1)Which privilege is required to create a database?
(A) SYSDBA
(B) DBA
(C) SYSOPER
(D) RESOURCE

2)Which Normal Form(NF) is considered adequate for normal relational database design?
(A) 2NF
(B) 5NF
(C) 4NF
(D) 3NF

3)A Foreign key in one table points to a ________ key in another table.
(A) Alternate
(B) Default
(C) Primary
(D) None of the above

4)In SQL, the spaces at the end of the string are removed by _______ function 
(A) Lower
(B) String
(C) Trim
(D) None of the above

5)The highest level in the hierarchy of data organization is called________
(A) data base
(B) data file
(C) data record
(D) None of the above

6)_______ is the process of organizing data into related tables.
(A) Generalization
(B) Normalization
(C) Specialization
(D) None of the above

7)Which of the following keyword can be used to return different values?
(A) SELECT
(B) GET
(C) OPEN
(D) DISTINCT

8)Which of the following field type is used to store photograph of employees?
(A) Memo
(B) Picture
(C) OLE
(D) Photo

9)Which of the following is standard interactive and programming language for getting information from and updating a database.
(A) SQL
(B) PHP
(C) ASP
(D) None of the above

10)Which TCL command is used to permanently save any transaction into database?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above




Answers:
1)a
2)d
3)c
4)c
5)a
6)b
7)d
8)c
9)a
10)c