1Z0-052章节练习(2018.11.28)

多项选择题
Which two statements are true regarding the SGA_TARGET initialization parameter（）
A.It can be increased up to the value of the SGA_MAX_SIZE parameter.
B.Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.
C.Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.
D.Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
单项选择题
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）
A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
单项选择题
Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future. What action would you take to achieve this task（）
A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.
多项选择题
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）
A.data files
B.control files
C.parameter file
D.online redo log files
E.server parameter file
单项选择题
You have two tables with referential integrity enforced between them. You need to insert data to thechild table first because it is going to be a long transaction and data for the parent table will be available ina later stage， which can be inserted as part of the same transaction. View the Exhibit to examine the commands used to create tables.Which action would you take to delay the referential integrity checking until the end of the transaction（）
A.Set the constraint to deferred before starting the transaction.
B.Alter the constraint to NOVALIDATE state before starting the transaction.
C.Enable the resumable mode for the session before starting the transaction.
D.Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction.
多项选择题
View the Exhibit. Which statements are true regarding the USERS tablespace（）
A.A bitmap is used to record free extents.
B.Free extents information is managed within the tablespace.
C.Free extents information is managed in the SYSAUX tablespace.
D.The data dictionary tables are updated when extents are allocated or deallocated
多项选择题
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN；Which two statements are true（）
A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked
单项选择题
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）
A.The XML script
B.The PL/SQL script
C.The DBMS_SCHEDULER package
D.Enterprise Manager to schedule the backup
多项选择题
Identify two situations in which the block header grows in a data block. （）
A.when row directories need more row entries
B.when there is row migration in the data block
C.when there is an increase in the PCTFREE value for the data block
D.when more transaction slots are required than are initially configured
多项选择题
View the Exhibit and examine the initialization parameter settings.Which three initialization parameters are to be set manually as they are not automatically tuned（）
A.LOG_BUFFER
B.SORT_AREA_SIZE
C.JAVA_POOL_SIZE
D.STREAMS_POOL_SIZE
E.DB_16K_CACHE_SIZE
F.DB_KEEP_CACHE_SIZE