Database Systems 600 Exam With Questions and Answers

DATABASE 600
MULTIPLE CHOICE
Question 1
Correct
Mark 1.00 out of 1.00




Flag question

Question text

The traditional Systems Development Life Cycle (SDLC) is divided into _____ phases.

Select one:
a. five
b. four
c. two
d. three
Feedback

The correct answer is: five

Question 2
Incorrect
Mark 0.00 out of 1.00




Flag question

Question text

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B
contains 18?

Select one:
a. 18
b. 26
c. 8
d. 144
Feedback

The correct answer is: 144

Question 3
Incorrect
Mark 0.00 out of 1.00

, Flag question

Question text

The main disadvantage of using CGI scripts is that:

Select one:
a. they do not have the capability to process forms or prepare outputs based on form data.
b. they cause a resource bottleneck since they have to execute separately for each user request.
c. an error in one script can damage and bring down the web server completely.
d. they are specific to the web server and to the operating system, thus being platform dependent.
Feedback

The correct answer is: they cause a resource bottleneck since they have to execute separately for each
user request.

Question 4
Correct
Mark 1.00 out of 1.00




Flag question

Question text

The _____ process analyses SQL queries and finds the most efficient way to access data.

Select one:
a. User
b. Optimizer
c. Scheduler
d. Listener
Feedback

The correct answer is: Optimizer

Question 5
Correct
Mark 1.00 out of 1.00




Flag question

,Question text

“All users must have passwords” is an example of a _____.

Select one:
a. Rule
b. Policy
c. Standard
d. Procedure
Feedback

The correct answer is: Policy

Question 6
Incorrect
Mark 0.00 out of 1.00




Flag question

Question text

During decentralized design, after the _____ has been completed, all modules are integrated into one
conceptual model.

Select one:
a. conceptual process
b. logical process
c. verification process
d. declaration process
Feedback

The correct answer is: verification process

Question 7
Incorrect
Mark 0.00 out of 1.00




Flag question

Question text

To work with data, a DBMS must retrieve the data from _____ and place them in _____.

Select one:
a. Permanent storage; RAM

, b. RAM; data cache
c. Data files; procedure cache
d. Temporary files; procedure cache
Feedback

The correct answer is: Permanent storage; RAM

Question 8
Correct
Mark 1.00 out of 1.00




Flag question

Question text

What is the purpose of data dictionary management?

Select one:
a. Creates a security system that enforces user security and data privacy.
b. Transforms entered data to conform to required data structures.
c. Creates and manage the complex structures required for data storage.
d. Stores definitions of the data elements and their relationships (metadata) in a data dictionary which
also automatically records structural changes.
Feedback

The correct answer is: Stores definitions of the data elements and their relationships (metadata) in a
data dictionary which also automatically records structural changes.

Question 9
Incorrect
Mark 0.00 out of 1.00




Flag question

Question text

The _____ data model uses the concept of inheritance.

Select one:
a. Entity relationship
b. Network
c. Object-oriented
d. Relational
Feedback