[单项选择]You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）
A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

[单项选择]You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）
A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

[多项选择] On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）
A. Only the ORD_CUSTOMER_IX1 index created.
B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.
F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

[单项选择]You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）
A.  the system change number
B.  the locations of the redo log files
C.  the locations of the datafiles
D.  the physical location of all the database changes

[单项选择]You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?（）
A. log01.log 
B. logORCL01.log 
C. 1_2.logALTER ROLLBACK SEGMENT 
D. ora_1_asdf1234.log

[单项选择]Have you shut the windows

[单项选择] You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.  Which statement should you use to enable the block change tracking feature？（）  
A.  ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B.  ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE 
C.  ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 
D.  ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

[单项选择] You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
A.  The log sequence is reset to 0.
B.  All the online redo logs are deleted.
C.  All the archived redo logs from a previous incarnation become useless.
D.  The full database backup taken from a previous incarnation can be used in future.
E.  Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

[单项选择]Have you got（）lychees?
A. some
B. any
C. /

[多项选择] You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）
A. The ASM compatibility attribute controls the format of the disk group metadata.
B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

[单项选择] After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: After changing the value, you notice that FULL redaction continues to redact numeric data with zero. What must you do to activate the new default value for numeric full redaction?（）
A. Re-enable redaction policies that use FULL data redaction.
B. Re-create redaction policies that use FULL data redaction.
C. Re-connect the sessions that access objects with redaction policies defined on them.
D. Flush the shared pool.
E. Restart the database instance

[单项选择]Have you ever received ______ of what have happened to her
A. the word
B. words
C. word
D. the words

[单项选择]How many Monkey King Stamps have you collected
A. No one
B. None
C. Nothing
D. Nobody

[单项选择]We ______ for you everywhere. Where have you been
A. have looked
B. looked
C. have been looking
D. are looking

[单项选择]Have you any other reasons ______ the ones you just mentioned above
A. in addition to
B. beside
C. off
D. at addition with

[单项选择]You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）
A.  The index can be changed from NOLOGGING to LOGGING
B.  The index cannot be recovered even in the ARCHIVELOG mode.
C.  The index can only be created if the base table is created with the NOLOGGING option.
D.  The index can be recovered if you perform a backup after the CREATE INDEX statement.

[单项选择]— Have you finished reading the books borrowed from the library — Yes, and I've returned them. Now ______ is left at home.
A. nothing
B. none
C. no one
D. neither

[单项选择]——How many elephants have you seen ——.
A. None
B. Nothing
C. No one
D. No

[单项选择]—Have you got any weather information today Will it rain this evening —No, I've no idea, though ______.