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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What is the basic structure of PL/SQL ?

6 12017

What are the components of a PL/SQL block ?

3 12671

What are the datatypes a available in PL/SQL ?

2 7178

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 12807

What is difference between % ROWTYPE and TYPE RECORD ?

2 22598

What is PL/SQL table ?

6 11338

What is a cursor ? Why Cursor is required ?

3 13585

Explain the two type of Cursors ?

Hi Caliber IT,

8 19514

What are the PL/SQL Statements used in cursor processing ?

4 10302

What are the cursor attributes used in PL/SQL ?

4 9951

What is a cursor for loop ?

4 9666

What will happen after commit statement ?

2 8243

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 14303

What is a database trigger ? Name some usages of database trigger ?

4 11268

How many types of database triggers can be specified on a table ? What are they ?

2 13765

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Which is the correct statement about truncate and delete?

1112

Why do we create stored procedures & functions in pl/sql and how are they different?

950

What is the max nvarchar size?

982

What do you mean by dbms? What are its different types?

1018

What is the usage of the distinct keyword?

1220

what is a join? : Sql dba

1036

Can I learn sql in a week?

1075

What is a sql select statement?

1040

What is rename command in sql?

1035

Difference between global and parameter variables?

1968

What is sql deadlock?

1144

Are there any features that are decommissioned in 11g that are not present in 11g?

2150

how many sql dml commands are supported by 'mysql'? : Sql dba

1123

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2113

what are the different type of sql's statements ? : Sql dba

926

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