Vidyalelo
Computer Science · all questions

Database Systems
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

148

Questions

4/8

Page

Pick an option on a question to see the right answer and solution.

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

Select an option to see the answer and solution.

In SQL, the ALTER TABLESPACE command is used

Select an option to see the answer and solution.

The language used in application programs to request data from the DBMS is referred to as the

Select an option to see the answer and solution.

A database management system might consist of application programs and a software package called

Select an option to see the answer and solution.

An audit trail

Select an option to see the answer and solution.

A race condition occurs when

Select an option to see the answer and solution.

An indexing operation

Select an option to see the answer and solution.

The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a

Select an option to see the answer and solution.

In SQL, which command(s) is(are) used to create a synonym for a schema object?

Select an option to see the answer and solution.

If you want your database to include methods, you should use a _____ database.

Select an option to see the answer and solution.

In SQL, which of the following is not a data Manipulation Language Commands?

Select an option to see the answer and solution.

Which of the following is not characteristic of a relational database model?

Select an option to see the answer and solution.

A computer file contains several records. What does each record contain?

Select an option to see the answer and solution.

In SQL, the CREATE VIEW command is used

Select an option to see the answer and solution.

A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

Select an option to see the answer and solution.

In the DBM approach, application programs perform the

Select an option to see the answer and solution.

In SQL, which command is used to create a database user?

Select an option to see the answer and solution.

When performing a look-up operation using a form

Select an option to see the answer and solution.

A _____ means that one record in a particular record type is related to only one record of another record type.

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.