Oracle Database 12c: Installation and Administration
Question No: 141
Which two are prerequisites for performing a flashback transaction?
Flashback Database must be enabled.
Undo retention guarantee for the database must be configured.
EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
Supplemental logging must be enabled.
Recycle bin must be enabled for the database.
Block change tracking must be enabled tor the database.
Answer: A,C Explanation:
Question No: 142
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?
The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds
Setting the target tablespace to read-only
The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
Setting the target tablespace offline
The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
Answer: B,C Explanation:
The value for TBS_PERCENT_USEDspecifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.
Question No: 143
Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE: SQLgt; ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?
It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
It succeeds only if memory is available from the autotuned components if SGA.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
Answer: D Explanation:
The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced.
Forexample, suppose you have an environment with the following configuration:
SGA_MAX_SIZE = 1024M SGA_TARGET = 512M DB_8K_CACHE_SIZE = 128M
In this example, the value of SGA_TARGET can be resized up to 1024M and can also be reduced until one or more of theautomatically sized components reaches its minimum size. The exact value depends on environmental factors such as the number of CPUs on the system. However, the value of DB_8K_CACHE_SIZE remains fixed at all times at 128M
Size of cachefor 8K buffers
For example, consider this configuration:
SGA_TARGET = 512M DB_8K_CACHE_SIZE = 128M
In this example, increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducingDB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the automatically sized components.
Question No: 144
To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?
It results in an error because these parameter settings are invalid.
One 64G flash cache file will be used.
Two 64G flash cache files will be used.
Two 32G flash cache files will be used.
Question No: 145
You upgradedfrom a previous Oracle database version to Oracle Database version to Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want tocollect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?
Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required
Answer: D Explanation:
Monitoring database operations
Real-Time Database Operations Monitoring enables you to monitor long running database tasks such as batch jobs, scheduler jobs, and Extraction, Transformation, and Loading (ETL) jobs as a composite business operation. This feature tracks the progress of SQL and PL/SQL queries associated with the business operation being monitored. As a DBA or developer, you can define business operations for monitoring by explicitly specifying the start and end of the operation or implicitly with tags that identify the operation.
Question No: 146
In which situations does the Database Writer process (DBWn) write to data files?
when the RMAN recovery process starts
when a user process commits a transaction
when a tablespace is made read-only or taken offline
when PMON cleans up dirty buffers in the database buffer cache
when clean buffers for reading new blocks into the database buffer cache are not found easily
Question No: 147
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
Oracle Data Pump
Oracle Recovery Manager (RMAN)
Oracle Label Security
Oracle Database Vault
Oracle Real Application Security
Question No: 148
What should you do to ensure that a job stored minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?
Create an event-based job.
Create a lightweight job.
Specify the job as amember of a job class.
Use a job array.
Answer: B Explanation: References:
Question No: 149
Which two statements are true about the logical storage structure of an Oracle database?
An extent contains data blocks that are always physically contiguous on disk.
An extent can span multiple segments.
Each data block always corresponds to one operating system block.
It is possible to have tablespaces of different block sizes.
A data block is the smallest unit of I/O in data files.
Answer: B,D Explanation: References:
Question No: 150
Examine the commands executed to monitor database operations:
$gt; conn sys oracle/oracle@prod as sysdba SQL gt; VAR eid NUMBER
SQL gt;EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING =gt; ‘Y’);
Which two statements are true?
Database operations will be monitored only when they consume a significant amount of resource.
Database operations for all sessions will be monitored.
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC TUNING.
Only DML and DDL statements will be monitored for the session.
All subsequent statements in the session will be treated as one database operation and will be monitored.
Answer: C,E Explanation:
C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function
starts a composite database operation in the current session.
/ (E) FORCE_TRACKING – forces the composite database operation to be tracked when the operation starts. You can also use the string variable #39;Y#39;.
/ (not A) NO_FORCE_TRACKING – the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable #39;N#39;.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|