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

Q.1

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

ALTER TABLE
ADD ROW
INSERT
APPEND
None of the above

Q.2

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

file
field
data
batch
None of the above

Q.3

In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

ALTER TRIGGERS
ALTER TABLE
MODIFY TRIGGERS IN TABLE
All of the above
None of the above

Q.4

In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.

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

Q.5

Which two files are used during operation of the DBMS?

query language and utilities
data manipulation language and query language
data dictionary and transaction log
data dictionary and query language
None of the above

Q.6

A form defines

where data is placed on the screen
the width of each field
both (a) and (b)
All of the above
None of the above

Q.7

Which of the following is true of a network structure?

It is a physical representation of the data
It allows a many-to-many relationship
It is conceptually simple
It will be the dominant data base of the future
None of the above

Q.8

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

ADD COLUMN
INSERT COLUMN
MODIFY TABLE
ALTER TABLE
None of the above

Q.9

In SQL, which command(s) is(are) used to enable/disable a database trigger?

ALTER TRIGGER
ALTER DATABASE
ALTER TABLE
MODIFY TRIGGER
All of the above

Q.10

When using a database management system, the first thing that you must do is to

create a database file
activate file editor
load the software into your micro¬computer
keep a floppy disk in readiness
None of the above

Q.11

A network schema

restricts the structure to a one-to-many relationship
permits many-to-many relation¬ships
stores data in tables
All of the above
None of the above

Q.12

Which of the following is not a relational database?

dBASE IV
4th Dimension
FoxPro
Reflex
None of the above

Q.13

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

Relations
Domains
Queries
All of the above
None of the above

Q.14

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

UPDATE
INSERT
BROWSE
APPEND
None of the above

Q.15

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

Database
Directory information
Information tree
Information provider
None of the above

Q.16

A database management system

allows simultaneous access to multiple files
can do more than a record management system
is a collection of programs for managing data in a single file
both (a) and (b)
None of the above

Q.17

Which of the following hardware components is the most important to the operation of a database management system?

high-resolution video display
printer
high speed, large-capacity disk
plotter
mouse

Q.18

The PROJECT command will create new table that has

more fields than the original table
more rows than the original table
both (a) and (b)
all the fields of master table
None of the above

Q.19

To have a file hold a list, it is necessary to

identify the records in the list
identify the name, width and type of the fields of each record.
decide which fields will be used as sort or index keys
All of the above
None of the above

Q.20

Sophisticated report generators can

print row-oriented reports
perform arithmetic operations
selectively retrieve and print portions of a list
All of the above
None of the above

Q.21

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

Bits
Characters
Data field
Schema
None of the above

Q.22

Which command is used to remove an index from the database in SQL?

DELETE INDEX
DROP INDEX
REMOVE INDEX
ROLL BACK INDEX
None of the above

Q.23

An-owner-member set in the CODASYL specifications may have

only one owner but many owner occurrences
only one member but many member occurrence
more than one member but only one occurrence per member
All of the above
None of the above

Q.24

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

Full media
Graphics media
Multimedia
Hypertext
None of the above

Q.25

A top-to-bottom relationship among the items in a database is established by a

Hierarchical schema
Network schema
Relational schema
All of the above
None of the above

Q.26

Sort/report generators

are faster than index/report generators
require more disk space than index/report generators
do not need to sort before generating a report
both (a) and (b)
None of the above

Q.27

The data dictionary tells the DBMS

what files are in the database
what attribute are possessed by the data
what these files contain
All of the above
None of the above

Q.28

After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

Delete
Update
Sort key
Index
None of the above

Q.29

In SQL, which command(s) is(are) used to enable/disable a database trigger?

MODIFY USER
CHANGE USER
ALTER TRIGGER
All of the above
None of the above

Q.30

If the record management system allows you to edit values before they are recorded on disk, you can

correct spelling changes before they are recorded
change the name of a field
change the width of a field
All of the above
None of the above

0 h : 0 m : 1 s