-
编辑 删除
ETL
ETL的清洗过程要清洗脏数据。脏数据有很多种。1.路错值或者没有录入。2.少数据。缺乏数据的万丈性。3.录入串行。4.多次录入同一个值。5.不可能值得录入。6.使用了不同的标准。加载过程可以使用更新，和刷新...
-
编辑 删除
043-125
125. Which statement is true while creating subplans using Resource Manager?A. The subplan must belong to the consumer group, SYS_GROUP.B. The total CPU usage at any given level must be less than 100%...
-
编辑 删除
043-124
124. You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RES...
-
编辑 删除
043-123
123. For an incomplete recovery, which four backup types can be usedby Recovery Manager (RMAN) to restore data files? (Choose four)A. RMAN image copies.B. RMAN database backups.C. RMAN tablespace back...
-
编辑 删除
043-122
122. You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameterin the parameter file to YYYY-MM-DD. The default format of which twodata types would be affected by this setting? (Choose two)A. DAT...
-
编辑 删除
043-121
121. While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges? Which two commands would you use to resolve this erro...
-
编辑 删除
043-120
120. What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery? (Choose two)A. BMR lowers the mean time to recover (MTTR).B. BMR supports point-in-time recovery of indivi...
-
编辑 删除
043-119
119. Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to usea single resource plan, WEEKEND_PLAN. Which task must have alre...
-
编辑 删除
043-118
118. Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablesp...
-
编辑 删除
043-117
117. You are working in a dedicated server environment. Your databaseis running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? (C...
-
编辑 删除
043-116
116. In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is...
-
编辑 删除
043-115
115. You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;How does RMAN find the control file autobackup? (Choose all the appl...
-
编辑 删除
043-114
114. By mistake, you ran the batch job (for updating the BILL_DETAILStable) twice. You are not sure which rows in the BILL_DETAILS tablewere affected. You need to identify:a) A list of changes made al...
-
编辑 删除
43-113
113. In your production database, you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statementsare correct? (Choose two)A. The parallel degree limit for DB_G...
-
编辑 删除
043-112
112. Because of hardware failure, you decided to drop a redo log member from the database.Which condition should be met to drop a redo log file?A. The redo log file should belong to an active group.B....
-
编辑 删除
043-111
111. You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the S...
-
编辑 删除
043-110
110. Your database is functioning in NOARCHIVELOG mode. Your databasecontains 15 tablespaces. You want to use Recovery Manager (RMAN) toperform. backups. Which two backups would you be able to perform...
-
编辑 删除
043-109
109. In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values,of the application tables. Some users generate application repo...
-
编辑 删除
043-108
108. You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of thedatabases. While analyzing an instance, you notice that the sys...
-
编辑 删除
043-107
107. In an Oracle 10g database, the in-memory statistics are gatheredat regular intervals and used to perform. growth-trend analysis andcapacity planning of the database. Which component stores these ...
