Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. ODBC stands for ______
a. none of above
b. open database connection
c. offline database connection
d. oriented database connection
Q. Which of the following is an unary operation?
a. selection operation
b. primitive operation
c. projection operation
d. generalized selection
Q. Which SQL Query is use to remove a table and all its data from the database?
a. none of these
b. drop table
c. create table
d. alter table
Q. In precedence of set operators the expression is evaluated from:
a. left to right
b. right to left
c. left to left
d. right to right
Q. In DBMS, FD stands for _______
a. facilitate data
b. functional data
c. facilitate dependency
d. functional dependency
Q. The management information system (MIS) structure with one main computer system is called a
a. hierarchical mis structure
b. distributed mis structure
c. centralized mis structure
d. decentralized mis structure
Q. The information about data in a database is called
a. metadata
b. hyper data
c. tera data
d. none of the mentioned
Q. The DBMS acts as an interface between what two components of an enterprise-class database system?
a. database application and the database
b. data and the database
c. the user and the database application
d. database application and sql
Q. A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
a. metadata
b. catalog
c. log
d. dictionary
Q. Relational schemas and other metadata about relations are stored in a structure called the
a. metadata
b. catalog
c. log
d. data dictionary
Q. is the collection of memory structures and Oracle background processes that operates against an Oracle database.
a. database
b. instance
c. tablespace
d. segment
Q. A is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
a. tablespace
b. segments
c. extents
d. blocks
Q. is the smallest unit of allocation in an Oracle database.
a. database
b. instance
c. tablespace
d. database block