Database Management System Multiple Choice Questions and Answers pdf - Set 08 - ObjectiveBooks
Database Management System Multiple Choice Questions and Answers pdf - Set 08

Database Management System Multiple Choice Questions and Answers pdf - Set 08

Practice Test: Question Set - 08

1. Data Manipulation Language (DML) is not to
    (A) Create information table in the Database
    (B) Insertion of new information into the Database
    (C) Deletion of information in the Database
    (D) Modification of information in the Database
2. In precedence of set operators the expression is evaluated from:
    (A) Left to Left
    (B) Left to Right
    (C) Right to Right
    (D) Right to Left
3. The minimal set of super key is called
    (A) Primary key
    (B) Secondary key
    (C) Candidate key
    (D) Foreign key
4. A type of query that is placed within a WHERE or HAVING clause of another query is called
    (A) Super query
    (B) Sub query
    (C) Master query
    (D) Multi-query
5. A data dictionary doesn't provide information about:
    (A) Where data is located
    (B) The size of the disk storage device
    (C) It allows a many-to-many relationship
    (D) It is conceptually simple
6. In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
    (A) Data field
    (B) Data record
    (C) Data file
    (D) Database
7. A report generator is used to
    (A) Update files
    (B) Print files on paper
    (C) Data entry
    (D) None of the above
8. Related fields in a data base are grouped to form
    (A) Data file
    (B) Data record
    (C) Menu
    (D) Bank
9. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
    (A) Specialized file
    (B) Log file
    (C) Master file
    (D) Update file
10. In SQL, which command is used to remove a stored function from the database?
    (A) REMOVE FUNCTION
    (B) DELETE FUNCTION
    (C) DROP FUNCTION
    (D) ERASE FUNCTION
11. Versatile report generators can provide
    (A) Columnar totals
    (B) Subtotals
    (C) Calculations
    (D) All of the above
12. In SQL, which command is used to select only one copy of each set of duplicable rows
    (A) SELECT DISTINCT
    (B) SELECT UNIQUE
    (C) SELECT DIFFERENT
    (D) All of the above
13. The distinguishable parts of a record are called
    (A) Files
    (B) Data
    (C) Fields
    (D) Database
14. The model for a _______ resembles the hierarchical model in many respects.
    (A) Network database
    (B) Relational database
    (C) Distributed database
    (D) Hierarchical database
15. In SQL, which command(s) is(are) used to enable/disable a database trigger?
    (A) ALTER TRIGGER
    (B) ALTER DATABASE
    (C) ALTER TABLE
    (D) MODIFY TRIGGER
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: