Database Systems 600 Exam With Questions and Answers

Document Content and Description Below

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 C... ycle (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 [Show More]

Last updated: 11 months ago

Preview 1 out of 115 pages