databases Online Quiz - 121
|Description: databases Online Quiz - 121|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Cascade option is used
To View all constraint definition and name table used is
View column associated with the constraint names view used is
can we insert a record in dual?
Can a primary key contain more than one columns?
Which one among the following is more faster?
Can we use a scalar data type as return type for CURSOR?
Can cursor variables be stored in PL/SQL tables?
Can a function take OUT parameters.?
Can the default values be assigned to actual parameters?
Can you use a commit statement within a database trigger?
Can we call a procedure from Anonymous PL/SQL block?
can we have more than one column of BLOB(data type to store images) in a table?
Which of the following can duplicate the structure and related objects of a database table?
DB2 Cursor Stablity i) Cursor Stablity Leads to Higher concurency ii) Repeatable Read Leads to Higher consistency
DB2 Indexes i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column.
DB2 Index Storate Format Indexes is Stored in
When do you open cursor before Fetching i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution.
Two or more transactions in a simultaneous wait state, each waiting for other to release before it can proceed, is called