Which setting enables the baselines by default in Oracle Database 11g?
A. setting the STATISTICS_LEVEL parameter to TYPICAL
B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
C. enabling Automated Maintenance Task using Oracle Enterprise Manager
D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)
A. Diagnose and repair a data file corruption offline.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair failures on a standby database.
D. Recover from failures in the Real Application Cluster (RAC) environment.
In which cases is reference partitioning effective in enhancing performance?
A. It is effective only in partition pruning.
B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
Your database initialization parameter file has the following entry:
Which statement is true regarding this setting?
A. It is enforced only if the password profile is enabled for the user.
B. It locks the user account after the specified number of attempts.
C. It drops the connection after the specified number of login attempts fail for any user.
D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
In which of the scenario will the DBA perform recovery? (Choose all that apply)
A. The alert log file is corrupted
B. One of the redo log members is corrupted
C. A database user terminates the session abnormally
D. The hard disk on which the data files is stored is corrupted
E. A tablespace is accidentally dropped
Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
A. An SPFILE can be read by the database server, but it is not written to by the server
B. An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database
C. An SPFILE is a binary file
D. An SPFILE can store changes persistently across instance restarts
E. An SPFILE cannot contain static parameters
F. An SPFILE cannot reside on a client
Which two statements are true about the Automatic Database Diagnostic Monitor(ADDM)? (Choose two.)
A. The ADDM analysis provides only diagnostics information but does not provide recommendations
B. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
C. The ADDM runs after each AWR snapshot is collected automatically by MMON
D. The ADDM calls other advisors if required, but does not provide recommendations about the advisors
E. The ADDM requires at least four AWR snapshots for analysis
On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.)
A. data files
B. control files
D. password file
E. parameter file
F. whole database
G. flashback log file
H. archived log files
I. change tracking file
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?
A. Set a threshold for the default system-defined moving window baseline.
B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
C. Modify the profile for the targeted users for which control needs to be imposed.
D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition?
A. The materialized log should be dropped before the online table redefinition process.
B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
C. Referential integrity constraints must be manually enabled after the online table redefinition process.
D. The dependent materialized view should have a complete refresh performed after the online table redefinition process.
Pass 1Z0-050 In First Try Passleader 1Z0-050 Real Dumps With 100% Money Back