Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Relations produced from an E-R model will always be in:
a. First normal form
b. Second normal form
c. Third normal form
d. Fourth normal form
Q. In ER model the details of the entities are hidden from the user. This process is called:
a. Generalization
b. Specialization
c. Abstraction
d. none of these above
Q. ‘AS’ clause is used in SQL for
a. Selection operation.
b. Rename operation.
c. Join operation.
d. Projection operation.
Q. ODBC stands for
a. Object Database Connectivity.
b. Oral Database Connectivity.
c. Oracle Database Connectivity.
d. Open Database Connectivity
Q. In case of entity integrity, the primary key may be
a. not Null
b. Null
c. both Null & not null
d. any value
Q. The language used in application programs to request data from the DBMS is referred to as the
a. DML
b. DDL
c. VDL
d. SDL
Q. Related fields in a database are grouped to form a
a. data file.
b. data record.
c. menu.
d. bank.
Q. The language which has recently become the defacto standard for interfacing application programs with relational database system is
a. Oracle.
b. SQL.
c. DBase.
d. 4GL.
Q. Transaction ends
a. Only when it is Committed
b. Only when it is Rolledback
c. When it is Committed or Rolledback
d. None of the above
Q. A Database Procedure is stored in the Database
a. In compiled form
b. As source code
c. Both A & B
d. Not stored
Q. Dedicated server configuration is
a. One server process – Many user processes
b. Many server processes – One user process
c. One server process – One user process
d. Many server processes – Many user processes
Q. Which of the following does not affect the size of the SGA?
a. Database buffer
b. Redolog buffer
c. Stored procedure
d. Shared pool