|
Question |
Rating |
View Answer |
 |
The most important DDL statements in SQL are? |
|
View Answer |
 |
What is Indexes? |
|
View Answer |
 |
What is the Delete Statements in SQL? |
|
View Answer |
 |
What is Locking? |
|
View Answer |
 |
Explain how procedures and functions are called in a PL/SQL block ? |
|
View Answer |
 |
Write the order of precedence for validation of a column in a table ? I. done using Database triggers. ii. done using Integarity Constraints. |
|
View Answer |
 |
The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records? |
|
View Answer |
 |
What is Multiple columns? |
|
View Answer |
 |
The Update Statement in SQL. |
|
View Answer |
 |
What is Consistency? |
|
View Answer |
 |
What is COMPUTE? |
|
View Answer |
 |
What are the datatypes a available in PL/SQL ? |
|
View Answer |
 |
What is a JOIN? |
|
View Answer |
 |
What are the modes of parameters that can be passed to a procedure ? |
|
View Answer |
 |
What is PL/SQL table ? |
|
View Answer |
 |
Can Commit,Rollback ,Savepoint be used in Database Triggers?If yes than HOW? If no Why?With Reasons |
|
View Answer |
 |
What is Posting? |
|
View Answer |
 |
What are the components of a PL/SQL block ? |
|
View Answer |
 |
What is difference between % ROWTYPE and TYPE RECORD ? |
|
View Answer |
 |
What is the basic structure of PL/SQL ? |
|
View Answer |