Question 1

A condition that led to the development of databases was

Accepted Answer

All of the above

Question 2

The database administration function includes

Accepted Answer

database access planning

Question 3

The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.

Accepted Answer

Flat file

Question 4

In SQL, the CREATE TABLESPACE is used

Accepted Answer

to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace

Question 5

A scheme describes

Accepted Answer

All of the above

Question 6

The master list of an indexed file

Accepted Answer

has a number assigned to each record

Question 7

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

Accepted Answer

SQL

Question 8

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

Accepted Answer

All of the above are advantages

Question 9

A _____ DBMS distributes data processing tasks between the workstation and a network server.

Accepted Answer

Client Server

Question 10

In SQL, which of the following is not a data definition language commands?

Accepted Answer

UPDATE

Question 11

In SQL, which command(s) is(are) used to recompile a stored function?

Accepted Answer

ALTER FUNCTION

Question 12

In SQL, the command(s) is(are) used to create an index for a table or cluster

Accepted Answer

CREATE INDEX

Question 13

In order to use a DBMS, it is important to understand

Accepted Answer

one subschema

Question 14

Report generators are used to

Accepted Answer

both (b) and (c)

Question 15

Administrate supervision of database activities is the responsibility of the

Accepted Answer

Database administrator

Question 16

There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

Accepted Answer

Database management system (DBMS)

Question 17

Subschema can be used to

Accepted Answer

All of the above

Question 18

Data integrity control

Accepted Answer

has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files

Question 19

Database management systems are intended to:

Accepted Answer

All of the above

Question 20

In SQL, which command(s) is(are) used to change a table's storage characteristics?

Accepted Answer

ALTER TABLE

Database Systems Questions