Sawaal
  • Home/
  • Searching for I

 Searching for "I"

Q:

What is the difference between a primary key and a unique key?

Answer

By default, primary key creates a clustered index on the column, whereas a unique key creates a non clustered index by default.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

What are constraints? Mention the different types of constraints?

Answer

Constraints enable the RDBMS to enforce the integrity of the database automatically, without the need to create triggers, rule or defaults.


Types of Constraints: NOT NULL, CHEQUE, UNIQUE, PRIMARY KEY, FOREIGN KEY.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

What are defaults? Is there a column to which a default can’t be bound?

Answer

A default is a value which will be used by a column, if no value is supplied to that column while inserting data.


Yes, IDENTITY and TIMESTAMP columns are free from the bounds of default.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

What are user defined data-types and when do you use them?

Answer

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.


We use them to format the database and segregate specific repetitions of rows and columns in the database.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

State one similarity and difference between WHERE Clause and HAVING Clause?

Answer

Similarity: Both WHERE and HAVING Clause filters out records based on one or more conditions.


Difference: WHERE Clause can only be applied to a static non-aggregated column whereas HAVING is needed for aggregated columns.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

How can you generate debugging output from PL/SQL?

Answer

Use the DBMS_OUTPUT package. Another possible method is to use the SHOW ERROR command.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

How can you find a PL/SQL block, if the cursor is open?

Answer

By use of %ISOPEN status variable.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

What are PL/SQL cursor exceptions?

Answer

Cursor_Already_Open,  Invalid_Cursor.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL