[2022年更新]1z0-062試験問題集でテストエンジン練習テスト問題
合格できる1z0-062試験[2022年03月20日]最新380問題
質問 59
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)
- A. You cannot have multiple SQL *Loader data files.
- B. If no data file is specified, it assumes the data file to be <table-name>.datin the current directory and uses it.
- C. You can have multiple bad files created when loading in parallel.
- D. The DEGREE_OF_PARALLELISMparameter is set to AUTO.
- E. You can selectively load rows into a table based on a filter.
正解: B,D
解説:
Explanation/Reference:
References: https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-8BF3-
2312893A67D7.htm#SUTIL3951
質問 60
You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.
Which two statements are true?
- A. A suspended statement will report an error if no corrective action has taken place during a timeout period.
- B. A resumable statement can be suspended and resumed only once during execution.
- C. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
- D. Before a statement executes in resumable mode, theALTER SESSION ENABLE
RESUMABLEstatement must be issued in its session. - E. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
正解: B,C
解説:
Referenceshttps://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#AD
MIN11581
質問 61
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 # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
- B. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
- C. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
- D. The C # # A_ADMIN user can perform wallet operations.
- E. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
正解: A,C,E
解説:
Explanation/Reference:
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.
質問 62
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?
- A. It results in an error because these parameter settings are invalid.
- B. Two 32G flash cache files will be used.
- C. Two 64G flash cache files will be used.
- D. One 64G flash cache file will be used.
正解: A
解説:
Explanation/Reference:
Explanation:
質問 63
Which two services may you see on the My Service Dashboard page? (Choose two.)
- A. Compute Cloud Service
- B. User Cloud Service
- C. Network Cloud Service
- D. Database Cloud Service
正解: A,D
解説:
Explanation/Reference:
質問 64
You are using RMAN to back up your database. All the data files are in read/write mode.
Examine the RMAN configuration parameters:
Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)
- A. The backup consists of blocks that have been formatted.
- B. The backup can be used as an incremental level 0 backup.
- C. The system Change Number (SCN) is the same for all the data files in the backup.
- D. The database must be in MOUNT state to take the backup.
- E. The database instance must be shut down to take the backup.
正解: C,E
質問 65
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? (Choose two.)
- A. Increase the value of the ASM_POWER_LIMIT parameter.
- B. Specify the statement that adds the disk back to the disk group.
- C. Increase the number of ASMB processes.
- D. Increase the number of DBWR_IO_SLAVES in the ASM instance.
- E. Set the DISK_REPAIR_TIME disk attribute to a lower value.
正解: A,C
解説:
Explanation/Reference:
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.
質問 66
Which two statements are true about standard database auditing? (Choose two.)
- A. Statements that refer to standalone procedure can be audited.
- B. Operations by the users logged on as SYSDBA cannot be audited.
- C. Only one audit record is ever created for a session per audited statement even though it is executed more than once.
- D. DDL statements can be audited.
正解: A,D
質問 67
Which three statements are true about Automatic Workload Repository (AWR)?
- A. AWR contains system wide tracing and logging information.
- B. The AWR data is stored in memory and in the database.
- C. All AWR tables belong to the SYSTEM schema.
- 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. The snapshots collected by AWR are used by the self-tuning components in the database
正解: A,B,E
解説:
Explanation/Reference:
Explanation:
* A fundamental aspect of the workload repository is that it collects and persists database performance data in a manner that enables historical performance analysis.
The mechanism for this is the AWR snapshot. On a periodic basis, AWR takes a "snapshot" of the current statistic values stored in the database instance's memory and persists them to its tables residing in the SYSAUX tablespace.
* AWR is primarily designed to provide input to higherlevel components such as automatic tuning algorithms and advisors, but can also provide a wealth of information for the manual tuning process.
質問 68
SMD is a smallfile locally managed tablespace with manual segment space management.
The SH user receives the following error while inserting data into the salestable:
Which three actions can be taken to enable the user to insert data? (Choose three.)
- A. changing segment space management for the SMD tablespace to automatic
- B. adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file
- C. increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size
- D. resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not yet reached their maximum size
- E. altering the data file associated with the SMD tablespace to grow automatically
正解: B,D,E
質問 69
The HR user receives the following error while inserting data into the sales table:
On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)
- A. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value
- B. Adding a data file to the USERS tablespace
- C. Changing segment space management for the USERS tablespace to manual
- D. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace
- E. Altering the data file associated with the USERStablespace to extend automatically
正解: B,E
解説:
Explanation/Reference:
質問 70
What is the benefit of running the catctl.plscript during an upgrade of a pre-12c database to an Oracle 12c database?
- A. It generates a log file containing the fixes that can be made to the source database.
- B. It provides a summary of the upgrade results.
- C. It recompiles all invalid PL/SQL and Java code.
- D. It generates fix-up scripts to be run on the source database before upgrade.
- E. It provides parallel upgrade options to finish the upgrade process with a reduced down time.
正解: E
解説:
Explanation/Reference:
References: https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52860
質問 71
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?
- A. Data Pump Export and import
- B. The BACKUP AS COPY DATABASE . . . command of RMAN
- C. Conventional Export and Import
- D. RMAN CONVERT command
- E. DBMS_FILE_TRANSFER with transportable tablespace
正解: B,D
解説:
A:
1. Get the list of all datafiles.
Note: RMAN Backup of ASM Storage
There is often a need to move the files from the file system to the ASM storage and vice versa. This may come in handy when one of the file systems is corrupted by some means and then the file may need to be moved to the other file system.
D: Migrating a Database into ASM
*To take advantage of Automatic Storage Management with an existing database you must migrate that database into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using RMAN for your primary backup and recovery strategy.
*Example:
Back up your database files as copies to the ASM disk group.
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE FORMAT '+DISK' TAG 'ORA_ASM_MIGRATION';
Reference: Migrating Databases To and From ASM with Recovery Manager
質問 72
Your database is configured in ARCHIVELOG mode.
Examine the RMAN configuration parameters:
Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two are true? (Choose two.)
- A. It creates a backupset of archive log files
- B. It creates image copies of the archivelogs
- C. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command
- D. It creates image copies of the database files
- E. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command
正解: B,E
質問 73
You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true?
- A. Corrupted blocks, if any, are repaired.
- B. Checks are performed to confirm whether all database files exist in correct locations
- C. Checks are performed for logical corruptions.
- D. Checks are performed for physical corruptions.
- E. Backup sets containing both data files and archive logs are created.
正解: B,D
解説:
B (not C): You can validate that all database files and archived redo logs can be backed up by running a command as
follows:
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
This form of the command would check for physical corruption. To check for logical corruption,
RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
D: You can use the VALIDATE keyword of the BACKUP command to do the following:
Check datafiles for physical and logical corruption
Confirm that all database files exist and are in the correct locations.
Note:
You can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the correct
locations (D), and have no physical or logical corruptions that would prevent RMAN from creating backups of them.
When performing a BACKUP...VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a
real backup. It does not, however, actually produce any backup sets or image copies (Not A, not E).
質問 74
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?
- A. SQL Access Advisor
- B. SQL Performance Analyzer
- C. Automatic Database Diagnostic Monitor (ADDM)
- D. SQL Tuning Advisor
- E. Automatic Workload Repository (AWR) report
正解: A
解説:
References:https://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_perform.htm
#TDPDW00813
質問 75
Your database is configured for ARCHIVELOGmode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.
In which three scenarios do you need media recovery? (Choose three.)
- A. abnormal termination of the database instance
- B. loss of data files that belong to the SYSTEMtablespace
- C. logical corruption of data that is caused by a wrong transaction
- D. loss of all the inactive online redo log group members
- E. loss of a data file that belongs to the active undo tablespace
- F. loss of all the copies of the control file
正解: B,E,F
質問 76
You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo?
- A. Performance improves because less redo is written to the redo log.
- B. Temporary undo reduces the amount of undo stored in undo tablespaces.
- C. Performance improves because no redo and undo are generated for the temporary tables.
- D. Performance improves because data manipulation language (DML)operations performed on temporary tables do not use the buffer cache.
正解: B,C
解説:
References:https://oracle-base.com/articles/12c/temporary-undo-12cr1
質問 77
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer
(OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?
- A. The operating system group that is specified must have permission to write to the inventory directory.
- B. The operating system group that is specified should have the root user as its member.
- C. The installation is being performed by the root user.
- D. The ORACLE_BASE base parameter is not set.
正解: A
解説:
Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.
You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine.
質問 78
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?
- A. Use Oracle Managed Files (OMF).
- B. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
- C. Specify the SEED FILE_NAME_CONVERT clause.
- D. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
- E. Specify the DB_FILE_NAMECONVERT initialization parameter.
正解: A,B,C
解説:
Explanation/Reference:
Explanation:
You must specify the names and locations of the seed's files in one of the following ways:
* (A) Oracle Managed Files
* (B) The SEED FILE_NAME_CONVERT Clause
* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter
質問 79
You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c.
Which three tasks should be performed before a manual upgrade? (Choose three.)
- A. running utlu121s.sqlfrom the new Oracle home to display information about the required initialization parameters
- B. copying the password file to the new Oracle home
- C. copying net configuration files to the new Oracle home
- D. running preupgrad.sqlin Oracle Database 11g to generate fix-up scripts and a log file
- E. copying the initialization parameter file to the new Oracle home
正解: C,D,E
質問 80
......
Oracle 1z0-062 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
Oracle 1z0-062リアルな2022年最新の知能問題集模擬試験問題集：https://jp.fast2test.com/1z0-062-premium-file.html