Practice Database Systems Multiple Choice Questions with Answers Quiz-11 - MCQGeeks.com

Q.1.

What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?

Special purpose packages
Custom made programs
Single function application packages
Data management packages
None of the above

Q.2.

In order to use a record management system

You need to understand the low-level details of how information in stored
You need to understand the model the record management system uses.
Both (a) and (b)
All of the above
None of the above

Q.3.

Which of the following is not the responsibility of the utilities component of DBMS software?

creating the physical and logical designs
removing flagged records for deletion
creating and maintaining the data dictionary
monitoring performance
None of the above

Q.4.

Which of the following is not an advantage of the data-base approach?

elimination of the data redundancy
ability to associate related data
increased security
program/data independence
All of the above are advantages

Q.5.

Which language has recently become the de-facto standard for interfacing application programs with relational database system?

Oracle
SQL
dBASE
4GL
None of the above

Q.6.

The activity of a file

is a low percentages of number of records added or deleted from a file
if high, reduces processing efficiency for sequential and nonsequential files
is a measure of the percentage of existing records updated during a run
refers to how closely the files fits into the allocated
None of the above.

Q.7.

A computer file can be best described as

a single data item
a general collection of data items
an orderly collection of data items
a random collection of data items
None of the above

Q.8.

A data dictionary doesn't provide information about:

where data is located
the size of the disk storage device
It allows a many-to-many relationship
It is conceptually simple
It will be the dominant data base of the future

Q.9.

In SQL, the CREATE TABLE is used

to create a table, defining its columns, integrity constrains, and storage allocation
to add a column/integrity constraint to a table
to redefine a column
to change a table's storage characteristics
All of the above

Q.10.

Versatile report generators can provide

Columnar totals
Subtotals
Calculations
All of the above
None of the above

Q.11.

A good query system

can accept English language commands
allows non-programmers to access information stored in a database
can be accessed only by data processing professionals
both (a) and (b)
None of the above