- 博客(73)
- 收藏
- 关注
RSS订阅转载 2018OCP题库变了，052最新考题解析（带答案）-78
78、Which four database objects never have any segments?A) A partitioned indexB) A view selecting fro...
2018-09-25 14:33:52
130
转载 OCP认证052考试最新题库及答案整理-77
77、Which structure can span multiple data files?A) a bigfile tablespaceB) a permanent tablespace...
2018-09-25 14:08:13
81
转载 OCP认证052考试最新题库及答案整理-76
76、Which three structures can span multiple data files?A) migrated rowsB) table extentsC) temp...
2018-09-25 13:34:44
94
转载 OCP认证052考试最新题库及答案整理-75
75、Your database is using Automatic Memory Management.Which two SGA components must be managed manually?...
2018-09-21 13:36:06
96
转载 OCP认证052考试最新题库及答案整理-74
74、Which two can be exported by a non-administrative account by using Data Pump?A. tablesB. databa...
2018-09-21 13:08:23
102
转载 OCP认证052考试最新题库及答案整理-73
73、In one of your databases: The database default tablespace is EXAMPLE. DEFERRED_SEGMENT_CREA...
2018-09-21 11:55:28
79
转载 OCP认证052考试最新题库及答案整理-72
72、Which is true about enabling AUTOEXTEND for data files?A. It can be enabled for data files only in smal...
2018-09-20 15:23:59
68
转载 OCP认证052考试最新题库及答案整理-71
71、Which command is used to display files that no longer conform to the backup retention policy?A. CROSS...
2018-09-20 14:38:05
102
转载 OCP认证052考试最新题库及答案整理-70
70、Which two are true about space management in tablespaces?A. Free lists are used for managing free space...
2018-09-20 14:21:20
79
转载 OCP认证052考试最新题库及答案整理-69
69、Which is true about unusable indexes?A. Rebuilding an unusable index always requires at least twice the...
2018-09-20 14:10:34
97
转载 OCP认证052考试最新题库及答案整理-
65、Which three structures can span multiple data files?A. chained rowsB. segmentsC. temporary ...
2018-09-18 13:49:00
107
转载 OCP认证052考试最新题库及答案整理-64
64、 Which three are true about Oracle database security?A. By default, SYSDBA connections have access to a...
2018-09-18 13:33:04
78
转载 OCP认证052考试最新题库及答案整理-63
63、Your database is open in ARCHIVELOG mode.LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is ...
2018-09-18 13:14:09
82
转载 OCP认证052考试最新题库及答案整理-62
62、In which state must a database be to enable ARCHIVELOG?A. NOMOUNTB. OPEN in RESTRICTED mode...
2018-09-18 13:01:01
70
转载 OCP认证052考试最新题库及答案整理-61
61、Which two can be configured with profiles?A. tablespace quotas for usersB. the time after which a...
2018-09-18 11:57:04
67
转载 OCP认证052考试最新题库及答案整理-60
60、Which two are true about UNDO data?A. Inactive UNDO is never written to disk.B. Active UNDO is al...
2018-09-17 12:03:05
98
转载 OCP认证052考试最新题库及答案整理-59
59、In which two cases is a consistent database backup created?A. when the RMAN BACKUP command is used whil...
2018-09-17 10:50:17
82
转载 OCP认证052考试最新题库及答案整理-58
58、Examine this session output:SQL> connct scott/tigerConnected.SQL> select name,value f...
2018-09-17 10:35:38
89
转载 OCP认证052考试最新题库及答案整理-57
57、Which two statements are true about dispatchers used by the Oracle shared server?A. Multiple user pro...
2018-09-14 11:06:56
78
转载 OCP认证052考试最新题库及答案整理-56
56、The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled. USER1.EMP is a table in tabl...
2018-09-14 10:46:17
109
转载 OCP认证052考试最新题库及答案整理-55
55、Which is true when a database instance is shut down?A. IMMEIATE, TRANSACTIONAL, and NORMAL modes wait f...
2018-09-14 10:27:56
72
转载 OCP认证052考试最新题库及答案整理-54
54、Your database instance is in NOMOUNT state.Your select the delete option in the database configuration ...
2018-09-14 09:53:39
118
转载 OCP认证052考试最新题库及答案整理-53
53、Which two are true about server-generated alerts?A. Stateful alerts must always be cleared manually....
2018-09-13 10:51:27
110
转载 OCP认证052考试最新题库及答案整理-52
52、In one of your databases:1. USER1 and USER2 have no system privileges.2. ROLE1 only has these pri...
2018-09-13 10:37:37
74
转载 OCP认证052考试最新题库及答案整理-51
51、Examine this query and its output:SQL> select sid,event,blocking_sessionfrom v$sessionwh...
2018-09-13 10:11:17
110
转载 OCP认证052考试最新题库及答案整理-50
50、When does an incremental checkpoint occur?• A. when DBWn writes dirty buffers as part of its normal pro...
2018-09-13 09:55:27
76
转载 OCP认证052考试最新题库及答案整理-49
49、For your ORCL database.1. The instance is started using an spfile.2. The database is opened....
2018-09-12 11:37:47
70
转载 OCP认证052考试最新题库及答案整理-48
48、Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?A. If the directory used i...
2018-09-12 11:04:40
60
转载 OCP认证052考试最新题库及答案整理-47
47、Which two are true about the Data Recovery Advisor?A. It can be used only for databases that are runnin...
2018-09-12 10:46:35
115
转载 OCP认证052考试最新题库及答案整理-46
46、Which three are true about undo segments and undo tablespaces in the same database and instance?A. Mu...
2018-09-12 10:20:56
121
转载 OCP认证052考试最新题库及答案整理-45
45、Which is true when a database instance is shut down?A. Only transactional and normal modes wait for all...
2018-09-11 13:14:41
146
转载 OCP认证052考试最新题库及答案整理-44
44、In one of your databases:* The database default tablespace is EXAMPLE.* Deferred_segment_creation...
2018-09-11 11:06:12
87
转载 OCP认证052考试最新题库及答案整理-43
43、Which two are true about external tables?A. They support the ORACLE_DATAPUMP access driver.B. The...
2018-09-11 10:32:15
82
转载 OCP认证052考试最新题库及答案整理-42
42、Examine these facts about a database:1. USERS is the database default tablespace.2. USER1, USER2,...
2018-09-11 09:40:34
221
转载 OCP认证052考试最新题库及答案整理-41
41、In which state can you back up a database in ARCHIVELOGMODE using RMAN?A. NOMOUNT, MOUNT, AND OPEN...
2018-09-10 13:43:34
57
转载 OCP认证052考试最新题库及答案整理-40
40、 Which is true about logical and physical database structures?(Choose the best answer)A. An undo ...
2018-09-10 13:26:50
70
转载 OCP认证052考试最新题库及答案整理-39
39、 YOUR DB_RECOVERY_FILE_DEST_SIZE Is 8G.Currently, 5G of the space Is used of which 4G consists of obsol...
2018-09-10 11:47:46
60
转载 OCP认证052考试最新题库及答案整理-38
38、Which two are true about data dictionary and dynamic performance views (v$ views)?A) All database use...
2018-09-07 12:19:08
79
转载 OCP认证052考试最新题库及答案整理-37
37、You are planning a software installation for both Oracle Database 11g Release 1 and Release 2.You pla...
2018-09-07 11:56:26
99
转载 OCP认证052考试最新题库及答案整理-36
36、Which two are true about roles?A) A role can be password-protected.B) A role can be granted to an...
2018-09-07 11:06:22
69
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人