SQL PLSQL Interview Questions
Questions Answers Views Company eMail

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

3 12904

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

1 4615

What is Referential Integrity?

IBM,

3 8890




What are the data types allowed in a table?

3 4818

What is an Integrity Constraint?

4 5749

Explain Connect by Prior?

2 9535

What are the types of SQL Statement?

3 17314

What is a transaction?

5 5418




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

6 8738

What is CYCLE/NO CYCLE in a Sequence?

2 7241

What is a database link?

3 5319

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

5 10566

Where the integrity constrints are stored in Data Dictionary?

1 4505

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

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

6 25639

What is ON DELETE CASCADE?

3 8180


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

3


How can you view the errors encountered in a trigger?

1


when MSQL8.0 is in market

982


Explain uses of cursor.

5


What are conditional predicates?

1






what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

147


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

2330


Can triggers stop a dml statement from executing on a table?

1


How can the performance of a trigger be improved?

3


Is it possible to include an insert statement on the same table to which the trigger is assigned?

1


Explain polymorphism in pl/sql.

3


How to display Row Number with Records in Oracle SQL Plus?

10


What are the uses of sysdate and user keywords?

3


Differentiate between syntax and runtime errors.

3