2018 Jan Oracle Official New Released 1z0-497
100% Free Download! 100% Pass Guaranteed!

Oracle Database 12c Essentials

Question No: 41

Which normalization level is adopted in real-world database systems?

  1. 1NF

  2. 2NF

  3. 3NF

  4. BCNF

Answer: C

Explanation: http://docs.oracle.com/database/121/DWHSG/ch2logdes.htm#DWHSG9225

Question No: 42

Which three background processes are mandatory in a database Instance started with a minimally configured Initialization parameter file?

  1. Process Monitor Process (PMON)

  2. Flashback Data Archive process (FBDA)

  3. Space Management Coordinator process (SMCO)

  4. Recoverer process (RECO)

  5. Listener Registration process (LREG)

  6. Checkpoint Process

Answer: D,E,F

Reference: Oracle Database Concepts 12c, Mandatory Background Processes http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT008

Question No: 43

You are about to apply a patch to a database. Which recommended action is incorrect?

  1. You should check the patch conflict with installed patches before applying the patch.

  2. You should make sure that you have a good backup of the software, database, and configuration files.

  3. You should install the latest O patch before applying the patch.

  4. You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

  5. You should stop all applications running from the software directory that is being


Answer: D

Question No: 44

Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

  1. Asynchronous redo transport with Data Guard

  2. Synchronous redo transport with Data Guard

  3. Active Data Guard Far Sync

  4. Data Guard SQL Apply

Answer: B,C

Explanation: http://www.oracle.com/technetwork/database/availability/active-data-guard- wp-12c-1896127.pdf

Question No: 45

Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?

  1. non-cumulative

  2. multi-version

  3. proactive

  4. stabilizing

  5. cumulative

Answer: C,D,E

Question No: 46

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and

SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

  1. These administrative privileges enable you to connect to the database only if the database is open.

  2. After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

  3. These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

  4. Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

Answer: B,D

Explanation: https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11052

Question No: 47

Which two statements represent where Oracle Net must reside?

  1. Only on the client for traditional client/server applications

  2. Only on the database server for web-based applications

  3. On both the web server and database server for web-based applications

  4. On both the client and database server for traditional client/server applications.

Answer: C,D

Question No: 48

Which two statements are true regarding undo data records?

  1. They are required to support Flashback features.

  2. They are not required if Flashback features are enabled.

  3. They are retained until the session making the changes ends.

  4. Undo records contain copies of data as it appears after a change is made.

  5. Undo records contain copies of data as it appears before a change is made.

Answer: A,E



Question No: 49

Which new process was introduced as of Oracle Database 12c?

  1. Result Cache Background process (RCBG)

  2. AQ Coordinator process (QMNC)

  3. Change Tracking Writer process (CTWR)

  4. Listener Registration process (LREG)

Answer: D

Reference: http://musingdba.wordpress.com/2013/07/05/new-in-oracle-database-12c-a/

Question No: 50

All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:

SQLgt; UPDATE persons SET ccode=#39;U031#39; WHERE ccode=#39;U029#39;; 123 rows updated.

SQLgt; DELETE FROM persons WHERE exp=#39;Y#39;;

3 rows deleted.

The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?

  1. all sessions of the HR user

  2. all sessions of the HR user and the SYS user

  3. the session of the HR user that executed the commands

  4. all sessions for which database users have access privileges to the PERSONS table

Answer: C

Explanation: Without issue of commit by the HR user, the other users are unable to see the changes even though they have access.

100% Free Download!
Download Free Demo:1z0-497 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-497 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE