20 TOP Database Testing Multiple Choice Questions and Answers

List of top 20 most frequently asked database testing multiple choice questions and answers pdf download free

Database Testing Multiple Choice Questions and Answers List

  1. RDBMS should focus on:
  2. Database Regression testing can be done:
  3. A process of making a small change to a database schema, which improves its design without changing its semantics is known as
  4. Regression testing allows an extensive testing of:
  5. Which of the following is true:
  6. The copy of a database is called:
  7. A load testing CASE TOOL is:
  8. What type of join is needed when you wish to return rows that do have matching values?
  9. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
  10. How many tables may be included with a join?
  11. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
  12. Triggers are stored blocks of code that have to be called in order to operate.
  13. The entity integrity rule states that:
  14. A foreign key is which of the following?
  15. Which of the following is NOT a type of SQL constraint?
  16. In which case would you use a FULL OUTER JOIN?
  17. “Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?”
  18. The DBMS acts as an interface between what two components of an enterprise-class database system?
  19. A DBMS that combines a DBMS and an application generator is ________ .
  20. The advantage of using a spreadsheet is _______ .

This entry was posted in Multiple Choice Questions. Bookmark the permalink.

Leave a Reply

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