当前分类： 1Z0-053
问题：单选题You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed o...
查看答案
问题：单选题You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scr...
问题：You installed Oracle Database 11g afresh. Which statements a...
问题：单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement： ALTER TABLESPACE data1 BEGIN BACKUP； While you are per...
问题：单选题Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）A Put the database in hot backup mode and perform an ...
问题：多选题What two statements are true regarding the recommendations received from the SQL Access Advisor？（）AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some ...
问题：单选题When setting arguments for a job， which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype？（）A SET_JOB_ARGUMENT_VALUEB SET_JOB_VALUE_ANYDATAC SET_JOB_ANYDATA_VALUED SET_SPECIAL_JOB_VALUEE SET_JOB_ANY...
问题：To set the history retention period for either window loggin...
问题：多选题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be...
问题：多选题Which statements are true regarding SecureFile LOBs？（）AThe amount of undo retained is user controlled.BSecureFile LOBs can be used only for nonpartitioned tables.CFragmentation is minimized by using variable-sized chunks dynamically.DSecureFile encrypt...
问题：单选题You run the following commands： RMAN list expired backup； RMAN delete expired backup； What will happen to the backup set pieces associated with the backups that appear in the list expired backup command？（）A They will be renamed.B Nothing will hap...
问题：多选题Which two statements are true about encrypting RMAN backup？（）AThe transparent encryption of backups uses the encryption walletBThe database uses the same encryption key for every encrypted backupCThe password encryption of backups only uses the passwor...
问题：多选题You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation o...
问题：What RMAN command is used to execute a tablespace point-in-t...
问题：When performing a database duplication， which duplicate data...
问题：单选题Which command creates an image copy？（）A backup as copyB backup copyC copy as backupD copy back...
问题：多选题ASM supports all but which of the following file types？（）ADatabase filesBSpfilesCRedo-log filesDArchived log filesERMAN backup setsFPassword filesGinit.ora files...
问题：单选题You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC？（）A A base catalog existsB ...
问题：单选题You need to create a partitioned table to store historical data and you issued the following command： CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3） （ PARTITION p1 VALUES LE...
问题：单选题What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?（）A 100KB default, 10TB maximumB 256KB default, 1024MB maximumC 10MB default, 126PB maximumD 64KB default, 1EB maximumE 1MB default, 64MB maximum...
