最新的Oracle 1z1-497免費考試真題

問題1

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 statically in the listener.ora file.

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

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

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

正確答案: A,C

問題2

You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?

A. Oracle-supplied metadata

B. shared UNDO and default database temporary tablespace

C. shared Oracle-supplied data

D. application tablespaces

E. local users and local roles

F. CDB views providing information across PDBs

G. local temporary tablespaces

H. non-shared local metadata

正確答案: D,E,G,H

問題3

You execute some DMLcommands, followed by a COMMIT Statement.
Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

A. 1. GWR writes only the transaction's redo entries from Redo Log Buffer to disk.
2. LGWR writes the commit record to disk.

B. 1. LGWR writes the commit record to disk.
2. LGWR writes all redo entries from Redo Log Buffer to disk.

C. 1. LGWR puts the commit record to Redo Log Buffer.
2.If the activity is high, LGWR waits three seconds for other transactions to commit.
3.LGWR writes all redo log entries from Redo Log Buffer to disk.

D. 1. LGWR puts the commit record to Redo Log Buffer.
2. IGWR writes all redo entries from Redo Log Buffer to disk.

E. 1. LGWR puts the commit record to Redo Log Buffer.
2.LGWR signals the database writer (DBW) process to write dirty blocks to disk.
3.LGWR writes all redo entries from Redo Log Buffer to disk.

正確答案: D

問題4

Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs.
Consider these options:
-Instance, site recovery, and heterogeneous setup
-Inter-region and intra-region load balancing across replicated databases
-Fine-grained error investigation of incorrect results
-Integrated client and application failover
-Fastest and simplest database replication Which four options would you recommend?

A. Oracle Advanced Queuing

B. Oracle Flashback technology

C. Oracle Data Guard

D. Oracle GoldenGate

E. Data Recovery Advisor

F. Global Data Services

正確答案: B,C,D,F

說明：（僅 Fast2test 成員可見）

問題5

Which two statements about multitenant architecture are true?

A. A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB.

B. Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.

C. It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.

D. It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.

E. Multiple PDBs on a single server need multiple database instances and multiple sets of database files.

正確答案: B,D

說明：（僅 Fast2test 成員可見）

問題6

There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:
lsnrctl start listener2
What would be the outcome?

A. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

B. It starts the second listener and terminates all current sessions.

C. It starts the second listener without affecting current sessions.

D. It gives an error because multiple listeners cannot run simultaneously.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題7

YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

A. S sqlplus / as sysdba SQL> startup immediate;

B. S sqlplus / as sysdba SQL> startup open recover;

C. S sqlplus / as sysdba SQL> restart;

D. S srvctl start database -db SORACLE_SID

E. S rman target / RMAN> Startup

正確答案: B,D,E

說明：（僅 Fast2test 成員可見）

問題8

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

A. OS file system

B. RAW

C. Automatic Storage Management (ASM)

D. clustered file system

E. logical volume (LVM)

正確答案: B

問題9

What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

A. SYSBKPRMAN

B. SYSRMAN

C. SYSBKP

D. SYSBACKUP

正確答案: D

說明：（僅 Fast2test 成員可見）

問題10

Which statement about CDB architecture is true?

A. Multiple PDBs with the same name can reside in the same CDB.

B. You can create common users in PDBs.

C. Oracle-supplied metadata resides only in the root container.

D. A seed PDB can sometimes be opened for particular operations.

E. A CDB can have an infinite number of PDBs.

正確答案: C

說明：（僅 Fast2test 成員可見）

最新的Oracle Database 12c Essentials - 1z1-497免費考試真題

聯系我們

站內鏈接

最新更新