Tag: databases

Questions Related to databases

What is the maximum number of statements that can be specified in a trigger statement?

technology databases

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: A

Which of the following is not a schema object?

technology databases

  1. Index

  2. Tables

  3. Public Synonymns

  4. Triggers

Show answer
Correct Option: C

What is the maximum number of Nested SubQueries used in WHERE Clause?
technology databases

  1. 255

  2. 256

  3. 300

  4. 225

Show answer
Correct Option: A

Where would you look for errors from the database engine?
technology databases

  1. Database Log

  2. Alert Log

  3. Error Log

  4. Session Log

Show answer
Correct Option: B

What are the min.extents allocated to a rollback extent?
technology databases

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: B

What is the maximum number of triggers, can apply to a single table?
technology databases

  1. 11

  2. 14

  3. 10

  4. 12

Show answer
Correct Option: D

When the 'SELECT' clause of the SQL has the aggregate function, it is must to have this clause to prevent error
technology databases

  1. WHERE

  2. ORDER BY

  3. GROUP BY

  4. Aggregate Function

Show answer
Correct Option: C

Identify the OLAP function from the given options
technology databases

  1. MSUM

  2. SUM

  3. AVG

  4. All of the above

Show answer
Correct Option: A

This table will have duplicate rows
technology databases

  1. Volatile Table

  2. Global Temporary table

  3. MultiSet Table

  4. Permanent Table

Show answer
Correct Option: C

When Database A has 5GB of spool space, Database B is created as child of Database A with 3GB of spool space, then Database A will have
technology databases

  1. 2GB of spool space

  2. 5GB of spool space

  3. 2GB of permanent space

  4. 3GB of spool space

Show answer
Correct Option: B