Database Systems Questions

MCQ bookmark_border

141.

A logical schema

A

is the entire database

B

is a standard way of organizing information into accessible parts

C

describes how data is actually stored on disk

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

142.

Queries to a database

A

are written in English

B

can use aggregate functions like SUM and COUNT

C

both (a) and (b)

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

143.

In order to use a record management system

A

You need to understand the low-level details of how information in stored

B

You need to understand the model the record management system uses.

C

Both (a) and (b)

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

144.

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

A

SELECT DISTINCT

B

SELECT UNIQUE

C

SELECT DIFFERENT

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

145.

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

A

a tree file

B

an indexed file

C

a hashed file

D

a sequential file

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

146.

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

A

SELECT ALL FROM BOOK

B

SELECT DISTINCT SUB FROM BOOK

C

SELECT SUB FROM BOOK

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

147.

The master list of an indexed file

A

is sorted in ascending order

B

contains only a list of keys and record numbers

C

has a number assigned to each record

D

both (b) and (c)

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

148.

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

A

creating the physical and logical designs

B

removing flagged records for deletion

C

creating and maintaining the data dictionary

D

monitoring performance

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

149.

In SQL, the CREATE TABLESPACE is used

A

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

B

to create a database trigger

C

to add/rename data files, to change storage

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

150.

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

A

REMOVE FUNCTION

B

DELETE FUNCTION

C

DROP FUNCTION

D

ERASE FUNCTION

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion