|
61. What Is The Advantage Of Specifying WITH GRANT OPTION In The GRANT Command?
Date Posted: 07/03/2012
Ans: The privilege receiver can further grant the privileges he/she obtained from the owner to any user.
|
|
|
62. What Does The Following Query Do?
Date Posted: 07/03/2012
Ans: This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary.
|
|
|
63. What Will Be The Output Of The Following Query? What Will Be The Output Of The Following Query?
Date Posted: 07/03/2012
Ans: SELECT REPLACE(TRANSLATE(LTRIM(RTRIM(‘!! ATHEN !!’,'!’), ‘!’), ‘AN’, ‘**’),’*',’TROUBLE’) FROM DUAL;?
TROUBLETHETROUBLE. p>
|
|
|
64. State True Or False. EXISTS, SOME, ANY Are Operators In SQL?
Date Posted: 07/03/2012
Ans: True.
|
|
|
65. State True Or False. !=, , ^= All Denote The Same Operation?
Date Posted: 07/03/2012
Ans: True.
|
|
|
66. If A View On A Single Base Table Is Manipulated Will The Changes Be Reflected On The Base Table?
Date Posted: 07/03/2012
Ans: If changes are made to the tables and these tables are the base tables of a view, then the changes will be reference on the view.
|
|
|
67. Which Of The Following Statements Is True About Implicit Cursors?
Date Posted: 07/03/2012
Ans:
1.Implicit cursors are used for SQL statements that are not named.
2. Developers should use implicit cursors with great care.
3. Implicit cursors are used in cursor for loops to handle data processing.
4. Implicit cursors are no longer a feature in Oracle.
|
|
|
68. Which Of The Following Is Not A Feature Of A Cursor FOR Loop?
Date Posted: 07/03/2012
Ans:
1.Record type declaration.
2. Opening and parsing of SQL statements.
3. Fetches records from cursor.
4. Requires exit condition to be defined.
|
|
|
69. A Developer Would Like To Use Referential Data Type Declaration On A Variable. The Variable Name Is EMPLOYEE_LASTNAME, And The Corresponding Table And Column Is EMPLOYEE, And LNAME, Respectively. How Would The Developer Define This Variable Using Referential Data Types?
Date Posted: 07/03/2012
Ans:
1.Use employee.lname%type.
2. Use employee.lname%rowtype.
3. Look up data type for EMPLOYEE column on LASTNAME table and use that.
4. Declare it to be type LONG.
|
|
|
70. If Left Out, Which Of The Following Would Cause An Infinite Loop To Occur In A Simple Loop?
Date Posted: 07/03/2012
Ans:
1.LOOP
2. END LOOP
3. IF-THEN
4. EXIT
|
|