SQL Plus Interview Questions from Various Oracle Job Tests

What do you understand by Connect by Prior?

What is the difference between Sorting and Grouping?

What do you understand by a sub query?

Explain Referential Integrity.

What is the difference between subquery and join?

Explain the various types of SQL.

Describe the uses of SAVEPOINTS.

What do you mean by Correlated sub query?

What is a Scrollable Cursor?List the various tablespaces in database.

How can we drop a table column?

List the various PL/SQL exceptions.

Various cursor exceptions in pl/sql.

How can replace null value with a text?

Can we update or delete a view?

Describe the Explicit cursor attributes.

Explain the various Implicit cursor attributes.

How can we use a select statement to replace a comma with a blank?

Do you know about any pseudo columns?

What is use of sign function?

How can we access the n’th row in a table?

What do you mean by UNION, UNION All?

What is MINUS, INTERSECT?

Define a transaction.

What do you mean by a join?

How do we know what version oracle is installed and related information?

How can you quickly access a row in a table?

What do you know about referential integrity constraint?

Are LONG COLUMNS used in WHERE clause or ORDER BY?

How to show the number value in words?

Which date function returns a number?

Definition of a sub query.

What do you understand by a correlated sub-query?

Explain the points of difference between INSTR and SUBSTR.

Explain the ROWID.

Are the changes visible on the base table, if we change teh view on a single base table?

How can the duplicate rows be removed?

How can we show the row number along with records?

What are the requirements to change datatype of a column?

How to add a column with NOT NULL constraint?

Benefit of Savepoints.

Various data types used in a table

Explain the difference between VARCHAR2 and CHAR

Tell about the size of each type.

Where do we store the integrity constraints?

How is an integrity constraint activated or deactivated?

What do you understand by a database link?

If we make a unique key constraint on Date Column, will the rows with SYSDATE be validated?

How can we get access to two values in a sequence?

What does a CYCLE / NO CYCLE mean in a sequence?

Describe the various benefits of VIEW.