Our Oracle 1z0-062 dumps are key to get success. More than 80000+ success stories.
Clients Passed Oracle 1z0-062 Exam Today
Passing score in Real Oracle 1z0-062 Exam
Questions were from our given 1z0-062 dumps
Which four are true about creating and running a remote database scheduler jobs? (Choose four.)
A. A database destination must exist or be created for the remote database
B. It must run as a user that is defined on the remote database
C. Remote database jobs always run as the same user who submits the job on the local database
D. A credential is optional for a remote database job
E. A credential must be created to define the remote user
F. A database destination group must exist or be created for a job to run on multiple remote databases
G. A destination is optional for a remote database job because DB links can be used instead
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)
A. Bind Variable Peeking
B. SQL Plan Baselines
C. Adaptive Cursor Sharing
D. Bind variable used in a SQL statement
E. Literals in a SQL statement
Examine this command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true? (Choose two.)
A. All data definition language (DDL) statements are written to the control file
B. Some DDL statements are written to an XML file in the ADR home
C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
D. Some data definition language (DDL) statements are written to the control file
E. Some DDL statements are written to a text file in the ADR home
F. The Alert Log still contains some DDL statements
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)
A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
B. In a PDB plan, sub plans may be used with up to eight consumer groups.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
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: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; Which statement is true?
A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
B. It succeeds only if memory is available from the autotuned components if SGA.
C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group uses normal redundancy. One of the ASM disks goes offline and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again? (Choose two.)
A. Increase the value of the ASM_POWER_LIMIT parameter.
B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
C. Specify the statement that adds the disk back to the disk group.
D. Increase the number of ASMB processes.
E. Increase the number of DBWR_IO_SLAVES in the ASM instance.
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?
A. The keep pool is not configured.
B. Automatic Workarea Management is not configured.
C. Automatic Shared Memory Management is not enabled.
D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?
A. Oracle Data Pump.
B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
D. Online Table Redefinition.
E. Edition-Based Table Redefinition.
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command: 1snrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?
A. They are able to perform only queries.
B. They are not affected and continue to function normally.
C. They are terminated and the active transactions are rolled back.
D. They are not allowed to perform any operations until the listener LISTENER is started.
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)
A. It utilizes the OS file system cache.
B. A traditional NFS mount is not required when using Direct NFS.
C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
D. Direct NFS is available only in UNIX platforms.
E. Direct NFS can load-balance I/O traffic across multiple network adapters.
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
A. All AWR tables belong to the SYSTEM schema.
B. The AWR data is stored in memory and in the database.
C. The snapshots collected by AWR are used by the self-tuning components in the database
D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
E. AWR contains system-wide tracing and logging information.
You conned using SQL Plus to the root container of a multitenant container database(CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?
A. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
D. The statement results in an error because there are open PDBs.
You configure your database Instance to support shared server connections. Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? (Choose two.)
A. User session data
B. Stack space
C. Private SQL area
D. Location of the runtime area for DML and DDL Statements
E. Location of a part of the runtime area for SELECT statements
Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)
A. The PDB must be open in read-only mode.
B. The PDB must be in mount state.
C. The PDB must be unplugged.
D. The PDB data files are always removed from disk.
E. A dropped PDB can never be plugged back into a multitenant container database (CDB).
You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script? (Choose two.)
A. The seed will be in mount state.
B. The seed will be opened read-only.
C. The seed will be opened read/write.
D. The other PDBs will be in mount state.
E. The other PDBs will be opened read-only.
F. The PDBs will be opened read/write.
You ran this command on a source database: $> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept On the target database, you run this command: $> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept Which two statements are true? (Choose two.)
A. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view
B. The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view
C. The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter
D. The impdp operation creates EMP_DEPT as a table
E. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view.
F. The impdp operation creates EMP_DEPT as a view
Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)
A. A port number for Oracle HTTP Server must be configured
B. The APEX_PUBLIC_USER role must be granted to SYSMAN
C. A SYSMAN user with SYSDBA privilege must be created
D. At least one TCP/IP dispatcher must be configured E. The Oracle HTTP Server must be installed
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform. Which two methods or commands would you use to accomplish this task? (Choose two.)
A. RMAN CONVERT command
B. Data Pump Export and import
C. Conventional Export and Import
D. The BACKUP AS COPY DATABASE . . . command of RMAN
E. DBMS_FILE_TRANSFER with transportable tablespace
Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)