Category Archives: Database Testing Questions

The advantage of using a spreadsheet is ____________ . | Database Testing Mcqs

A. Calculations can be done automatically B. Changing data automatically updates calculations C. More flexibility D. All of the Above Ans: D

Posted in Database Testing Questions | Leave a comment

A DBMS that combines a DBMS and an application generator is ________ . | Database Testing Mcqs

A Microsoft SQL Server B MS Access C IBM DB2 D Oracle Corp Ans: B

Posted in Database Testing Questions | Leave a comment

The DBMS acts as an interface between what two components of an enterprise-class database system? | Database Testing Mcqs

A Database application and the database B Data and the database C The user and the database application D Database application and SQL Ans: A

Posted in Database Testing Questions | Leave a comment

“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?” | Database Testing Mcqs

A. Selection, projection, join B. Difference, projection, join C. Selection, intersection, join D. Intersection, projection, join E. Difference, projection, product Ans: A

Posted in Database Testing Questions | Leave a comment

In which case would you use a FULL OUTER JOIN? | Database Testing Mcqs

A. Both tables have NULL values. B. You want all unmatched data from one table. C. You want all matched data from both tables. D. You want all unmatched data from both tables. E. One of the tables has more … Continue reading

Posted in Database Testing Questions | Leave a comment

Which of the following is NOT a type of SQL constraint? | Database Testing Mcqs

A. Primary Key B. Foreign Key C. Alternate Key D. Unique Ans: C

Posted in Database Testing Questions | Leave a comment

A foreign key is which of the following? | Database Testing Mcqs

A. Any attribute B. The same thing as a primary key C. An attribute that serves as the primary key of another relation D. An attribute that serves no purpose Ans: C

Posted in Database Testing Questions | Leave a comment

The entity integrity rule states that: | Database Testing Mcqs

A. no primary key attribute may be null. B. no primary key can be composite. C. no primary key may be unique. D. no primary key may be equal to a value in a foreign key | Database Testing Mcqs … Continue reading

Posted in Database Testing Questions | Leave a comment

Triggers are stored blocks of code that have to be called in order to operate. | Database Testing Mcqs

A. TRUE B. FALSE Ans: B

Posted in Database Testing Questions | Leave a comment

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 ; | Database Testing Mcqs

A. Equi Join B. Natural Join C. Outer Join D. Cartesian Join Ans: D

Posted in Database Testing Questions | Leave a comment