DATABASE PROGRAMMING Online Test – Multiple Choice Questions and Answers

1. A BI reporting system does not ________

 
 
 
 

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

 
 
 
 

3. Embedded SQL is which of the following?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

Question 1 of 10

Leave a Reply

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