Database Management System MCQs Online - Set 04 - ObjectiveBooks

Database Management System MCQs Online - Set 04

Practice Test: Question Set - 04


1. Data integrity control
    (A) Is used to set upper and lower limits on numeric data
    (B) Requires the use of passwords to prohibit unauthorized access to the file
    (C) Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
    (D) None of the above

2. Embedded pointer provide
    (A) A secondary access path
    (B) A physical record key
    (C) An inverted index
    (D) All of the above

3. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
    (A) Bits
    (B) Characters
    (C) Data field
    (D) Schema

4. A computer file contains several records. What does each record contain?
    (A) Bytes
    (B) Words
    (C) Fields
    (D) Database

5. In order to use a record management system
    (A) You need to understand the low-level details of how information in stored
    (B) You need to understand the model the record management system uses
    (C) Both (a) and (b)
    (D) None of the above

6. In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
    (A) CREATE PACKAGE
    (B) CREATE SCHEMA
    (C) CREATE CLUSTER
    (D) None of the above

7. A _________ Contains fields of data about one entity.
    (A) Record
    (B) File
    (C) Fields
    (D) Document

8. In SQL, the ALTER TABLESPACE command is used
    (A) To add/rename data files
    (B) To change storage characteristics
    (C) To take a table space online/offline
    (D) All of the above

9. In SQL, which command(s) is(are) used to recompile a stored function?
    (A) SET FUNCTION
    (B) SET STORED FUNCTION
    (C) ALTER FUNCTION
    (D) All of the above

10. Which of the following is not a relational database?
    (A) dBASE IV
    (B) 4th Dimension
    (C) FoxPro
    (D) Reflex

11. Which of the following is a database administrator's function?
    (A) Database design
    (B) Backing up the database
    (C) Performance monitoring
    (D) All of the above

12. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
    (A) DEFINE TABLE
    (B) MODIFY TABLE
    (C) ALTER TABLE
    (D) All of the above

13. The PROJECT command will create new table that has
    (A) More fields than the original table
    (B) More rows than the original table
    (C) Both (a) and (b)
    (D) None of the above

14. A logical schema
    (A) Is the entire database
    (B) Is a standard way of organizing information into accessible parts
    (C) Describes how data is actually stored on disk
    (D) None of the above

15. A compound key
    (A) Is made up a several pieces of information
    (B) Uniquely identifies an item in a list
    (C) Both (a) and (b)
    (D) Is a combination of each unique key

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:


    Blogger Comment
    Facebook Comment