In your database, the flash recovery area （FRA) is configured as the default for RMAN back

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 . RCO1 only. B . DB01 only. C . DB02 only. D . DB01 and DB02 only. E . DB01，DB02，and RC01.

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 .  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 . The C # # ROLE1 role is created in the root database and all the PDBs. B . The C # # ROLE1 role is created only in the root database because the container clause is not used. C . Privileges are granted to the C##A_ADMIN user only in the root database. D . Privileges are granted to the C##A_ADMIN user in the root database and all PDBs. E . The statement for granting a role to a user fails because the CONTAINER clause is not used.

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 . adding a new user to the database B . dropping a user from the database C . dropping a table from the database D . dropping a data file from a tablespace E . adding a new tablespace to the database

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 . Writes buffers to disk  B . Writes current redo log number to datafile headers  C . Writes redo log information to disk  D . Reads information into memory for user

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.