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?

 
 
 
 

2. How many tables may be included with a join?

 
 
 
 

3. Which of the following is true concerning systems information in an RDBMS?

 
 
 
 

4. A CASE SQL statement is which of the following?

 
 
 
 

5. A BI reporting system does not ________

 
 
 
 

6. Which of the following is one of the basic approaches for joining tables?

 
 
 
 

7. Which of the following is true concerning a procedure?

 
 
 
 

8. What type of join is needed when you wish to include rows that do not have matching values?

 
 
 
 

9. Embedded SQL is which of the following?

 
 
 
 

10. The “curse of dimensionality” relates to which problem of using operational data for BI reporting?

 
 
 
 

Question 1 of 10

Leave a Reply

Your email address will not be published. Required fields are marked *