Krishna Logo
Divied
Call: Harsha @ 571-386-2972

 

Loading
Latest News
Home Navigation Divied
INTERVIEW Navigation Divied DATABASE INTERVIEW QUESTIONS
Showing 1 - 10 of 93 Previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next
DATABASE INTERVIEW QUESTIONS
 

1) What is ETL? In data warehousing architecture, ETL is an importan...  

 
 
2Which 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.

 
 
3Which 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.

 
 
4A 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.

 
 
5If 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

 
 
6Which Line In The Following Statement Will Produce An Error?
Date Posted: 07/03/2012

Ans:
1.Cursor action_cursor is
2. Select name, rate, action
3. Into action_record
4. from action_table;
5. There are no errors in this statement.

 
 
7The Command Used To Open A CURSOR FOR Loop Is
Date Posted: 07/03/2012

Ans:
1.Open
2. Fetch
3. Parse
4. None, cursor for loops handle cursor opening implicitly.

 
 
8What Happens When Rows Are Found Using A FETCH Statement
Date Posted: 07/03/2012

Ans:
1.It causes the cursor to close
2. It causes the cursor to open
3. It loads the current row values into variables
4. It creates the variables to hold the current row values

 
 
9Under Which Circumstance Must You Recompile The Package Body After Recompiling The Package Specification?
Date Posted: 07/03/2012

Ans:
1.Altering the argument list of one of the package constructs
2. Any change made to one of the package constructs
3. Any SQL statement change made to one of the package constructs
4. Removing a local variable from the DECLARE section of one of the package constructs

 
 
10Procedure And Functions Are Explicitly Executed. This Is Different From A Database Trigger. When Is A Database Trigger Executed?
Date Posted: 07/03/2012

Ans:
1.When the transaction is committed
2. During the data manipulation statement
3. When an Oracle supplied package references the trigger
4. During a data manipulation statement and when the transaction is committed

 
Showing 1 - 10 of 93 Previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next
Shadow Bottom
 
    Courses Offered
  • Courses not available.
 
© 2005 - 2018 Krishna Training.
Designed & Developed By BitraNet