SQL PLSQL Interview Questions
Questions Answers Views Company eMail

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

TCS, Saama Tech,

4 7008

What is your daily office routine?

Data Vision,

1201

which will default fire firstĀ  statement level trigger or row level trigger

Data Vision, Cap Gemini,

2 4924




Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

TCS,

1 1596

How did you export data from database to excel file.

TCS,

1 3369

Difference between global and parameter variables?

TCS,

803

What is extent clause in table space?

TCS,

1 1490

What is the use of time stamp in select statement?

TCS,

1 1907




Which data type doesn't allow null data type?

TCS,

6 4792

What is window clause?

TCS,

1 2192

Can you alter start with clause?

TCS,

1 2718

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

JPMorgan Chase,

3 5573

write a query to find 4th max salary

7 3277

How global cursor can be declare with dynamic trigger ?

1024

how view used for security purposes?

Glam India,

3 2920


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

What are instead of triggers?

4


How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

382


Explain ttitle and btitle.

1


How are functions and procedures called in PL/SQL?

9


What are the uses of merge?

1






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

147


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1066


What is Histogram?

425


Can cursors be part of a trigger body?

3


Differentiate between syntax and runtime errors.

3


Explain raise_application_error.

3


Differentiate between sga and pga.

5


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

10


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

3


Explain commit, rollback and savepoint.

1