SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 16718

Is it possible to access the current value in a session before accessing next value?

1 6427

What is Referential Integrity?

IBM,

3 12808

What are the data types allowed in a table?

3 7499

What is an Integrity Constraint?

4 9431

Explain Connect by Prior?

2 11787

What are the types of SQL Statement?

3 20842

What is a transaction?

5 9113

How to access the current value and next value from a sequence?

6 12948

What is CYCLE/NO CYCLE in a Sequence?

2 9814

What is a database link?

3 8516

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 14372

Where the integrity constrints are stored in Data Dictionary?

1 6443

What is a join?Explain the different types of joins?

Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

6 33631

What is ON DELETE CASCADE?

3 11128

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to fetch alternate records from a table?

1157

Can you have a foreign key without a primary key?

899

Does sql view stored data?

897

How many types of triggers are there in pl sql?

1011

How do you add a column to a table?

994

What is database migration?

913

How would you reference column values before and after you have inserted and deleted triggers?

1016

How to change the order of columns in Oracle SQL Plus ?

993

What is an alias command?

1002

What is synchronized subquery?

1090

Can you have more than one key in a database?

890

What is the function that is used to transfer a pl/sql table log to a database table?

949

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1083

What is character functions?

1016

What is the most important ddl statements in sql are?

945

For More Un-Answered { SQL PLSQL } Questions Click Here