Which of these following features are correct if SQL is a set-oriented language?
Individual rows must have a unique identifier
Sets of users can be managed in groups
One statement can affect multiple rows
SQL statements can be placed within blocks of code
All the above
What are the disadvantages of SQL ?
Cannot drop a field
Cannot rename a field
Cannot manage memory
Index on view or index on index not provided
View updation problem
What is the result of the following SQL: Select 1 from dual UNION Select 'A' from dual;
Error
1 & A are retreived
1 is retreived
A is retreived
Index can be created on view?
True
False
What's the length of SQL integer ?
32 bit
64 bit
18 bit
None of the above
What languages can run within the oracle database?
Java
Any other language linked to the OCI libraries
SQL
C
PL/SQL
All the above expect Option 2
Dual table can be deleted, dropped or altered or updated or inserted ?
For which relational operators in where clause, index is not used ?
<>
like '%...' is NOT functions
field +constant
field||''
AND
Oracle is the sole proprietor of grid concept
The SQL application developer need not know how the Grid has been implemented