ITPub博客

（640）Examine the parameter setting in your database:Which statement is correct about the database?A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not setB. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET an...

（639）You want to enable automatic PGA memory management in your database.Which setting is required to achieve this?A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET paramet...

（638）Which three statements are true about persistent configuration?(Choose three.)A. A user cannot set privileges on the persistent lightweight jobsB. Persistent lightweight jobs generate a large amount of metadataC. It is possible to create fully self-contained persistent lightweight ...

（637）Which three statements are true about windows?(Choose three.)A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows...

（636）Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.(Choose all that apply.)A. Backup retention policyB. Default backup device typeC. Default destinations for backupsD. Multiple backup device types for single backup...

（635）While Monitoring the space usage in your database that is in ARCHIVELOG modeyou observed that the flash recovery area does not have enough free space toaccommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occu...

（634）Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration Assist...

（633）Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?(Choose three.)A. Both source and target database must be the same character setB. Both source and target database must have the same endian format...

（632）Note the following parameter settings:Which setting is NOT allowed?A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;答案：（B）解析：B，因为DB_BLOCK_SIZ...

（631）View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN>BACKUP DATABASE FILESPERSET 2;The database has seven data files.Why is the%_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?Exhi...

（630）Which two statements are true about encrypting RMAN backup?(Choose two.)A. The transparent encryption of backups uses the encryption walletB. The database uses the same encryption key for every encrypted backupC. The password encryption of backups only uses the password while creat...

（629）Which option is best practice for creating a recovery catalog owner in the catalog database?A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC. Creating a new ...

（628）The database is running in the ARCHIVELOG mode.It has three redo log groups with one member each.One of the redo log groups has become corrupted.You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Whi...

（627）In Recovery Manager(RMAN),you are taking image copies of the data files of your production database and rolling them forward at regular intervals.You attempt to restart your database.After a regular maintenance task,you realize that one of the data files that belongs to the USERS table...

（626）Which options must you configure while performing an automated Tablespace Point-in-Time Recovery（TSPITR）by using Recovery Manager(RMAN)?A. New channels for restore and recovery tasksB. New name for the data files of the tablespaceC. Auxiliary name for the data files of the tables...

（625）Your database is running in ARCHIVELOG mode.One of the data files,USERDATA01.dbf,in the USERS tablespace is damaged and you need to recover the file until the point of failure.The backup for the datafile is available.Which three files would be used in the user-managed recovery proc...

（624）You work with a newly created database.Presently,there is no application load on the database instance.You want to create a baseline for tuning the application,so you decide to collect recommendations that can be implemented to improve application performance.What action must you take ...

（623）You issued the following commands to configure setting in RMAN;RMAN>CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN>CONFIGURE DEFAULT DEVICE TYPE TO sbt;RMAN>CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN>CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;...

（622）You need to maintain a record of all transactions on some tables for at least three years.Automatic undo management is enabled for the database.What must you do accomplish this task?A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the database...