Database Testing Objective type Questions and Answers

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 ;
A. Equi Join
B. Natural Join
C. Outer Join
D. Cartesian Join
Ans: D

12.  Triggers are stored blocks of code that have to be called in order to operate.
A. TRUE
B. FALSE
Ans: B

13.  The entity integrity rule states that:
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
Ans: A

14.   A foreign key is which of the following?
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

15.  Which of the following is NOT a type of SQL constraint?
A. Primary Key
B. Foreign Key
C. Alternate Key
D. Unique
Ans: C

16.  In which case would you use a FULL OUTER JOIN?
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 data than the other.
Ans: D

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?"
A. Selection, projection, join
B. Difference, projection, join
C. Selection, intersection, join
D. Intersection, projection, join
E. Difference, projection, product
Ans: A

18.  The DBMS acts as an interface between what two components of an enterprise-class database system?
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

19.    A DBMS that combines a DBMS and an application generator is ________ .
A Microsoft SQL Server
B             MS Access
C IBM DB2
D Oracle Corp
Ans: B

20.    The advantage of using a spreadsheet is ____________ .
A. Calculations can be done automatically
B. Changing data automatically updates calculations
C. More flexibility
D. All of the Above
Ans: D

More Questions & Answers:-
Page1 Page2 Page3 Page4