Oracle Quiz With Questions & Answers

1. Maximum Number Of Column A Table Can Have In Oracle?

100

500

1000

2000

In Oracle, the maximum number of columns a table can have is 1000. This means that a table can have up to 1000 different columns to store data. Having a high limit like this allows for more flexibility and complexity in database design, as it can accommodate a wide range of data types and attributes. It is important to note that having a large number of columns in a table can impact performance and efficiency, so it is recommended to carefully consider the design and organization of data when approaching this limit.

Explanation

In Oracle, the maximum number of columns a table can have is 1000. This means that a table can have up to 1000 different columns to store data. Having a high limit like this allows for more flexibility and complexity in database design, as it can accommodate a wide range of data types and attributes. It is important to note that having a large number of columns in a table can impact performance and efficiency, so it is recommended to carefully consider the design and organization of data when approaching this limit.

2. AWR is acronym for

AWR stands for Automated Workload Repository. It is a built-in feature of Oracle Database that collects and stores performance statistics of the database. AWR provides a historical perspective of the database workload and can be used for performance tuning and troubleshooting. The repository stores data such as SQL statements, wait events, system statistics, and other performance-related information. By analyzing the data in AWR, database administrators can identify performance bottlenecks, diagnose issues, and make informed decisions to optimize the database performance.

Explanation

AWR stands for Automated Workload Repository. It is a built-in feature of Oracle Database that collects and stores performance statistics of the database. AWR provides a historical perspective of the database workload and can be used for performance tuning and troubleshooting. The repository stores data such as SQL statements, wait events, system statistics, and other performance-related information. By analyzing the data in AWR, database administrators can identify performance bottlenecks, diagnose issues, and make informed decisions to optimize the database performance.

Submit

3. You are using command prompt to access Oracle db. If you want to switch to DOS prompt, then you will type?

To switch to the DOS prompt while using command prompt to access Oracle db, the correct command to be typed is "host" or "Host". This command allows the user to temporarily exit from the command prompt and access the DOS prompt.

Explanation

To switch to the DOS prompt while using command prompt to access Oracle db, the correct command to be typed is "host" or "Host". This command allows the user to temporarily exit from the command prompt and access the DOS prompt.

Submit

4. Oracle Datapump Introduced In Which Version?

Oracle 9i

Oracle 10g

Oracle 11g

Can't say

not-available-via-ai

Explanation

not-available-via-ai

5. Which Analytical Function Has Been Added In Oracle 11g?

REGEXP_SUBSTR

REGEXP_INSTR

REGEXP_COUNT

REGEXP_LIKE

In Oracle 11g, the REGEXP_COUNT function has been added. This function is used to count the number of occurrences of a pattern in a string. It takes two arguments - the string to be searched and the regular expression pattern to be matched. The function returns the number of times the pattern is found in the string.

Explanation

In Oracle 11g, the REGEXP_COUNT function has been added. This function is used to count the number of occurrences of a pattern in a string. It takes two arguments - the string to be searched and the regular expression pattern to be matched. The function returns the number of times the pattern is found in the string.

6. Which set operator can be used to join two sub-queries ?

Union

Union All

Intersect

Minus

The Intersect set operator can be used to join two sub-queries. It returns the common rows between the two sub-queries, eliminating any duplicate rows. This operator is useful when you want to find the intersection of two result sets, i.e., the rows that are present in both sub-queries.

Explanation

The Intersect set operator can be used to join two sub-queries. It returns the common rows between the two sub-queries, eliminating any duplicate rows. This operator is useful when you want to find the intersection of two result sets, i.e., the rows that are present in both sub-queries.

7. Truncate command has following attributes

Redo log generated for truncate

Redo log not generated for truncate

Lowers HWM

No effect on HWM

The correct answer is "Redo log not generated for truncate, Lowers HWM." When the truncate command is used, it does not generate a redo log. This means that the changes made by the truncate command are not recorded in the redo log, which can be useful for performance reasons. Additionally, the truncate command lowers the high water mark (HWM) of a table. The HWM represents the maximum amount of space that has been allocated to a table, and by lowering it, the truncate command frees up space in the table for future use.

Explanation

The correct answer is "Redo log not generated for truncate, Lowers HWM." When the truncate command is used, it does not generate a redo log. This means that the changes made by the truncate command are not recorded in the redo log, which can be useful for performance reasons. Additionally, the truncate command lowers the high water mark (HWM) of a table. The HWM represents the maximum amount of space that has been allocated to a table, and by lowering it, the truncate command frees up space in the table for future use.

Submit