ITPub博客

48. You work as a database administrator at Certkiller .com. In yourtest database, you find that a user's session is executing a lot of SQL statements, resulting in the generation of a large number of...

47. You are working on an Oracle Database 10g database. Because of data loss, you decided to perform. a Flashback Database operation usingthe following command:SQL> FLASHBACK DATABASE TO TIMESTAMP(SYS...

46. A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?A. clear the re...

46. A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?A. clear the re...

44. Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What woul...

42. ExhibitA user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectifythe erroneous inserts. While performing the recover...

41 . You decided to change the location of the flash recovery area. You executed the following command:ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*';Which statement is true?A....

40. In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impactof this setting on the backup that is being performed by using ...

39. In your production database you want to use an Automatic StorageManagement (ASM) instance to manage the database files. Which optionwould you use to migrate the database files from a non-ASM insta...

38. The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?A. The Oracle ...

37. You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management (ASM) instanceto manage its files. You want to add a new disk group to the AS...

45. On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that t...

索引组织表，位图组织表。内存分配。asm存储asmm 内存管理datapumpASmhttp://database.chinaunix.net/a2010/0415/874/000000874032.shtmlasm是oracle为了霸占存储管理弄的一个东西。在文件级别上进行存...

36. ExhibitOne of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed thisat 11:00 a.m. and you want to perform. an incomplete recovery to...

34. In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored thecontrol file by using the following command:RMAN> RESTORE CONT...

oracle 字典管理就是把表空间的使用状况放在数据字典中。而本地管理就是把表空间信息放在数据文件中。system是不能本地管理的。智能字典管理。http://www.itpub.net/thread-809871-1-1.html...

33. Your database operates in ARCHIVELOGmode. The redo log files arenot multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived and it contained inf...

32. You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN> REPORT NEED BACKUP days 3;What would be the output of this command?A. a list of files that requ...

31. You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics, you find that the actual space us...

30. You work as a database administrator at Certkiller .com. In yourproduction database, you observe that users' transactions are consuming a lot of resource and you plan to impose resource restrictio...