[2017-New-Version!]Instant Oracle 1Z0-062 Exam Questions Free Download in Braindump2go[Q211-Q221]
2017 February NEW 1Z0-062 Exam Questions Updated Today!
Free Instant Download 1Z0-062 Exam Dumps (PDF & VCE) 272Q&As Download from www.braindump2go.com Today!
100% Real Exam Questions! 100% Exam Pass Guaranteed!
Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:
And then grantOPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true?
A. GUEST_USER can query the tables created in the USERS tablespace by default.
B. The authentication details for GUEST_USER are stored in the database password file.
C. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.
D. GUEST_USER can log on to the database without specifying a username and password.
E. GUEST_USER is forced to change the password at the first login.
Your database is configured for ARCHIVELOG mode, and a daily full database backupis taken.
RMAN is configured to perform control file autobackup.
In which three scenarios do you need media recovery?
A. loss of all the copies of the control file
B. loss of all the inactive online redo log group members
C. loss of a data file that belongs to the active undo tablespace
D. loss of data files that belong to the SYSTEM tablespace
E. logical corruption of data that is caused by a wrong transaction
F. abnormal termination of the database instance
Your database has been running with a peak load for the past hour.
You want to preserve the performance statistics collected during this period forcomparison when you analyze the performance of the database later.
What must you do to achieve this?
A. Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.
B. Createa baseline on a pair of snapshots that span the peak load period.
C. Generate Active Session History reports for the peak load period.
D. Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.
Which three statements are true about space usage alerts?
A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.
B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
C. Databasealerts can provide warnings about low space availability at both tablespace and segment levels.
D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo?
A. Performance improves because less redo is writtento the redo log.
B. Temporary undo reduces the amount of undo stored in undo tablespaces.
C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.
D. Performance improves because no redo and undo are generated for the temporary tables.
Which two statements are true about Oracle Data Pump export and import operations?
A. You cannot specify how partitioned tables shouldbe handled during an import operation.
B. Only data can be compressed during an export operation.
C. Existing dump files can be overwritten during an export operation.
D. Tables cannot be renamed during an import operation.
E. Metadata that is exported andimported can be filtered based on objects and object types.
Your database is running in NOARCHIVING mode.
Examine the following parameters:
You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?
A. It executes successfully and sets the Fast Recovery Area as the local archive destination.
B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
C. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
Your production database uses file system storage.
You want to move storage to Oracle Automatic Storage Management (ASM).
How would you achieve this?
A. by using a transportable database
B. by using the Database Upgrade Assistant (DBUA)
C. by using Data Pump
D. by using RMAN
Which two statements are true about Oracle network connections?
A. A listener may listen on behalf of only one database instance at a time.
B. A server process checks a user’s authentication credentials and creates a session if the credentials are valid.
C. The listener continuously monitors a connection after the user process connects to a service handler.
D. The listener always spawns a new server process to deal with each new connection.
E. A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.
Which two actions does an incremental checkpoint perform?
A. It signals CKPT to write thecheckpoint position to the data file headers.
B. It writes the checkpoint position to the data file headers.
C. It advances the checkpoint position in the checkpoint queue.
D. It writes the checkpoint position to the control file.
Which statement is true aboutusing the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?
A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
B. It automatically makes necessary changes to Oracle environment variables.
C. It automatically enables unified auditing in the upgraded database.
D. It automatically adds new data files if there is not enough disk space to grow.
1.|NEW 1Z0-062 Exam Dumps (PDF & VCE) 272Q&As Download:
2.|NEW 1Z0-062 Study Guide: