1Z0-497 Exam Questions

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 issu...

You add the following code in the tnsnames.ora file on a client PC: sales= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP)(HOST=sales data) (PORT=1521) ) (CONNECT_DATA= (SERVICE_NAME=sales....

Which three statements are true about database storage structures?

You are about to apply a patch to a database. Which recommended action is incorrect?

Which type of information is included in dynamic performance views? 1 - System and session parameters 2 - Memory usage and allocation 3 - File states (including RMAN backup files)...

Which three statements are true about System Global Area (SGA)?

Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?

Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?

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

Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?

Examine the error: GSM-45054: GSM error or NET-40006: unable to start GSH What is the cause of this error, and what troubleshooting steps should you perform?

Which three events signal a database writer (DWR) to write buffers to disk?

Which three background processes are mandatory in a database Instance started with a minimally configured Initialization parameter file?

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administ...

Examine the output: SQL> SELECT index_name, status FROM dba_indexes WHERE status='UNUSABLE'; INDEX_NAME STATUS --------------------- ----------------- EINDUNUSABLE Which two statem...

All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions: SQL...

Which three statements about replication options are true?

Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

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-ea...

You connect to a database instance and execute a DML command that changes one data block. The block is read from the buffer cache, modified, and modified, and marked as dirty. You...

In Oracle Database 12c, when does a transaction begin?

Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the c...

Which database feature can be used for organizing data when there is a very large amount of data?

Which four items exist in the root of a CDB, but not in the PDBs?

What do the regexp_pattern and regexp_replace_string parameters accomplish?

Which normalization level is adopted in real-world database systems?

What happens when you execute these SQL statements? ALTER SYSTEM SET SGA_TARGET = 992M; ALTER SYSTEM SET SHARED_POOL_SIZE = 0; ALTER SYSTEM SET LARGE_POOL_SIZE = 0; ALTER SYSTEM SE...

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

Which three are initialization parameters for backup and recovery?

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

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

Which two statements are true about a buffer cache?

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

Which process is responsible for writing the contents of database buffers to data files?

Which statement about CDB architecture is true?

As part of your Oracle Database 12c post-installation tasks, you run these commands: Cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm srvctl start database -d myDb...

Exhibit below: Which three statements are true about terminating a session?

Which two statements are true about shared server sessions?

Which targets can be managed by using Enterprise Manager Cloud Control?

Which two statements are true regarding SQL*Plus?

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

Which statement is true about loading data by using the conventional path of SQL*Loader?

Identify three key properties of a transaction in Oracle Database 12c.

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

Which two statements about ADDM are true?

Which two items are key for maintaining data consistency in Oracle Database 12c?

You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

Which logical storage relationship is correct?

Which two statements about multitenant architecture are true?

Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?