ITPub博客

（547）You backed up the database at 8 a.m. today using an online backup.Accounting made a large change to the underlying data between 10 a.m. and noon.Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?A. Create a manual incremental on...

（546）You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up.What command would you use?A. alter tablespace MY_DATA begin backup;B. alter tablespace MY_DATA start backup;C. alter tablespace MY_DATA backup begin;D. alter MY_DATA begin backup;...

（545）When performing an online backup,what is the proper order of the following steps?a. Issue the alter database end backup command.b. Back up the archived redo logs.c. Issue the alter database begin backup command.d. Back up the database files.e. Determine the beginning log se...

（544）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 online backup,including backing up ...

（543）As the DBA, you run the following query on your ASM instance.What is the implication of the results of the query?(Choose two.)SQL>select group_number,name,state from v$ASM_DISKGROUP;GROUP_NUMBER    NAME        STATE  &...

（542）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 scratch.What do you do?A. Take the w...

（541）If you use ALTER DISKGROUP...ADD DISK and specify a wildcard for the discovery string,what happens to disks that are already a part of the same or another disk group?A. The command fails unless you specify the FORCE option.B. The command fails unless you specify the REUSE option....

（540）Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?A. ADD DIRECTORYB. DROP DISKC. RESIZE DISKD. REBALANCEE. ADD FAILGROUP答案：（A）

（539）How can you reverse the effects of an ALTER DISKGROUP...DROP DISK command if it has already completed?A. Issue the ALTER DISKGROUP...ADD DISK command.B. Issue the ALTER DISKGROUP...UNDROP DISKS command.C. Issue the ALTER DISKGROUP...DROP DISK CANCEL command.D. Retrieve the disk...

（538）Which type of database file is spread across all disks in a disk group?A. All types of files are spread across all disks in the disk group.B. DatafilesC. Redo log filesD. Archived redo log filesE. Control files答案：（A）解析：只要是存储在ASM存储系统中的文件，...

（537）On the development database rac0,there are six raw devices: /dev/raw/raw1 through/dev/raw/raw6./dev/raw/raw1 and/dev/raw/raw2 are 8GB each,and the rest are 6GB each.An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and /dev/raw/raw2.Which series of the followi...

（536）Which background process coordinates the rebalance activity for disk groups?A. ORBnB. OSMBC. RBALD. ASMn答案：（C）解析：RBALASM Rebalance Master ProcessCoordinates rebalance activity...

（535）To reference existing ASM files,you need to use a fully qualified ASM filename.Your development database has a disk group named DG2A, the database name is DEV19,and the ASM file that you want to reference is a datafile for the USERS02 tablespace.Which of the following is a valid ASM fi...

（534）How can you reverse the effects of an ALTER DISKGROUP...DROP DISK command if it has not yet completed?A. Issue the ALTER DISKGROUP...ADD DISK command.B. Issue the ALTER DISKGROUP...UNDROP DISKS command.C. Issue the ALTER DISKGROUP...DROP DISK CANCEL command.D. Retrieve the disk...

（533）You want to migrate your database to ASM,so you have done a clean shutdown,made a closed backup of the entire database,noted the location of your control files and online redo log files,and changed your spfile to use OMF.The last step is to run an RMAN script to do the conversion.U...

（532）As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database.Using ASM,you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data(you do not have advanced SAN mirroring technology available to...

（531）When starting up your ASM instance,you receive the following error:What is the cause of the error?A. The ASM_DISKGROUPS parameter is configured for three disk groups:DGROUP1,DGROUP2,and DGROUP3.     The underlying disks for these disk groups have apparently ...

（530）When an ASM instance receives a SHUTDOWN NORMAL command,what command does it pass on to all database instances that rely on the ASM instances disk groups?A. TRANSACTIONALB. IMMEDIATEC. ABORTD. NORMAL答案：（C）

（529）Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?A. ASM_DISKMOUNTB. ASM_DISKGROUPC. ASM_DISKSTRINGD. ASM_MOUNTGROUP答案：（B）

（528）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答案：（E）解析：Determ...