·
Tell me about yourself.
·
Tell me about your project
·
What are your responsibilities
·
Syntax of export and import
·
What is transform parameter while using import
·
Why do you want to change your company
·
How to add primary key constraint to an already
existing table. Write the command
·
How to delete a primary key.
·
How to delete a constraint.
·
When views will be become invalid? What are the
possible cases
·
How to make these views valid
·
If I change the structure of the table what
happens to the views
·
I have a
package and I want to make the package valid while making the view in the
package valid
·
What are private procedures
·
What is ref cursor
·
In how many ways can u define ref cursor
·
How do you debug your code
·
What are new features of 11g
·
What is listagg
·
What is index
·
What is binary index
·
What is btree index
·
What is pls_integer , binary_integer
·
What is compound trigger
·
What is what are inline views
·
Can we write an inline view in columns place of
a query
·
What is explain plan
·
How do you optimize a query
·
What are the checkpoints in query tuning
·
I have a sequence , current value is 5. I want
to re initialize it to 2. How to do it.
·
Can we reset sequence value
·
How can I perform ddl operations in a procedure
·
What are dml statement
·
What is default
keyword, how it is useful with parameters in plsql
·
How it is useful when inserting the values in a
table
·
What is merge statement
·
What is nocopy .
·
Which model you are following in your project.
