-
How you were passing cursor variables in PL/SQL 2.2?
In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.
-
What is the meaning of cost, card, Bytes?
Cost is basically unit of work or resource used involved memory, I/Oand CPU to execute the query.Card( or Base cardinality) - is the number of rows in a base table captured by running statistics on the table. If u have incorrect statistics u will be having problem here.Bytes - represents number of bytes accessed by the query.
-
-
-
-
-
-
-
-
-
-
-
-
-
List the premium customers who is not using the service within the last one week.
List the premium customers who is not using the service within the last one week.if you have these tables: 1-'Premuim_USER'columns: Customer_ID, post_paid.2-'calls'columns: called_number, Customer_ID, call_date, call_time_started, Call_time_ended, transaction_no.
-
Non Cluster Index
1. How many non cluster index we have use in one table?2. How we set the priority in the cluster index?3. What is co-releated sub query?
-
Explain Plan and TKPROFF
What is explain plan and what is tkproff?
-
Students SQL Query
these are the columns in the exam_report tableEXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCEnow i want to know how many student have passed at the end of the yr for each paper? and if they r failed i need to know there mark of the last appearance for each paper(ie)he might have appeared 5 times but still he may have failed and i want the mark of the 5 appearance
-
Variable Length Record
Describe variable length record representation in files using byte string representation
-
Date Function BC & AD
What is BC and AD in date function of SQL?
Oracle SQL Interview Questions
Ans