What does the following query Do?
Null
The Null values of COMMISSION column will be displayed as Null after addition to sal
The Null values of COMMISSION column will be changed to 0 & will be added to sal
Syntax error
Examine the SQL Statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement?
) SER_NO, PROD_ID_NUMBER
ORDER_ID and ORDER_DATE
SER_NO, Composite index on ORDER_ID and ORDER_DATE
SER_NO, ORDER_ID and ORDER_DATE
How many LONG columns are allowed in a table ?
0
1
8
Any number
The data contained in Materialized view will be deleted automatically if the base tables will be deleted?
True
False
Find the error in the line for the query written below?
Line 1
Line 2
Line 3
Line 4
Can a view be created be based on another view definition?
Does the view exist if the table is dropped from the database?
Is this a valid join condition written in the query below?
Can we create index on Materialized Views?
The RowID can be changed for the particular row whenever any insert or update operation is performed on the table?