Download Oracle.1z0-497.Train4Sure.2018-11-10.93q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-497 |
| Exam Name: | Oracle Database 12c Essentials |
| Date: | Nov 10, 2018 |
| File Size: | 1 MB |
| Downloads: | 1 |
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:
