Flydumps is one of the leading exam preparation material providers.We have a complete range of exams offered by the top vendors of their respective industries. You can download Oracle https://www.pass4itsure.com/1z0-040.html free demos in PDF files that are the latest.
At 6:00 p.m. you noticed that the database performance was slow between 2:00 p.m. and 6:00 p.m. due to a series of interrelated problems. You plan to use the Automatic Database Diagnostic Monitor (ADDM) findings for the time period 2:00 p.m. to 6:00 p.m. to resolve the performance issue. The Automatic Workload Repository (AWR) snapshots are made every 30 minutes. What would you do?
A. Look at the latest ADDM report
B. Check the alert log to see if it contains ADDM advice
C. Modify the time interval by using the DBMS_JOB.INTERVAL procedure
D. Check for the ADDM advice trace file in the BACKGROUND_DUMP_DEST directory
E. Modify the Automatic Workload Repository (AWR) snapshot retention period to four hours
F. Create a custom ADDM task over the period defined by the snapshots taken at 2:00 p.m. and 6:00
Correct Answer: F
In an online transaction processing (OLTP) environment, you find that the transaction tables get heavily fragmented during the week. You decide to defragment the transaction tables on every Friday at 9:30 p.m. to gain performance. Which two new features of the Oracle 10 g database could you use to automate this task? (Choose two.)
A. the DBMS_AQ package
B. the DBMS_IJOB package
C. the OS level job automation tool
D. the DBMS_SCHEDULER package
E. Enterprise Manager job scheduling
Correct Answer: DE
You are checking every 10 minutes for alerts regarding the violation of tablespace usage threshold. Some of the tablespaces’ fullness was not detected on time. As a result the transactions were aborted before you had a chance to resolve the space issue. What would you do to avoid transaction failures?
A. use bigfile tablespaces (BFTs)
B. enable resumable space allocation
C. modify the background process PMON settings
D. modify the LOG_CHECKPOINT_TIMEOUT parameter
E. reduce the default tablespace usage threshold values for the database
Correct Answer: B
Sam is a DBA of an OLTP system that has a large number of users. He receives a complaint from two users with client ids Richard and Hardy that the Application response time is poor. To understand the problem faced by Richard and Hardy better, Sam wants to gather the statistics for all active sessions of these clients for a particular instance. Which two of these steps should Sam perform and in which order to view the relevant information? 1. Execute DBMS_MONITOR.CLIENT_ID_STAT_ENABLE procedure for the two clients. 2. Execute DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE procedure for the two clients.
3. View the data in the V$CLIENT_STATS view. 4. View the data in the V$SERVICE_STATS view.
A. 1, 3
B. 1, 4
C. 2, 3
D. 2, 4
Correct Answer: A
You want to convert your existing non-ASM files to ASM files for the database PROD . Which method or command would you use to accomplish this task?
A. the CONVERT command of RMAN
B. Data Pump Export and Import
C. conventional export and import
D. the BACKUP .. RESTORE .. command of RMAN
E. the BACKUP AS COPY DATABASE .. command of RMAN
Correct Answer: E
Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)
A. set LOG_BUFFER to zero
B. set SHARED_POOL_SIZE to zero
C. set DB_CACHE_SIZE to a non-zero value
D. set STATISTICS_LEVEL to BASIC
E. set SGA_TARGET to a non-zero value
F. set STATISTICS_LEVEL to TYPICAL or ALL
Correct Answer: EF
You have three production databases, HRDB , FINDB , and ORGDB , that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?
A. All the instances, including the ASM instance, are shut down in the ABORT mode.
B. The ASM instance is shut down, but the other instances are still running.
C. The ASM instance is still functional, but the other instances are shut down.
D. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
E. HRDB , FINDB , and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
F. HRDB , FINDB , and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode.
Correct Answer: D
To which three elements is the size of the block change tracking file proportional? (Choose three.)
A. number of redo log groups
B. number of DBWR processes
C. size of the database in bytes
D. number of archiving destinations
E. number of old backups maintained by the block change tracking file
F. number of enabled threads in a Real Application Cluster (RAC) environment
Correct Answer: CEF
Which two statements regarding unusable indexes are correct? (Choose two.)
A. You can set SKIP_UNUSABLE_INDEXES to true to skip unusable indexes.
B. You can check the alert log file to get a message recorded about unusable indexes.
C. You do not need to set any parameter because unusable indexes are skipped automatically.
D. Your Data Definition Language (DDL) statement shows a warning message when an index is made unusable.
Correct Answer: AB
View the Exhibit and examine the Data Pump architecture. Identify the numbered components.
Flydumps Oracle 1Z0-040 practice tests are composed of latest exam questions formulate an actual exam scenario with an intent to expose your potentials and latent skills. Our Microsoft practice tests encompass all the fundamental of Oracle https://www.pass4itsure.com/1z0-040.html exam formats, orients your efforts towards guaranteed success for Oracle 1Z0-040 exams. You can hit your target with assurance if you have opted for our Oracle 1Z0-040 practice test training.