Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
a. Attributes of common
b. Tuple of common
c. Tuple of distinct
d. Attributes of distinct
Q. A domain is atomic if elements of the domain are considered to be ____________units.
a. Different
b. Indivisbile
c. Constant
d. Divisible
Q. Which of the following products was an early implementation of the relational modeldeveloped by E.F. Codd of IBM?
a. IDMS
b. DB2
c. dBase-II
d. R:base
Q. The following are components of a database except ________
a. user data
b. Metadata
c. Reports
d. Indexes
Q. An application where only one user accesses the database at a given time is an exampleof a(n) ________ .
a. single-user database application
b. multiuser database application
c. e-commerce database application
d. data mining database application
Q. An on-line commercial site such as Amazon.com is an example of a(n) ________ .
a. single-user database application
b. multiuser database application
c. e-commerce database application
d. data mining database application
Q. SQL stands for ________ .
a. Structured Query Language
b. Sequential Query Language
c. Structured Question Language
d. Sequential Question Language
Q. Because it contains a description of its own structure, a database is considered to be ________
a. Described
b. metadata compatible
c. self-describing
d. an application program
Q. The following are functions of a DBMS except ________ .
a. creating and processing forms
b. creating databases
c. processing data
d. administrating databases
Q. Helping people keep track of things is the purpose of a(n) ________ .
a. Database
b. Table
c. Instance
d. Relationship
Q. A DBMS that combines a DBMS and an application generator is ________ .
a. Microsoft's SQL Server
b. Microsoft's Access
c. IBM's DB2
d. Oracle Corporation's Oracle
Q. Given the basic ER and relational models, which of the following is INCORRECT?
a. An attribute of an entity can have more than one value
b. An attribute of an entity can be composite
c. In a row of a relational table, an attribute can have more than one value
d. In a row of a relational table, an attribute can have exactly one value or a NULL value
Q. In an object-oriented model, one object can access data of another object by passing:
a. Instance variable
b. Message
c. Variable
d. None of these
Q. A view of database that appears to an application program is known as:
a. Schema
b. Subschema
c. virtual table
d. none of the above