oracle

1,EMP_EAST patition in EMPLOYEES for physical corruptions

D ANALYZE

2,RESUMABLE TIMEOUT 60

C not rectified within 60 sec.

3,add or remove disk performance in ASM

B, POWER,ASM_POWERLIMIT

4,SGA MAXSIZE 14G

A SGATARGET to 14G , increase AUTO TUNNED

5.change consumer group

D DBMS_RESOURCE_MANAGER_PRIVS

6.NLS_TIMESTAMP

BE TIMESTAMP/(WITH LOCAL)

7.  Backup

B,C,E

8. temporary tablespace

D

9 RESOTRE CONTROLFILE

C recovery catalog

10 RESETLOGS

BE, new incarnation,RESETLOGS SCN

11 PURGE

B oldest dropscn

12 restore already create DEPT

A RENAME TO

13 Flashback drop feature

AC no-SYSTEM,before drop

14 Flashback SCN

B 209 300

15 Flashback not right

D another Flash

16 Flashback to timestamp

B undone,single transaction

17 Flashback to timestamp

A undo

18 Flash table

B update,insert

19 bring the data to correct state

D flash version and transaction

20 flash version query

D table structure changed

21 flahs version query

D commited,insert update deletes

22 batch job twice

E version query,transaction query

23 flashback_transaction_query

D both active and commited

24 transaction identifier provide by ...query, 

C Flashback Version query

25 check datafile for block corruption

B DBVerify

26 check table block corruption

B ANALYZE

27 DB_BLOCK_CHECKING FALSE

E SYSTEM ONLY

28 DB_BLOCK_CHECKING TRUE

A self-consistent

29 MTTR for block corrupted

D RMAN BLOCKRECOVER

30 block media recovery

A mount/open , must be complete media recovery

31 Backup validate database;block recover corruption list;

D Backup validate database ->V$DATABASE_BLOCK_CORRUPTION->block recover corruption list;

32 BMR

A MTTR,remain online

33 database buffer cache 

A Memory Advisor

34 TRANS table is fragmented

B Segment Advisor

35 lack of indexes

C Sql access advisor

36 SQL Tunning Advisor input

A top SQL,snapshots,SQL tunning set

37 redolog in one disk

D different disks

38 ARCHIVE on disk

BE redolog groups,LOG_ARCHIVE_DEST_n

39 log switch

ABC achival logwrite,dabase writer

40 AST_START_MTTR_TARGET 300 

DE V$INSTANCE_RECOVERY,EM

41 resumable

BD space quota,max extents

42 resumable auto

D database trigger

43 85% - 54 %

A appliedbut no alerts

44 static 

C AWR

45 no alerts

D STATISTICS_LEVEL=BASIC

46 not been shrunk.

D segment space management is manual

47 ALTER TABLE trans SHRINK SPACE CASCADE;

AB the TRANS table,B*Tree indexes

48 shrink the table immediately without affecting the currently active queries

E.SHRINK SPACE COMPACT

49 faster primary key access

D.indexorganized tables (IOTs)

50 create a bitmap index on the JOB_ID column

B.A mapping table

51 you generate reports frequently.You are currently using joins

B.index clusters

52 listed in chronological order.

D.create a sorted hash cluster to store the data

53 mapping table segment is fragmented

B.drop and recreate the mapping table

54 OLTP

A.heap table

55 unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES

BE lcoalesce the ORDERS_IND index,E.rebuild the index online and move it to another tablespace

56 the number of indexes on the table is high.

C enable index monitoring and query the V$OBJECT_USAGE view

57 rebuild an index

B.when you need to change storage options

D.when you need to move the index to another tablespace

58 ASM

E LOG_ARCHIVE_FORMAT

59 +ASM 

B manage the files of other databases

60 ASM_DISKSTRING = /devices/*

D identify all disks

61 ADD ALIAS '+tdgroupA/data/datafile.dbf'

D The command creates an alias

62 DB_CREATE_ONLINE_LOG_DEST_1 = '+dg1'DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2'

A.When a new log group is added, it would have one member in each disk group.

63 DATAFILE '+dgroup3(user_temp)/user_files/user_tbsp'

C.It would create a tablespace with a data file that has an alias, and its attributes are set by the userdefined template.

64 ALTER DISKGROUP dgroupA ADD DISK '/devices/D*';

A.The command adds the new disk, D4, to the disk group

65 FAILOVERGROUP control01 DISK

B.This command would result in an error because the /devices/A1 disk is a member of another disk group

tdgroup1.

66 DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;

A.This command would result in an error because the disk group is not empty.

67 ALTER DISKGROUP dg3 REBALANCE POWER 0;

A The rebalancing of the disk group would be stopped.

68 MIRROR FINE

C twoway mirroring and file striping.

69 ASM not impact on the currently connected users

A. mount the new disk group in the ASM instance

70 to ASM

AE CONVERT,BACKUP AND SWITCH TO COPY

71 to ASM

A RMAN would relocate

72 to ASM

B RMAN

73 Automatic Shared Memory Management

A java pool ,large pool, shared pool,database buffer cache

74 ot able to set SGA_TARGET to a nonzero value

A STATISTICS_LEVEL   BASIC

75 import a tablespace with a 4 KB block

C.DB_4K_CACHE_SIZE only

76 configured the large pool

B less shared pool

77 DB_BLOCK_SIZE = 8KB

A cannot set DB_8K_CACHE_SIZE

B.The memory used by Streams will be allocated from the shared pool.

78 

A not DB_8K_CACHE_SIZE

C SGA_TARGET is changed to 1 GB

79 BACKUP performance overhead on the shared pool

A large pool

80 shared server

A large pool

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25556693/viewspace-704513/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25556693/viewspace-704513/