OCP052中文题库整理版.docx-资料库

7e120114-bdfc-4e8e-9840-30163b47ec37.docx.pdf-第1页.png

第1页 / 共62页

7e120114-bdfc-4e8e-9840-30163b47ec37.docx.pdf-第2页.png

第2页 / 共62页

7e120114-bdfc-4e8e-9840-30163b47ec37.docx.pdf-第3页.png

第3页 / 共62页

7e120114-bdfc-4e8e-9840-30163b47ec37.docx.pdf-第4页.png

第4页 / 共62页

7e120114-bdfc-4e8e-9840-30163b47ec37.docx.pdf-第5页.png

第5页 / 共62页

7e120114-bdfc-4e8e-9840-30163b47ec37.docx.pdf-第6页.png

第6页 / 共62页

7e120114-bdfc-4e8e-9840-30163b47ec37.docx.pdf-第7页.png

第7页 / 共62页

7e120114-bdfc-4e8e-9840-30163b47ec37.docx.pdf-第8页.png

第8页 / 共62页

1.The instance abnormally terminates because of a power outage.断电 Which statement is true about redo log files during instance recovery? 在实例恢复过程中关于重做日志那种是正确的？ C. All redo log entries after the last checkpoint are applied from redo log files to data files 最后一个检查点后的所有重做日志条目都从重做日志文件应用到数据文件。 2.Examine the command: SQL>ALTER USR skd ACCOUNT LOCK; 将 scott 用户上锁 Which two statements are true after the command is executed.? (Choose two.) A. The SKD user cannot log in to the database instance 不能连接到数据库 C. The other users can access the objects owned by the SKD user, on which they have access 其他用户可以访问 3.For which database operation would you need the database to be in the MOUNT state? 那种情况是需要在装载状态下 E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes 修改数据库归档模式或非归档模式 4.The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.Which statement is true in this scenario? 一个作业在你的数据库实例的自动维护窗口中为一些对象正在搜集优化统计信息，在一个特定的时间点，所有对象的统计信息还没有搜集完，维护窗口就关闭了，此时： D. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened. 这个作业被终止，剩下的统计信息的搜集将在下次维护窗口打开的时候继续搜集 5.You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database.Which option of IMPDP would you use to accomplish this task? 你想要移动的应用程序的用户在测试数据库中的所有对象的 db_usr 图式生产数据库。您会选择 IMPDP 哪个参数用来完成这项任务吗？ D. REMAP_SCHEMA 6.You executed the following command to create a password file in the database server: $ orapwd file = orapworcl entries = 5 ignorecase=N Which statement describes the purpose of the above password file? 哪个语句描述了上述密码文件的用途？

C. It is used by Oracle to authenticate users for remote database administrator 用于用户远程连接验证 7.Which two statements are true regarding the MRKT tablespace? (Choose two.) SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered. A. No more data files can be added to the tablespace.没有更多的数据添加到表空间 C. A user created without being assigned a default tablespace uses this tablespace. 设置默认表空间，以后用户创建的数据都会放在这个表空间里 size 10M LOGGING 3 EXTENT 8.View the Exhibit and examine the privileges granted to the MGR_ROLE role.、 The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command: SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION; Which statement is true about the user SKD after he/she is granted this role? A. The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it 可以授权给 MGR_ ROLE 给别的用户，但不能把 MGR_ ROLE 里面的权限如 cr eat e user 授

权给别的用户 9.After performing a clean shut down of the database instance for maintenance, you mount the database 在清理维护完数据实例后挂载数据库 and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements are true? (Choose two.) A. The online redo log files and online data files are opened 打开所有数据文件和联机重做日志文件 B. All the online data files headers are checked for consistency 检查数据库的一致性 10.Examine the command that is used to create a table: SQL> CREATE TABLE orders (oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamt NUMBER(10,2) ) TABLESPACE users; Which two statements are true about the effect of the above command? (Choose two.) B. A NOT NULL constraint is created on the OID column. D. The ORDERS table and a unique index are created in the USERS tablespace. 唯一的索引 11.Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.) 共享 sql 区和私有 sql 区 A. Shared SQL Area will be allocated in the shared pool 共享 S QL 区域将在共享池中分配 F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter 私人 S QL 区域分配的数量依赖于判断参数。 12.Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can be created on temporary tables 可以临时表上创建索引和视图 C. Temporary tables are always created in a user's temporary tablespace 一个用户的临时表就放在当前用户的临时表空间中 E. Data Manipulation Language (DML) locks are never acquired on the data of temporary tables 数据操作语言（DML）锁不上临时表的数据采集 13.Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? 哪两种故障使数据恢复顾问( DRA) 生成一个手动检查表 B. Failure because a data file is renamed accidentally 数据文件重命名 D. Failure due to loss of connectivity-for example, an unplugged disk cable 未插入磁盘电缆

