Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-497

Free Oracle 1Z0-497 Exam Braindumps (page: 3)

Page 3 of 31
PDF with 150 Questions

Which two statements are true regarding SQL*Plus?

  1. It has commands for performing database administration operations.
  2. It can be used in interactive but not batch mode for SQL commands.
  3. It has to be installed separately after the Oracle Database 12c installation.
  4. Operating system commands can be executed from the SQL*Plus command prompt.

Answer(s): A,D


Reference:

http://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm



Which two statements about the Process Monitor (PMON) process are true?

  1. PMON performs process recovery when a client process fails.
  2. During instance startup, PMON takes care of instance recovery.
  3. PMON performs listener registration.
  4. PMON restarts background and dispatcher processes when they fail.
  5. PMON resolves failures of distributed transactions.

Answer(s): A,D

Explanation:

http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9840



Which statement is true about loading data by using the conventional path of SQL*Loader?

  1. Redo is not generated while performing conventional path loads.
  2. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
  3. No exclusive locks are acquired when the conventional path loads are performed.
  4. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
  5. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

Answer(s): C


Reference:

http://www.orafaq.com/wiki/SQL*Loader



Identify three key properties of a transaction in Oracle Database 12c.

  1. durability
  2. consistency
  3. concurrency
  4. isolation
  5. scalability
  6. manageability

Answer(s): A,B,D


Reference:

http://docs.oracle.com/cd/E16655_01/server.121/e17633/transact.htm#CNCPT016



Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?

  1. Automatic Storage Management (ASM)
  2. OS file system
  3. logical volume (LVM)
  4. clustered file system
  5. RAW

Answer(s): E

Explanation:

https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60120



Viewing page 3 of 31
Viewing questions 11 - 15 out of 150 questions



Post your Comments and Discuss Oracle 1Z0-497 exam prep with other Community members:

1Z0-497 Exam Discussions & Posts