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

3/8

Page

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

When you have finished entering information into a form

Select an option to see the answer and solution.

The main idea behind computer files is that it is convenient to

Select an option to see the answer and solution.

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

Select an option to see the answer and solution.

In SQL, which command is used to add new rows to a table?

Select an option to see the answer and solution.

A number of related records that are treated as a unit is called

Select an option to see the answer and solution.

If you want to group the records in the abc database, you could use the Jobcode as the _____.

Select an option to see the answer and solution.

The Management Information system (MIS) structure with one main computer system is called a

Select an option to see the answer and solution.

If a calculation is embedded in a form

Select an option to see the answer and solution.

Data security threats include

Select an option to see the answer and solution.

An operation that will increase the length of a list is

Select an option to see the answer and solution.

In SQL, which command is used to add a column/integrity constraint to a table

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.

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

Select an option to see the answer and solution.

In SQL, which command is used to changes data in a table?

Select an option to see the answer and solution.

What name is given to the collection of facts, items of information or data which are related in some way?

Select an option to see the answer and solution.

In a large DBMS

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

Internal auditors should review data system design before they are

Select an option to see the answer and solution.

A _____ means that one record in a particular record type may be related to more than one record of another record type.

Select an option to see the answer and solution.

Which command(s) is(are) used to redefine a column of the table in SQL ?

Select an option to see the answer and solution.