databases Online Quiz - 118
Description: databases Online Quiz - 118 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Attempted
0/20
Correct 0
Score 0
‹
›
Consider the following SELECT statement: SELECT dept_no "Departments", MAX(salary) "Max Salaries" FROM employee WHERE dept_no IN(200, 300, 400) GROUP BY Departments HAVING MAX(salary) > 60000; Due to which clause does this statement fail?
We can not remove a row from view, if it contains
Any attempt on DML operation on view
What is inline view
Why cache option used in sequences
What are different keys in oracle
How do you see current user name
How to change SQL prompt name