Home - Computer Science - Database Systems

Database Systems Online Exam Quiz

Important questions about Database Systems. Database Systems MCQ questions with answers. Database Systems exam questions and answers for students and interviews.

1. Internal auditors should review data system design before they are

Options

A : developed

B : implemented

C : modified

D : All of the above

2. In a relational schema, each tuple is divided into fields called

Options

A : Relations

B : Domains

C : Queries

D : All of the above

3. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

Options

A : Network

B : Hierarchical

C : Relational

D : Object-Oriented

4. The index consists of

Options

A : a list of keys

B : pointers to the master list

C : both (a) and (b)

D : All of the above

5. Long-range planning report produced in an MIS are primarily designed for

Options

A : top management

B : middle management

C : lower management

D : All of the above

6. In SQL, which command(s) is(are) used to redefine an index's future storage allocation

Options

A : ALTER INDEX

B : REDEFINE INDEX

C : MODIFY INDEX

D : DO INDEX

7. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

Options

A : COMPILE PROCEDURE

B : ALTER PROCEDURE

C : MODIFY PROCEDURE id) All of the above

D : None of the above

8. The model for a record management system might be

Options

A : handwritten list

B : a Rolodex card file

C : a business form

D : All of the above

9. Which of the following is not true of the traditional approach to information processing?

Options

A : There is common sharing of data among the various applications

B : It is file-oriented

C : Programs are dependent on the files

D : It is inflexible

10. A data dictionary is a special file that contains

Options

A : the names of all fields in all files

B : the data types of all fields in all files

C : the widths of all fields in all files

D : All of the above

1. A data dictionary doesn't provide information about:

Options

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

2. In SQL, the _____ command is used to recompile a view

Options

A : COMPILE VIEW

B : DEFINE VIEW

C : CREATE VIEW

D : ALTER VIEW

3. Which of the following is a type of DBMS software?

Options

A : database manipulation language

B : query language

C : utilities

D : report writer

4. In SQL, the CREATE TABLE is used

Options

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

5. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in

Options

A : a tree file

B : an indexed file

C : a hashed file

D : a sequential file

6. Which command is used to select distinct subject (SUB) from the table (BOOK)?

Options

A : SELECT ALL FROM BOOK

B : SELECT DISTINCT SUB FROM BOOK

C : SELECT SUB FROM BOOK

D : All of the above

7. One approach to standardizing storing of data

Options

A : MIS

B : structured programming

C : CODASYL specifications

D : All of the above

8. In SQL, which command is used to remove a stored function from the database?

Options

A : REMOVE FUNCTION

B : DELETE FUNCTION

C : DROP FUNCTION

D : ERASE FUNCTION

9. Versatile report generators can provide

Options

A : Columnar totals

B : Subtotals

C : Calculations

D : All of the above

10. The modify operation is likely to be done after

Options

A : Delete

B : Look-up

C : Insert

D : All of the above

Computer Science more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.020220994949341