databases Online Quiz - 186
|Description: databases Online Quiz - 186|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
choose the environments which can access DB2
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Which are true regarding the use of outer joins?
Which two are true about aggregate functions? (Choose two.)
Which of the following is non-PL/SQL variable?
PL/SQL does not support boolean variables
Which four are valid Oracle constraint types?
Which is an iSQL*PLUS command?
Top N analysis requires _____ and ______?(Choose two)
Which constraint can be defined only at the column level?
What does the FORCE option for creating a view do?
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?
Which three are true?(Choose three)
What is true about Sequences?
John has created a procedure named SALARY_CALC. Which SQL query allows him to view the text of the procedure?