WCF-DSE-Q7

Views are ____ tables that don't exist physically in Oracle.

One or more tables can be joined to create a ____.

• view

• variable

• synonym

• none of these

A new user on the database is created by executing the following command:

SQL> CREATE USER user01 IDENTIFIED BY user01;

Then you granted the following privileges to user01 by executing the following command:

SQL> GRANT CREATE SESSION, CREATE TABLE TO user01;

Which of the following is correct in this scenario?

• The user can create table

• The user cannot query any tables

• The user can not create tables

• none of these

The ____ statement is used to modify the data in a table in SQL.

• Insert

• Update

• Delete

• Truncate

Query to display the Employees name, salary and department id who earn a salary less than the average salaryof their respective department

• Select first_name,salary,e.department_id from Employees e, (Select department_id,avg(salary) avgsal from Employees group by department_id) qr where e.salary < qr.avgsal

• Select first_name,salary,e.department_id from Employees e, (Select department_id,avg(salary) avgsal from Employees group by department_id) qr where e.salary < qr.avgsal and e.department_id = qr.department_id

• Select first_name,salary,e.department_id from Employees e, (Select department_id,avg(salary) avgsal from Employees ) qr where e.salary < qr.avgsal and e.department_id = qr.department_id/

• none of these

Fill in the blanks for the below query to rename the Employee table to Employees_TB

------  Employee to Employees_TB;

The ____ keyword is used to delete a record in a database in SQL.

• Update

• Delete

• Remove

• Clear

The ____ keyword is used to arrange the result-set in ascending or descending order in SQL.

• Sort

• Ordered By

• Order By

• Arrange

Query to get first 3 characters of the name of an employee

• Select str(name, 1,3) from employees

• Select trim(name, 3) from employees

• Select get(name, 3) from employees

• Select substr(name, 1,3) from employees

Which query finds employees whose department has more than 10 employees?

• SELECT first_name FROM employees WHERE department_id IN (    SELECT department_id    FROM employees    GROUP BY department_id    HAVING COUNT(*) > 10)

• SELECT first_nameFROM employeesWHERE department_id IN ( SELECT department_id FROM employees GROUP BY department_id)

• SELECT first_name FROM employees WHERE department_id IN (    SELECT department_id    FROM employees    GROUP BY department_id    HAVING COUNT(*) < 10)

• none of these