1Z0-514 | A Review Of Practical 1Z0-514 pdf
Q11. Which statement describes the function of the Segment Advisor?
A. It advises on the usage frequency of the database objects
B. It advises on the currently validity status of the database
C. Itidentifies database objects that have unused space that can be reclaimed
D. It identifies the space requirements for the database objects based on their usage and growth statistics.
Answer: C
Q12. Which mode of database shutdown requires an instance recovery at the time of the database startup?
A. ABORT
B. NORMAL
C. IMMEDIATE
D. TRANSACTIONAL
Answer: A
Q13. You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since they may alter optimization plans in an unexpected way. To avoid this potential outcome, your best course of action would be to:
A. refrain from collecting statistics
B. use Real Application Testing to capture the workload and the worked and then run the worked on a test machine
C. use hints to create fixed plans for SQL statements
D. use deferred publishing of statistics to allow you to test execution plans before making the statistics public
E. use invisible indexes to dominate execution plans
Answer: D
Q14. Listed below are the database resident program units and their descriptions in random order.
1. Package a. stored subprogram that is associated with a database table, view or event
2. Procedure b. stand alone program that must return a value
3. Functionc. structure that contains program definitions and PL/SQL code
4. Trigged. stand-alone program that may or may not return a value
Which option specifies the correct definition for each program unit?
A. 1-c, 2-d, 3-b, 4-a
B. l-c, 2 b, 3-d, 4-a
C. l-a, 2-b, 3-d, 4-c
D. l-a, 2-d, 3-b, 4-c
Answer: A
Q15. Which two statements are true regarding the structure of the redo logs? (Choose two.)
A. Each group must have a minimum of two members.
B. Each group must have the same number of members.
C. The redo log groups in a database are written to in a cyclic fashion.
D. A minimum of two redo log groups is required for a database to open.
E. The members within a redo log group are written to in a cyclic fashion.
Answer: C,D
Q16. Which two statements are true regarding undo data records? (Choose two.)
A. They are required to support Flashback features.
B. I hey are not required if Flashback features are enabled.
C. They are retained until the session making the changes ends.
D. Undo records contain copies of data as it appears after a change is made.
E. Undo records contain copies of data as it appears before a change is made.
Answer: A,E
Q17. Which method can you use to receive a notification when the free disk space in the recovery area falls below 10%?
A. Submit a job that queries the Automatic Workload Repository (AWK).
B. Create an alert that sends a notification when the threshold value is reached.
C. Invoke the Database Configuration Assistant (DBCA. to configure notifications and set threshold values.
D. Specify the users who should receive notifications In the Preferred Credentials of the Enterprise Manager.
E. Run the Automatic Database Diagnostic Monitor (ADDM) to analyze disk space and display a warning messagE.
Answer: B
Q18. Which two statements are true regarding SQL*Plus? (Choose two.)
A. It has commands to perform database administration operations.
B. It can be used in interactive hut not batch mode for SQL commands.
C. It has to be installed separately after the Oracle database install installation.
D. Operating system commands can be executed from the SOL *Plus command prompt
Answer: A,D
Q19. You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
Which three constraints must be explicitly enforced on the table? (Choose three)
A. check constraint on the COURSE_ID column
B. foreign key constraint on the COURSE_ID column
C. check constraint on the DATE_OF_BIRTH column
D. unique key constraint on the STUDENT_ID column
E. not null constraint on the DATE_OF_BIRTH column
F. primary key constraint on the STUDENT_ID columns
Answer: B,C,F
Q20. You issue the following command as a DBA:
SQL> SHUTDOWN
What would be the outcome of the above command?
A. It causes the instance to abort.
B. It waits for all sessions to disconnect.
C. It rolls back the current transactions and disconnects a/I sessions.
D. It waits for the current transaction in each session to complete before disconnecting the sessions.
Answer: B