1Z0-497 Exam Questions
166 real 1Z0-497 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #102
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...
- Question #103
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....
- Question #104
Which three statements are true about database storage structures?
- Question #105
You are about to apply a patch to a database. Which recommended action is incorrect?
- Question #106
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)...
- Question #107
Which three statements are true about System Global Area (SGA)?
- Question #108
Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?
- Question #109
Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?
- Question #110
What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?
- Question #111
Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?
- Question #112
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?
- Question #113
Which three events signal a database writer (DWR) to write buffers to disk?
- Question #114
Which three background processes are mandatory in a database Instance started with a minimally configured Initialization parameter file?
- Question #115
Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administ...
- Question #116
Examine the output: SQL> SELECT index_name, status FROM dba_indexes WHERE status='UNUSABLE'; INDEX_NAME STATUS --------------------- ----------------- EINDUNUSABLE Which two statem...
- Question #117
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...
- Question #118
Which three statements about replication options are true?
- Question #119
Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.
- Question #120
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...
- Question #121
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...
- Question #122
In Oracle Database 12c, when does a transaction begin?
- Question #123
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...
- Question #124
Which database feature can be used for organizing data when there is a very large amount of data?
- Question #125
Which four items exist in the root of a CDB, but not in the PDBs?
- Question #126
What do the regexp_pattern and regexp_replace_string parameters accomplish?
- Question #127
Which normalization level is adopted in real-world database systems?
- Question #128
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...
- Question #129
Which two statements about Global Data Services (GDS) are correct?
- Question #130
Which three are initialization parameters for backup and recovery?
- Question #131
In which situation would you use static database registration for a listener?
- Question #132
YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?
- Question #133
Which two statements are true about a buffer cache?
- Question #134
You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?
- Question #135
Which process is responsible for writing the contents of database buffers to data files?
- Question #136
Which statement about CDB architecture is true?
- Question #137
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...
- Question #138
Exhibit below: Which three statements are true about terminating a session?
- Question #139
Which two statements are true about shared server sessions?
- Question #140
Which targets can be managed by using Enterprise Manager Cloud Control?
- Question #141
Which two statements are true regarding SQL*Plus?
- Question #142
Which two statements about the Process Monitor (PMON) process are true?
- Question #143
Which statement is true about loading data by using the conventional path of SQL*Loader?
- Question #144
Identify three key properties of a transaction in Oracle Database 12c.
- Question #145
Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?
- Question #146
Which two statements about ADDM are true?
- Question #147
Which two items are key for maintaining data consistency in Oracle Database 12c?
- Question #148
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
- Question #149
Which logical storage relationship is correct?
- Question #150
Which two statements about multitenant architecture are true?
- Question #151
Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?