Which statements are true regarding SecureFile LOBs? (Choose all that apply.)
A. The amount of undo retained is user controlled.
B. SecureFile LOBs can be used only for nonpartitioned tables.
C. Fragmentation is minimized by using variable-sized chunks dynamically.
D. SecureFile encryption allows for random reads and writes of the encrypted data.
E. It automatically detects duplicate LOB data and conserves space by storing only one copy.
Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)
A. It is possible to have tablespaces of different block sizes in a database.
B. A data block is the smallest unit of I/O for data files.
C. Multiple tablespaces can share single data file.
D. Each data block in the database always corresponds to one OS block.
E. Each segment contains one or more extents.
You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users’ passwords?
A. All passwords automatically become case-sensitive.
B. All passwords remain non-case-sensitive till they are changed.
C. All passwords remain non-case-sensitive and cannot be changed.
D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.
What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)
A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?
A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
B. Capture the plans from the previous version using STS and then load them into the stored outline.
C. Capture the plans from the previous version using STS and then load them into SQL Management
D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being
loaded to the SQL plan baseline.
You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:
ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H; Which statement is true in this scenario?
A. It starts the ASM fast mirror resync.
B. It drops all disk paths from the dga disk group.
C. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute
would be set to 5 hours.
D. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME
disk attribute would be set to 5 hours.
Which three statements are true about the stages of database startup? (Choose three.)
A. Data files and redo log files can be renamed at the MOUNT stage.
B. Control files are required to bring the database to the NOMOUNT stage.
C. Data files and online redo log files are checked for consistency while opening the database.
D. Data files and redo log files are made available to users at the OPEN stage.
E. Control files are read at the OPEN stage for the location of data files.
Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)
A. It translates tasks into jobs for execution by the scheduler.
B. It creates jobs without considering the priorities associated with them.
C. It determines the list of jobs that must be created for each maintenance window.
D. It is spawned by the MMON background process at the start of the maintenance window.
E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE
D. It produces advice only for new failures and the failures listed in the last LIST FAILURE command
Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)
A. renaming of control files
B. multiplexing of control files
C. dropping the database user
D. configuring the database in ARCHIVELOG mode
E. renaming of data files
If you want to pass Oracle 1Z0-050 successfully, do not missing to read latest lead2pass Oracle 1Z0-050 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.