OCP最新考试题库解析之052考试原题-6-20180615
052题库解析,最新15道题 052-题库解析-6-20180615,题库新特点:, 更加灵活,题库的顺序与考试时的顺序每场都在变化, 更加考验知识点的掌握,题库答案为二,考试时要求选择 最佳一个答案, 不断有新的考题出现,目前最新已经更新到130道题 每周五晚8点-直播地址:ke.qq.com/course/326223 ocp考试讨论群:836361015 验证:ocp CUUG整理,官网:www.cuug.com,1、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: BE,2、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,3、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 archive destinations are defined. What is the outcome? A. Obsolete backups are automatically deleted and now archivelogs are,generated., B. The archivelog entries are made in the diagnostic destination and when space 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) makes space available in the FRA. Correct Answer: E,4、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 to,TRUE., Correct Answer: ABE,5. 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: ABF,6、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 to retain active undo. C. Inactive undo will be retained as long as possible within the limits of the current size 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, 7,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. manual locking of database objects for DML statements E. committing transactions in a timely manner Correct Answer: CDE,8、 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 server. B. It is shared by all Oracle software installations on a single,server., C. It should be created before installing Oracle software for the first time on a server. D. It is required only for Oracle Grid Infrastructure and Oracle Database software installations. E. It can be created only if the ORACLE_BASE environment variable is set. Correct Answer: AB,9、 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 allows DML statements on the index s table during the rebuild. C. Rebuilding occurs automatically when an unusable index is chosen by the optimizer when creating an execution plan D. Rebuilding an unusable index creates a new segment after,dropping the unusable index. Correct Answer: D,10、 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 must be specified as automatic for automatic segment space management (ASSM) tablespaces. C. ASSM tablespaces prevent row chaining. D. Locally managed tablespaces track adjacent free space,automatically 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: DE,11、 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: B,12 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 recovery of USERS D. Flashback Transaction Backout E. Flashback Table,