Oracle server generates a name by using which format
sys_cn
ora_cn
tab_cn
col_cn
Constraints are defined at which level
row, column
row, table
column, table
all of above
Cascade option is used
disable dependent integrity constraint
deactivate an integrity constraint
both of above
none of above
To View all constraint definition and name table used is
sys_constraints
user_constraints
tab_constraints
col_constraints
View column associated with the constraint names view used is
user_tab_columns
user_cons_columns
user_sys_columns
can we insert a record in dual?
True
False
Can a primary key contain more than one columns?
Which one among the following is more faster?
IN
EXISTS
LIKE
EXIST
Can we use a scalar data type as return type for CURSOR?
Can cursor variables be stored in PL/SQL tables?