File Info
| Exam | Oracle Database 12c Essentials |
| Number | 1z0-497 |
| File Name | Oracle.1z0-497.Train4Sure.2018-11-10.93q.tqb |
| Size | 1 MB |
| Posted | Nov 10, 2018 |
| Download | Oracle.1z0-497.Train4Sure.2018-11-10.93q.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
Which two statements are true regarding SQL*Plus?
- It has commands for performing database administration operations.
- It can be used in interactive but not batch mode for SQL commands.
- It has to be installed separately after the Oracle Database 12c installation.
- Operating system commands can be executed from the SQL*Plus command prompt.
Correct answer: AD
Explanation:
Question 2
Which two statements about the Process Monitor (PMON) process are true?
- PMON performs process recovery when a client process fails.
- During instance startup, PMON takes care of instance recovery.
- PMON performs listener registration.
- PMON restarts background and dispatcher processes when they fail.
- PMON resolves failures of distributed transactions.
Correct answer: AD
Explanation:
http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9840 http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9840
Question 3
Which statement is true about loading data by using the conventional path of SQL*Loader?
- Redo is not generated while performing conventional path loads.
- Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
- No exclusive locks are acquired when the conventional path loads are performed.
- Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
- INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.
Correct answer: C
Explanation:
