Practice Database Systems Multiple Choice Questions Quiz-3 - MCQGeeks.com

Q.1

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

High level language
Query language
SQL
4GL
None of the above

Q.2

Data item characteristics that are important in data management include

punctuation
language
spelling
width
None of the above

Q.3

A logical schema

is the entire database
is a standard way of organizing information into accessible parts
describes how data is actually stored on disk
All of the above
None of the above

Q.4

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

record
field
file
data base
data item

Q.5

A report generator is used to

update files
print files on paper
data entry
All of the above
None of the above

Q.6

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

tree
relational
network
chain
All of the above

Q.7

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

ZIP
PACK
COMMIT
SAVE
None of the above

Q.8

Periodically adding, changing and deleting file records is called file

Updating
upgrading
restructuring
renewing
None of the above

Q.9

Queries to a database

are written in English
can use aggregate functions like SUM and COUNT
both (a) and (b)
All of the above
None of the above

Q.10

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.11

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

database design
backing up the database
performance monitoring
user coordination
All of the above

Q.12

Primitive operations common to all record management systems include

Print
Sort
Look-up
All of the above
None of the above

Q.13

What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

DBMS
DASD
FMS
EMMS
None of the above

Q.14

In SQL, which command is used to select only one copy of each set of duplicable rows

SELECT DISTINCT
SELECT UNIQUE
SELECT DIFFERENT
All of the above
None of the above

Q.15

The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in

a tree file
an indexed file
a hashed file
a sequential file
None of the above

Q.16

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

File structure
Records
Fields
Database
None of the above

Q.17

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.18

A form can be used to

modify records
delete records
format printed output
All of the above
None of the above

Q.19

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.20

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.21

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.22

Data encryption techniques are particularly useful for

reducing storage space requirements
improving data integrity
protecting data in data communication systems
All of the above
None of the above

Q.23

It is more accurate to define a _____ as a variety of different record types that are treated as a single unit

Database
Table
Record
Flat File
None of the above

Q.24

In SQL, the _____ command is used to recompile a view

COMPILE VIEW
DEFINE VIEW
CREATE VIEW
ALTER VIEW
None of the above

Q.25

Which of the following is not true of the traditional approach to information processing?

There is common sharing of data among the various applications
It is file-oriented
Programs are dependent on the files
It is inflexible
All of the above are true

Q.26

Data items grouped together for storage purposes are called a

record
title
list
string
None of the above

Q.27

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.28

A list in alphabetical order

is in descending order
is in ascending order
is the result of a sort operation
both (b) and (c)
None of the above

Q.29

If a piece of data is stored in two places in the database, then

storage space is wasted
changing the data is one spot will cause data inconsistency
it can be more easily accessed
both (a) and (b)
None of the above

Q.30

Batch processing is appropriate if

a large computer system is available
only a small computer system is available
only a few transactions are involved
All of the above
None of the above

0 h : 0 m : 1 s