Ensure 100% Pass The Latest Accurate Oracle 1Z0-040 By Training Latest Cisco 350-030 Download
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct? (Choose two.)
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
Correct Answer: BC
You used the following command to perform backup: RMAN> BACKUP AS COPY DURATION
PARTIAL MINIMIZE LOAD DATABASE; Which recommendation regarding the above command is true?
It is recommended that you do not use the above command in the RUN block.
It is recommended that you do not use the MINIMIZE LOAD option with tape.
It is recommended that you use the MINIMIZE LOAD option only when you perform tablespace backup.
It is recommended that you use the DURATION and MINIMIZE LOAD options when you perform backup to backup sets.
Correct Answer: B
You enabled Flashback Database with the following command: ALTER DATABASE FLASHBACK ON; Which view would you query to determine whether the Flashback Database has been enabled?
Correct Answer: B
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?
A. point-in-time recovery
B. manually enter the appropriate data again
C. execute the ROLLBACK command with transaction number
D. flashback the database to before the transaction was committed
E. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
Correct Answer: E
You have a materialized view called emp_mv on the emp table. You want to stop the following query from executing if it does not rewrite: SELECT deptno,sum(sal)FROM emp GROUP BY deptno; Which statement would you use?
A. SELECT / *+ USE_CONCAT */ deptno,sum(sal)FROM emp GROUP BY deptno;
B. SELECT /*+ NO_EXPAND * /deptno,sum(sal)FROM emp GROUP BY deptno;
C. SELECT /*+ NO_REWRITE */ deptno,sum(sal)FROM emp GROUP BY deptno;
D. SELECT /*+ REWRITE_OR_ERROR */ deptno,sum(sal)FROM emp GROUP BY deptno;
E. SELECT /*+ NO_QUERY_TRANSFORMATION */ deptno,sum(sal)FROM emp GROUP BY deptno;
Correct Answer: D
Identify four uses of the Oracle Scheduler. (Choose four.)
A. Enables you to set idle time limits for a resource plan.
B. Enables you to schedule job execution based on time.
C. Enables you to execute jobs in a clustered environment.
D. Enables you to assign priorities to the consumer groups.
E. Enables you to map a consumer group to an Oracle user.
F. Enables you to create a job that makes use of saved programs and schedules.
G. Enables you to periodically execute operating system script files located on the same server as the database.
Correct Answer: BCFG
Consider the following configuration: /devices/D1 is a member of disk group dgroupA . /devices/D2 is a member of disk group dgroupA . /devices/D3 is a member of disk group dgroupA . You plan to add a new disk, /devices/D4, to the disk group dgroupA and execute the following command: SQL> ALTER DISKGROUP dgroupA ADD DISK ‘/devices/D*’; Which task would be accomplished by the command?
A. The command adds the new disk, D4 , to the disk group.
B. The command would result in an error because there is no disk by the name ” /devices/D* “.
C. The command would result in an error because no wildcard characters can be used in the disk name.
D. The command will be ignored because disks starting with “D” are already members of the disk group.
E. The command first detaches all the member disks starting with “D” and then reattaches all of them including the new disk.
Correct Answer: A
Examine the following commands of Data Pump to import objects to new non-existent users hr1 and oe1 .
Which objective would be achieved by the above command sets?
A. expdp will fail because no path has been defined for the dumpfile.
B. expdp will succeed but Impdp will fail because users do not exist.
C. impdp would create two schemas called hr1 and oe1 and copy the schema objects to the new users.
D. impdp would create two schemas called hr1 and oe1 and import tables owned by hr and oe schemas to hr1 and oe1 schemas, respectively.
Correct Answer: B
You are using SQL Tuning Advisor (STA) to tune SQL workload in your database. Which four types of recommendations do you get from Automatic Tuning Optimizer (ATO) via the STA? (Choose four.)
A. recommendation to create indexes
B. recommendation to use stored outlines
C. recommendation to create a SQL profile
D. recommendation to gather relevant statistics
E. recommendation to denormalize the schema
F. recommendation to restructure SQL statements
Correct Answer: ACDF
You have created the following auditing policy:
Which statement is true about the fine-grained auditing implemented by this policy?
A. An audit record is created for all INSERT and UPDATE statements on either the ACCOUNT_ID or AMOUNT columns.
B. An audit record is created for all INSERT and UPDATE statements on both the ACCOUNT_ID and AMOUNT columns.
C. An audit record is created for all INSERT statements on the ACCOUNT_ID column and the UPDATE statement on the AMOUNT column.
D. An audit record is created for all INSERT and UPDATE statements when the ACCOUNT_ID or the AMOUNT column contains a NULL value.
Correct Answer: B