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.

Your customer is looking for a solution to address these downtime needs:

-Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.

-Dynamically add or remove clustered nodes without disrupting the database or applications.

-Automate the sizing and distribution of shared memory.

-Add a column with a default value without disrupting the database or applications.

-Perform rolling patch upgrades.

Which four would you recommend to address those needs?

A. Automatic Storage Management (ASM)

B. Online Data and Application change

C. Global Data Services (GDS)

D. Real Application Clusters (RAC)

E. Oracle Streams

F. Online Table Redefinition

G. Oracle Database Vault

A DBA informs you that an Oracle instance has started. What does this imply?

A. Users can access the data in the database.

B. Only SGA has been allocated for the database.

C. Only background and user processes are running.

D. Memory areas have been allocated and background processes have been started.

When you start up a CDB, which operations are performed automatically and in what order?

a - The instance is started.

b - Control files are opened.

c - The root container is opened (redo logs and root data files).

d - Seed pluggable database is in READ ONLY mode.

e - Other PDBs are still in MOUNTED mode.

f - Triggers may fire if they exist to open other PDBs.

A. a, b, c, d, e, f

B. b, c, a, d, e, f

C. c, b, a, d, f, e

D. a, b, c, d

E. b, c, a, d

You went to create a new CDB foe your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB?

A. You have to copy the seed data files yourself,

B. You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.

C. The seed pluggable database is not required.

D. The seed pluggable database does not require data files.

E. The seed pluggable database is always kept in READ ONLY mode.

F. The seed pluggable database is not a container.

G. The seed pluggable database can be dropped.

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

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

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

B. GDS helps in performing data replication.

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

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

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

You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

A. You can drop the PDB only if it is closed.

B. You can drop the seed PDB, but you cannot create any other PDB within the CDB.

C. You can drop the PDB and keep the data files to be reused by another PDB.

D. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.