你可能喜欢
多项选择题
A.Execute the ALTER DATABASE ARCHIVELOG statement
B.Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C.Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D.Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
单项选择题
A.Restore all the data files and open the database
B.Create the data file and performtablespacerecovery
C.No need to restore any file, just recover the database
D.Restore only the system data file and recover the database
E.Restore only lost date file and performtablespacerecovery
多项选择题
A.Event Viewer gives more details on the failure.
B.The alert log file gives detailed information about the failure.
C.PMON rolls back the transaction and releases the locks.
D.SMON rolls back the transaction and releases the locks.
E.The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
F.Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
单项选择题
A.The database is in mount state.
B.One of the tablespaces is offline.
C.One of the tablespaces is read only.
D.The database operates in ARCHIEVELOG mode.
E.The database operates in NOARCHIEVELOG mode.
多项选择题
A.Increase the size of redo log files
B.Increase the size of redo log buffer
C.Increase the number of redo log files
D.Place the redo log files on a separate disk
E.Decrease the number of redo log groups to two
F.Increate the number Log Writer (LGWR) process
单项选择题
A.RECOVER LOFIEL BLOCK GROUP 2;
B.ALTER DATABASE DROP LOGFILE GROUP 2;
C.ALTER DATABASE CLEAR LOGFILE GROUP 2;
D.ALTER DATABASE RECOVER LOGFILE GROUP 2;
E.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
单项选择题
A.It degrades the run time and compiler performance.
B.It provides better run time and compiler performance.
C.It provides better optimization of the statement during parse time.
D.It forces the rule based optimizer to be used for statement optimization.
E.It provides better run time performance but slightly degraded compiler performance.
F.It provides better run time performance but slightly degraded run time performance.
单项选择题
A.Memory Advisors
B.Segment Advisors
C.SQL Tuning and Access Advisors
D.Automated Workload Repository (AWR)
E.Automatic Database Diagnostic Monitor (ADDM)
单项选择题
A.The modified data are not available on disk.
B.The modified data have been flushed out from memory.
C.The modified rows of the Certkiller STAFF table have been locked.
D.Jack has not committed the changes after modifying the value.
E.Both users are accessing the database from two different machines.
单项选择题
A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates