
OCP认证052考试最新题库及答案整理-27
27、Which two are true about data dictionary views? A) ALL or USER prefixed views display output that are subsets of the ...
27、Which two are true about data dictionary views? A) ALL or USER prefixed views display output that are subsets of the ...
60、Which two are true about UNDO data? A. Inactive UNDO is never written to disk. B. Active UNDO is always kept in memor...
1、Which two are true about the Archive (ARCn) processes? A) They automatically delete obsolete archive logs to make spac...
50、When does an incremental checkpoint occur? • A. when DBWn writes dirty buffers as part of its normal process • B. whe...
连接操作相关的命令 默认直接连接 远程连接-h 192.168.1.20 -p 6379 ping:测试连接是否存活如果正常会返回pong ...
22、USER1 grants SELECT, INSERT, and UPDATE privileges on USER1. EMP to USER2. SYS executes this command: SQL> REVOKE ...
47、Which two are true about the Data Recovery Advisor? A. It can be used only for databases that are running in ARCHIVEL...
71、Which command is used to display files that no longer conform to the backup retention policy? A. CROSSCHECK BACKUP B....
34、Which is true about invalid PL/SQL objects? A) They are automatically recompiled against the new definition of a refe...
65、Which three structures can span multiple data files? A. chained rows B. segments C. temporary segment extents D. inde...
70、Which two are true about space management in tablespaces? A. Free lists are used for managing free space for segments...
20、Your database is using Automatic Memory Management. Which two SGA components must be managed manually? A) default buf...
2、Which two are true about Optimizer Statistics? A) They do not persist across Instance restarts. B) They are automatica...
69、Which is true about unusable indexes? A. Rebuilding an unusable index always requires at least twice the space of the...
57、Which two statements are true about dispatchers used by the Oracle shared server? A. Multiple user processes can conn...
19、Which two can be backed up by using RMAN when a database Is open in ARCHIVELOG mode, so that media recovery can be pe...
38、Which two are true about data dictionary and dynamic performance views (v$ views)? A) All database users have access ...