DATABASE PROGRAMMING Online Test – Multiple Choice Questions and Answers

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

7. Embedded SQL is which of the following?

 
 
 
 

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

 
 
 
 

9. A BI reporting system does not ________

 
 
 
 

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

 
 
 
 

Question 1 of 10

Leave a Reply

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