Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
1z0-062
Free trial
Verified
Question 51
In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
- A: Apply fine-grained auditing.
- B: Implement value-based auditing.
- C: Impose standard database auditing to audit object privileges.
- D: Impose standard database auditing to audit SQL statements.
Question 52
The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?
- A: The command fails as a transaction is still pending.
- B: The transaction in Scott's session is rolled back and the tablespace becomes readonly.
- C: The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
- D: The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
Question 53
Which two statements are true about standard database auditing? (Choose two.)
- A: DDL statements can be audited.
- B: Statements that refer to standalone procedure can be audited.
- C: Operations by the users logged on as SYSDBA cannot be audited.
- D: Only one audit record is ever created for a session per audited statement even though it is executed more than once.
Question 54
You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?
- A: It records usernames and passwords of users when granted the DBA role
- B: It contains usernames and passwords of users for whom auditing is enabled
- C: It is used by Oracle to authenticate users for remote database administrator
- D: It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
Question 55
Which three statements are true about space usage alerts? (Choose three.)
- A: Alerts are issued only when the critical threshold for space available in a tablespace is breached.
- B: The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
- C: Database alerts can provide warnings about low space availability at both tablespace and segment levels.
- D: Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
- E: A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
Question 56
Your database instance has started using an SPFILE.
Examine the RMAN configuration settings:
You execute the command:
RMAN> BACKUP AS COPY TABLESPACE TEST;
Which three types of files are backed up by using this command? (Choose three.)
- A: online redo log files
- B: control file
- C: SPFILE
- D: archived redo log files
- E: data file(s)
- F: PFILE
Question 57
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle
Database 12c?
- A: shutting down the database instance that is being upgraded
- B: executing the catctl.pl script to run the upgrade processes in parallel
- C: running the Pre-Upgrade Information Tool
- D: copying the listener.ora file to the new ORACLE_HOME
That’s the end of your free questions
You’ve reached the preview limit for 1z0-062Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!