Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is the basic structure of PL/SQL ?

6 8374

What are the components of a PL/SQL block ?

3 9458

What are the datatypes a available in PL/SQL ?

2 5256

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

4 9786

What is difference between % ROWTYPE and TYPE RECORD ?

2 20251

What is PL/SQL table ?

6 7122

What is a cursor ? Why Cursor is required ?

3 10769

Explain the two type of Cursors ?

Hi Caliber IT,

8 14833

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

4 7459

What are the cursor attributes used in PL/SQL ?

4 6916

What is a cursor for loop ?

4 6632

What will happen after commit statement ?

2 6354

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 10874

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

4 8465

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

2 11885


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

what are dynamic queries in t-sql? : Transact sql

138


How can we solve sql error: ora-00904: invalid identifier?

208


How can check sql version from command line?

109


List the ways to get the count of records in a table?

133


Explain select statements in sql?

166






In pl/sql, what is bulk binding, and when/how would it help performance?

153


Can procedure in a package be overloaded?

142


Can we insert data into materialized view?

100


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

158


Is there a 64 bit version of ssms?

111


What is full join in sql?

142


Can we group by two columns in sql?

100


What is the difference between truncate and drop statements?

172


Can you have more than one key in a database?

104


What is an example of translating a date into julian format?

161