⼗十四.DBlink
24. you successfully executed these commands:
connect scott/tiger@prod1; CREAET DATABASE LINK db_prod2
CONNECT TO scott IDENTIFIED BY tiger USING 'PROD2';
Which type of database link is created?
A) private current user database link
B) public connected user database link
C) public current user database link
D) private fixed user database link
need-to-insert-img
E) public fixed user database link
：
need-to-insert-img
⼗十五.External Table
25. which is true about external tables?
A) Segments are allocated for external tables.
B) They may have indexes.
C) They do not support partitioning.
D) The ORACLE_DATAPUMP access driver can be used to write data to external tables.
E) DML operations may be performed on external tables.
Answer：D （验证过）
need-to-insert-img
need-to-insert-img
need-to-insert-img
26. Which two are true about external tables?
A) They can be stored in an ASM Cluster File System(ACFS).
B) They can always be updated using SQL.
need-to-insert-img
C) They support the ORACLE_DATAPUMP access driver.
D) They have extents.
E) They support all DML operations.
Answer：AC
27. You want to access employee details contained in flat files created by an application. Which two methods will achieve this?
A) Use a BFILE column in a table to access the flat file.
B) Use an Oracle Loader type External table.
C) Use an Oracle Data Pump type External table.
D) Use a CLOB column in a table to access the flat file.
E) Use a LONG RAW column in a table to access the flat file.
Answer：AB
need-to-insert-img
⼗十六.Temporary table
28. Examine this command:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area
(startdateDATE,
enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS;
Which three statements are true about rows inserted into REPORT_WORK_AREA?
A) Rows will be lost if a ROLLBACK is done.
B) Rows will be lost upon session failure.
C) Rows are visible to all sessions logged in by the same user until the session that inserted the rows terminates.
D) Rows are visible to all sessions logged in by all users granted the DBA role until the session that inserted the rows terminates.
need-to-insert-img
E) Rows will be lost upon session normal termination.
F) Rows are visible globally to all sessions logged in by any user until the session that inserted the rows terminates.
Answer：ABE
need-to-insert-img
need-to-insert-img
need-to-insert-img
need-to-insert-img
need-to-insert-img
need-to-insert-img
⼗十七.ADDM
41. Which three are true about the Automatic Database Diagnostic Monitor (ADDM)?
A) It improves database performance by automatically implementing Oracle ‘s best practices.
B) It can assist the DBA in diagnosing database instance startup failures.
C) It can be used by executing the PL/SQL procedures in the DBMS_ADDM package.
D) It runs automatically after each Automatic Workload Repository snapshot is created.
E) It provides recommendations to improve database performance.
F) Its findings are accessible only by using Oracle Enterprise Manager.
Answer：CDE
42. Which is true about the Automatic Diagnostic Repository (ADR) ？
A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured.
B) It only contains the alert log and trace files for background processes.
C) Its location is always set by the ORACLE_BASE variable.
D) It includes diagnostic data for critical errors for each server and background process.
Answer：D
43. Which two statements are true about the Automatic Diagnostic Repository (ADR) ？
A) It only exists if DIAGNOSTIC_DEST is configured in the SPFILE.
B) It includes diagnostic data for critical errors for background processes.
C) It only contains the alert log.
D) It only contains trace files.
E) It includes diagnostic data for critical errors for client processes.
F) It includes diagnostic data for critical errors for server process.
Answer：BF
在Oracle的11g版本中，alert文件的位置发生了变化，与此同时Oracle提供了一个命令行工具ADRCI，它可以很便利的查看数据库中出现的异常。
1.查看到adrci命令行帮助
$ adrci -help
2.使用 help show alert 命令查看帮助文档
adrci> help
3.使用 show alert 列出各个目录下的日志目录
adrci> show alert
ADR的结构和位置：
初始化参数diagnostic_dest指定了ADR的根目录。即使你忽略了该初始化参数。oracle也会创建ADR。
如果你设置了ORACLE_BASE环境变量，那么diagnostic_dest缺省值是该目录。如果你没有设置ORACLE_BASE变量，该参数值为$ORACLE_HOME/log目录。
ADR存储所有oracle产品的诊断数据。ADR为每一个oracle产品及其实例分配一个单独的home目
录。因此一个ADR目录包含多个home目录。每一个ADR的home目录是一个为每一个数据库实例或其它oracle产品或组件存储其诊断文件。其目录结构如下：
ADR_base/diag/product_type/product_id/instance_id/，比如一个 diagnostic_dest初始化参数为 /u05/
app/oracle。那么一个oracle数据库的sid为prod1的home目录就如下所示：
/u05/app/oracle/diag/rdbms/prod1/prod1/
need-to-insert-img
⼗十⼋八.FRA
44. Which two are true about the Fast Recovery Area (FRA)?
A) It should be larger than the database.
B) Only consistent backups can be stored in the FRA.
C) Space management in the FRA is influenced by the database backup retention policy.
D) It must reside on the same file system as the database data files.
E) A database must be in ARCHIVELOG mode to use the FRA.
Answer：AC
45. 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 new archivelogs are generated.
B) All active sessions hang until the database administrator (DBA) makes space available in the FRA.
C) The archivelog entries are made in the diagnostic destination and when space is available, new archivelogs are generated.
D) All active sessions are disconnected and their transactions rolled back.
E) No archivelogs are generated.
Answer：A （验证过）
46. Your DB_RECOVERY_FILE_DEST_SIZE IS 8G,
Currently，5G of the space is used of which 4G consists of obsolete backups, You execute this command;
SQL> ALTER SYSTEM SET db_recovery_file_dest_size=2G;
What is the outcome?
A) It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes the obsolete backups
B) It changes DB_RECOVERY_FILE_DEST_SIZE to 5G
C) It fails because DB_RECOVERY_FILE_DEST_SIZE is a static parameter
D) It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups
E) It fails because the new size is less than 5G
Answer：D（验证过）
need-to-insert-img
⼗十九.Privileges
47. USER1 grants SELECT, INSERT, and UPDATE privileges on USER1.EMP to USER2. Sys executes this command:
SQL> REVOKE UPDATE ON user1.emp FROM user1;
What will be the outcome?
A) It will fail because USER1 is the owner of USER1.EMP.
B) It will succeed but neither USER1 nor USER2 will be able to perform SELECT, INSERT, or UPDATE on USER1.EMP.
C) It will succeed and only USER1 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP.
D) It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1.EMP, but both will be able to query USER1.EMP.
E) It will succeed and only USER2 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP.
Answer：A
48. USER1 grants SELECT and UPDATE privileges on USER1.EMP to USER2 SYS executes this command
SQL> REVOKE SELECT ON user1.emp FROM user1;
What will be the outcome?
A) It will succeed and USER2 will be unable to perform SELECT on USER1.EMP
B) It will succeed and USER2 will be unable to perform sELECT or UPDATE on USER1 EMP because updates require select be done internally
C) It will fail because sys can not revoke object privileges for other users
D) It will fail because USER1 owns USER1.EMP
Answer：D
49. Examine these facts about a database:
1. USER is the database default tablespace.
2. USER1, USER2, and USER3 have the CREATE SESSION privilege.
3. They also have UNLIMITED QUOTA on the default tablespace USERS.
4. They have no other privileges.
Examine these commands:
need-to-insert-img
SQL> conn / as sysdba Connected.
SQL> GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;
Grant succeeded.
SQL> conn user1/oracle_4U Connected.
SQL> GRANT CREATE TABLE TO user2;
Grant succeeded.
SQL> GRANT CREATE TABLE TO user3 WITH ADMIN OPTION;
Grant succeeded.
Which two are true?
A) If SYS revokes CREATE TABLE from USER1, it is not revoked from USER2 and USER3.
B) Only SYS can revoke CREATE TABLE from USER1.
C) If SYS revokes CREATE TABLE from USER1, it is revoked from USER2 but not from USER3.
D) Any user with CREATE TABLE WITH ADMIN OPTION can revoke CREATE TABLE from USER1.
E) Only SYS and USER1 can revoke CREATE TABLE from USER3.(为什么错了？）
Answer：AD
50. Examine the facts about a database:
1. USERS is the database default tablespace.
2. USER1,USER2,and USER3 have the CREATE SESSION privilege.
3. They also have UNLIMITED QUOTA on the default tablespace USERS.
4. They have no other privileges. Examine these commands:
SQL > conn / as sysdba Connected
SQL > GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;
Grant succeeded.
SQL > GRANT CREATE TABLE TO user2;
Grant succeeded.
SQL > GRANT CREATE TABLE TO user3 WITH ADMIN OPTION;
Grant succeeded.
Which two are true ?
A) If sys revokes CREATE TABLE from user1 , it is not revoked from USER2 and USER3.
B) Only sys can revoke CREATE TABLE from user1.
need-to-insert-img
C) If sys revokes CREATE TABLE FROM user1 , it is revoked from user2 but not from user3.
D) Any user with CREATE TABLE WITH GRANT OPTION can revoke CREATE TABLE from user1.
E) Only sys and USER1 can revoke CREATE TABLE from user3.
Answer: AD
51. Examine these facts about a databases:
1. USERS is the database default tablespace.
2. USER1,USER2,and USER3 have the CREATE SESSION privilege
3. They also have UNLIMITED QUOTA on the default tablespace USERS.
4. They have no other provileges. Examine these commands:
SQL>conn / as sysdba Connected.
SQL>GRANT CREATE TABLE TO user1 WITH ADMIN OPTION
Grant succeeded
SQL>conn user1/oracle_4U Connected.
SQL>GRANT CREATE TABLE TO user2;
Grant succeeded.
SQL>GRANT CREATE TABLE TO user3 WITH ADMIN OPTION;
Grant succeeded.
Which two are true?
A) If sys revokes CREATE TABLE from USER1,it is not revoked from USER2 and USER3
B) Any user with CREATE TABLE WITH ADMIN OPTION can revoke CREATE TABLE from USER1
C) If sys revokes CREATE TABLE from USER1,it is revoked from USER2 but not from USER3
D) Only sys and USER1 can revoke CREATE TABLE from USER3
E) Only sys can revoke CREATE TABLE from USER1.
Answer：AB
49. In one of your databases:
1. USER1 and USER2 have no system privileges.
2. ROLE1 only has these privileges:
• CREATE SESSION
• CREATE TABLE
• CREATE VIEW
Examine these commands: SQL> conn / as sysdba Connected.
need-to-insert-img
SQL> GRANT create table, role1 TO user1 WITH ADMIN OPTION; Grant succeeded.
SQL> conn user1/oracle_4U Connected.
SQL> GRANT role1 TO user2;
Grant succeeded.
Which command would you execute and as which user, to revoke the create table privilege from USER2?
A) REVOKE CREATE TABLE FROM user2 as SYS
B) REVOKE CREATE TABLE FROM role1 as SYS
C) REVOKE CREATE TABLE FROM role1 as USER1
D) REVOKE CREATE TABLE FROM user1 as SYS
Answer: B
只有sys用户才能够从role中revoke权限，而user1只能把role授权给其它用户，或者从其它用户回收role。
50. In one of your databases:
1. USER1 and USER2 have no system privileges.
2. ROLE1 only has these privileges:
• CREATE SESSION
• CREATE TABLE
• CREATE VIEW
Examine these commands: SQL> conn / as sysdba Connected.
SQL> GRANT create table, role1 TO user1 WITH ADMIN OPTION; Grant succeeded.
SQL> conn user1/oracle_4U Connected.
SQL> GRANT role1 TO user2; Grant succeeded.
Which command would you execute and as which user, to revoke the create table 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 CREATE TABLE FROM user2 as SYS
Answer: D
51. Examine these facts about a database:
• The database default tablespace to EXAMPLE.
• DEFERRED_SEGMENT_CREATION is TRUE （原来为FALSE，题目有错）
Examine these commands:
SQL> CREATE USER user1 IDENTIFIED BY oracle_4U PASSWORD EXPIRE;
User created.
need-to-insert-img
SQL>ALTER USER user1 IDENTIFIED BY oracle;
User altered.
SQL>GRANT CREATE SESSION TO user1;
Grant succeeded.
SQL>GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;
Grant succeeded.
Which four are true?
A) User1 can connect to the database instance.
B) User1 can create in the EXAMPLE tablespace.
C) User1 must change the password at first login.
D) User1 can grant the CREATE SESSION privilege to other users.
E) User1 can grant the CREATE TABLE privilege to other users.
F) User1 can REVOKE the CREATE TABLE privilege from users that were granted the privilege by SYS .
G) User1 can REVOKE the CREATE SESSION privilege from users that were granted the privilege by SYS .
Answer: ABEF
52. IN one of your databases;
The database default tablespace is EXAMPLE. DEFERRED_SEGMENT_CREATION IS FALES.
Examine these commands;
SQL.>CREATE USERuser1 IDENTIFIED BY oracle_4U password expire; User created.
SQL>ALTER USER user1 ACCOUUNT UNLOCK;
User altered.
SQL>GRANT CREATE SEAAION TO user1;
Grant succeeded;
SQL>GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;
Grant succeeded.
Which three are true?
A) USER1 can create indexes in EXAMPLE tablespace
B) USER1 can grant the CREATE TABLE privilege to other users
C) USER1 can log into the database instance
D) USER1 must change it’s password at first login
E) USER1 can create tables in the EXAMPLE tablespace
Answer：BCD
need-to-insert-img
53. 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;
User created.
SQL>GRANT CREATE SESSION TO user1;
User altered
Which two are true?
A) USER1 can create tables in EXAMPLE tablespace
B) USER1 must change their password at first login
C) USER1 can create tables in the EXAMPLE tablespace
D) USER1 can be granted access to tables in other schemas
E) USER1 can log in to the database instance.
Answer：DE
54. You have decided to implement the principle of least privilege and separation of duties. Which two actions must you take?
A) Grant SYSOPER to application schema owners.
B) Grant access to the Oracle software owner O/S account to all database administrators.
C) Assign the OSOPER and OSDBA groups to the Oracle software owner O/S account.
D) Assign different O/S groups to the OSOPER and OSDBA credentials.
E) Assign the DBA role to application schema owners.
Answer：CD
55. Examine these facts about a database:
1. USERS is the database default tablespace.
2. USER1 and USER2 have the CREATE SESSION privilege.
3. They also have UNLIMITED QUOTA on the USERS tablespace. Examine these commands:
SQL> conn / as sysdba Connected.
SQL> GRANT CREATE TABLE TO USER1 WITH ADMIN OPTION;
Grant succeeded.
SQL> GRANT CREATE VIEW TO USER1 WITH ADMIN OPTION;
Grant succeeded.
need-to-insert-img
SQL> GRANT CREATE MATERIALIZED VIEW TO USER1 WITH ADMIN OPTION;
Grant succeeded.
SQL> GRANT CREATE MATERIALIZED VIEW TO USER2 WITH ADMIN OPTION;
Grant succeeded.
SQL> conn user1/oracle Connected.
SQL> GRANT CREATE TABLE TO USER2 WITH ADMIN OPTION;
Grant succeeded.
SQL> GRANT CREATE VIEW TO USER2 WITH ADMIN OPTION;
Grant succeeded. SQL> conn / as sysdba Connected.
SQL> REVOKE CREATE TABLE FROM USER1;
Revoke succeeded.
Which two are true?
A) USER1 cannot create tables but can create views and materialized views.
B) USER1 cannot create tables or materialized views, but can create views.
C) USER1 cannot create tables, views or materialized views.
D) USER2 cannot create tables but can create views and materialized views.
E) USER2 cannot create tables or materialized views, but can create views.
F) USER2 can create tables, views and materialized vies.
Answer: AF
56. In a database,EXAMPLE is the default tablespace and DEFERED_SEGMENT_CREATION is FLASE. Examine these commands executed by SYS:
SQL> CREATE USER u1 IDENTIFIED BY oracle;
SQL> CREATE TABLE u1.tab1 (c1 number);
What will be the outcome and why?
A) It will fail because U1 does not have the CREATE SESSION privilege.
B) It will fail because U1 has no quota on EXAMPLE.
C) U1.TAB1 will be created.
D) It will fail because U1 does not have the CREATE TABLE privilege.
E) It will fail because U1 has no default tablespace.
Answer：B （已验证）
need-to-insert-img
⼆二⼗十.Undo
57. Examine these SQL statements and their output:
SQL> select name,value
2 from v$parameter
3 where name like 'undo%'; NAMEVALUE
------------------------------------
undo_managementAUTO
undo_tablespaceUNDO
undo_retention900
SQL> select contents,retention
2 from dba_tablespaces
3 where tablespace_name='UNDO'; CONTENTSRETENTION
---------------------------------- UNDOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2 from dba_data_files
3 Where tablespace_name='UNDO'; BLOCKSAUTMAXBLOCKS
------------- ----- ----------
6400NO0
Which two are true?
A) Transactions will wait until free space becomes available in the undo tablespace when they have failed to allocate space
B) The undo tablespace will grow automatically if there is not enough space to retain active undo
C) Inactive undo will be retain for at least 15 minutes
D) Expired undo will be retained as long as possible within the limits of the current size of the undo tablespace
E) Active undo will be retained as long as needed by the transactions
Answer：CE
58. Examine these SQL statements and their output:
SQL> select name,value
2 from v$parameter
3 where name like 'undo%'; NAMEVALUE
------------------------------------
undo_managementAUTO
undo_tablespaceUNDO
need-to-insert-img
undo_retention900
SQL> select contents,retention
2 from dba_tablespaces
3 where tablespace_name='UNDO'; CONTENTSRETENTION
---------------------------------- UNDONOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2 from dba_data_files
3 Where tablespace_name='UNDO'; BLOCKSAUTMAXBLOCKS
------------- ----- ----------
6400YES64000
Which two are true?
A) Inactive UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace.
B) The UNDO tablespace can grow automatically if there is not enough space to retain active UNDO.
C) Active UNDO will be retained as long as needed by transactions.
D) Inactive UNDO will never be retained for more than 15 minutes.
E) Inactive UNDO will always be retained for at least 15 minutes.
Answer：BC
59. Examine these SQL statements and their output:
SQL> select name,value
2 from v$parameter
3 where name like 'undo%'; NAMEVALUE
------------------------------------
undo_managementAUTO
undo_tablespaceUNDO
undo_retention900
SQL> select contents,retention
2 from dba_tablespaces
3 where tablespace_name='UNDO'; CONTENTSRETENTION
---------------------------------- UNDONOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2 from dba_data_files
need-to-insert-img
3 Where tablespace_name='UNDO'; BLOCKSAUTMAXBLOCKS
------------- ----- ----------
6400YES64000
Which two are true?
A) Inactive expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace.
B) The UNDO tablespace can grow automatically if there is not enough space to retain active UNDO.
C) Active UNDO will be retained as long as needed by transactions.
D) Inactive expired UNDO will never be retained for more than 15 minutes.
E) Inactive expired UNDO will always be retained for at least 15 minutes.
Answer：BC
60. Examine these SQL statements and their output:
SQL> select name,value
2 from v$parameter
3 where name like 'undo%'; NAMEVALUE
------------------------------------
undo_managementAUTO
undo_tablespaceUNDO
undo_retention900
SQL> select contents,retention
2 from dba_tablespaces
3 where tablespace_name='UNDO'; CONTENTSRETENTION
---------------------------------- UNDOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2 from dba_data_files
3 Where tablespace_name='UNDO'; BLOCKSAUTMAXBLOCKS
------------- ----- ----------
6400NO0
Which three are true?
A) Active UNDO might be retained for 15 or more minutes.
B) Inactive UNDO might be retained for 15 or more minutes.
C) The UNDO tablespace is guaranteed to be retained forever.
D) Expired UNDO might be retained for 15 or more minutes.
E) UNDO Blocks are retained for 900 days.
need-to-insert-img
F) UNDO segments are guaranteed to be retained forever.
Answer：ABD
这道题目答案不严谨
61. Which two are true about transactions, UNDO segments, and UNDO tablespaces?
A) UNDO tablespaces are created and dropped automatically.
B) UNDO tablespaces are brought ONLINE or OFFLINE as required.
C) All transactions belonging to a single session use the same UNDO segment.
D) UNDO segments grow or shrink automatically.
E) UNDO segments are created and dropped automatically.
Answer：DE
62. Which four are true about transactions, undo segments, and undo tablespaces?
A) undo tablespaces contain undo segments and Global Temporary Table Data.
B) undo segments can be brought offline automatically by Oracle.
C) undo segment updates are logged in redo logs.
D) A single transaction can use multiple undo segments simultaneously.
E) undo segments can be brought online automatically by Oracle.
F) undo segments can be used simultaneously by multiple transactions.
Answer：BCEF
63. Which three are true about UNDO data?
A) It is used to rewind a database by using FLASHBACK DATABASE.
B) It is used to recover dropped tables by using FLASHBACK TABLE … TO BEFORE DROP.
C) It is used to enable ROLLBACK statements to roll back uncommitted updates.
D) It is used to roll back failed transactions.
E) It is used during online backups to guarantee their consistency.
F) It is used to provide read consistency.
Answer：CDF
64. Which four are true about UNDO ?
A) Guaranteed UNDO retention prevents inactive and expired undo from being deleted.
B) DML statements generate UNDO.
C) Active UNDO is never deleted.
D) Inactive and expired UNDO is never deleted.
need-to-insert-img
E) Inactive and unexpired UNDO is never deleted.
F) It can by used to restore a table by using FLASHBACK TABLE. G) DDL statements generate UNDO （因为会对数据字典进行修改）
Answer：BCFG
65. Which three are true about UNDO segments and UNDO tablespaces in the same database and instance ?
A) A database can have multiple UNDO tablespaces.
B) UNDO segments are automatically dropped shortly after transactions that use them commit
C) Multiple transactions run by different Oracle users can share a single UNDO segment.
D) Multiple transactions run by the same Oracle user can share a single UNDO segment.
E) A serial transaction can use multiple UNDO segments
F) A new UNDO segment is always creted for each transaction
Answer：ACD
66. Which two are true about UNDO segments and UNDO tablespaces in the same database and instance ?
A) Multiple transactions may share a single UNDO segment.
B) A database can have multiple active UNDO tablespaces.
C) Multiple transactions run by the same Oracle user must share a single UNDO segment.
D) Automatic Undo Management attempts to minimize the number of active transactions that share the same UNDO segment
E) Multiple transactions run by the same Oracle user must not share a single UNDO segment.
F) Multiple transactions run by the different Oracle user must not share a single UNDO segment
Answer： AD
67. Which two are true about UNDO data ?
A) Inactive UNDO cannot be overwritten until the elapsed time since becoming inactive exceeds UNDO_RETENTION.
B) Active UNDO can never be overwritten.
C) Active UDNO is always kept in memory.
D) It can be used to restore a table by using FLASHBACK TABLE.
E) Inactive UNDO is never written to disk.
F) Only DML statements generate UNDO.
Answer：BD
need-to-insert-img
need-to-insert-img
68. Which two are true about undo tablespaces?
A) Tables can be created in undo tablespaces by sys
B) Single-instance databases can have only on active undo tablespace
C) They must have only one data file
D) They can be recovered only when an instance is in MOUNT state
E) They always retain undo for the time period defined by UNDO_RETENTION
Answer：BD
69. Which three are true about undo tablespaces?
A) They can contain undo blocks and data blocks.
B) They can be configured to prevent ORA-1555 snapshot too old errors.
C) An administrator can create multiple undo tablespaces In a single-instance database.
D) They are opened even when the database Is In mount state.
E) They can be smallfile tablespaces.
Answer：BCE
need-to-insert-img
⼆二⼗十.Initialization parameter
70. which is true about initialization parameter administration?
A) Some Dynamic parameter values can be modified to affect only one session
B) Dynamic parameters, when modified, always revert to their original values after the database instance is restarted
C) Static parameter values can be changed in the spfile only by using the alter system command with scope=spfile when the database is closed
D) Static parameter values can be changed for the current instance by using alter system command with scope=memory
Answer：A（基本验证过）
71. You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to change an initialization parameter value.
Which is true?
A) It can be used only if a pfile is used.
B) The change occurs immediately in memory for static parameters but it is not persistent after instance restart.
C) The change occurs immediate in memory for dynamic parameters but it is not persistent after instance restart.
D) In can be used only if an spfile is used.
Answer：C
72. which three statements are true about initialization parameters and files?
A) An idle instance must start with a PFILE.
B) Session modifiable initialization parameters can only be changed by a user with the DBA role.
C) The ALTER SYSTEM command can be used to change parameter values for an instance started using a PFILE.
D) An SPFILE can be created from an idle instance.
E) Session modifiable initialization parameters can only be changed once per session.
F) The ALTER SYSTEM command can be used to change parameter values for an instance started using an SPFILE
G) System modifiable initialization parameters can only be changed by the SYS user.
Answer：DFG
need-to-insert-img
⼆二⼗十⼀一.Backup
73. 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 Table.
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 Drop.
Answer：BC
74. Which two are true about consistent database backups?
A) They can only be taken by using RMAN commands.
B) They can only be taken by using RMAN when the database is in MOUNT state.
C) They can only be taken when a RECOVERY CATALOG is used.
D) They can only be taken if the database is in ARCHIVELOG mode.
E) They can only be taken if a NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.
Answer：BE
75. Which four are true about consistent database backups?
A) They can only be taken using O/S utilities if the database is in mount state.
B) They can only be taken using RMAN when the database is in mount state.
C) They can be taken using O/S utilities.
D) They can only be taken using RMAN when the database instance is shut down.
E) They can be taken if the database is in archivelog mode.
F) They can be taken by using rman commands.
G) They can be taken if the database is in noarchivelog mode.
Answer：CEFG
76. Which three can be used to schedule automated backups of the database?
A) a cron job
B) Enterprise Manager Database Control
C) DBMS_SCHEDULER
D) DBMS_BACKUP_RESTORE
need-to-insert-img
E) expdp
F) RMAN
Answer：ABC
77. Which four can be used to schedule automated backups of an Oracle database?
A) data Guard
B) DBMS_JOB
C) Enterprise Manager
D) anacron jobs
E) cron jobs
F) Automatic Storage Management (ASM)
Answer：BCDE
78. Which two tools or utilities can be used to configure and schedule on-line database backups to run automatically?
A) the RMAN command line utility
B) SQL*PLUS
C) Enterprise Manager Cloud Control
D) The Database Configuration Assistant(DBCA)
E) the DBMS_SCHEDULER package
Answer：CE
79. 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) All active sessions hang until the database administrator (DBA) makes space available in the FRA
B) No archivelogs are generated.
C) The archivelog entries are made in the diagnostic destination and when space is available, new archivelog are generated.
D) All active sessions are disconnected and their transactions rolled back.
E) Obsolete backups are automatically deleted and new archivelogs are generated.
Answer：E（验证过）
need-to-insert-img
80. In which two cases is a consistent database backup created ?
A) when the RMAN BACKUP AS COPY command is used while the database is open
B) when the RMAN BACKUP command is used while the database is OPEN READ ONLY
C) when the RMAN BACKUP AS COPY command is used while the database is OPEN RESTRICTED
D) when the RMAN BACKUP command is used while the database is MOUNTED
E) when O/S commands are used to copy database files after a database instance is shut down normally
Answer：DE
81. Which command is used to display files that no longer conform to the backup retention policy?
A) LIST EXPIRED BACKUP
B) REPORT OBSOLETE.
C) SHOW DATAFILE BACKUP COPIES.
D) CROSSCHECK BACKUP.
Answer：B
