File Info
| Exam | Oracle Database 12c Essentials |
| Number | 1z0-497 |
| File Name | Oracle.1z0-497.Train4Sure.2018-11-10.93q.vcex |
| Size | 1 MB |
| Posted | Nov 10, 2018 |
| Download | Oracle.1z0-497.Train4Sure.2018-11-10.93q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which two statements are true regarding SQL*Plus?
- It has commands for performing database administration operations.
- It can be used in interactive but not batch mode for SQL commands.
- It has to be installed separately after the Oracle Database 12c installation.
- Operating system commands can be executed from the SQL*Plus command prompt.
Correct answer: AD
Explanation:
Question 2
Which two statements about the Process Monitor (PMON) process are true?
- PMON performs process recovery when a client process fails.
- During instance startup, PMON takes care of instance recovery.
- PMON performs listener registration.
- PMON restarts background and dispatcher processes when they fail.
- PMON resolves failures of distributed transactions.
Correct answer: AD
Explanation:
http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9840 http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9840
Question 3
Which statement is true about loading data by using the conventional path of SQL*Loader?
- Redo is not generated while performing conventional path loads.
- Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
- No exclusive locks are acquired when the conventional path loads are performed.
- Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
- INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.
Correct answer: C
Explanation:
Question 4
Identify three key properties of a transaction in Oracle Database 12c.
- durability
- consistency
- concurrency
- isolation
- scalability
- manageability
Correct answer: ABD
Explanation:
Question 5
Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?
- Automatic Storage Management (ASM)
- OS file system
- logical volume (LVM)
- clustered file system
- RAW
Correct answer: E
Explanation:
https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60120 https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60120
Question 6
Which two statements about ADDM are true?
- Real-Time ADDM uses AWR snapshots of the last 10 minutes.
- Real-Time ADDM uses ASH recent activity from SGA data.
- Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
- Regular ADDM uses AWR snapshots that are not yet purged.
Correct answer: BD
Explanation:
http://www.dba-scripts.com/articles/ocp-flashcards/ocp-12c-emergency-monitoring-real-time-addm/ http://www.dba-scripts.com/articles/ocp-flashcards/ocp-12c-emergency-monitoring-real-time-addm/
Question 7
Which two items are key for maintaining data consistency in Oracle Database 12c?
- undo data
- isolation level
- lock mechanism
- serializability
Correct answer: BC
Explanation:
Question 8
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
- You should not install the Oracle Database software into an existing Oracle home from a different release.
- A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
- Oracle recommends that you back up the root. sh script after you complete the installation.
- Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
- You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.
Correct answer: A
Explanation:
https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1035 https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1035
Question 9
Which logical storage relationship is correct?
- Tablespace< Segment < Extent < Oracle Datablock
- Segment < Extent < Oracle Datablock<Tablespace
- Tablespace< Extent < Segment < Oracle Datablock
- Data File <Tablespace< Segment < Extent < Oracle Datablock
Correct answer: A
Explanation:
Question 10
Which two statements about multitenant architecture are true?
- Multiple PDBs on a single server need multiple database instances and multiple sets of database files.
- Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.
- 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.
- It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.
- 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
Explanation:
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 databasesbefore Oracle Database 12c were non-CDBs. D: Ease of performance tuningIt is easier to collect performance metrics for a single database than for multiple databases. It is easier to size one SGA than 100 SGAs. 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.
