《2023年考试题库考试原题》由会员分享,可在线阅读,更多相关《2023年考试题库考试原题(48页珍藏版)》请在金锄头文库上搜索。
1、052题库解析最新16道题052-题库解析-5-0608题库新特点:l 愈加灵活,题库旳次序与考试时旳次序每场都在变化l 愈加考验知识点旳掌握,题库答案为二,考试时规定选择最佳一种答案l 不停有新旳考题出现,目前最新已经更新到130道题每周五晚8点-直播地址: 验证:ocpCUUG整顿,官网:.com1、Which three are true about undo segments and undo tablespaces in the same database and instance? A. Multiple transactions run by the same Oracle us
2、er canshare a single undo segment. B. Multiple transactions run by different Oracle users canshare a single undo segment. C. A serial transaction can use multiple undo segments. D. Undo segments are automatically dropped shortly aftertransactions that use them commit. E. A new undo segment is always
3、 created for each transaction. F. A database can have multiple undo tablespaces. Correct Answer: ABF2、Which two are true about the Data Recovery Advisor? A. It can be used only for databases that are running inARCHIVELOG mode. B. It can be used when the database is closed. C. It can be used to valid
4、ate database recovery strategies. D. It provides intelligent database problem analysis. E. It can be used to validate database backup strategies. F. It can be used only for databases with FLASHBACK enabled. Correct Answer: CD3、Which two are true about Oracle Data Pump in Oracle Database 11g Release
5、2? A. If the directory used in the export operation has existingdump files, it overwrites them. B. It allows encryption to be performed without using apassword. C. It supports the renaming of tables during import. D. It supports the export of specific views as tables. E. It allows compression levels
6、 to be defined for the export. Correct Answer: BE4、For your ORCL database.1. The instance is started using an spfile.2. The database is opened.3. It is in ARCHIVELOG mode.4. CONTROL FILE AUTOBACKUP IS ON.Examine this command:RMAN backup as copy datafile users01.dbf ,example01.dbf ; Which four files
7、are backed up? A. spfile B. undo01.dbf C. users01.dbf D. archivelogs E. sysaux01.dbf F. control file G. system01.dbf H. example01.dbf Correct Answer: ACFH5、 When does an incremental checkpoint occur? A. when DBWn writes dirty buffers as part of its normal process B. when the alter system checkpoint
8、statement is executed. C. when a user tablespace is taken offline D. when an online redo log switch occurs Correct Answer: A6、 Examine this query and its output:Which two are true? A. The blocked session is waiting on a shared table lock. B. The blocked session is waiting on an enqueue. C. The block
9、ing session is waiting on a row-level lock. D. Session 105 is blocked by session 15. E. Session 105 is blocking session 15. Correct Answer: BD 7、 In one of your databases:1. USER1 and USER2 have no system privileges.2. ROLE1 only has these privileges: * create session* create table * create viewExam
10、ine these commands:7Which command would you execute and as which user, to revoke the createtable privilege from USER2? A. Revoke create table from user2 as user1 B. Revoke create table from user1 as sys C. Revoke create table from role1 as user1 D. Revoke create table from role1 as sys E. Revoke cre
11、ate table from user2 as sys Correct Answer: D假如用user1回收角色旳权限,会报错:SQL revoke create session from role1;revoke create session from role1*ERROR at line 1:ORA-01031: insufficient privileges8、 Which two are true about server-generated alerts? A. Stateful alerts must always be cleared manually. B. They ar
12、e visible in Oracle Enterprise Manager by default. C. All stateful alerts can be found in DBA_ALERT_HISTORY. D. They can be based only on database metrics. E. Stateless alerts cannot be found inDBA_OUTSTANDING_ALERTS. F. They can be based only on instance metrics. Correct Answer: BE9、 Your database
13、instance is in NOMOUNT state.Your select the delete option in the database configurationassistant (DBCA) for your database.What is the outcome? A. DBCA is able to delete the data files but not the services. B. DBCA shuts down the instance and deletes the database. C. DBCA is able to delete the servi
14、ces but not the data files. D. DBCA prompts you to open the database, and then proceedswith the deletion.Correct Answer: D10、 Which is true when a database instance is shut down? A. IMMEIATE, TRANSACTIONAL, and NORMAL modes wait for all uncommitted transactions either to commit or rollback and then
15、close the database B. IMMEIATE, TRANSACTIONAL, and NORMAL modes all resultin a checkpoint C. Only TRANSACTIONAL, and NORMAL modes wait for all uncommitted transactions to commit or rollback and then close the database D. Neither the IMMEDIATE nor the ABORT mode rolls backuncommitted transactions.Correct Answer: B11、 The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled. USER1.EMP is a table in tablespace TBS1.There are no existing backups of the database.Examine these comm