Online Access Free 1Z0-042 Practice Test

You want to refer the employee personal information stored in operating system(OS) files in EMPLOYEE table. You plan to add a new column to EMPLOYEE table to achieve this. Which data type would you use for the new column?

• A.BLOB
• B.BFILE
• C.CLOB
• D.LONG RAW

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

• A.The ADDM requires at least four AWR snapshots for analysis.
• B.The ADDM runs after each AWR snapshot is collected.
• C.The ADDM calls other advisors if required, but does not provide recommendations about the advisors.
• D.The ADDM analysis provides only the diagnostic information but does not provide recommendations.
• E.The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).

You executed the following command to export the EMPLOYEES table from a remote machine:
$ EXPDP hr/[email protected]
DUMPFILE=my_dir:exp_hr.log
LOGFILE=data_pump_dir:log_hr.log
TABLES=employees
What would be the outcome of this command?

• A.The command would execute successfully. But log file would not be created as DATA_PUMP_DIR directory is only accessible to user with SYSDBA privilege.
• B.The command fails with an error because no absolute path is specified for log file and dumpfile.
• C.The command would execute successfully and the export dump file would be created in the destination of the directory object MY_DIR.
• D.The command fails with an error because DATA_PUMP_DIR directory have higher precedence over the per-file directory.

Your database is configured with the following parameters related to SGA:
SGA_TARGET=256MB
SHARED_POOL_SIZE=32MB
DB_CACHE_SIZE=100MB
LARGE_POOL_SIZE=0
JAVA_POOL_SIZE=0
STREAMS_POOL_SIZE=0
Which two statements are true about the configuration? (Choose two.)

• A.124 MB (256 minus 132) of memory is available for use by all the manually sized components.
• B.The shared pool and the default buffer pool will not be sized smaller than 32 MB and 100 MB, respectively.
• C.124 MB (256 minus 132) of memory is available for use by all the manually and automatically sized components.
• D.The SGA_TARGET value cannot be sized smaller than 100 MB.
• E.The shared pool and the default buffer pool will not be sized bigger than 32 MB and 100 MB, respectively.

Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

• A.Reducing the value of the SGA_TARGET parameter takes away memory from both autotuned and manually sized components.
• B.Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.
• C.Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.
• D.It can be increased up to the value of the SGA_MAX_SIZE parameter.