In a new installation of Oracle Database 11g, you perform these activities: 1:Organize software and data on different subdirectories to avoid poor performance. 2:Use consistent naming conventions for database files. 3:Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed()
You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true()
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ,you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?()
用于在启动实例时配置数据库,确定Oracle 11g的运行环境文件是()。
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? ()
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?()
You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? ()
You are managing an Oracle Database 11g database with the following backup strategy:1) On Sunday, an incremental level 0 tape backup is performed.2) Monday through Saturday, a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed()
In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)