加载中
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) An Oracle Loader type external ta...

OCP
2018/09/25 14:33
59
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) an extent Answer:C 北京CUUG整理,转...

OCP
2018/09/25 14:07
4
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) chained rows F) segments Answer:AEF...

OCP
2018/09/25 13:31
1
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 C. large pool D. shared pool E....

OCP
2018/09/21 13:35
1
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. schemas Answer: AE 北京CUUG整理,转...

OCP
2018/09/21 13:07
3
OCP题库更新,新版052考试题和答案(73)

73、In one of your databases: The database default tablespace is EXAMPLE. DEFERRED_SEGMENT_CREATION is FALSE. Examine these commands: SQL> CREATE USER user1 IDENTIFIED BY oracle...

OCP
2018/09/21 11:54
14
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 enabled for an existing data file in ...

OCP
2018/09/20 15:23
5
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 EXPIRED BACKUP D. SHOW DATAFILE...

2018/09/20 14:37
2
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 tablespaces. B. Extent allocation mu...

OCP
2018/09/20 14:20
7
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. Rebuilding an unusable index always a...

OCP
2018/09/20 14:09
1
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 for the first time on a serve...

2018/09/19 11:36
26
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 workloads at different times D. manua...

2018/09/19 11:14
26
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 grow automatically if there is no...

OCP
2018/09/19 10:42
80
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 extents F. migrated rows Correct Answ...

OCP
2018/09/18 13:48
11
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 connections are always subject to mandat...

OCP
2018/09/18 13:32
11
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. No alternative or optional a...

OCP
2018/09/18 13:13
13
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 in READ ONLY mode Correct Answer: D...

OCP
2018/09/18 13:00
9
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 tablespace for users D. default ob...

OCP
2018/09/18 11:56
7
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 generate UNDO. D. Active UNDO c...

OCP
2018/09/17 12:02
7
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. when the RMAN BACKUP AS COPY comm...

2018/09/17 10:49
13

没有更多内容

加载失败,请刷新页面

返回顶部
顶部