Sunday, January 31, 2016

MetricStream -PLSQL 2nd Round interview questions

PLSQL Intervriew -2nd round.

·         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.

No comments :

Post a Comment