databases Online Quiz - 118
Description: databases Online Quiz - 118 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
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?
Which SQL statement is used to extract data from a database?
Did row migration is caused by less pctfree space in datablock ?
Which background processes is not mandatory in Oracle server?
We can not remove a row from view, if it contains
We can not remove a row from view, if it contains
On dropping a view
We can not modify data in view
Any attempt on DML operation on view
What is inline view
Which is correct about an inline view
Sequence is basically used in generating
Why cache option used in sequences
When we do not prefer to create index
Which is not right for Truncate Statement
What are different keys in oracle
How do you see current user name
How to change SQL prompt name
How to Switch to DOS prompt ?
How do I eliminate the duplicate rows ?