1Z0-497 Online Practice Questions and Answers

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

A. PMON performs process recovery when a client process fails.

B. During instance startup, PMON takes care of instance recovery.

C. PMON performs listener registration.

D. PMON restarts background and dispatcher processes when they fail.

E. PMON resolves failures of distributed transactions.

YOU want to move all objects of the CONSULTANT user from the test database to theDB- USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

A. FULL

B. SCHEMAS

C. TRANSFORM

D. REMAP_SCHEMA

E. REMAP_TABLESPACE

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

A. full redaction

B. partial redaction

C. regular expressions

D. random redaction

E. no redaction

You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer

(OUI) shows a message that says one of the product-specific prerequisite checks has failed:

Checking available swap space requirements...

Expected result: 1512MB

Actual Result: 1018MB

Check complete. The overall result of this check is: failed «« Problem: The system does not have the

required swap space.

What happens to the installation in this situation?

A. It can be continued.

B. It resizes the swap space automatically when you proceed further.

C. It can be continued, but the instance cannot be started without increasing swap space.

D. It shows a message saying one or more prerequisite checks have failed and the installation aborts.

Examine the command below:

LSNRCTL> SERVICES LISTENER2

Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb. us. abc.com)

(PORT=1525)))

Services Summary. . .

Service "orcl.oracle.com" has 1 instance(s).

Instance "oracle", status UNKNOWN, has 1 handler(s) for this service... Handler(s):

"DEDICATED" established:2 refused:0 LOCAL SERVER The command completed successfully

Which two statements are true about LISTENER2?

A. The ORCL instance is registered dynamically with the listener.

B. The ORCL instance is registered statically in the listener.ora file.

C. The number of current client connections handled by the service handler is two.

D. The total number of client connections handled so far by the service handler is two.

Which two statements about switchover and failover are true?

A. A snapshot standby can be the target of a switchover or fast-start failover operation.

B. Neither a switchover nor a failover is possible to a far sync instance.

C. For fast-start failover, you must preselect the target standby database that will be used.

D. You can activate a standby database to test whether it is being updated correctly.

Which three tasks can you perform in Database Express?

A. View performance and status information about the database instance.

B. Start up the database.

C. Shut down the database.

D. Create database structures.

E. Manage users and security.

What must you do to an application for it to take advantage of partitioning?

A. recompile it

B. rewrite its SQL queries

C. relink

D. rework the applications schema

E. nothing; it is transparent

Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?

A. 615 MB

B. 2.5 GB

C. 4 GB

D. 12 GB

E. 22 GB

Which three statements about replication options are true?

A. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

B. Oracle Streams is deprecated in Oracle Database 12c Release 1.

C. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

D. Oracle Database Advanced Queuing is independent of Oracle Streams.

E. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.