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

1/8

Page

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

A report generator is used to

Select an option to see the answer and solution.

Which of the following is not a logical data-base structure?

Select an option to see the answer and solution.

Which of the following is a database administrator's function?

Select an option to see the answer and solution.

Primitive operations common to all record management systems include

Select an option to see the answer and solution.

Each of data files has a _____ that describe the way the data is stored in the file.

Select an option to see the answer and solution.

After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

Select an option to see the answer and solution.

What is the language used by most of the DBMSs for helping their users to access data?

Select an option to see the answer and solution.

Data item characteristics that are important in data management include

Select an option to see the answer and solution.

In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

Select an option to see the answer and solution.

Periodically adding, changing and deleting file records is called file

Select an option to see the answer and solution.

Sort/report generators

Select an option to see the answer and solution.

The data dictionary tells the DBMS

Select an option to see the answer and solution.

In SQL, which command(s) is(are) used to enable/disable a database trigger?

Select an option to see the answer and solution.

If the record management system allows you to edit values before they are recorded on disk, you can

Select an option to see the answer and solution.

The relational model uses some unfamiliar terminology. A tuple is equivalent to a:

Select an option to see the answer and solution.

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

Select an option to see the answer and solution.

Which command is used to remove an index from the database in SQL?

Select an option to see the answer and solution.

An-owner-member set in the CODASYL specifications may have

Select an option to see the answer and solution.

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

Select an option to see the answer and solution.

A top-to-bottom relationship among the items in a database is established by a

Select an option to see the answer and solution.