Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）

A . when row directories need more row entries B . when there is row migration in the data block C . when there is an increase in the PCTFREE value for the data block D . when more transaction slots are required than are initially configured

A . Cursor cache B . Stored outline C . SQL Tuning Set D . Automatic Workload Repository (AWR) snapshot

A . The tablespace has two data files. B . An error is reported and tablespace creation fails. C . Data files are created with names generated by the instance. D . The tablespace can be extended without specifying the data file. E . Data files belonging to the USERS tablespace cannot be renamed.

A . automated process using the Admin Server B . automated using JDeveloper C . manual process with or without Smart Update D . scripted with WLST E . automated process using Enterprise Manager 12c

A . The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files. B . The MRKT tablespace may be dropped if it has no contents. C . Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace. D . No more data files can be added to the tablespace. E . The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

A . This clause is not valid for a temporary or undotablespace. B . If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo. C . Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace. D . Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.

A .  FREE_SPACE indicates only the space that is currently unallocated. B .  ALLOCATED_SPACE indicates only the space currently allocated and in use. C .  FREE_SPACE indicates only the space that is currently allocated and available for reuse. D .  ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse. E .  FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

A . process business logic B . store business logic in the database C . retrieve business logic from the database D . manage communication between desktop/client tier and database tier

A . The database must be opened in restricted mode. B . The database must be configured to run in ARCHIVELOG mode. C . The tablespaces are required to be in backup mode before taking the backup. D . The tablespaces are required to be in read-only mode before taking the backu

A .  Authentication Provider B .  Adjudication Provider C .  Authorization Provider D .  Auditing Provider

A . No more data files can be added to the tablespace. B . Segment space is managed by free lists in the tablespace. C . A user created without being assigned a default tablespace uses this tablespace. D . The tablespace can be dropped with the current setting with segments present in it.

A . The database must be opened in restricted mode. B . The database must be configured to run in ARCHIVELOG mode. C . The tablespaces are required to be in backup mode before taking the backup. D . The tablespaces are required to be in read-only mode before taking the backu

A . The database automatically determines the extent-sizing policy for the tablespace. B . The segments are automatically shrunk when the contents are removed from them. C . The allocation of extents within the tablespace is managed through the dictionary tables. D . The space utilization description of the data blocks in segments is recorded inbitmapblocks. E . The space utilization description of the data blocks in segments is managed through free lists.MANUAL

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 .  The database must be opened in restricted mode. B .  The database must be configured to run in ARCHIVELOG mode. C .  The tablespaces are required to be in backup mode before taking the backup. D .  The tablespaces are required to be in read-only mode before taking the backu

A . The setting up of the descriptive flexfield is mandatory. B . The Asset Category flexfield is owned by the Oracle Assets module. C . The descriptive flexfield is associated with tables in the Oracle Assets module. D . Only the Asset Category flexfield is associated with tables in the Oracle Assets module.

A . It strives to protect access to design documentation. B . It facilitates customer deployments that are more predictable. C . It facilitates customer deployments that are less reliable. D . It incorporates products and technologies into a broad portfolio.

A . To store the backup information of multiple database B . To restrict the amount of space that is used by the backups C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter. D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

A . The data file backup is done with multiple channels B . The data files is in the read-write mode after being backed up in the read only mode C . The backup was taken after the data files was taken offline-normal or is in the read only mode D . The data file backup complies with the back retention policy and the backup duplexing feature

A . This clause is not valid for a temporary or undo tablespace. B . If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo. C . The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace. D . The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

A . The database automatically determines the extent-sizing policy for the tablespace. B . The segments are automatically shrunk when the contents are removed from them. C . The allocation of extents within the tablespace is managed through the dictionary tables. D . The space utilization description of the data blocks in segments is recorded in bitmap blocks. E . The space utilization description of the data blocks in segments is managed through free lists.

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 . Rebuilding an index using ALTER INDEX ...REBUILD fails with an error "ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.

<img src='https://img2.soutiyun.com/shangxueba/ask/64263001-64266000/64265568/67e67a73b604e73a7d1e2def2ff7dcea.jpg' /> A. It stores only the temporary table but not its indexes. B. It stores both the temporary table as well as its indexes. C. It must be a nondefault temporary tablespace for the database. D. It can be a default or nondefault temporary tablespace for the database. E. It must be the default temporary tablespace of the user who issues the command.