当前位置：文档之家 › 【CUUG内部资料】OCP-052-考试原题讲解-第8次课

【CUUG内部资料】OCP-052-考试原题讲解-第8次课

  • 格式：pdf
  • 大小：416.24 KB
  • 文档页数：18

九. Inventory Directory 24. Which two are true about the Inventory directory? A) It is shared by all Oracle software installations on a single server. B) It is required only for Oracle Grid Infrastructure and Oracle Database software Installations. C) It can be created only if the ORACLE_BASE environment variable is set. D) It should be created before installing Oracle software for the first time on a server. E) It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server. Answer：AD
23. Which two of these must be available READ/WRITE to keep a database open? A) all copies of the control file. B) the password file. C) all members of the current redo log group. D) spfile. E) TEMP tablespace F) SYSAUX tablespace
30. Which two statements are true regarding the Oracle Data Pump export and import operations?（choose two） A) You cannot export data from a remote database. B) You can rename tables during an import operation. C) You can overwrite existing dump files during an export operation. D) You can compress the data during export but not the metadata because it is not supported. Answer: BC
31. Examine these facts about objects in the SYSTEM schema: 1.EMP is a table. 2.EMP_PK is a primary key constraint on EMP.ENO. 3.EMP_IDX is an index on EMP.MGR_NO. 4.EMP_SEQ is a sequence used to generate values for EMP.ENO. 5.EMP_OPS_PKG is a package that performs DML operations on EMP. 6.EMP_VU is a view on EMP. 7.EMP_TRG is a trigger on EMP. Examine this command: $ expdp system/oracle \ > FULL =Y \ > EXCLUDE=TABTLE:"= 'EMP' "\ > DIRECTORY=data_pump_dir \ > DUMPFILE=full_db.dmp \ > LOGFILE=full_db.1og Which three objects will be exported? A) EMP_PK B) EMP_SEQ C) EMP_OPS_PKG D) EMP_VU E) EMP_IDX F) EMP_TRG G) EME_FN Answer：BCD (已验证） expdp system/oracle DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott EXCLUDE=TABLE:\"IN\(\'EMP\'\)\" SCHEMAS=scott
Answer：BCEG
八. Checkpoint 25. When does an incremental checkpoint occur ? A) when an online redo log switch occurs. B) when DBWn writes dirty buffers as part of its normal processing. C) when the ALTER SYSTEM CHECKPOINT statement is executed. D) when a user tablespace is tabken offline. Answer： A
Answer：AC
24. Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/ db01’.The parameters, DB_CREATE_ONLINE_LOG_DESN_n and DB_RECOVERY_FILE_DEST, and not specified. Which four are stored in the location specified by DB_CREATE_FILE_DEST? A) audit logs B) control files C) redo logs D) audit files E) data files F) archived redo logs G) temp files H) RMAN backups
十. Administer Database
25. which four are true about the tools used to administer Oracle database? A) the Data Pump utility can be used to load data from text files. B) SRVCTL can be used to shut down Oracle instances. C) SQL* Plus can be used to create databases. D) SQL*Plus can be used to startup Oracle instances. E) DBCA can be used to upgrade databases. F) RMAN can be used to startup Oracle instances. Answer：BCDF
十一.Archivelog
26. Which state must a database be to enable ARCHIVELOG ? A) NOMOUNT B) OPEN IN READ WRITE mode C) OPEN IN READ ONLY mode D) OPEN IN RESTRICTED mode E) MOUNT
11g expdp工具支持压缩和加密功能，但是加密的时候需要用到密码。压缩的 级别分别是ALL, DATA_ONLY, METADATA_ONLY,DEFAULT 或 NONE。默认是会采用 DEFAULT的压缩方式采用METADATA_ONLY级别压缩。加密的级别是ALL, DATA_ONLY, METADATA_ONLY,ENCRYPTED_COLUMNS_ONLY 或 NONE。 如果当前的dump文件已经存在，需要使用参数REUSE_DUMPFILES ＝y 覆盖 目标转储文件
Answer：BD
28. Where is an expdp operation tracked? A) dump files B) control file C) log files D) Automatic Diagnostic Repository(ADR) E) mich 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
22. Which three of these must be accessible to keep a database open? A) Control file. B) All members of a redo log group. C) SYSTEM tablespace. D) SYSAUX tablespace. E) spfile Answer：ABC
052题库解析
最新15道题
题库新特点：
最原有的题库基础上有添加了新的题库
七. Storage Structures 19. Which three structures can span multiple data files？ A) migrated rows B) table extents C) temporary segment extents D) index extents E) chained rows F) segments Answer：AEF
21. 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 table E) An empty table F) A view selecting from an empty table G) An Oracle Data Pump type external table Answer：BDFG

合集下载

【CUUG内部资料】OCP最新考试题库-1Z0-062(1)

【CUUG内部资料】OCP最新考试题库-1Z0-062(1)

