New 2022 1z0-062 exam questions Welcome to download the newest PracticeDump 1z0-062 PDF dumps (380 Q&As)
P.S. Free 2022 Oracle Database 1z0-062 dumps are available on Google Drive shared by PracticeDump
NEW QUESTION 98
You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time? (Choose two.)
- A. Moving the job to an existing higher priority scheduler window with the same schedule and duration
- B. Increasing the priority of the scheduler window to which the job belongs
- C. Increasing the priority of the job class to which the job belongs
- D. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class
within the plan mapped to the scheduler window - E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
- F. Increasing the job's relative priority within the Job class to which it belongs
Answer: D,F
Explanation:
Explanation/Reference:
Explanation:
B: Job priorities are used only to prioritize among jobs in the same class.
Note: Group jobs for prioritization
Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the
class are scheduled to start at the same time, the one with the higher priority takes precedence. This
ensures that you do not have a less important job preventing the timely completion of a more important
one.
C: Set resource allocation for member jobs
Job classes provide the link between the Database Resource Manager and the Scheduler, because each
job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified
consumer group and are assigned resources according to settings in the current resource plan.
NEW QUESTION 99
Which two statements are true about variable extent size support for large ASM files? (Choose two.)
- A. An ASM Instance automatically allocates an appropriate extent size.
- B. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.
- C. The metadata used to track extents in SGA is reduced.
- D. Resync operations are completed faster when a disk comes online after being taken offline.
- E. Rebalance operations are completed faster than with a fixed extent size
Answer: A,C
Explanation:
Explanation/Reference:
Explanation:
A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for
very large databases (A), and improve performance for file create and open operations.
C: You don't have to worry about the sizes; the ASM instance automatically allocates the appropriate
extent size.
Note:
* The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored
on individual disks within disk groups. Each extent resides on an individual disk. Extents consist of one or
more allocation units (AU). To accommodate increasingly larger files, ASM uses variable size extents.
* The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file
size. The initial extent size is equal to the allocation unit size and it increases by a factor of 8 and 64 at
predefined thresholds. This feature is automatic for newly created and resized datafiles when the disk
group compatibility attributes are set to Oracle Release 11 or higher.
NEW QUESTION 100
Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)
- A. The pluggable databases increase patching time.
- B. All administration tasks must be done to a specific pluggable database.
- C. Pluggable databases are only used for database consolidation.
- D. The pluggable databases are patched together.
- E. The pluggable databases reduce administration effort.
Answer: D,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 101
Unified auditing is enabled in your database. The HR_ADMINand OE_ADMINroles exist and are granted
system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE
ROLES
hr_admin, oe_admin;
Which statement is true?
- A. It succeeds and starts capturing only successful SQL statements for all users who have either the
specified privileges or roles granted to them. - B. It fails because system privileges cannot be granted with roles in the same audit policy.
- C. It fails because the command does not specify when the unified audit policy should be enforced.
- D. It succeeds and needs to be enabled to capture all SQL statements that require either the specified
privileges or any privilege granted to the HR_ADMINand OE_ADMINrole.
Answer: A
NEW QUESTION 102
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)
- A. It fails because no SQL *Loader data file location is specified.
- B. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
- C. It fails because no SQL *Loader control file location is specified.
- D. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
Answer: B,D
Explanation:
Explanation/Reference:
Explanation:
Note:
* SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.
NEW QUESTION 103
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.
Identify the correct sequence of steps.
- A. 3, 2, 4, 1
- B. 3, 2, 1, 4
- C. 2, 3, 4, 1
- D. 4, 1, 3, 2
Answer: C
Explanation:
Explanation/Reference:
Explanation:
Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column groups.
Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statisticsHere are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.2 – Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute (“exec”) statement, Oracle extended statistics are created via a select statement.
NEW QUESTION 104
The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR.
You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.
BOSTON is defined as a service name in the tnsnames.ora of both the databases.
You plan to use the command:
CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY hr USING 'denver';
What must be done to ensure only the HR user in the BOSTON database can access the
HR schema in the DENVER database?
- A. Execute this command as SYS user in both the databases.
- B. Execute this command as HR user in the BOSTON database and SYS user in the
DENVER database. - C. Execute this command as HR user in the DENVER database.
- D. Execute this command as HR user in the BOSTON database.
Answer: D
NEW QUESTION 105
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12' , 'MM/DD/YY')";
Examine following commands:
1 . ALTER PLUGGABLE DATABASE ALL OPEN;
2 . ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
- A. 3 and 1
- B. Only 2
- C. Only 1
- D. Only 3
- E. 1 and 2
Answer: A
NEW QUESTION 106
The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user
SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?
- A. The command waits and the user SCOTT can execute data manipulation language
(DML) statements only as part of the current transaction. - B. The command hangs until all transactions on theobjects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
- C. The command fails as a transaction is still pending.
- D. The transaction inScott's session is rolled back and the tablespace becomes readonly.
Answer: A
Explanation:
You can issue the ALTER TABLESPACE...READ ONLY statement while the database is processing transactions. After the statement is issued, the tablespace is put into a transitional read-only state. No transactions are allowed to make further changes (using
DML statements) to the tablespace. If a transaction attempts further changes, it is terminated and rolled back. However, transactions thatalready made changes and that attempt no further changes are allowed to commit or roll back.
NEW QUESTION 107
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?
- A. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
- B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
- C. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
- D. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
- E. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
Answer: B
Explanation:
Note:
* BY SESSION
In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or operations of the same type executed on the same schema objects in the same session. Beginning with this release (11g) of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to write one audit record for each audited statement and operation.
* BY ACCESS
Specify BY ACCESS if you want Oracle Database to write one record for each audited statement and operation.
Note:
If you specify either a SQL statement shortcut or a system privilege that audits a data definition language (DDL) statement, then the database always audits by access. In all other cases, the database honors the BY SESSION or BY ACCESS specification.
* For each audited operation, Oracle Database produces an audit record containing this information:
/ The user performing the operation
/ The type of operation
/ The object involved in the operation
/ The date and time of the operation
References:
NEW QUESTION 108
Which three statements are true about using flashback database in a multitenant container database (CDB)?
- A. Individual PDBs can be flashed back without flashing back the entire CDB.
- B. The root container can be flashed back without flashing back the pluggable databases
(PDBs). - C. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable
flashback of the CDB. - D. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
- E. To enable flashback database, the CDB must be mounted.
Answer: C,D,E
NEW QUESTION 109
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement? (Choose three.)
- A. The partitions can be compressed in the new tablespaces.
- B. Global indexes must be rebuilt manually after moving the partitions.
- C. Local indexes must be rebuilt manually after moving the partitions.
- D. The partitions can be compressed in the same tablespaces.
- E. The partitions can be moved online to new tablespaces.
Answer: A,D,E
Explanation:
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.
D: Moving (Rebuilding) Index-Organized Tables
Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.
Incorrect:
Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.
NEW QUESTION 110
Which two statements are true about the logical storage structure of an Oracle database?
- A. Each data block always corresponds to one operating system block.
- B. An extent contains data blocks that are always physically contiguous on disk.
- C. An extent can span multiple segments,
- D. A data block is the smallest unit of I/O in data files.
- E. It is possible to have tablespaces of different block sizes.
Answer: C,E
Explanation:
Reference: http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT250
NEW QUESTION 111
Identify two correct statements about multitenant architectures.
- A. Patches are always applied at the CDB level.
- B. A PDB can have a private undo tablespace.
- C. Multiple CDBs share certain PDB resources.
- D. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
- E. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
- F. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
Answer: A,D
Explanation:
Explanation/Reference:
Explanation:
B: Using 12c Resource manager you will be able control CPU, Exadata I/O, sessions and parallel servers.
A new 12c CDB Resource Manager Plan will use so-called “Shares” (resource allocations) to specify how CPU is distributed between PDBs. A CDB Resource Manager Plan also can use “utilization limits” to limit the CPU usage for a PDB. With a default directive, you do not need to modify the resource plan for each PDB plug and unplug.
E: New paradigms for rapid patching and upgrades.
The investment of time and effort to patch one multitenant container database results in patching all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug to a multitenant container database at a different Oracle Database software version.
Incorrect:
Not A:
* The Oracle RAC documentation describes special considerations for a CDB in an Oracle RAC environment.
* Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more.
It is supported by a new architecture that allows a container database to hold many pluggable databases.
And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application.
Not D: You can unplug a PDB from one CDB and plug it into a different CDB without altering your schemas or applications. A PDB can be plugged into only one CDB at a time.
not F:
* UNDO tablespace can NOT be local and stays on the CDB level.
* Redo and undo go hand in hand, and so the CDB as a whole has a single undo tablespace per RAC instance.
NEW QUESTION 112
Examine the parameters for your database instance:
You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?
- A. Undo data is written to flashback logs after 1200 seconds.
- B. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
- C. You can perform a Flashback Database operation only within the duration of 1200 seconds.
- D. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION 113
Which two statements are true about the use of the procedures listed in the
v$sysaux_occupants.move_procedure column? (Choose two.)
- A. All the components may be moved into SYSAUX tablespace.
- B. The procedure may be used for some components to relocate component data to the SYSAUX
tablespace from its current tablespace. - C. All the components may be moved from the SYSAUX tablespace.
- D. The procedure may be used for some components to relocate component data from the SYSAUX
tablespace to another tablespace.
Answer: B,D
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 114
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output? (Choose three.)
- A. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
- B. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
- C. The C # # A_ADMIN user can perform wallet operations.
- D. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
- E. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
Answer: A,B,E
Explanation:
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM
The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database Incorrect:
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.
Note:
Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.
NEW QUESTION 115
Which two are true for databases running in ARCHIVELOGmode? (Choose two.)
- A. Inactive redo log groups must be archived before they can be reused.
- B. Archived redo log files can only be backed up when backing up the database.
- C. Archived redo log files can only be multiplexed to a maximum of ten local destinations.
- D. Archived redo log files get overwritten if the archived redo file destination is full.
- E. Archived redo log files can be multiplexed to a maximum of thirty destinations.
Answer: A,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14231/archredo.htm
NEW QUESTION 116
Which three database operations can be performed only at MOUNT state? (Choose three.)
- A. re-creating control files
- B. performing Flashback Database
- C. enabling or disabling ARCHIVELOG mode
- D. renaming control files
- E. performing full database recovery
Answer: B,C,E
NEW QUESTION 117
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output?
- A. The C # # B_ADMIN user can perform all backup and recovery operations usingRMAN only.
- B. The C # # D_ADMIN user can perform backup and recovery operations for Automatic
Storage Management(ASM). - C. The C # # C_ADMIN user can perform the data guard operation with Data Guard
Broker. - D. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
- E. The C # # A_ADMIN user can perform wallet operations.
Answer: B,C,D
Explanation:
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM
The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup
E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database
Incorrect:
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.
Note:
Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.
NEW QUESTION 118
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
- A. All DDL commands are logged in the alert log file.
- B. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
- C. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
- D. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
- E. Only DDL commands that resulted in the creation of new segments are logged.
Answer: A
Explanation:
Once DDL logging is turned on, every DDL command will be logged in the alert log file and also the log.xml file.
Note:
*By default Oracle database does not log any DDL operations performed by any user. The default settings for auditing only logs DML operations.
*Oracle 12c DDL Logging - ENABLE_DDL_LOGGING
The first method is by using the enabling a DDL logging feature built into the database. By default it is turned off and you can turn it on by setting the value of ENABLE_DDL_LOGGING initialization parameter to true.
*We can turn it on using the following command. The parameter is dynamic and you can turn it
on/off on the go.
SQL> alter system set ENABLE_DDL_LOGGING=true;
System altered.
Elapsed: 00:00:00.05
SQL>
Once it is turned on, every DDL command will be logged in the alert log file and also the log.xml file.
NEW QUESTION 119
......
1z0-062 exam questions from PracticeDump dumps: https://pass4sure.practicedump.com/1z0-062-exam-questions.html (380 Q&As)