Which index is automatically created if you enable a UNIQUE KEY or PRIMARY KEY constraint
cluster index
simple index
unique index
functional index
We can insert a new column in between two existing columns without altering the table.
True
False
Can we use a subquery in insert statement
maximum limit of VARCHAR2 datatype in SQL & PLSQLRespectively
4000 / 4000
4000 / 32767
2000 / 4000
None of these
Default type of compilation in Oracle
INTERPRETTED
NATIVE
BOTH
A Package spec is compulsory but a package Body is not compulsory
For a certain row ina table, a VARCHAR2 coilumn contains the value TCSLTD, padded to the right with seven spaces by the application when the length() function processes the coplumn value , what will be the value returned
6
13
30
60
Dropping of table has which of the following effects on the non unique index created on the table
no effect
The Index will be dropped
The index will become unusable
the index will have NULLvalues
You cannot drop a table until you drop the index
Which of the following requires correlated subquery
IN
BETWEEN
LIKE
EXISTS
Which of the following is a valid statement for Sequences
IDENTIFIED BY
USING TEMPORARY TABLESPACE
MAXVALUE
ON DELETE CASCADE
CURRVAL
NEXTVAL