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

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

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

In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:
1 . The user account must be locked after four unsuccessful login attempts.
2 . The user must be prompted to change the password at regular intervals.
3 . The user may not have more than three simultaneous sessions.
4 . The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?

• A.By assigning profiles for the users
• B.By implementing the Database Resource Manager plan
• C.By granting a secure application role to the users
• D.By implementing Fine-Grained Auditing (FGA)

Examine these commands and their output:

A power failure occurs. The instance is restarted and this query is executed.
SQL> SELECT ename FROM emp;
What is the outcome?

• A.Only Adam and Alan are displayed
• B.Adam, Alan, Ben, and Bryan are displayed
• C.No rows are returned
• D.Only Adam, Alan, and Bryan are displayed
• E.Only Adam, Alan, and Ben are displayed

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:
Which two statements are true about differential incremental backups? (Choose two.)

• A.The backup performed on each working day contains all the blocks that have changed since the last level 0 backup
• B.The backup performed on Sundays contains all the blocks that have ever been used in the database
• C.The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup
• D.The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup

You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.
View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction?
Exhibit:

• A.Enable the resumable mode for the session before starting the transaction
• B.Set the constraint to deferred before starting the transaction
• C.Alter the constraint to NOVALIDATE state before starting the transaction
• D.Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction