CUUG内部OCP题库解析-052-文档6

CUUG内部OCP题库解析-052-文档6题库新特点：oracle 11g版本的ocp认证考试题库，来自cuug整理，考试题大部分都在这里能找到，如果想考ocp认证可以参考这些文档。下面的题是（052考试-第6个文档）里的一些考题。其他题找相关文档，或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档6 7/17/191、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 object privileges for users E. session CPU limits F. default system privileges for users Correct Answer: BE2、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: D3、Your database is open in ARCHIVELOG mode.LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full whena log switch takes place.No alternative or optional archive destinations are defined.What is the outcome? A. Obsolete backups are automatically deleted and now archivelogs aregenerated. B. The archivelog entries are made in the diagnostic destination and whenspace is available, now archivelogs are generated. C. No archivelogs are generated. D. All active sessions are disconnected and their transactions rolled back. E. All active sessions hang until the database administrator (DBA) makesspace available in the FRA. Correct Answer: E4、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 mandatory auditing. C. By default, SYSOPER connections have access to the data dictionary. D. Fine Grained Auditing can be used to restrict access to sensitive data. E. SYSOPER connections are always subject to mandatory auditing. F. Mandatory auditing is enabled by setting AUDIT_SYS OPERATIONS toTRUE. Correct Answer: ABE5. 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 Answer: ABF6、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 not enough space toretain active undo.C. Inactive undo will be retained as long as possible within the limits of the currentsize of the undo tablespace.D. Inactive undo will always be retained for at least 15 minutes.E. Active undo will be retained as long as needed by transactions.Correct Answer: BE 7Which three can reduce lock contention in an Oracledatabase?A. The Database Resource ManagerB. profilesC. scheduling OLTP and batch workloads at different timesD. manual locking of database objects for DML statementsE. committing transactions in a timely mannerCorrect Answer: CDE8、 Which two are true about the Inventory directory? A. It is owned by the oinstall group, which must be createdbefore installing Oracle software for the first time on a server. B. It is shared by all Oracle software installations on a singleserver. C. It should be created before installing Oracle software for thefirst time on a server. D. It is required only for Oracle Grid Infrastructure and OracleDatabase software installations. E. It can be created only if the ORACLE_BASE environmentvariable is set. Correct Answer: AB9、 Which is true about unusable indexes? A. Rebuilding an unusable index always requires at least twicethe space of the original index B. Rebuilding an unusable index always allows DML statementson the index s table during the rebuild. C. Rebuilding occurs automatically when an unusable index ischosen by the optimizer when creating an execution plan D. Rebuilding an unusable index creates a new segment afterdropping the unusable index. Correct Answer: D10、 Which two are true about space management in tablespaces? A. Free lists are used for managing free space for segments inlocally managed tablespaces. B. Extent allocation must be specified as automatic forautomatic segment space management (ASSM) tablespaces. C. ASSM tablespaces prevent row chaining. D. Locally managed tablespaces track adjacent free spaceautomatically by using bitmaps. E. Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other. Correct Answer: DE11、 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 BACKUP COPIES Answer: B12 Table EMP resides in the USERS tablespace.Examine this command:SQL> DROP TABLE emp PURGE;Which two methods would you use to recover EMP? A. Flashback Drop B. re-creating the table and reinserting the rows C. performing a tablespace point in time recove