Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. In an Entity-Relationship Diagram “Ellipses” represents
a. attributes
b. weak entity set
c. relationship sets
d. multi-valued attributes
Q. In an Entity-Relationship Diagram “Diamonds” represents
a. attributes
b. multi-valued attributes
c. weak entity set
d. relationship sets
Q. Which of the following is a Data Model?
a. entity-relationship model
b. relational data model
c. object-based data model
d. all of the above
Q. What is the expansion of QBE?
a. Query by Example
b. Query by Experiment
c. Question before evaluation
d. None of the above
Q. Who developed Structured English Query Language?
a. E.F. Codd
b. D. Chamberlain
c. Chris Date
d. None of the above
Q. Which of the following is the first commercial RDBMS?
a. DB2
b. INGRESS
c. ORACLE
d. None of the above
Q. Which of the following company now known as the Oracle Corporation?
a. Stepware Inc.
b. Relational Software Inc.
c. Rational In
d. Oracle Software Inc.
Q. What is the process that is done to SQL before execution, to check for proper syntaxand to optimize the request called?
a. Syntax checking
b. Performance tuning
c. Parsing
d. Optimizing
Q. Which of the following is a valid SQL data type?
a. CHARACTER
b. NUMERIC
c. FLOAT
d. All of the above
Q. Which of the following is not a data definition language statement?
a. CREATE
b. ALTER
c. DROP
d. SELECT
Q. Which of the following is not a DCL statement?
a. GRANT
b. REVOKE
c. ROLLBACK
d. None of the above
Q. Which of the following consists of a row of column headings, together with zero or morerows of data values?
a. COMPOSITE INDEX
b. UNIQUE INDEX
c. TABLE
d. None of the above
Q. In which of the following cases will the RDBMS specify a default value for the columnif there are no values for it?
a. NOT NULL WITH DEFAULT
b. COLUMN DEFAULT
c. NOT NULL UNIUE
d. None of the above