#1.ABC company is about to give each staff a $500 increase in monthly salary. You want to "preview" the
result from your database table without making any modification. How do you do that?

A. Give the arithmetic expression to invoke salary
increment in the select clause.

B. You cannot do this. Actual update will take place.

C. Give the arithmetic expression to invoke salary
increment in the from clause.

D. Give the arithmetic expression to invoke salary increment in the where clause.

E. Give the arithmetic
expression to invoke salary increment with an update clause.

Ans:A.

#2.You are the DBA of ABC Corp. You need to retrieve the employee names
and salaries from the employment tables, and to make the results assorted by salary, NOT in ascending order. Just in case, if two names match for a
salary are found, the two names should be shown in alphabetical order. How do you do this?

A. ORDERED BY sal,ename;

B. ORDER BY ename, sal;


C. ORDER BY sal NON-ASC, ename;

D. SORT BY sal DESC, ORDER BY
ename;

E. ORDER BY sal DESC, ename;


Ans:E.

#3.You are the DBA
for ABC Corp. You are asked to write some SQL statements. When will you NOT to use the where clause when building a SQL query?

A. Compare
different values.

B. To show data with value less than a specified value.

C. Restrict the rows to be displayed with the group function.


D. Display unique data but nothing else.

E. Specify a table type.

F. Restrict the rows to be included in the display.


Ans:C,D,E.


#4.You are the DBA for ABC Corp. You are asked to test if the current fetch is successful within the loop of a PL/SQL block. Which SQL cursor
attributes can be useful in this case?

A. SQL%ISCOUNT.

B. SQL%FOUND.

C. SQL%FETCHED.

D. SQL%ISFOUND.

E. SQL%SUCCESS .

#5.ABC
company is about to give each staff a $500 increase in monthly salary. You want to "preview" the result from your database table without making
any modification. How do you do that?

A. Give the arithmetic expression to invoke salary increment in the from clause

B. Give the arithmetic
expression to invoke salary increment in the where clause

C. Give the arithmetic expression to invoke salary increment in the select clause


D. Give the arithmetic expression to invoke salary increment with an update clause

E. You cannot do this. Actual update will take place.



Ans:C.


#6.You are the DBA for ABC Corp. You are asked to write some SQL statements. When will you NOT to use the where clause when
building a SQL query?

A. Restrict the rows to be included in the display.

B. Restrict the rows to be displayed with the group function.


C. Display unique data but nothing else.

D. To show data with value less than a specified value.

E. Compare different values.

F.
Specify a table type.


Ans:B,C,F.

---