Oracle 11g New Features_15 March
-
Which of the following is a type of segment in Oracle?
-
Views
-
Tables
-
Procedures
-
Partitions
-
About This Quiz
This quiz titled 'Oracle 11g New Features_15 March' assesses knowledge on Oracle 11g's new features, focusing on segment types, memory operations, partitioning impacts, data integrity during DML operations, and optimizer execution plans based on filter criteria. Ideal for learners upgrading their Oracle skills.
(76).webp "Oracle 11g New Features_15 March - Quiz")
Quiz Preview
- 2.
During any database operation DBMS fetches information from?
-
Disk
-
Memory
-
Logs
-
None of these
Correct Answer
A. MemoryExplanation
During any database operation, DBMS fetches information from memory. This is because memory, also known as RAM (Random Access Memory), provides faster access to data compared to disk or logs. When a database operation is executed, the required data is loaded into memory from disk or logs, and the DBMS performs the necessary operations on the data in memory. This allows for quicker retrieval and manipulation of data, improving the overall performance of the database system.Rate this question:
-
- 3.
Which of the will be impacted when you implement partitioning on a table?
-
Select Operation
-
Insert Operation
-
Update Operation
-
None of these
Correct Answer
A. Update OperationExplanation
When partitioning is implemented on a table, the update operation will be impacted. Partitioning involves dividing a large table into smaller, more manageable partitions based on certain criteria such as range, list, or hash. This allows for improved performance and easier management of data. However, when a table is partitioned, the update operation may be affected because it may require updating data across multiple partitions, which can be more time-consuming and complex compared to updating data in a non-partitioned table.Rate this question:
-
- 4.
How is data integrity ensured during DML operations in Oracle?
-
Through constraints
-
Through latches
-
Through locks
-
The responsibility lies with the code
Correct Answer
A. Through locksExplanation
During DML operations in Oracle, data integrity is ensured through locks. Locks are used to prevent concurrent access to the same data by multiple transactions, ensuring that only one transaction can modify the data at a time. This helps to prevent data inconsistencies and maintain the integrity of the data.Rate this question:
-
- 5.
DDL operations require which of the following locks?
-
Table Exclusive
-
Row Exclusive
-
Row Shared
-
User Lock
Correct Answer
A. Table ExclusiveExplanation
DDL operations require a Table Exclusive lock because these operations involve making structural changes to the database schema, such as creating or dropping tables, altering table structures, or modifying indexes. A Table Exclusive lock ensures that no other transactions can read or modify the table while the DDL operation is in progress, preventing any potential conflicts or inconsistencies in the database.Rate this question:
-
- 6.
Oracle optimizer determines execution plans based on?
-
The way query is written
-
There is a set plan based on types of objects
-
Filter criteria
-
Expected Result set
Correct Answer(s)
A. Filter criteria
A. Expected Result setExplanation
The Oracle optimizer determines execution plans based on the filter criteria and the expected result set. It analyzes the query's filter conditions and the desired outcome to determine the most efficient way to retrieve the required data. By considering the filter criteria and expected result set, the optimizer can choose the appropriate indexes, join methods, and access paths to optimize the query execution. This helps improve the performance of the query and minimize the response time.Rate this question:
-
- 7.
Optimizer can choose to share plans based on the use of bind variables?
-
True
-
False
Correct Answer
A. TrueExplanation
The optimizer can choose to share plans based on the use of bind variables because bind variables allow for the reuse of execution plans for different SQL statements that have the same structure but different values. This can improve performance by avoiding the need to generate a new execution plan each time a similar SQL statement is executed. By using bind variables, the optimizer can identify and share execution plans among different SQL statements, resulting in better query performance and resource utilization.Rate this question:
-
- 8.
Which of the following will be impacted after Table compression?
-
Views
-
Indexes
-
Triggers
-
Partitions
Correct Answer
A. IndexesExplanation
After table compression, the indexes will be impacted. Table compression reduces the size of the table by eliminating unused space and compressing the data. This can affect the indexes because the compressed data may not be organized in the same way as before, leading to changes in the index structure. As a result, the indexes may need to be rebuilt or reorganized to reflect the new compressed table.Rate this question:
-
- 9.
You are the owner of an application that is shared by global users. The underlying database stores the sensitive data that is to be restricted based on a set of conditions. The best place to restrict the access is
-
Client
-
Application
-
Database
-
Not possible
Correct Answer
A. DatabaseExplanation
The best place to restrict access to sensitive data stored in an application shared by global users is the database. By implementing access controls and security measures at the database level, you can ensure that only authorized users have the necessary permissions to access and manipulate the data. This approach provides a centralized and robust solution, as it protects the data regardless of the client or application being used. Restricting access at the client or application level may not be as effective, as it can be bypassed or exploited by knowledgeable users.Rate this question:
-
- 10.
The database code for your application generates a huge amount of log which needs to be cleared regularly. What is the best way to achieve that?
-
A chron job on server
-
A database job
-
An autosys job
-
All of these
Correct Answer
A. All of theseExplanation
All of these options can be used to achieve the goal of clearing the huge amount of log generated by the database code. A chron job on the server can be scheduled to run at specific intervals and execute a script or command to clear the logs. A database job can be created within the database management system to perform the log clearing task. And an autosys job, which is a job scheduling and management tool, can also be utilized to automate the log clearing process. Therefore, all of these options are valid and effective ways to achieve the desired outcome.Rate this question:
-
- 11.
Which one of these is most preferred in OLTP?
-
1NF
-
2NF
-
3NF
-
4NF
Correct Answer
A. 3NFExplanation
In OLTP (Online Transaction Processing), the most preferred normalization form is 3NF (Third Normal Form). This form minimizes data redundancy and ensures that each column in a table is dependent only on the primary key. It eliminates transitive dependencies, where a non-key attribute depends on another non-key attribute. By organizing data in 3NF, it becomes easier to maintain data integrity, improve data consistency, and optimize query performance in transactional systems.Rate this question:
-
- 12.
Use of virtual columns is against transitive dependency principles related to Normalization?
-
True
-
False
Correct Answer
A. FalseExplanation
The use of virtual columns does not go against the principles of transitive dependency related to normalization. Transitive dependency occurs when a non-key attribute depends on another non-key attribute through a key attribute. Virtual columns are computed columns that are not physically stored in the database but are dynamically generated based on other columns. They do not introduce any new dependencies and do not violate normalization principles. Therefore, the statement is false.Rate this question:
-
- 13.
Which of the following is not a part of SGA?
-
Shared pool
-
Java pool
-
Redo log buffer
-
Private SQL Area
Correct Answer
A. Private SQL AreaExplanation
The Private SQL Area is not a part of the System Global Area (SGA). The SGA is a shared memory region in the Oracle database that contains data and control information for the database instance. It includes the Shared Pool, which stores shared SQL and PL/SQL statements, the Java Pool, which stores Java objects and code, and the Redo Log Buffer, which stores redo log records. The Private SQL Area, on the other hand, is a part of the Program Global Area (PGA), which is a memory region specific to each server process and stores private SQL and PL/SQL statements.Rate this question:
-
- 14.
The best way to tune an application is?
-
Modify database parameters
-
Tune query
-
Tune application
-
None of these
Correct Answer
A. Tune applicationExplanation
To tune an application means to optimize its performance. Modifying database parameters may improve the performance of the database, but it does not directly address the application itself. Tuning the query can enhance the efficiency of retrieving data from the database, but it still does not encompass the entire application. Therefore, the best way to tune an application is to specifically optimize and fine-tune the application code and logic, ensuring that it runs efficiently and effectively.Rate this question:
-
Quiz Review Timeline (Updated): Aug 25, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Aug 25, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 11, 2013Quiz Created by
James Richardson
Back to top