Oracle 1z0-062 Actual Free Exam Questions & Community Discussion

Which three statements are true about windows? (Choose three.)

Your database is open in read/write mode and multiple users are connected to the database instance.
You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?

You execute the following PL/SQL:

Which two statements are true? (Choose two.)

What must you use to read data from a table in your database and write it to an external table?

What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

Which two tasks can be performed on an external table? (Choose two.)

Which two statements are true about the RMAN validate database command? (Choose two.)

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this? (Choose three.)

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy?
(Choose two.)

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?

The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)

Examine these steps:
CONNECT / AS SYSDBA
CREATE DIRECTORY dumpdir AS '/u01/app/';
Directory created.
GRANT READ, WRITE ON DIRECTORY dumpdir TO PUBLIC;
Grant succeeded.
CREATE USER TEST IDENTIFIED BY test;
User created.
GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE TO test;
Grant succeeded.
CONN test/test
Connected.
CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER(7)); Table created.
SQL> CREATE SYNONYM emp FOR test_employees;
Synonym created.
Now examine this command:
$ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp CONTENT=data_only query='EMP:"WHERE salary=12000"' What is true about the execution of this command?

Your database has the SRV1 service configured for an application that runs on middle-tier application server.
The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE ('SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?