You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

A . You must use Oracle predefined names to identify raw partitions that will hold OMF structures.  B . You must define directories for two online redo log groups and three copies of the control file.  C . If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.  D . You must use only OMF data files when adding new tablespaces or data files to your database in the future.

A . Issue ALTER DATABASE BACKUP CONTROLFILE TO filename B . Make a copy of the control file with the database shut down C . Issue ALTER DATABASE BACKUP CONTROLFILE TO trace D . Make a copy of the control file with the database still running&e

A .  DB_CACHE_SIZE B .  SHARED_POOL_SIZE C .  LARGE_POOL_SIZE D .  JAVA_POOL_SIZE E .  SGA_MAX_SIZE F .  SORT_AREA_SIZE

A . Only host B . Only local C . Either host or local D . Both host and local

A . when performing export and import using Oracle Data Pump B . when performing backup and recovery operations using Oracle Recovery Manager C . when performing batch processing and bulk loading operation in a data warehouse environment  D . in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

A . BFILE  B . REF column  C . Object table  D . Column object  E . INSTEAD-OF trigger

A .  One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST. B .  One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST. C .  One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST. D .  One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

A . Oracle WebLogic Domain Upgrade tool B . Smart Update  C . Smart Upgrade   D . No tool required, just install WebLogic 12c, update the domain to point to the new WebLogic installation and start your domain. E . JDeveloper

A .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

A .  it can be used to concatenate two strings. B .  it can be used to find out the total length of the string. C .  it can be used for string manipulation and searching operations. D .  it can be used to format the output for a column or expression having string data. E .  it can be used to find and replace operations for a column or expression having string data.

A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

A . LOGICAL_READS_PER_SESSION  B . CONNECT_TIME  C . COMPOSITE_LIMIT  D . CPU_PER_SESSION  E . PRIVATE_SGA

A . Clone  B . Copy  C . Template  D . Terminal&e

A .  create catalog B .  install database C .  catalog database D .  merge Catalog with database E .  register database

A .  WLDF has better performance than OEM  B .  my organization already has a solution for unified management and monitoring； we need to supplement that with some specific WLS-related capabilities C .  OEM is not certified with latest version of WLS D .  OEM is really focused on the database tier， is not meant to address JEE management and monitoring

A .  To recover a dropped table. B .  To recover a dropped schema. C .  To recover data from a truncated table. D .  To view changes made by all the transactions during a given period of time. E .  To view changes made by a single transaction during a given period of time.

A .  Generate reports on data failure such as data file failures. B .  You can track the Service Request （SR） and implement repairs. C .  You can package and upload diagnostic data to Oracle Support. D .  You can manually run health checks to gather diagnostic data for a problem.

A . It is a SQL script. B . It is a PL/SQL file. C . It is an operating system （OS） file. D . It is a Recovery Manager （RMAN） script

A . A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows B . All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application. C . A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows. D . A TOP-N query is created to limit the rows to 20 percent of the total row

A. student card B. passport C. library card D. young person card 此题为多项选择题。