Oracle 11g New Features_15 March

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By James Richardson
J
James Richardson
Community Contributor
Quizzes Created: 13 | Total Attempts: 11,383
| Attempts: 74
SettingsSettings
Please wait...
  • 1/14 Questions

    Optimizer can choose to share plans based on the use of bind variables?

    • True
    • False
Please wait...
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.

Oracle 11g New Features_15 March - Quiz

Quiz Preview

  • 2. 

    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. Database
    Explanation
    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:

  • 3. 

    Which one of these is most preferred in OLTP?

    • 1NF

    • 2NF

    • 3NF

    • 4NF

    Correct Answer
    A. 3NF
    Explanation
    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:

  • 4. 

    DDL operations require which of the following locks?

    • Table Exclusive

    • Row Exclusive

    • Row Shared

    • User Lock

    Correct Answer
    A. Table Exclusive
    Explanation
    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:

  • 5. 

    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 Area
    Explanation
    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:

  • 6. 

    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 locks
    Explanation
    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:

  • 7. 

    Which of the following will be impacted after Table compression?

    • Views

    • Indexes

    • Triggers

    • Partitions

    Correct Answer
    A. Indexes
    Explanation
    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:

  • 8. 

    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 these
    Explanation
    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:

  • 9. 

    During any database operation DBMS fetches information from?

    • Disk

    • Memory

    • Logs

    • None of these

    Correct Answer
    A. Memory
    Explanation
    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:

  • 10. 

    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 Operation
    Explanation
    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:

  • 11. 

     Which of the following is a type of segment in Oracle?

    • Views

    • Tables

    • Procedures

    • Partitions

    Correct Answer(s)
    A. Tables
    A. Partitions
    Explanation
    Tables and partitions are both types of segments in Oracle. Tables are the basic unit of data storage in a database, where data is organized in rows and columns. Partitions, on the other hand, are a way to divide a large table into smaller, more manageable pieces. Each partition is treated as a separate segment, allowing for better performance and easier maintenance. Both tables and partitions play a crucial role in storing and managing data in Oracle databases.

    Rate this question:

  • 12. 

    The best way to tune an application is?

    • Modify database parameters

    • Tune query

    • Tune application

    • None of these

    Correct Answer
    A. Tune application
    Explanation
    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:

  • 13. 

    Use of virtual columns is against transitive dependency principles related to Normalization?

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 14. 

    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 set
    Explanation
    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:

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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 11, 2013
    Quiz Created by
    James Richardson
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.