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

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?

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.

How are functions and procedures called in PL/SQL?

What are the uses of merge?

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?

Differentiate between syntax and runtime errors.

Explain raise_application_error.

Differentiate between sga and pga.

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

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

Explain commit, rollback and savepoint.

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