Oracle 1z0-034 問題集

質問 1：
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object?
A. Perform Export before TSPITR and Import after TSPITR
B. Move objects to another schema that has the same tablespace assigned
C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
正解：A

質問 2：
Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?
A. Only one nested subplan is allowed per parent plan
B. The plans can be nested up to four levels.
C. Nested plans control only the degree of parallelism and I/O requests
D. Each nested plan gets a proportion of the CPU resources assigned to its parent group.
E. Nested plans only control resources used by recursive SQL
正解：D

質問 3：
View the Exhibit and examine the RMAN commands.

Which statement describes the effect of a backup retention policy on the backup of a backup set?
A. All the copies of the backup set are counted as one instance of a backup and will deleted in backup setexceeds the redundancy-based backup retention policy.
B. The copies of the backup will be reported as obsolete under a recovery window-based backup retentionpolicy.
C. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.
D. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.
正解：D

質問 4：
Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

A. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.
B. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
C. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.
D. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
正解：B

質問 5：
You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)
A. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;
B. ALTER TABLESPACE adtbs RESIZE 20G;
C. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;
D. ALTER TABLESPACE adtbs ADD DATAFILE;
E. ALTER TABLESPACE adtbs AUTOEXTEND ON;
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.
Which two actions will permit the TSPITR to work? (Choose two.)
A. Taking the MASTERTBS tablespace offline
B. Dropping the relationship between the tables
C. Putting the MASTERTBS tablespace in read-only mode
D. Adding the MASTERTBS tablespace to the recovery set
正解：B,D

質問 7：
Which two statements are true about encrypting RMAN backups?
A. If transparent encryption is configured, you cannot use the set encryption by password command to make password-protected backups.
B. The password encryption of backups only uses the password while creating and restoring backups.
C. The database uses the same encryption key for every encrypted backup.
D. The transparent encryption of backups uses the encryption wallet.
正解：B,D

質問 8：
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.
A. The data file backup complies with the back retention policy and the backup duplexing feature
B. The data files is in the read-write mode after being backed up in the read only mode
C. The backup was taken after the data files was taken offline-normal or is in the read only mode
D. The data file backup is done with multiple channels
正解：A,C