DATABASE PROGRAMMING Online Test – Multiple Choice Questions and Answers

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

5. Embedded SQL is which of the following?

 
 
 
 

6. Business Intelligence (BI) systems do not obtain their data by which of the following means?

 
 
 
 

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

 
 
 
 

8. A BI reporting system does not ________

 
 
 
 

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

 
 
 
 

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

 
 
 
 

Question 1 of 10

Leave a Reply

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