DATABASE PROGRAMMING Online Test – Multiple Choice Questions and Answers 1. Business Intelligence (BI) systems do not obtain their data by which of the following means? Process data purchased from data vendors Process transactions Process extracts from operational databases Read and process data from an operational database 2. Which of the following is true concerning a procedure? They do not need to have a unique name You do not create them with SQL They are the same thing as a function They include procedural and SQL statements 3. A CASE SQL statement is which of the following? A way to establish an IF-THEN-ELSE in SQL A way to establish a loop in SQL A way to establish a data definition in SQL All of the above 4. A BI reporting system does not ________ deliver information to users on a timely basis use disparate data sources use statistical procedures to predict future events create meaningful information 5. Embedded SQL is which of the following? Hard-coded SQL statements in a procedure The process of making an application capable of generating specific SQL code on the fly Hard-coded SQL statements in a program language such as Java Hard-coded SQL statements in a trigger 6. Which of the following is true concerning systems information in an RDBMS? RDBMS store database definition information in system-created tables This information often cannot be updated by a user This information can be accessed using SQL All of the above 7. How many tables may be included with a join? 1 2 3 All of above 8. Which of the following is one of the basic approaches for joining tables? Union Join Subqueries Natural join All of the above 9. What type of join is needed when you wish to include rows that do not have matching values? Outer join Equi-join Natural join All of the above 10. The “curse of dimensionality” relates to which problem of using operational data for BI reporting? Non-integrated data Too much data Dirty data Inconsistent data Loading … Question 1 of 10
