1z1-497 試験問題を無料オンラインアクセス

You are in the middle of transaction, updating a table. The machine on which the database is running reboots because of a power outage. This causes a database instance failure.
Which statement is true in this situation?

• A.The DBA has to perform a recovery on the database to recover the uncommitted transaction.
• B.The online redo log files and archived redo log files are required to accomplish a recovery.
• C.The uncommitted transaction is committed at the next startup of the database instance.
• D.The uncommitted transaction is rolled back automatically at the next opening of the database.

Which two statements about this policy are true?

• A.It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.
• B.It replaces the first four digits of the value from the SALARY column with the number 9.
• C.It uses the full data redaction method.
• D.It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.
• E.It replaces the first digit of the value from the SALARY column with the number 4.
• F.It uses the random redaction method.

Your database instance is down because there was a user-initiated shutdown. Which option represents the actions performed, in the correct order, if you start up the instance?
a - The control file is read.
b - Memory is allocated.
c - Background processes pre started.
d -The initialization parameter file is read,
e- Redo log files and data files are opened.

• A.c, b, d, a, e
• B.b, c, a
• C.a, e, d, b
• D.d, b, c, a, e
• E.d, a, e

Your database is down. You log in as the SYS user and issue this command:
SQL> STARTUP
What happens after the instance is started?

• A.The database is mounted and finally opened.
• B.The database is opened and finally mounted.
• C.The database is mounted but not opened.
• D.Nothing else happens.

Which statement about Online Move Data file is true?

• A.Moving a data file online prevents DML operations on segments stored in the data file.
• B.Moving a data file online can be performed if the data file is in OFFLINE mode.
• C.Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.
• D.Flashing back a database to a point in time before a data file had been renamed online retains the new name.