- 博客(78)
- 收藏
- 关注
RSS订阅转载 OCP题库更新，新版052考试题和答案（78）
78、Which four database objects never have any segments? A) A partitioned index B) A view selecting from a populated table C) An empty index D) ...
2018-09-25 14:33:00
90
转载 OCP题库更新，新版052考试题和答案（77）
77、Which structure can span multiple data files? A) a bigfile tablespace B) a permanent tablespace C) a segment D) a temporary tablespace E) a...
2018-09-25 14:07:00
104
转载 OCP题库更新，新版052考试题和答案（76）
76、Which three structures can span multi-ple data files? A) migrated rows B) table extents C) temporary segment extents D) index extents E) ch...
2018-09-25 13:31:00
129
转载 OCP题库更新，新版052考试题和答案（75）
75、Your database is using Automatic Memory Management. Which two SGA components must be managed manually? A. redo log buffer B. keep buffer pool...
2018-09-21 13:35:00
83
转载 OCP题库更新，新版052考试题和答案（74）
74、Which two can be exported by a non-administrative account by using Data Pump? A. tables B. database C. directory objects D. tablespaces E. ...
2018-09-21 13:07:00
90
转载 OCP题库更新，新版052考试题和答案（73）
73、In one of your databases: The database default tablespace is EXAMPLE. DEFERRED_SEGMENT_CREATION is FALSE. Examine these commands: SQ...
2018-09-21 11:54:00
84
转载 OCP题库更新，新版052考试题和答案（72）
72、Which is true about enabling AUTOEXTEND for data files? A. It can be enabled for data files only in smallfile tablespaces. B. It can be enable...
2018-09-20 15:23:00
67
转载 OCP题库更新，新版052考试题和答案（71）
71、Which command is used to display files that no longer conform to the backup retention policy? A. CROSSCHECK BACKUP B. REPORT OBSOLETE C. LIST...
2018-09-20 14:37:00
75
转载 OCP题库更新，新版052考试题和答案（70）
70、Which two are true about space management in tablespaces? A. Free lists are used for managing free space for segments in locally managed tables...
2018-09-20 14:20:00
73
转载 OCP题库更新，新版052考试题和答案（69）
69、Which is true about unusable indexes? A. Rebuilding an unusable index always requires at least twice the space of the original index B. Rebuil...
2018-09-20 14:09:00
65
转载 OCP题库更新，新版052考试题和答案（68）
68、Which two are true about the Inventory directory? A. It is owned by the oinstall group, which must be created before installing Oracle software...
2018-09-19 11:36:00
88
转载 OCP题库更新，新版052考试题和答案（67）
67、Which three can reduce lock contention in an Oracle database? A. The Database Resource Manager B. profiles C. scheduling OLTP and batch workl...
2018-09-19 11:14:00
135
转载 OCP题库更新，新版052考试题和答案（66）
66、Examine these SQL statements and their output: A. Inactive undo will never be retained for more than 15 minutes. B. The undo tablespace can ...
2018-09-19 10:42:00
121
转载 OCP题库更新，新版052考试题和答案（65）
65、Which three structures can span multiple data files? A. chained rows B. segments C. temporary segment extents D. index extents E. table ext...
2018-09-18 13:48:00
85
转载 OCP题库更新，新版052考试题和答案（64）
64、 Which three are true about Oracle database security? A. By default, SYSDBA connections have access to all schema objects. B. SYSDBA connectio...
2018-09-18 13:32:00
73
转载 OCP题库更新，新版052考试题和答案（63）
63、Your database is open in ARCHIVELOG mode. LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes place...
2018-09-18 13:13:00
92
转载 OCP题库更新，新版052考试题和答案（62）
62、In which state must a database be to enable ARCHIVELOG? A. NOMOUNT B. OPEN in RESTRICTED mode C. OPEN in READ WRITE mode D. MOUNT E. OPEN i...
2018-09-18 13:00:00
141
转载 OCP题库更新，新版052考试题和答案（61）
61、Which two can be configured with profiles? A. tablespace quotas for users B. the time after which an idle session is terminated C. default ta...
2018-09-18 11:56:00
113
转载 OCP题库更新，新版052考试题和答案（60）
60、Which two are true about UNDO data? A. Inactive UNDO is never written to disk. B. Active UNDO is always kept in memory C. Only DML statements...
2018-09-17 12:02:00
56
转载 OCP题库更新，新版052考试题和答案（59）
59、In which two cases is a consistent database backup created? A. when the RMAN BACKUP command is used while the database is OPEN READ ONLY B. wh...
2018-09-17 10:49:00
49
转载 OCP题库更新，新版052考试题和答案（58）
58、Examine this session output: SQL> connct scott/tiger Connected. SQL> select name,value from V$parameter where name='audit_trail'; NAME...
2018-09-17 10:34:00
75
转载 OCP题库更新，新版052考试题和答案（57）
57、Which two statements are true about dispatchers used by the Oracle shared server? A. Multiple user processes can connect to a single dispatcher...
2018-09-14 11:06:00
55
转载 OCP题库更新，新版052考试题和答案（56）
56、The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled. USER1.EMP is a table in tablespace TBS1. There are no existing b...
2018-09-14 10:45:00
83
转载 OCP题库更新，新版052考试题和答案（55）
55、Which is true when a database instance is shut down? A. IMMEIATE, TRANSACTIONAL, and NORMAL modes wait for all uncommitted transactions either ...
2018-09-14 10:27:00
82
转载 OCP题库更新，新版052考试题和答案（54）
54、Your database instance is in NOMOUNT state. Your select the delete option in the database configuration assistant (DBCA) for your database. Wh...
2018-09-14 09:52:00
53
转载 OCP题库更新，新版052考试题和答案（53）
53、Which two are true about server-generated alerts? A. Stateful alerts must always be cleared manually. B. They are visible in Oracle Enterprise...
2018-09-13 10:50:00
64
转载 OCP题库更新，新版052考试题和答案（52）
52、In one of your databases: 1. USER1 and USER2 have no system privileges. 2. ROLE1 only has these privileges: * create session * create table ...
2018-09-13 10:36:00
67
转载 OCP题库更新，新版052考试题和答案（51）
51、Examine this query and its output: SQL> select sid,event,blocking_session from v$session where blocking_session is not null; SID EVENT BL...
2018-09-13 10:10:00
99
转载 OCP题库更新，新版052考试题和答案（50）
50、When does an incremental checkpoint occur? • A. when DBWn writes dirty buffers as part of its normal process • B. when the alter system checkp...
2018-09-13 09:54:00
57
转载 OCP题库更新，新版052考试题和答案（49）
49、For your ORCL database. 1. The instance is started using an spfile. 2. The database is opened. 3. It is in ARCHIVELOG mode. 4. CONTROL FILE ...
2018-09-12 11:36:00
70
转载 OCP题库更新，新版052考试题和答案（48）
48、Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A. If the directory used in the export operation has existing dump ...
2018-09-12 11:03:00
47
转载 OCP题库更新，新版052考试题和答案（47）
47、Which two are true about the Data Recovery Advisor? A. It can be used only for databases that are running in ARCHIVELOG mode. B. It can be use...
2018-09-12 10:45:00
74
转载 OCP题库更新，新版052考试题和答案（46）
46、Which three are true about undo segments and undo tablespaces in the same database and instance? A. Multiple transactions run by the same Oracl...
2018-09-12 10:20:00
51
转载 OCP题库更新，新版052考试题和答案（45）
45、Which is true when a database instance is shut down? A. Only transactional and normal modes wait for all uncommitted transactions to commit or ...
2018-09-11 13:13:00
55
转载 OCP题库更新，新版052考试题和答案（44）
44、In one of your databases: * The database default tablespace is EXAMPLE. * Deferred_segment_creation is false. Examine these commands: SQL>...
2018-09-11 11:05:00
54
转载 OCP题库更新，新版052考试题和答案（43）
43、Which two are true about external tables? A. They support the ORACLE_DATAPUMP access driver. B. They have extents. C. They support all DML op...
2018-09-11 10:26:00
56
转载 OCP题库更新，新版052考试题和答案（42）
42、Examine these facts about a database: 1. USERS is the database default tablespace. 2. USER1, USER2, AND USER3 have the CREATE SESSION privileg...
2018-09-11 09:39:00
55
转载 OCP题库更新，新版052考试题和答案（41）
41、In which state can you back up a database in ARCHIVELOGMODE using RMAN? A. NOMOUNT, MOUNT, AND OPEN B. NOMOUNT AND MOUNT ONLY C. OPEN ONLY D...
2018-09-10 13:42:00
71
转载 OCP题库更新，新版052考试题和答案（40）
40、 Which is true about logical and physical database structures? (Choose the best answer) A. An undo tablespace has a temp file instead of a dat...
2018-09-10 13:25:00
46
转载 OCP题库更新，新版052考试题和答案（39）
39、 YOUR DB_RECOVERY_FILE_DEST_SIZE Is 8G. Currently, 5G of the space Is used of which 4G consists of obsolete backups. You execute this command:...
2018-09-10 11:46:00
53
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人