FREE Bachelor of Science in Computer Science : Database Management Systems Questions and Answers

Question 1

Which of the following is not a function performed by a DBMS?

Accepted Answer

Creating and processing forms

Answer

Administrating database

Answer

Creating database

Answer

Processing data

Question 2

What is the definition of a database management system (DBMS)?

Accepted Answer

Software system used to create, maintain, and provide controlled access to a database

Answer

Hardware system used to create, maintain, and provide uncontrolled access to a database

Answer

Software system used to create, maintain, and provide uncontrolled access to a database

Answer

Hardware system used to create, maintain, and provide controlled access to a database

Question 3

An _______ within a table signifies a connection or link between a group of values.

Accepted Answer

Record

Answer

Primary key

Answer

Field

Answer

Foreign key

Question 4

The term attribute pertains to a ________ within a table.

Accepted Answer

Field

Answer

Primary key

Answer

Record

Answer

Foreign key

Question 5

The expression _______ is employed to denote a row.

Accepted Answer

Record

Answer

Primary key

Answer

Field

Answer

Foreign key

Question 6

Among the attributes ID, CITY, and NAME, which one can be regarded as a primary key?

Accepted Answer

ID

Answer

CITY

Answer

ID, NAME

Answer

NAME

Question 7

Which of the options listed below cannot be chosen as a primary key?

Accepted Answer

Street

Answer

ID

Answer

Registration No.

Answer

Department ID

Question 8

Which among the options provided is NOT an instance of data?

Accepted Answer

The boy received RM10

Answer

RM10

Answer

The

Answer

Boy

Question 9

Among the options listed, which one does NOT fall under the category of advantages associated with a DBMS?

Accepted Answer

Increase data isolation

Answer

Improved data security

Answer

Increased data consistency

Answer

Reduced data redundancy

Question 10

What does the term "Attribute" refer to?

Accepted Answer

It is the characteristics of entity

Answer

It is the characteristics of the table

Answer

It is the characteristics of a relation

Answer

None