[2022年03月] 無料1z0-063試験問題をゲット！1z0-063実際の無料試験問題
検証済みの1z0-063問題集と278格別な問題
Oracle 1z0-063 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
質問 87
Which two statements are true regarding the Oracle Data Pump export and import operations?
- A. You cannot export data from a remote database.
- B. You can compress data but not metadata during export.
- C. You can rename tables during import.
- D. You can overwrite existing dump files during export.
正解: A,C
解説:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_import.htm#BEHFFDCD
質問 88
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
- A. by using the connect statement as a local user having only the set container privilege
- B. as a common user with the set container privilege
- C. by using external authentication
- D. by executing the alter session set container command as a local user
- E. by using easy connect
正解: A,B
質問 89
Which three statements are true about persistent lightweight jobs? (Choose three.)
- A. They generate large amounts of metadata.
- B. They are useful when users need to create a large number of jobs quickly.
- C. They may be created as fully self-contained jobs.
- D. A user cannot set privileges on them.
- E. They must reference an existing Scheduler Program.
正解: B,D,E
質問 90
You plan to duplicate the multitenant container database (CDB) cdb1that contains the pluggable database (PDB) SALES:
Which two statements are true? (Choose two.)
- A. The root and seed databases are included in the duplication.
- B. Only the SALESPDB is duplicated as the non-CDB CDBDUP.
- C. RMAN must be connected to a recovery catalog for the execution of the command.
- D. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASEset to TRUE.
- E. A backup of the SALES PDB must exist before the execution of the command.
正解: A,D
解説:
D: When duplicating a whole CDB or one more PDBs:
You must create the auxiliary instance as a CDB. To do so, start the instance with the following declaration in the initialization parameter file:
enable_pluggable_database=TRUE
A: To duplicate PDBs, you must create the auxiliary instance as a CDB. To do so, start the instance with the declaration enable_pluggable_database=TRUE in the initialization parameter file. When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the seed database, and the duplicated PDBs.
References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm
質問 91
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)
- A. The control file backup is older than the database backup.
- B. The current online redo log file is missing.
- C. A data file belonging to a noncritical tablespace is missing.
- D. All the data files are missing.
- E. All the control files are missing.
正解: A,E
解説:
Explanation/Reference:
Reference:
http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel
質問 92
Which two statements are true about a common user? (Choose two.)
- A. A common user can have a local schema in a PDB.
- B. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.
- C. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
- D. A common user can be granted only a common role.
- E. A common user with the create user privilege can create other common users, as well as local users.
正解: A,E
質問 93
Identify three scenarios in which RMAN will use backup sets to perform active database duplication. (Choose three.)
- A. when the duplicate ... from active database command contains the section size clause
- B. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
- C. when you specify set encryption before the duplicate ... from active database command
- D. when you perform active database duplication on a database with flashback disabled
- E. when you perform active database duplication on a database that has read-only tablespaces
正解: A,B,C
解説:
Reference:
http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298
質問 94
Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL> STARTUP
Which two statements are true about the successful execution of the command? (Choose two.)
- A. All the PDBs are opened in read-write mode.
- B. All redo log files are opened.
- C. All the PDBs are in closed state.
- D. The root, the seed, and all the PDBs are opened in read-write mode.
- E. Only the root database is opened in read-write mode.
正解: B,E
質問 95
An incremental level 1 backup is taken every week day. A new tablespace is created before the backup is performed.
You execute:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which two are true? (Choose two.)
- A. It creates image copies of all the new data files.
- B. It creates a level 1 incremental backup set containing all the previously existing data files.
- C. It creates a level 0 backup set containing all the new data files.
- D. It creates a level 1 incremental backup set containing all the new data files.
- E. It returns an error because there is no existing level 0 backup for new data files.
正解: B
質問 96
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.
- A. 2, 1, 6, 4, 7
- B. 1, 3, 6, 7, 4
- C. 1, 3, 5, 7, 4
- D. 1, 3, 6, 4, 7
正解: B
解説:
Explanation
The storage selector act as a layer between RMAN, which accesses the database, and the Oracle Secure Backup software, which manages the backup media.
For backups, Oracle Secure Backup stores metadata about RMAN backup pieces in the Oracle Secure Backup catalog.
The Oracle Secure Backup catalog is stored and managed completely separately from the RMAN recovery catalog. Oracle Secure Backup stores each backup piece and corresponding metadata about the piece.
References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm
質問 97
Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2. RMAN is connected to the target database PDB2_1.
Examine the command executed to back up PDB2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
- A. It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.
- B. It fails because archive log files cannot be backed up using a connection to a PDB.
- C. It fails because the PLUGGABLE clause is missing.
- D. It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.
正解: A
質問 98
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
- A. when you perform active database duplication on a database that has readonlytablespaces
- B. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
- C. when you specify set encryption before the duplicate ... from active database command
- D. whenthe duplicate ... from active database command contains the section size clause
- E. when you perform active database duplication on a database with flashback disabled
正解: B,C,D
解説:
Reference:http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298
質問 99
You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)
- A. Restart the database instance to create the temp file automatically.
- B. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
- C. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.
- D. Drop the TEMP tablespace, and then re-create it with new temp files.
正解: A,B
解説:
Explanation
Temp files are a special class of data files that are associated only with temporary tablespaces.
B: After restore and recovery of a whole database, when the database is open, missing temporary tablespaces that were recorded in the control file are re-created with their previous creation size, AUTOEXTEND, and MAXSIZE attributes. Only temporary tablespaces that are missing are re-created. If a temp file exists at the location recorded in the RMAN repository but has an invalid header, then RMAN does not re-create the temp file.
If the temp files were created as Oracle-managed files, then they are re-created in the current DB_CREATE_FILE_DEST location. Otherwise, they are re-created at their previous locations.
C: If a data file becomes missing or corrupted. You must take it offline before you can open the database.
References:
https://docs.oracle.com/database/121/ADMIN/dfiles.htm
https://docs.oracle.com/database/121/BRADV/rcmcomre.htm
質問 100
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)
- A. switching the online redo log
- B. backing up all used and unused blocks in the data files
- C. backing up all data files as image copies and archive logs, and deleting those archive logs
- D. backing up only the used blocks in the data files
- E. backing up all archived logs and marking them as obsolete
正解: A,B,C
質問 101
One of your database suffered an instance failure.
At the next startup, from which point in the redo logs does instance recovery begin?
- A. from a point corresponding to the most recent log instance checkpoint
- B. from a point corresponding to the most recent incremental checkpoint
- C. from a point corresponding to the most recent log switch checkpoint
- D. from a point corresponding to the most recent successful transaction commit
- E. from a point corresponding to the most recent checkpoint of any kind
正解: D
解説:
Explanation/Reference: http://www.cs.kent.edu/~wfan/link/dbapre/dbatest/54913f.htm
質問 102
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
- A. SQL Performance Analyzer
- B. Active Session History (ASH) report
- C. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
- D. Database Replay
正解: C
解説:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm
質問 103
Which two statements are true about roles in multitenant container databases (CDBs)?
- A. A common role can be granted only to a common user.
- B. A local role can be assigned to a common role in a PDB.
- C. Local roles can be granted to local and common users.
- D. The root container can have both local and common roles.
- E. A common role can be granted only system privileges.
- F. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
正解: C,F
解説:
Explanation/Reference:
Reference https://oracle-base.com/articles/12c/multitenant-manage-users-and-privileges-for-cdb-and-pdb-
12cr1
質問 104
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
( order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION ('ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?
- A. LOCATION
- B. ORGANIZATION EXTERNAL
- C. PARALLEL
- D. TYPE
- E. DEFAULT DIRECTORY
正解: C
質問 105
Which three statements are true about the keystore storage framework for transparent data encryption?
(Choose three.)
- A. It enables a keystore to be stored only in a file on a file system.
- B. It enables separation of duties between the database administrator and the security administrator.
- C. It handles encrypted data without modifying applications.
- D. It facilitates and helps to enforce keystore backup requirements.
- E. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.
- F. It transparently decrypts data for the database users and applications that access this data.
正解: B,D,E
解説:
Explanation/Reference:
Explanation:
Reference:
http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework)
質問 106
......
最新100%合格率保証-素晴らしい1z0-063試験問題PDF：https://jp.fast2test.com/1z0-063-premium-file.html