单项选择题
A. CONNECT / AS SYSDBA
B. CONNECT sys/admin AS SYSDBA
C. CONNECT sys/admin@mynewdb AS SYSDBA
D. CONNECT sys/change_on_install AS SYSDBA
单项选择题 Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()
单项选择题 Inwhichofthefollowingscenariosisatablespacerecoveryrequired?()
单项选择题 YourdatabaseisconfiguredinNOARCHIVELOGmode.Duetoamediafailure,youhavelostoneofthedatafilesbelongingtoaread-onlytablespace.Youknowthatthelastbackupwasperformedafterthetablespacewasmaderead-only.Whichactionshouldyoutaketorestorethemissingdatafileintheminimumamountoftime?()