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

2/8

Page

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

A database management system

Select an option to see the answer and solution.

Which of the following hardware components is the most important to the operation of a database management system?

Select an option to see the answer and solution.

The PROJECT command will create new table that has

Select an option to see the answer and solution.

To have a file hold a list, it is necessary to

Select an option to see the answer and solution.

Sophisticated report generators can

Select an option to see the answer and solution.

In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.

Select an option to see the answer and solution.

Which two files are used during operation of the DBMS?

Select an option to see the answer and solution.

When using a database management system, the first thing that you must do is to

Select an option to see the answer and solution.

A network schema

Select an option to see the answer and solution.

Which of the following is not a relational database?

Select an option to see the answer and solution.

Which command is used to remove a table from the database in SQL?

Select an option to see the answer and solution.

A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?

Select an option to see the answer and solution.

A file produced by a spreadsheet

Select an option to see the answer and solution.

A form defines

Select an option to see the answer and solution.

Which of the following is true of a network structure?

Select an option to see the answer and solution.

In SQL, GRANT command is used to

Select an option to see the answer and solution.

The highest level in the hierarchy of data organization is called

Select an option to see the answer and solution.

The logical data structure with a one-to-many relationship is a :

Select an option to see the answer and solution.

Updating a database means

Select an option to see the answer and solution.

In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

Select an option to see the answer and solution.