In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?（）

A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated." E . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

A . Use the DROP DATAFILE command. B . Use the DROP TABLESPACE command. C . Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command. D . Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

A .  creating a table in your schema and you exceed your allocated space quota on the tablespace B .  executing a long query that involves a sort operation and the statement runs out of temporary space C .  loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit D .  creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

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 change

A . renaming the control files B . dropping a user in your database C . enabling or disabling redo log archiving D . dropping a tablespace in your database E . re-creating the control files， after you lost all the control files in your database

A . To limit the User Global Area （UGA） memory allocated to a session from the SGA B . To limit the amount of memory to be used for the dispatcher queue of a session in SGA C . To limit the amount of memory to be used for the request pool in System Global Area （SGA） D . To control the amount of memory allocated in SGA for the local variables for each shared server proce

A . Only the SET command must be within a RUN block. B . All commands should be executed at the RMAN prompt. C . All three commands must be within a single RUN block. D . Only the RESTORE and RECOVER commands must be within a single RUN block.

A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."  E . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

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

A . the size of an undo block B . the size of the redo log files C . undo blocks generated per second D . the size of the database buffer cache E . the value of the UNDO_RETENTION parameter

A . Set the UNDO_RETENTION parameter to 900 or more. B . Create an initial undo segment in the undo tablespace. C . Enable the retention guarantee for the undo tablespace. D . Set the UNDO_TABLESPACE parameter to UNDO_TBS1. E . Set the UNDO_MANAGEMENT initialization parameter to AUTO.

A . to limit the User Global Area （UGA） memory allocated to a session from the SGA B . to limit the amount of memory to be used for the dispatcher queue of a session in SGA C . to limit the amount of memory to be used for the request pool in System Global Area （SGA） D . to control the amount of memory allocated in SGA for the local variables for each shared server proce

A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

A . You can perform open database backups. B . You can perform closed database backups. C . You cannot perform schema-level logical backups. D . You can perform the backup of only the SYSTEM tablespace when the database is open.

A .  Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs. B .  Just back up the database datafiles without shutting down the database. C .  You will have to wait until you can shut down the database to perform the backup. D .  Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up. E .  Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backu

A . the time when the last flashback operation in your database was performed B . the time when the first flashback operation in your database was performed C . a list of flashback operations performed in your database using SCN and time D . the approximate time and the lowest system change number （SCN） to which you can flash back your database

A . Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set B . The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set C . The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set D . Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startu

A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

A . The destination must be global only. B . A maximum of five destinations can be assigned. C . A maximum of ten different destinations can be assigned. D . All the destinations are determined by the server automatically. E . The destination may be local or remote for a Standby Database. F . The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

A . The database instance aborts. B . The database operation temporarily halts till the member becomes available. C . Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members. D . The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file. E . The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

A .  You cannot perform the TSPITR with the constraints enabled. B .  You must perform the TSPITR recovery of both tablespaces for it to be successful. C .  You can perform TSPITR only on the USERS tablespace. D .  RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically. E .  The TSPITR will only be successful if the constraint is enabled.

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome？（） <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/4f3f38f4fa50f6813beecdb37f5e123f.jpg' /> A. Only one channel is allocated and the backup is created in the flash recovery area B. Only one channel is allocated and the backup is created in the destination specified for channel C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2 D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA