Oracle 1Z0-497 Exam Actual Questions

Name: Oracle Database 12c Essentials
Brand: QA4Exam
SKU: 1Z0-497
Price: 30 USD
Availability: InStock
Rating: 5.0 (290 reviews)

The questions for 1Z0-497 were last updated on Oct 3, 2024.

Viewing page 1 out of 30 pages.
Viewing questions 1-5 out of 150 questions

Unlock Access to All 150 Questions & Answers

Question No. 1

Which three are initialization parameters for backup and recovery?

ACLONEDB

BFILESYSTEMIO_OPTIONS

CDB_CREATE_FILE_DEST

DRECYCLEBIN

ETAPE_ASYNCH_IO

Show Answer

Correct Answer: A, D, E

http://docs.oracle.com/database/121/REFRN/refrn00102.htm#REFRN00102

Question No. 2

In which situation would you use static database registration for a listener?

Awhen multiple databases are to be registered with the listener

Bwhen DBAs need to connect remotely to start up the database instance

Cwhen users need to connect the database instance by using the host naming method

Dwhen the database instance to be registered with the listener is configured in shared server mode

Show Answer

Correct Answer: B

https://docs.oracle.com/database/121/NETAG/advcfg.htm#NETAG1589

Question No. 3

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

AS sqlplus / as sysdba
SQL> restart;

BS sqlplus / as sysdba
SQL> startup immediate;

CS rman target /
RMAN> Startup

DS sqlplus / as sysdba
SQL> startup open recover;

ES srvctl start database -db SORACLE_SID

Show Answer

Correct Answer: C, D, E

The following command starts an instance, reads the initialization parameters from the default location, and then mounts and opens the database. (You can optionally specify a PFILE clause.)

STARTUP

If you know that media recovery is required, you can start an instance, mount a database to the instance, and have the recovery process automatically start by using the STARTUP command with the RECOVER clause:

STARTUP OPEN RECOVER

To start or stop your entire cluster database, that is, all of the instances and its enabled services, enter the following SRVCTL commands:

$ srvctl start database -db db_unique_name [-startoption start_options]

Question No. 4

Which two statements are true about a buffer cache?

AWhen a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.

BA buffer cache stores copies of data blocks from all files of the database.

CBuffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.

DA buffer cache always resides completely in System Global Area (SGA).

EA buffer cache contains exactly three pools: default, keep, and recycle pool.

Show Answer

Correct Answer: A, E

Question No. 5

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

AYou can drop the PDB only if it is closed.

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

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

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

Show Answer

Correct Answer: A, C

https://docs.oracle.com/database/121/SQLRF/statements_8028.htm#SQLRF55699

Unlock All Questions for Oracle 1Z0-497 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 150 Questions & Answers