[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-497 Dumps with VCE and PDF Download 21-30

Ensurepass.com : Ensure you pass the IT Exams 2018 Jan Oracle Official New Released 1z0-497
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-497.html

Oracle Database 12c Essentials

Question No: 21

Which two statements are true about shared server sessions?

  1. No Program Global Area (PGA) is allocated for shared server processes.

  2. User Global Area is stored in System Global Area (SGA).

  3. Shared SQL Area is allocated from Program Global Area (PGA).

  4. Private SQL Area is allocated from Library Cache.

  5. Large Pool is used for SQL work areas.

Answer: B,D

Reference: Oracle Database Concepts, 12c, Memory Architecture

Question No: 22

Which two statements are true about listeners?

  1. Listeners use only the TCP/IP protocol.

  2. Multiple listener processes can run simultaneously on a host.

  3. Multiple database instances can be registered with a single listener,

  4. Listener-related errors can be traced only at the administrative level.

  5. Only one database instance can be registered with a single listener at any time.

Answer: B,C Explanation:

http://docs.oracle.com/cd/E11882_01/network.112/e10835/protocoladd.htm#NETRF179

Question No: 23

Which tablespace contains the data dictionary, being automatically created at database creation?

  1. USERS

  2. TEMP

  3. SYSAUX

  4. SYSTEM

  5. EXAMPLE

Answer: D

Reference: http://docs.oracle.com/cd/B10500_01/server.920/a96524/c04space.htm

Question No: 24

Which two statements about Global Data Services (GDS) are correct?

  1. GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).

  2. GDS helps in performing data replication.

  3. GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.

  4. GDS helps to perform database failovers, and does not require Data Guard Broker.

  5. The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.

Answer: A,C

Reference: http://www.oracle.com/technetwork/database/availability/global-data-services- 12c-wp-1964780.pdf (page 8)

Question No: 25

Which three statements are true about a database instance that has mounted a database but has not opened it?

  1. System administrators and users with the CREATE SESSION system privilege may

    connect to the instance.

  2. Data files are open in read-only mode.

  3. A control file is open.

  4. System Global Area (SGA) is allocated and background processes are started.

  5. An alert log and trace files are open.

  6. Instance recovery is performed for the database.

Answer: C,D,E

Question No: 26

Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?

  1. full redaction

  2. partial redaction

  3. regular expressions

  4. random redaction

  5. no redaction

Answer: C Explanation:

http://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG10563

Question No: 27

In this SQL statement, what is the partitioning criteria?

CREATE TABLE books_part PARTITION BY RANGE (cell_id) (

PARTITION p0l VALUES LESS THAN (2), PARTITION p02 VALUES LESS THAN (3) ,

. . .

PARTITION pl4 VALUES LESS THAN (15),

PARTITION pl5 VALUES LESS THAN (16), PARTITION pl6 VALUES LESS THAN (MAXVALUE)

)

AS SELECT * FROM books;

  1. books

  2. pxx

  3. MAXVALUE

  4. cell_id

  5. There is no partitioning criteria.

Answer: D

Question No: 28

You execute some DMLcommands, followed by a COMMIT Statement.

Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

  1. 1. LGWR writes the commit record to disk.

    2. LGWR writes all redo entries from Redo Log Buffer to disk.

  2. 1. GWR writes only the transaction#39;s redo entries from Redo Log Buffer to disk.

    2. LGWR writes the commit record to disk.

  3. 1. LGWR puts the commit record to Redo Log Buffer.

    2. IGWR writes all redo entries from Redo Log Buffer to disk.

  4. 1. LGWR puts the commit record to Redo Log Buffer.

    1. If the activity is high, LGWR waits three seconds for other transactions to commit.

    2. LGWR writes all redo log entries from Redo Log Buffer to disk.

  5. 1. LGWR puts the commit record to Redo Log Buffer.

  1. LGWR signals the database writer (DBW) process to write dirty blocks to disk.

  2. LGWR writes all redo entries from Redo Log Buffer to disk.

    Answer: A

    Question No: 29

    Which statement is true regarding this connect string?

    (DESCRIPTION (FAILOVER=on) (ADDRESS_LIST= (LOAD_BALANCE=ON)

    (ADDRESS=(host=sales-east1) (port=1522) ) (ADDRESS=(host=sales-east2)(port=1522)) (ADDRESS=(host=sales-east3) (port=1522) )) (ADDRESS_LIST=

    (LOAD_BALANCE=ON)

    (ADDRESS=(host=sales-west1) (port=1522) ) (ADDRESS=(host=sales-west2) (port=JS22)) (ADDRESS=(host=sales-west3) (port=lS22) ) ) (CONNECT_DATA= (SERVICE_NAME=sales)

    (REGION=east)))

    1. It contains three global service managers in the client#39;s local region (east).

    2. Client-side load balancing has been enabled only for the global service managers within the client#39;s buddy (west).

    3. Connect-time failover between regions has not been enabled.

    4. The REGION parameter is optional.

Answer: D

Explanation: https://docs.oracle.com/database/121/GSMUG/globser.htm#GSMUG650

Question No: 30

Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle Database 12con Solaris, and is concerned about the downtime. Which Oracle solution would you recommend?

  1. Active Data Guard

  2. Oracle GoldenGate

  3. Oracle Real Application Clusters

  4. Oracle Transportable Tablespaces

  5. Oracle Cloud Platform as a Service

Answer: B

100% Ensurepass Free Download!
Download Free Demo:1z0-497 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-497 Dumps

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

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.