Correct Answer: DE
OCP最新考试题库 1015267481 QUESTION 7 3群： Which two statements correctly describe the relationship between data files a nd logical 流 database structures? 试交 A. A segment cannot span data files. OCP考 B. A data file can belong to only one tablespace.
A. by granting a secure application role to the user B. by implementing Database Resource Manager C. by using Oracle Label Security options D. by assigning a profile to the user Correct Answer: D
】 B. An extent can span multiple segments, 料 C. Each data block always corresponds to one operating system block. 部资 D. It is possible to have tablespaces of different block sizes. 【CUUG内 -1Z0-062 E. A data block is the smallest unit of I/O in data files.
： A. Undo data is written to flashback logs after 1200 seconds. 3群 B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack 交流 of space in the undo tablespace. CP考试 C. You can perform a Flashback Database operation only within t he duration of 1200 seconds. O D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite
2018ocp 052最新题库及答案整理--6月15日

2018ocp 052最新题库及答案整理--6月15日

052题库解析-6.15题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案不断有新的考题出现新版 OCP 题库解析公开课地址：/course/307596收看直播 = 一手 OCP 考试消息 + 学技术涨经验 + 过关考试 + 技术解答更多 OCP 的新题解析资料群：569933648 验证码：ocp1、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 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 ar chivelog 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 ha ng until the database administrator (DBA) makes space 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 alw ays 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: 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 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 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 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: AB9、 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 segm ent after dropping 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 in locally managed tablespaces.• B. Extent allocation must be specifie d 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 AS SM 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 recovery of USERS• D. Flashback Transaction Backout• E. Flashback Table• Answer: BC12 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 a tablespace by using the ALTER TABLESPACE command.• C. It can be enabled only for data files in non-OMF tablespaces.• D. It c an be enabled for data files only in bigfile tablespaces.• E. It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablespace have autoextend enabled.• Answer:B13 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_4U PASSWORD EXPIRE;• User created.• SQL> ALTER USER user1 ACCOUUNT UNLOCK;• User altered.• S QL> GRANT CREATE SESSION to user1;• Grant succeeded.• SQL> GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;• Grant succeeded.• Which three are true?• A. USER1 can grant the CREATE TABLE privilege to other users.• B. USER1 can log in to the database ins tance.• C. USER1 can create tables in the EXAMPLE tablespace.• D. USER1 can create indexes in EXAMPLE tablespace• E. USER1 must change it‟s password at first login.• Answer: ABE14 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: AE15 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. default buffer Cache• Answer: AB。

【CUUG内部资料】OCP-052-考试原题讲解-第13次课

【CUUG内部资料】OCP-052-考试原题讲解-第13次课


117. which three are true when a database instance is shut down? A) STARTUP FORCE performs a CHECKPOINT then ABORTS the database instance. B) SHUTDOWN IMMEDIATE performs a CHECKPOINT. C) SHUTDOWN TRANSACTIONAL rolls back uncommitted transactions. D) SHUTDOWN IMMEDIATE rolls back uncommitted transactions. E) SHUTDOWN TRANSACTIONAL preform a CHECKPOINT. F) SHUTDOWN ABORT rolls back uncommitted transactions. Answer：BDE
A) They display information that is not available in data dictionary views. B) They can be queried only by SYS even when the database is open. C) They display selected data from data dictionary base tables. D) Read consistency is not guaranteed for these views. E) Some of them display data that is useful for SQL statement tuning. Answer：ADE
120. in which state can you back up a database in ARCHIVELOGMODE using RMAN? A) MOUNT and OPEN only B) NOMOUNT and MOUNT only C) NOMOUNT,MOUNT, and OPEN D) OPEN RESTRICTED only E) OPEN only Answer：A
【CUUG内部资料】OCP-12C-1Z0-062题库解析-第3次课

【CUUG内部资料】OCP-12C-1Z0-062题库解析-第3次课

【CUUG 内部资料】OCP-12C-1Z0-062题库解析-第3次课序：2018年的时候，OCP 11g 考试题库大更新，052 053出现了很多新题，2019年，11g 即将停考的前期，Oracle 又出现了一次大变动，12c 出现了很多新题，比如062 063题库大更新QUESTION 31Which two are true concerning a multitenant container database with three pluggable database? A. All administration tasks must be done to a specific pluggable database. B. The pluggable databases increase patching time. C. The pluggable databases reduce administration effort. D. The pluggable databases are patched together . E. Pluggable databases are only used for database consolidation. Correct Answer: CEQUESTION 32Examine the current value for the following parameters in your database instance:SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the following command to increase the value of DB_8K_CACHE_SIZE:SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; Which statement is true? A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically. B. It succeeds only if memory is available from the autotuned components if SGA. C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET .D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated withinSGA_MAX_SIZE. Correct Answer: B QUESTION 33Which three statements are true concerning unplugging a pluggable database (PDB)? A. The PDB must be open in read only mode. B. The PDB must be closed.C. The unplugged PDB becomes a non-CDB.D. The unplugged PDB can be plugged into the same multitenant container database (CDB)E. The unplugged PDB can be plugged into another CDB.F. The PDB data files are automatically removed from disk. Correct Answer: BDEC U U G C U U G C U U G 内部考试资料 内部考试资料 O C P 讨论群：1015267481C U U G C U U G C U U G 内部考试资料 内部考试资料 严禁外传O C P 讨论群：1015267481QUESTION 34Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in t he PRODUCTS table?A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.B. The DESCRIBE commands in SQL *Plus will not display the invisible column in t he output.C. Referential integrity constraint cannot be set on t he invisible column.D. The invisible column cannot be made visible and can only be marked as unused.E. A primary key constraint can be added on t he invisible column. Correct Answer: ABE (解析：一般来说,看不见列帮助迁移和发展在线应用程序。