Question 1

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

technology databases

255
256
300
225

Answer

Correct Option: A

Question 2

Where would you look for errors from the database engine?

technology databases

Database Log
Alert Log
Error Log
Session Log

Answer

Correct Option: B

Question 3

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

technology databases

1
2
3
4

Answer

Correct Option: B

Question 4

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

technology databases

11
14
10
12

Answer

Correct Option: D

Question 5

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

technology databases

WHERE
ORDER BY
GROUP BY
Aggregate Function

Answer

Correct Option: C

Question 6

Identify the OLAP function from the given options

technology databases

MSUM
SUM
AVG
All of the above

Answer

Correct Option: A

Question 7

This table will have duplicate rows

technology databases

Volatile Table
Global Temporary table
MultiSet Table
Permanent Table

Answer

Correct Option: C

Question 8

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

2GB of spool space
5GB of spool space
2GB of permanent space
3GB of spool space

Answer

Correct Option: B

Question 9

While creating a table Primary key is defined but not Primary Index, then this will be considered as Primary Index

technology databases

Secondary Index
First unique column in the table
Primary key
First non-unique coulmn in the table

Answer

Correct Option: C

Question 10

Statistics cannot be collected on this table

technology databases

Permanent Table
Set Table
Multiset Table
Volatile Table

Answer

Correct Option: D

Question 11

This temporary table will not be dropped once the session is signed off

technology databases

Volatile Temporary Table
Global Temporary table
MultiSet Table
Permanent Table

Answer

Correct Option: B

Question 12

Volatile temporary table is materialized at

technology databases

Temporary Space
Spool Space
Permanent Space
Any of the above

Answer

Correct Option: B

Question 13

Intermediate results of the user query is materialized at

technology databases

Temporary Space
Spool Space
Permanent Space
Any of the above

Answer

Correct Option: B

Question 14

An USER cannot have these if Permanent space is not allocated to it

technology databases

Permanent Table and Stored Procedure
Permanent View and Stored Procedure
Macros and Stored Procedure
None of the above

Answer

Correct Option: A

Question 15

This table will have duplicate rows

technology databases

Volatile Table
Global Temporary table
MultiSet Table
Permanent Table

Answer

Correct Option: C

Question 16

While creating a table Primary key is defined but not Primary Index, then this will be considered as Primary Index

technology databases

Secondary Index
First unique column in the table
Primary key
First non-unique coulmn in the table

Answer

Correct Option: C

Question 17

This temporary table will not be dropped once the session is signed off

technology databases

Volatile Temporary Table
Global Temporary table
MultiSet Table
Permanent Table

Answer

Correct Option: B

Question 18

Volatile temporary table is materialized at

technology databases

Temporary Space
Spool Space
Permanent Space
Any of the above

Answer

Correct Option: B

Question 19

Intermediate results of the user query is materialized at

technology databases

Temporary Space
Spool Space
Permanent Space
Any of the above

Answer

Correct Option: B

Question 20

An USER cannot have these if Permanent space is not allocated to it

technology databases

Permanent Table and Stored Procedure
Permanent View and Stored Procedure
Macros and Stored Procedure
None of the above

Answer

Correct Option: A

Description: databases Online Quiz - 102
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 102

Find more quizzes from top tags