You executed the following commands in a database session: What could have caused the recycle bin to clean up?（）

A、 There is demand for space from the new table

B、 The undo tablespace does not have sufficient free space

C、 The new table name is the same as the table name in the recycle bin

D、 The temporary tablespace that is assigned to you does not have sufficient free space

相关问题推荐

• Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

  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.

  查看答案

• You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

  A、You must have change tracking enabled in your database

  B、Your database must be running in NOARCHIVELOG mode

  C、To back up a tablespace, it must be in backup mode

  D、To back up a tablespace, it must first be taken offline

  查看答案

• In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）

  A、using only the RMAN SWITCH command to set the new location for the data file

  B、placing the database in the MOUNT state for the restore and recovery operations.

  C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

  D、configuring two channels: one for the restore operation and the other for the recovery operation

  查看答案

• Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

  A、 Yes， if the database is in ARCHIVELOG mode

  B、 Yes， if the database is in NOARCHIVELOG mode

  C、 No， the backup is not usable in any way

  D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

  查看答案

• Which of the following is not a valid linguistic sort element？（）

  A、 Accent expansion

  B、 Canonical equivalence

  C、 Reverse secondary sorting

  D、 Ignorable characters

  E、 Character rearrangement

  查看答案