DATABASE PROGRAMMING Online Test – Multiple Choice Questions and Answers

1. Embedded SQL is which of the following?

 
 
 
 

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

 
 
 
 

3. A BI reporting system does not ________

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

Question 1 of 10

Leave a Reply

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