1z0-043单项选择题每日一练(2019.01.15)

单项选择题
You issued the following command： ALTER TABLE SCOTT.EMP SHRINK SPACE； The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties： DATA1 is a read/write tablespace. DATA1 is not autoextensible to an unlimited size. DATA1 is online. Segment space management for the DATA1 tablespace is manual. You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error： ORA-10635： Invalid segment or tablespace type What could be the reason for the failure of the command？（）
A. The tablespace， DATA1， is not read-only.
B. The tablespace， DATA1， is not autoextensible.
C. The tablespace， DATA1， is not offline.
D. The segment space management for the tablespace， DATA1， is manual.
单项选择题
What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）
A. The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are already in the Recycle Bin are dropped.
B. The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.
C. The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.
D. The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.
单项选择题
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）
A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday’s backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening
单项选择题
You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（）
A. The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
B. The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
C. The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
D. The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
单项选择题
You execute the following command to enable a session in resumable mode： SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60； What is the impact of a timeout on the statements being suspended？（）
A. The statements remain suspended for at least 60 seconds.
B. The statements are suspended for 60 seconds and then they are executed.
C. The suspended statements error out if the problem is not rectified within 60 seconds.
D. The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.