Practice Database Systems Multiple Choice Questions with Answers Quiz-5

Q.1.

Long-range planning report produced in an MIS are primarily designed for

top management
middle management
lower management
All of the above
None of the above

Q.2.

A compound key

is made up a several pieces of information
uniquely identifies an item in a list
both (a) and (b)
is a combination of each unique key
None of the above

Q.3.

In SQL, which command(s) is(are) used to redefine an index's future storage allocation

ALTER INDEX
REDEFINE INDEX
MODIFY INDEX
DO INDEX
None of the above

Q.4.

In the DBM approach, application programs perform the

storage function
processing functions
access control
All of the above
None of the above

Q.5.

The model for a record management system might be

handwritten list
a Rolodex card file
a business form
All of the above
None of the above

Q.6.

The designer of a form includes

filed designators
prompts
data
both (a) and (b)
None of the above

Q.7.

Which of the following is a serious problem of file management systems?

difficult to update
lack of data independence
data redundancy
program dependence
All of the above

Q.8.

With respect to data input, the most accurate description of batch control is

dividing documents to be entered into batches
controlling the input of each input clerk
comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
All of the above
None of the above

Q.9.

In SQL, which command is used to create a database user?

ADD USER TO DATABASE
MK USER
CREATE USER
All of the above
None of the above

Q.10.

When performing a look-up operation using a form

you enter the search value into the form
you look at each form sequentially until you see the one you want
you type the key in an entry line, and the correct form is displayed
All of the above
None of the above

Q.11.

A _____ means that one record in a particular record type is related to only one record of another record type.

One-to-one relationship
One-to-many relationship
Many-to-one relationship
Many-to-many relationship
None of the above

Q.12.

In SQL, which of the following is not a data Manipulation Language Commands?

DELETE
SELECT
UPDATE
CREATE
None of the above

Q.13.

Which of the following is not characteristic of a relational database model?

tables
treelike structure
complex logical relationships
records
None of the above

Q.14.

The database administration function includes

application programming
computer operations management
database access planning
All of the above
None of the above

Q.15.

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

report writer
query language
data manipulation language
transaction log
None of the above

Q.16.

Which command is used to select distinct subject (SUB) from the table (BOOK)?

SELECT ALL FROM BOOK
SELECT DISTINCT SUB FROM BOOK
SELECT SUB FROM BOOK
All of the above
None of the above

Q.17.

The master list of an indexed file

is sorted in ascending order
contains only a list of keys and record numbers
has a number assigned to each record
both (b) and (c)
None of the above

Q.18.

The model for a _____ resembles the hierarchical model in many respects.

Network database
Relational database
Distributed database
Hierarchical database
None of the above

Q.19.

A set of programs that handle a firm's data base responsibilities is called a

Data Base Management System (DBMS)
Data Base Processing System (DBPS)
Data Management System (DMS)
All of the above
None of the above

Q.20.

A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

Network
Hierarchical
Relational
Object-Oriented
None of the above

Q.21.

A computer file contains several records. What does each record contain?

Bytes
Words
Fields
Database
None of the above

Q.22.

In SQL, the CREATE VIEW command is used

to recompile view
to define a view of one or more tables or views
to recompile a table
to create a trigger
None of the above

Q.23.

A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As

tables
relations
tuple
both (a) and (b)
None of the above

Q.24.

A command that lets you change one or more fields in a record is

Insert
Modify
Look-up
All of the above
None of the above

Q.25.

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

In SQL, the CREATE TABLESPACE is used

to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
to create a database trigger
to add/rename data files, to change storage
All of the above
None of the above

Q.27.

A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

File structure
Records
Fields
Database
None of the above

Q.28.

In SQL, which command is used to remove a stored function from the database?

REMOVE FUNCTION
DELETE FUNCTION
DROP FUNCTION
ERASE FUNCTION
None of the above

Q.29.

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

ALTER TABLE
MODIFY TABLE
CHANGE TABLE
All of the above
None of the above

Q.30.

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

the physical schema
all sub-schemas that the system supports
one subschema
both (a) and (b)
None of the above

Support mcqgeeks.com by disabling your adblocker.