1Z0-497 Dumps Update Helps Prepare For Challenging Oracle Exams
To help you prepare for this challenging Oracle Database 12c Essentials exam, we’ve got updated 1Z0-497 dumps for you to study.
The PassITDump 1Z0-497 dumps cover everything about the exam, practice the 150+ quiz questions carefully and you will be successful.
If you need to check sample questions of the 1Z0-497 free dumps, go through the Q and As from 1Z0-497 dumps below.
Question 1:
Which statement about CDB architecture is true?
A. Oracle-supplied metadata resides only in the root container.
B. A seed PDB can sometimes be opened for particular operations.
C. Multiple PDBs with the same name can reside in the same CDB.
D. A CDB can have an infinite number of PDBs.
E. You can create common users in PDBs.
Correct Answer: A
Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89235
Question 2:
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
What does this do?
A. It enables the Oracle Data Mining option in your Oracle binary files.
B. It creates the Fast Recovery Area disk group.
C. It generates Client Static Library.
D. It configures one of the Oracle user accounts.
E. It configures Oracle Net Services.
F. It configures Oracle Messaging Gateway.
Correct Answer: A
Reference: http://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (see 4.4)
Question 3:
Exhibit below:
Which three statements are true about terminating a session?
A. Without any error, you can terminate the active session by executing: SQL> ALTER SYSTEM KILL SESSION \’7, 15\’;
B. You can terminate the active session by executing: SQL> ALTER SYSTEM KILL SESSION “7, 15\’; But you also get the error message: ORA-00028: your session has been killed C. You cannot terminate the active session. You have to wait until that session becomes inactive.
D. Without any error, you can terminate the inactive session by executing: SQL> ALTER SYSTEM KILL SESSION \’12, 63\’;
E. When an inactive session is killed, the status of that session remains visible in VSSESSION with status KILLED. The rowf the terminated session is removed from VSSESSION after the user attempts to use the session again.
F. You cannot terminate the inactive session. You have to wait until that session becomes active again.
Correct Answer: BDE
B (not A, Not C):
* You terminate a current session using the SQL statement ALTER SYSTEM KILL SESSION. The following statement terminates the session whose system identifier is 7 and serial number is
15:
* Terminating an Active Session If a user session is processing a transaction (ACTIVE status) when you terminate the session, the transaction is rolled back and the user immediately receives the following message:
ORA-00028: your session has been killed
ALTER SYSTEM KILL SESSION \’7,15\’;
E (not F): Terminating an Inactive Session
If the session is not making a SQL call to Oracle Database (is INACTIVE) when it is terminated, the ORA00028 message is not returned immediately. The message is not returned until the user subsequently attempts to use the terminated session.
When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED. The row for the terminated session is removed from V$SESSION after the user attempts to use the session again and receives the ORA-00028 message.
Reference: Oracle Database Administrator\’s Guide, Terminating Sessions URL: http://docs.oracle.com/cd/ B28359_01/server.111/b28310/manproc008.htm#ADMIN11192
Question 4:
Which targets can be managed by using Enterprise Manager Cloud Control?
A. Hosts and databases
B. Hosts, databases, and application servers
C. Application servers and web applications
D. Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)
E. Databases, application servers, and web applications
F. Hosts, databases, application servers, web applications, OMS, and OMR
Correct Answer: A
Reference: http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-security-best- practicesv21493383.pdf (page 3, second bulleted point, last couple of sentences)
Question 5:
Which two statements are true regarding SQL*Plus?
A. It has commands for performing database administration operations.
B. It can be used in interactive but not batch mode for SQL commands.
C. It has to be installed separately after the Oracle Database 12c installation.
D. Operating system commands can be executed from the SQL*Plus command prompt.
Correct Answer: AC
C: how to start SQL*Plus:
1- Make sure that SQL*Plus has been installed on your computer.
2.
Log on to the operating system (if required).
3.
Enter the command, SQLPLUS, and press Return.
Etc.
Not B: In SQL*Plus command-line, the use of an external editor in combination with the @, @@ or START commands is an effective method of creating and executing generic scripts. You can write scripts which contain SQL*Plus, SQL and PL/SQL commands, which you can retrieve and edit. This is especially useful for storing complex commands or frequently used reports.
Reference: http://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm
Question 6:
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.
Correct Answer: AC
Question 7:
Which statement is true about loading data by using the conventional path of SQL*Loader?
A. Redo is not generated while performing conventional path loads.
B. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
C. No exclusive locks are acquired when the conventional path loads are performed.
D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
E. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.
Correct Answer: B
Reference: http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SUT73/ch8.htm#data %20paths (see direct loads, integrity constraints, and triggers)
Question 8:
Identify three key properties of a transaction in Oracle Database 12c.
A. durability
B. consistency
C. concurrency
D. isolation
E. scalability
F. manageability
Correct Answer: ABD
Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17633/transact.htm#CNCPT016
Question 9:
Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?
A. Automatic Storage Management (ASM)
B. OS file system
C. logical volume (LVM)
D. clustered file system
E. RAW
Correct Answer: E
Question 10:
Which two statements about ADDM are true?
A. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
B. Real-Time ADDM uses ASH recent activity from SGA data.
C. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
D. Regular ADDM uses AWR snapshots that are not yet purged.
Correct Answer: CD
C: Real-Time ADDM provides an innovative way to analyze problems in unresponsive or hung databases. Using a normal and a diagnostic mode connection Real-Time ADDM runs through a set of predefined criteria to analyze the current performance and helps the DBA to resolve deadlocks, hangs, shared pool contentions and many other exception situations that today forces the administrator to bounce their databases, causing significant loss of revenue. Real-Time ADDM is the only tool available in the market today that can log into a hung database, analyze the problem and recommend a resolution
Note: Real-Time ADDM is an innovative way to analyze problems in extremely slow or unresponsive databases, which would have traditionally required a database restart. Real-Time ADDM can help resolve issues such as deadlocks, hangs, and shared pool contentions, as well as many other exception situations, without resorting to a restart of the database.
D: ADDM builds upon the data captured in AWR.
Question 11:
Which two items are key for maintaining data consistency in Oracle Database 12c?
A. undo data
B. isolation level
C. lock mechanism
D. serializability
Correct Answer: C
Reference: http://docs.oracle.com/cd/E11882_01/server.112/e25789/consist.htm#CNCPT88969 (overview of the oracle database locking mechanism)
Question 12:
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
A. You should not install the Oracle Database software into an existing Oracle home from a different release.
B. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
C. Oracle recommends that you back up the root. sh script after you complete the installation.
D. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
E. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.
Correct Answer: B
Question 13:
Which logical storage relationship is correct?
A. Tablespace< Segment < Extent < Oracle Datablock
B. B) Segment < Extent < Oracle Datablock<Tablespace
C. Tablespace< Extent < Segment < Oracle Datablock
D. Data File <Tablespace< Segment < Extent < Oracle Datablock
Correct Answer: A
Reference: http://www.dummies.com/how-to/content/basics-of-logical-structures-in-oracle- 12c.html
Question 14:
Which two statements about multitenant architecture are true?
A. Multiple PDBs on a single server need multiple database instances and multiple sets of database files.
B. Although consolidated into a single physical database, PDBs mimic the behavior of non- CDBs.
C. 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.
D. It is easier to collect performance metrics for many databases in a CDB than individual non- CDB databases.
E. It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.
Correct Answer: BD
B: A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.
D: Ease of performance tuning
It is easier to collect performance metrics for a single database than for multiple databases. It is easier to size one SGA than 100 SGAs.
Reference: Benefits of the Multitenant Architecture for Database Consolidation URL: http:// docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239
Question 15:
Which three statements represent the benefits of multitenant architecture for database consolidation?
A. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.
B. You can consolidate shared database memory by combining multiple PDBs in a single CDB.
C. Patching individual PDBs requires the same amount of time as patching individual databases.
D. Consolidating separate databases into a single CDB requires the same amount of storage allocation.
E. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.
Correct Answer: ADE
A: By design, you can quickly plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this
PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the
transportable tablespace technique.
D: The process of consolidating data from multiple databases into one database on one computer is
known as database consolidation. Starting in Oracle Database 12c, the Oracle Multitenant option enables
you to consolidate data and code without altering existing schemas or applications.
By consolidating hardware and sharing database memory and files, you reduce costs for hardware,
storage, availability, and labor. For example, 100 PDBs on a single server share one database instance
and one set of database files, thereby requiring less hardware and fewer personnel.
E: A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.
Reference: Benefits of the Multitenant Architecture for Database Consolidation URL: http:// docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239