NEW
Font size
WorksheetsDBMS-QUIZ
Total questions: 20
Worksheet time: 10mins
The database administrator is, in effect, the coordinator between them ____ and the ____
(A) Database, users
(B) Application program; database
(C) DBMS; database
(D) Application programs; users
Where will we find the referential integrity command?
(A) Table
(B) Tools
(C) Format
(D) None of these
Which of the following component of a computer system is the most important to a database management system?
(A) High speed, large capacity disk
(B) High resolution video display
(C) Mouse
(D) Printer
In a relational schema, each tuple is divided into fields called
(A) Domains
(B) Queries
(C) Relations
(D) None of these
An indexing operation
(A) Establishes an index for a file
(B) Sorts a file using two keys
(C) Sorts a file using a single key
(D) Both (b) and (c)
The modify operation is likely to be done after
(A) Insert
(B) Delete
(C) Look-up
(D) None of these
The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the
(A) Sequential access method
(B) Queuing method
(C) Predetermined method
(D) Direct access method
External database is
(A) Database created using DBMS package
(B) Database created in MS-Word
(C) Database created in EXCEL
(D) All of the above
ROLLBACK in a database is ____ statement.
(A) DDL
(B) DML
(C) DCL
(D) TCL
The logical data structure with a one-to-many relationship is a
(A) Tree
(B) Chain
(C) Network
(D) All of these
The following are components of a database except _____
(A) reports
(B) indexes
(C) metadata
(D) user data
The smallest logical data entity is called a data item or data
(A) Field
(B) Collection
(C) Base
(D) Bank
E.F. Codd represented _____ rules that a database must obey if it has to be considered truly relational.
(A) 6
(B) 8
(C) 10
(D) 12
The distinguishable parts of a record are called
(A) Fields
(B) Files
(C) Data
(D) All of these
The command to convert a numeric number to characters is
(A) STR ()
(B) CHR ()
(C) ASC ()
(D) All of these
What is not true about a view?
a. It is a definition of a restricted portion of the database
b. It is a security mechanism
c. It is always updatable like any other table
d. All are true
In a relational database a referential integrity constraint can be specified with the help of
a. primary key
b. foreign key
c. secondary key
d. none of the above
4NF is designed to cope with
a. Transitive dependency
b. Join dependency
c. Multi valued dependency
d. None of these
Which command is used to add a column to an existing table?
a. Create
b. Update
c.Alter
d. None of these
Rollback of transactions is normally used to
a. recover from transaction failure
b. update the transaction
c. retrieve old records
d. repeat a transaction
