File Info
| Exam | Oracle Database 12c: Installation and Administration |
| Number | 1z0-062 |
| File Name | Oracle.1z0-062.TestKing.2019-12-26.221q.tqb |
| Size | 2 MB |
| Posted | Dec 26, 2019 |
| Download | Oracle.1z0-062.TestKing.2019-12-26.221q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:
- The user account must be locked after five unsuccessful login attempts.
- Data read per session must be limited for the user.
- The user cannot have more than three simultaneous sessions.
- The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?
- by granting a secure application role to the user
- by implementing Database Resource Manager
- by using Oracle Label Security options
- by assigning a profile to the user
Correct answer: D
Question 2
What happens if a maintenance window closes before a job that collects optimizer statistics completes?
- The job is terminated and the gathered statistics are not saved.
- The job is terminated but the gathered statistics are not published.
- The job continues to run until all statistics are gathered.
- The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.
Correct answer: D
Explanation:
The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The remaining objects are then processed in the next maintenance window. References: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431 The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The remaining objects are then processed in the next maintenance window.
References: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431
Question 3
Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)
- An extent contains data blocks that are always physically contiguous on disk.
- An extent can span multiple segments.
- Each data block always corresponds to one operating system block.
- It is possible to have tablespaces of different block sizes.
- A data block is the smallest unit of I/O in data files.
Correct answer: DE
Explanation:
