Pass Oracle Database 1z0-062 exam [Jan 28, 2022] Updated 380 Questions
Oracle 1z0-062 Actual Questions and 100% Cover Real Exam Questions
NEW QUESTION 161
Which three are activities performed by SMON?
- A. applying online redo during instance recovery
- B. restarting a server or a dispatcher process that terminated abnormally
- C. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline
errors - D. cleaning up temporary segments that are no longer needed
- E. performing database services registration with the default listener
- F. cleaning up the database buffer cache and freeing resources that a client process was using
Answer: A,C,D
NEW QUESTION 162
Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)
- A. optimizer statistics gathering
- B. Segment Advisor
- C. Automatic Database Diagnostic Monitor
- D. Automatic SQL Tuning Advisor
- E. SQL Access Advisor
Answer: A,B,D
NEW QUESTION 163
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS
PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle
Management (ILM) to automate data movement?
- A. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS
PERCENT USED - B. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS
PERCENT USED - C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS
PERCENT USED - D. Setting the target tablespace to read-only
- E. Setting the target tablespace offline
Answer: C,D
Explanation:
The value forTBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the valueof TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.
NEW QUESTION 164
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?
- A. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
- B. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
- C. It fails and reports an error because the CONTAINER=ALL clause is not used.
- D. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
- E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
Answer: D
Explanation:
Explanation
REVOKE ..FROM
If the current container is the root:
/ Specify CONTAINER = CURRENT to revoke a locally granted system privilege, object privilege, or role from a common user or common role. The privilege or role is revoked from the user or role only in the root.
This clause does not revoke privileges granted with CONTAINER = ALL.
/ Specify CONTAINER = ALL to revoke a commonly granted system privilege, object privilege on a common object, or role from a common user or common role. The privilege or role is revoked from the user or role across the entire CDB. This clause can revoke only a privilege or role granted with CONTAINER = ALL from the specified common user or common role. This clause does not revoke privileges granted locally with CONTAINER = CURRENT. However, any locally granted privileges that depend on the commonly granted privilege being revoked are also revoked.
If you omit this clause, then CONTAINER = CURRENT is the default.
References:
NEW QUESTION 165
Your database is configured in ARCHIVELOGmode, and a daily full database backup is taken by using RMAN.
Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)
- A. a data file belonging to the SYSAUXtablespace
- B. inactive online redo log file group
- C. a data file belonging to the default temporary tablespace
- D. active online redo log file group
- E. server parameter file (SPFILE)
- F. all the control flies
Answer: B,D,F
NEW QUESTION 166
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
- A. Existing dump files can be overwritten during an export operation.
- B. Only data can be compressed during an export operation.
- C. Metadata that is exported and imported can be filtered based on objects and object types.
- D. Tables cannot be renamed during an import operation.
- E. You cannot specify how partitioned tables should be handled during an import operation.
Answer: C,E
Explanation:
Explanation
References https://docs.oracle.com/cd/B28359_01/server.111/b28300/expimp.htm#UPGRD12560
NEW QUESTION 167
Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');
Which three statements are true about the effect of this command?
- A. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
- B. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
- C. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
- D. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
- E. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
Answer: A,B,C
Explanation:
* SET_TABLE_PREFS Procedure
This procedure is used to set the statistics preferences of the specified table in the specified schema.
* Example: Using Pending Statistics
Assume many modifications have been made to the employees table since the last time statistics were gathered. To ensure that the cost-based optimizer is still picking the best plan, statistics should be gathered once again; however, the user is concerned that new statistics will cause the optimizer to choose bad plans when the current ones are acceptable. The user can do the following:
EXEC DBMS_STATS.SET_TABLE_PREFS('hr', 'employees', 'PUBLISH', 'false');
By setting the employees tables publish preference to FALSE, any statistics gather from now on will not be automatically published. The newly gathered statistics will be marked as pending.
NEW QUESTION 168
Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)
- A. An extent cannot span data files.
- B. A segment cannot span data files.
- C. The size of an Oracle data block in a data file should be the same as the size of an OS block.
- D. A data file can belong to only one tablespace.
Answer: A,D
Explanation:
A single extent can never span data files.
https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1095
NEW QUESTION 169
Which three resources might be prioritized between competing pluggable databases when creating a
multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose
three.)
- A. CPU
- B. Parallel server limit
- C. Local file system I/O
- D. Maximum Idle time
- E. Exadata I/O
- F. Maximum Undo per consumer group
Answer: A,B,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 170
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
– Version: Oracle Database 12c Releases 1 64-bit
– Character set: WE8ISO8859P15
– National character set: AL16UTF16
– O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
– Version: Oracle Database 12c Release 1 64-bit
– Character set: AL32UTF8
– O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
- A. Data Pump full export / import
- B. Transportable database
- C. RMAN
- D. Transportable tablespace
- E. The DBMS_PDB package
Answer: A
NEW QUESTION 171
Examine the parameters for a database instance:
Which two statements are true? (Choose two.)
- A. No redo is generated for the undo records belonging to temporary tables.
- B. Undo records for temporary tables are stored in a temporary tablespace.
- C. No redo and undo records are generated for temporary tables.
- D. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.
- E. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.
Answer: A,B
NEW QUESTION 172
Examine the query and its output:
What might have caused three of the alerts to disappear?
- A. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second
query. - B. The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.
- C. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.
- D. The database instance was restarted before the execution of the second query.
Answer: D
NEW QUESTION 173
Which two statements are true about the Oracle Direct Network File system (DNFS)?
(Choose two.)
- A. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
- B. A traditional NFS mount is not required when using Direct NFS.
- C. Direct NFS can load-balance I/O traffic across multiple network adapters.
- D. It utilizes the OS file system cache.
- E. Direct NFS is available only in UNIX platforms.
Answer: A,C
Explanation:
E: Performance is improved by load balancing across multiple network interfaces (if available).
Note:
* To enable Direct NFS Client, you must replace the standard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.
Incorrect:
Not A: Direct NFS Client is capable of performing concurrent direct I/O, which bypasses any operating system level caches and eliminates any operating system write-ordering locks Not B:
* To use Direct NFS Client, the NFS file systems must first be mounted and available over regular NFS mounts.
* Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP).
Not D: Direct NFS is provided as part of the database kernel, and is thus available on all supported database platforms - even those that don't support NFS natively, like Windows.
Note:
* Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP). Direct NFS is built directly into the database kernel - just like ASM which is mainly used when using DAS or SAN storage.
* Oracle Direct NFS (dNFS) is an internal I/O layer that provides faster access to large NFS files than traditional NFS clients.
NEW QUESTION 174
As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database.
SCOTT’s password is TIGER. The service mane “HQ” is used to connect to the remote HQ database.
Which command would you execute to create the database link?
- A. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING ‘HQ’;
- B. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
- C. CREATE DATABASE LINK HQ USING 'HQ';
- D. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
Answer: D
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 175
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?
- A. Set DB_FLASH_CACHE_ZISE = 64G, 64G
- B. Set DB_FLASH_CACHE_ZISE = 128G.
- C. Set DB_FLASH_CACHE_ZISE = 64G.
- D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.
Answer: A
Explanation:
Explanation
* Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for "Database Smart Flash Cache" area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc
DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by "DB Smart Flash Cache"
/dev/sda - size 32G
/dev/sdb - size 32G
/dev/sdc - size 64G
New view V$FLASHFILESTAT - it's used to determine the cumulative latency and read counts of each file|device and compute the average latency
NEW QUESTION 176
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage
Management (ASM) and whose disk group use 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?
- A. Set the DISK_REPAIR_TIME disk attribute to a lower value.
- B. Increase the number of DBWR_IO_SLAVES in the ASM instance.
- C. Increase the value of the ASM_POWER_LIMIT parameter.
- D. Specify the statement that adds the disk back to the disk group.
- E. Increase the number of ASMB processes.
Answer: C,E
Explanation:
A: ASM_POWER_LIMIT specifies the maximum power on an Automatic Storage Management instance for disk
rebalancing. The higher the limit, the faster rebalancing will complete. Lower values will take longer, but consume
fewer processing and I/O resources.
D:
* Normally a separate process is fired up to do that rebalance. This will take a certain amount of time. If you want it to
happen faster, fire up more processes. You tell ASM it can add more processes by increasing the rebalance power.
* ASMB
ASM Background Process
Communicates with the ASM instance, managing storage and providing statistics
Incorrect:
Not B: A higher, not a lower, value of DISK_REPAIR_TIME would be helpful here.
Not E: If you implement database writer I/O slaves by setting the DBWR_IO_SLAVES parameter, you configure a single
(master) DBWR process that has slave processes that are subservient to it. In addition, I/O slaves can be used to
"simulate" asynchronous I/O on platforms that do not support asynchronous I/O or implement it inefficiently.
Database I/O slaves provide non-blocking, asynchronous requests to simulate asynchronous I/O.
NEW QUESTION 177
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:
There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
- A. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
- B. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
- C. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
- D. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
- E. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
Answer: C
NEW QUESTION 178
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3 . Create a database clone template for the database.
4 . Run the Database Configuration Assistant (DBCA) to create the database.
5 . Run OUI in graphical mode on each machine.
6 . Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
- A. 1, 5, and 4
- B. 2, 3, 1, and 6
- C. 2, 3, 6, and 4
- D. 3, 1, 5, and 6
- E. 2, 1, 6, and 4
Answer: C
NEW QUESTION 179
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
- Applications will connect to the database via a middle tier.
- The number of concurrent user connections will be high.
- The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
- A. a default database configuration
- B. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
- C. a General Purpose database template with default memory allocation
- D. a Data Warehouse database template, with the dedicated server mode option and AMM enabled
Answer: B
Explanation:
Explanation/Reference:
References:
NEW QUESTION 180
Which two statements are true when row archival management is enabled? (Choose two.)
- A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
- B. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
- C. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
- D. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
- E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
Answer: B,D
NEW QUESTION 181
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
- A. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
- B. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
- C. In a PDB plan, subplans may be used with up to eight consumer groups.
- D. 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.
- 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.
Answer: D,E
Explanation:
Explanation/Reference:
Explanation:
A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.
* In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans.
The functionality is similar except for the following differences:
/Non-CDB Database
Multi-level resource plans
Up to 32 consumer groups
Subplans
/PDB Database
Single-level resource plans only
Up to 8 consumer groups
(not B) No subplans
NEW QUESTION 182
You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed.
You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas.
What must you run to achieve this?
- A. SQL Access Advisor with a SQL tuning set
- B. SQL Access Advisor with a hypothetical workload
- C. SQL Tuning Advisor
- D. Automatic Database Diagnostic Monitor (ADDM) report
- E. SQL Performance Analyzer
Answer: B
NEW QUESTION 183
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?
- A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
- B. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
- C. It fails because no SQL *Loader data file location is specified.
- D. It fails because no SQL *Loader control file location is specified.
Answer: A,B
Explanation:
Explanation/Reference:
Explanation:
Note:
* SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.
NEW QUESTION 184
Which two statements are true about Oracle Data Pump export and import operations?
(Choose two.)
- A. Existing dump files can be overwritten during an export operation.
- B. Only data can be compressed during an export operation.
- C. Metadata that is exported and imported can be filtered based on objects and object types.
- D. Tables cannot be renamed during an import operation.
- E. You cannot specify how partitioned tables should be handled during an import operation.
Answer: C,E
Explanation:
References
https://docs.oracle.com/cd/B28359_01/server.111/b28300/expimp.htm#UPGRD12560
NEW QUESTION 185
......
Oracle 1z0-062 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
Oracle 1z0-062 Real 2022 Braindumps Mock Exam Dumps: https://www.fast2test.com/1z0-062-premium-file.html