14.Which two statements correctly describe the relation between a data file and the logical database structures? 哪两个语句正确地描述了数据文件和逻辑数据库结构之间的关系？ A. An extent cannot spread across data files. 在一定程度上不能跨越数据文件。 C. A data file can belong to only one tablespace. 一个数据文件只能属于一个表空间。 15.Which two statements are true regarding a tablespace? (Choose two.) B. It can consist of multiple data files 它可以包含多个数据文件。 D. It can contains segments of different sizes 可以包含不同大小的片段。 16.Which two statements are true regarding Oracle Data Pump? (Choose two.) 数据泵 A. EXPDP and IMPDP are the client components of Oracle Data Pump EXP DP 和 I MP DP Or acl e 数据泵的客户端组件。 B. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients DBMS_DATAP UMP PL/SQL 包可以独立使用的数据泵的客户。 17.Identify the two situations in which the alert log file is updated with details. 确定警报日志文件与详细信息更新的两种情况。 A. Running a query on a table returns "ORA-600: Internal Error" 已发生的所有内部错误 ( ORA- 600) E. Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578: ORACLE data 块损坏错误( ORA- 1578 )block corrupted (file # 14, block @ 50)." 块损坏错误 ( ORA- 1578 ) 18.Which two statements are true about alerts? (Choose two.) 警报 A. Clearing an alert sends the alert to the alert history 清除警报将警报发送到警报历史。 D. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified 服务器生成的警报通知不能自动解决的问题，并要求管理员得到通知。 19.Examine the following steps performed on a database instance: 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION 2. The SKD user creates a table 3. The SKD user grants the CREATE TABLE system privilege to the HR user 4. The HR user creates a table 5. The DBA revokes the CREATE TABLE system privilege from SKD Which statement is true after step 5 is performed? C. The table created by HR remains and HR still has the CREATE TABLE system privilege 由

HR 创建的表和 HR 仍然具有创建表系统特权。 20.You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; 删除所有的参照完整性约束包括主键约束和唯一性约束。 Which two statements are true about the effect of the command? (Choose two.) A. No flashback is possible to bring back the ITEM table. 不可能闪回来返回项目表。 D. The dependent referential integrity constraints in the ORDERS table are removed. 删除订单表中的依赖引用完整性约束。 21.View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command? A. The command executes successfully 22.You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (

startdate DATE, enddate DATE, class CHAR(20) ) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction? 指定插入行的生存期为会话的持续时间 A. The rows stay in the table only until session termination 表中的行保持直到会话终止。 23.You want to access employee details contained in (flat files) 平面文件 as part of the EMPLOYEE table. You plan toadd a new column to the EMPLOYEE table to achieve this. Which data types would you use for the new column? C. BFILE ( v_deptno NUMBER, v_dname 24.The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users: CREATE OR REPLACE PROCEDURE create_dept VARCHAR2, v_mgr NUMBER, v_loc NUMBER) BEGIN INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END; The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this? B. Create the procedure with invoker's right. 创建程序的调用是正确的。 25.Examine the following command that is used to create a table: 重复题 SQL> CREATE TABLE orders ( oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamt NUMBER(10,2) ) TABLESPACE users; Which two statements are true about the effect of the above command? (Choose two.) B. A NOT NULL constraint is created on the OID column D. The ORDERS table and a unique index are created in the USERS tablespace 26.View the Exhibit to examine the details for an incident

Which statement is true regarding the status of the incident? D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle 事件的数据收集已经完成，事件可以打包并发送到 Oracle 27.What can you achieve by implementing reverse key index? 通过反向键索引可以实现什么？ C. Prevent contention on the highest leaf block when using sequences to generate keys 在使用序列生成密钥时防止在最高叶块上发生争用 28.What is the effect of this command? SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables 如果用户 scott 成功地删除一个或多个表，则为整个会话创建一个审计记录。 29.You executed the following command to perform a backup of the USERS tablespace: 您执行以下命令执行备份的用户表空间: SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error? B. The database is in NOARCHIVELOG mode. 数据库在非归档模式下

30.Which statements listed below describe the data dictionary views? 下面列出的哪些语句描述了数据字典视图？ 1. These are stored in the SYSTEM tablespace 这些存储在系统表空间中。 2. These are the based on the virtual tables 这些是基于虚拟表的 3. These are owned by the SYS user 这些是 sys 用户拥有的。 4. These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE 这些可以通过一个普通用户只有 o7_dictionary_accessiblility 参数设置为查询 5. The V$FIXED_TABLE view can be queried to list the names of these views ----V $ fixed_table 视图可以查询这些视图的名称列表 A. 1 and 3 B. 2,3 and 5 C. 1,2, and 5 D. 2,3,4 and 5 Answer: A 31.View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command: RMAN> REPAIR FAILURE; D. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command 该命令产生一个错误，因为在修复失败命令之前未执行通知失败命令。 32.You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS 重复题 table: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about the effect of the command? (Choose two.) A. No flashback is possible to bring back the ITEM table D. The dependent referential integrity constraints in the ORDERS table are removed

资料库

OCP052中文题库整理版.docx

相关推荐

数据库

热门标签

最新资料