1) Evaluate the SQL statement

DROP TABLE DEPT:

Which four statements are true of the SQL statement? (Choose four)

A. You cannot roll back this statement.

B. All pending transactions are committed.

C. All data in the table is deleted, and the table structure is also deleted.

D. All data in the table is deleted, but the structure of the table is retained.

2)From SQL*Plus, you issue this SELECT statement:

SELECT*

FROM order;

You use this statement to retrieve data from a data table for ______. (Choose all that apply)

A. Updating

B. Viewing

C. Deleting

D. Inserting

E. Truncating

3)select 1000 from dual;

a)Error

b)It gives out put

c) no rows selected

d)None

4)select 1000+’2000’ from dual;

a)Error

b)It gives out put

c) no rows selected

d)None

5) select KRISHNA from emp

Where 1=2;

a)Error

b)It gives out put

c) no rows selected

d)None

6)Which a valid table name?

A.EMP@_TAB

B. EMP#_TAB

C.$EMP_TAB

D. EMP_DELETE

7) Display all employee names and their salaries whose

salary is not in the range on 1500 and 2850

The Column Heading to be displayed as

EmpMonthly

NameSalary

------

SQL>column ename heading 'Emp|Name'

SQL>column sal heading 'Monthly|Salary'

SQL>select ename,sal from emp

where sal not between 1500 and 2850;

8)Which INSERT statement is valid for pass NULL value to LOC column in DEPT table.

A. insert into dept values(50,’SOFTWARE’,’ ‘);

B. insert into dept values(50,’SOFTWARE’, );

C. insert into dept(deptno,dname) values(50,’SOFTWARE’);

`D.NONE

9)Select employee name whose job is Manager or Clerk and

Salary greater than 1000 and commission greater than 100 and deptno is

either 10 or 20.

A. select ename from emp

where job in('MANAGER','CLERK')

AND SAL >1000

AND COMM>100

AND DEPTNO=(10,20);

B.Select ename from emp

where job in('MANAGER'OR 'CLERK')

AND SAL >1000

AND COMM>100

AND DEPTNO IN(10,20);

C. Select ename from emp

where job in('MANAGER','CLERK')

AND SAL >1000

AND COMM>100

AND DEPTNO IN(10,20);

D.None

10) Which four statements correctly describe functions that are available in

SQL?

A. NVL2 returns the first non-null expression in the expression list.

B. NVL compares two expressions and returns null if they are equal, or the first

expression of they are not equal.

C. NULLIF compares twp expressions and returns null if they are equal, or the first

expression if they are not equal.

11)MERGE into dept d

Using (Select deptno,dname

From tdept

) t

On (d.dname = t.dname)

When MATCHED THEN

UPDATE

Set d. deptno= t.deptno

12) Evaluate these two SQL statements:

SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC;

SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC;

What is true about them?

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in

descending order by default.

D. The two statements can be made to produce identical results by adding

a column alias for the salary column

13)A SELECT statement can be used to perform these three functions:

1. Choose rows from a table.

2. Choose columns from a table

3. Bring together data that is stored in different tables by creating a link

between them.

Which set of keywords describes these capabilities?

A. difference, projection, join B. selection, projection, join

C. selection, intersection, join D. intersection, projection, join

E. difference, projection, product

14)Regexp_count() functions

15)The ______allows for automatic make it null value of child record when a

parent record

is deleted.

A)Add constraint

B)Drop Constraint

C)On delete cascade

D)None