Database Systems 600 Exam With Questions and Answers
18 views 0 purchase
Course
Database Systems 600
Institution
Richfield Graduate Institute Of Technology
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
Feedbac...
database systems 600 exam with questions and answe
the traditional systems development life cycle sd
how many rows would be returned from a cross join
Written for
Richfield Graduate Institute Of Technology
Database Systems 600
All documents for this subject (1)
Seller
Follow
StudyConnect
Reviews received
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StudyConnect. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.49. You're not tied to anything after your purchase.
