Database Management System Lab Viva Questions and Answers - Set 10 - ObjectiveBooks

Database Management System Lab Viva Questions and Answers - Set 10

Practice Test: Question Set - 10

1. Which of the following hardware components is the most important to the operation of a database management system?
    (A) High-resolution video display
    (B) Printer
    (C) High speed, large-capacity disk
    (D) Plotter

2. In SQL, GRANT command is used to
    (A) Allow user to access databases
    (B) Allow user to create databases
    (C) Grant system privileges, roles, and object privileges to uses and roles
    (D) Choose auditing for specific SQL commands

3. In SQL, which command is used to select data in rows and column from one or more tables?
    (A) CHOOSE
    (B) SELECT
    (C) LIST
    (D) BROWSE

4. After you _______ a record, many data management the environments require you to issue a command to save the changes you made.
    (A) Delete
    (B) Update
    (C) Sort key
    (D) Index

5. Which command(s) is(are) used to redefine a column of the table in SQL?
    (D) None of the above

6. Batch processing is appropriate if
    (A) A large computer system is available
    (B) Only a small computer system is available
    (C) Only a few transactions are involved
    (D) None of the above

7. Characteristic(s) of a distributed MIS structure is
    (A) Interactive sharing of the workload
    (B) A multiprocessing environment
    (C) Computers supporting local DP operations
    (D) All of the above

8. A file that is organized in uniform format is formally referred to as a _______ or a database file.
    (A) Document
    (B) Database
    (C) Record
    (D) Structured data file

9. A set of programs that handle a firm's data base responsibilities is called a
    (A) Data Base Management System (DBMS)
    (B) Data Base Processing System (DBPS)
    (C) Data Management System (DMS)
    (D) All of the above

10. A top-to-bottom relationship among the items in a database is established by a
    (A) Hierarchical schema
    (B) Network schema
    (C) Relational schema
    (D) None of the above

11. A condition that led to the development of databases was
    (A) A demand for more data to support information needs
    (B) An increase in the amount of data handled by organizations
    (C) The proliferation of data files
    (D) All of the above

12. In SQL, the CREATE TABLESPACE is used
    (A) To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the table-space
    (B) To create a database trigger
    (C) To add/rename data files, to change storage
    (D) All of the above

13. In SQL, the CREATE TABLE is used
    (A) To create a table, defining its columns, integrity constrains, and storage allocation
    (B) To add a column/integrity constraint to a table
    (C) To redefine a column
    (D) To change a table's storage characteristics

14. The model for a record management system might be
    (A) Handwritten list
    (B) A Rolodex card file
    (C) A business form
    (D) All of the above

15. In SQL, the ________ command is used to recompile a view

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: