多項選擇題

In which two conditions are resumable statements suspended？（）

A. when a user exceeds the space quota
B. when a user session is terminated
C. when a table that is being accessed by the current transaction is not found
D. when a user manually suspends the statement
E. when the maximum extents of a segment is reached

你可能感興趣的試題

多項選擇題

View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；
Which three types of files are backed up？（）

A. all the data files belonging to the USERS tablespace
B. password file
C. online redo log files
D. the current control file
E. archived redo log files
F. the current server parameter file
G. data files belonging to the USERS tablespace and all the default tablespaces

單項選擇題

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

A. loss of one of the tablespaces
B. loss of a system data file
C. loss of one of the control files
D. loss of a tempfile
E. loss of the only member of an unarchived redo log group
F. loss of a member from each redo log group

In which two conditions are resumable statements suspended？（）

你可能感興趣的試題

View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS； Which three types of files are backed up？ （）

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；
Which three types of files are backed up？（）

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）