你可能感興趣的試題

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）

A.configure the database to run in ARCHIVELOG mode
B.configure the Flash Recovery Area to enable automatic database backup
C.schedule the database backup using DBMS_JOB package after creating the database
D.schedule the database backup using Recovery Manager （RMAN） commands after creating the database
E.schedule the database backup using Database Configuration Assistant （DBCA） while creating the database

多項選擇題

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

A.null lock on the row being updated
B.null lock on the table containing the row
C.ROW SHARE lock for the row being updated
D.ROW EXCLUSIVE lock for the row being updated
E.shared row-exclusive lock for the row being updated
F.a shareable table lock for the table containing the row
G.exclusive table-level lock for the table containing the row

One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）

你可能感興趣的試題

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）