Tag: databases

Questions Related to databases

What does the following query Do?
technology databases

  1. Null

  2. The Null values of COMMISSION column will be displayed as Null after addition to sal

  3. The Null values of COMMISSION column will be changed to 0 & will be added to sal

  4. Syntax error

Show answer
Correct Option: C

Examine the SQL Statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement?
technology databases

  1. ) SER_NO, PROD_ID_NUMBER

  2. ORDER_ID and ORDER_DATE

  3. SER_NO, Composite index on ORDER_ID and ORDER_DATE

  4. SER_NO, ORDER_ID and ORDER_DATE

Show answer
Correct Option: C

How many LONG columns are allowed in a table ?

technology databases

  1. 0

  2. 1

  3. 8

  4. Any number

Show answer
Correct Option: B

The data contained in Materialized view will be deleted automatically if the base tables will be deleted?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Find the error in the line for the query written below?
technology databases

  1. Line 1

  2. Line 2

  3. Line 3

  4. Line 4

Show answer
Correct Option: D

Can a view be created be based on another view definition?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Does the view exist if the table is dropped from the database?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Is this a valid join condition written in the query below?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Can we create index on Materialized Views?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The RowID can be changed for the particular row whenever any insert or update operation is performed on the table?
technology databases

  1. True

  2. False

Show answer
Correct Option: B