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