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

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

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

Which two operations can be flashed back using the Flashback technology? (Choose two.)

• A.DROP USER SMITH;
• B.ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;
• C.DROP TABLESPACE USERS;
• D.ALTER TABLE SALES_REP DROP PARTITION P1;
• E.DROP TABLE EMPLOYEES;

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?

• A.dropping a tablespace in your database
• B.re-creating the control files, after you lost all the control files in your database
• C.renaming the control files
• D.enabling or disabling redo log archiving
• E.dropping a user in your database

A user complains about getting this error after issuing a certain SQL statement: ORA-02393: exceeded call limit on CPU usage Because of the error, the SQL statement gets aborted. What action would you take to
increase the CPU usage limit in the subsequent sessions of the user?

• A.Set the RESOURCE_LIMIT initialization parameter to FALSE.
• B.Modify the resource limit in the profile used by the user.
• C.Increase the value of the SESSION_MAX_OPEN_FILES initialization parameter.
• D.Increase the value of the SESSION_CACHED_CURSORS initialization parameter.

View the Exhibit.
Which statement regarding the dept and emp tables is true?

• A.When you delete a row from the emp table, automatically the corresponding rows are updated with null values in the dept table.
• B.When you delete a row from the emp table, automatically the corresponding rows are deleted from the dept table.
• C.When you delete a row from the dept table, automatically the corresponding rows are deleted from the emp table.
• D.When you delete a row from the emp table, you would receive a constraint violation error.
• E.When you delete a row from the dept table, you would receive a constraint violation error.
• F.When you delete a row from the dept table, automatically the corresponding rows are updated with null values in the emp table.