Questions And Answers PDF
Oracle 1Z0-497 Oracle Database 12c Essentials
Version: DEMO
http://www.TestWarrior.com/1Z0-497-practice-exam.html
FOR 1Z0-497 Candidates: We offer Two Products: 1st - We have Practice Tests Software with Actual Exam Questions 2nd - Questions and Answers in PDF Format. Try a Free DEMO of these Exam Products via below Link:
http://www.TestWarrior.com/1Z0-497-practice-exam.html
TestWarrior.com
1
Questions And Answers PDF
Question: 1 Which statement about CDB architecture is true? A. Oracle-supplied metadata resides only in the root container. B. A seed PDB can sometmes be opened for partcular operatons. C. Multple PDBs with the same name can reside in the same CDB. D. A CDB can have an infnite number of PDBs. E. You can create common users in PDBs.
Answer: A Explanatonn Referencen htpn::docs.oracle.com:cd:E111665_1:server.121:e11166:cdbovrvw.htmmCCCPTT8266
Question: 2 As part of your Oracle Database 12c post-installaton tasks, you run these commandsn Cd $ORACLE5HOME: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 opton in your Oracle binary fles. B. It creates the Fast Recovery Area disk group. C. It generates Client Statc Library. D. It confgures one of the Oracle user accounts. E. It confgures Oracle Cet Services. F. It confgures Oracle Messaging Gateway.
Answer: A Explanatonn Referencen htpn::docs.oracle.com:cd:E111665_1:install.121:e11TT8:postnst.htmmRILIC1_18 (see 1.1)
Question: 3 Exhibit belown
Which three statements are true about terminatng a session?
TestWarrior.com
2
Questions And Answers PDF
A. Without any error, you can terminate the actve session by executngn SQL> ALTER SYSTEM KILL SESSIOU '1, 16'; B. You can terminate the actve session by executngn SQL> ALTER SYSTEM KILL SESSIOM "1, 16'; But you also get the error messagen ORA-___2Tn your session has been killed C. You cannot terminate the actve session. You have to wait untl that session becomes inactve. D. Without any error, you can terminate the inactve session by executngn SQL> ALTER SYSTEM KILL SESSIOC '12, 16'; E. When an inactve session is killed, the status of that session remains visible in VSSESSIOC with status KILLED. The rowf the terminated session is removed from VSSESSIOC afer the user atempts to use the session again. F. You cannot terminate the inactve session. You have to wait untl that session becomes actve again.
Answer: D,E,F Referencen htpn::docs.oracle.com:cd:B2T6685_1:server.111:b2T61_:manproc__T.htmmADMIC11182
Question: 4 Which two statements are true about shared server sessions? A. Co Program Global Area (PGA) is allocated for shared server processes. B. User Global Area is stored in System Global Area (SGA). C. Shared SQL Area is allocated from Program Global Area (PGA). D. Private SQL Area is allocated from Library Cache. E. Large Pool is used for SQL work areas.
Answer: D Explanatonn Referencen htpn::docs.oracle.com:cd:B186_15_1:server.1_2:b1122_:memory.htm (see library cache)
Question: 5 Which targets can be managed by using Enterprise Manager Cloud Control? A. Hosts and databases B. Hosts, databases, and applicaton servers C. Applicaton servers and web applicatons D. Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR) E. Databases, applicaton servers, and web applicatons F. Hosts, databases, applicaton servers, web applicatons, OMS, and OMR
Answer: A
TestWarrior.com
6
Questions And Answers PDF
Explanatonn Referencen htpn::www.oracle.com:technetwork:oem:framework-infra:wp-em12c-security-bestpractcesv211866T6.pdf (page 6, second bulleted point, last couple of sentences)
Question: 6 Which two statements are true regarding SQL*Plus? A. It has commands for performing database administraton operatons. B. It can be used in interactve but not batch mode for SQL commands. C. It has to be installed separately afer the Oracle Database 12c installaton. D. Operatng system commands can be executed from the SQL*Plus command prompt.
Answer: A Explanatonn Referencen htpn::docs.oracle.com:cd:B111115_1:server.1_1:b1211_:/start.htm
Question: 7 Which two statements about the Process Monitor (PMOC) process are true? A. PMOC performs process recovery when a client process fails. B. During instance startup, PMOC takes care of instance recovery. C. PMOC performs listener registraton. D. PMOC restarts background and dispatcher processes when they fail. E. PMOC resolves failures of distributed transactons.
Answer: A,C Question: 8 Which statement is true about loading data by using the conventonal path of SQL*Loader? A. Redo is not generated while performing conventonal path loads. B. Only PRIMARY KEY, UCIQUE KEY, and COT CULL constraints are checked, C. Co exclusive locks are ac/uired when the conventonal path loads are performed. D. Instead of performing transactons, SQL*Loader directly writes data blocks to the data fles. E. ICSERT triggers are disabled before the conventonal path load and re-enabled at the end of the load.
Answer: B Explanatonn Referencen htpn::docs.oracle.com:cd:A611165_1:DOC:server:doc:SUT16:chT.htmmdataa2_paths(see loads, integrity constraints, and triggers)
TestWarrior.com
1
direct
Questions And Answers PDF
Question: 9 Identfy three key propertes of a transacton in Oracle Database 12c. A. durability B. consistency C. concurrency D. isolaton E. scalability F. manageability
Answer: A,B,D Explanatonn Referencen htpn::docs.oracle.com:cd:E111665_1:server.121:e11166:transact.htmmCCCPT_11
Question: 10 Which type of fle system is COT valid for storing data fles, online redo log fles, and control fles for a pluggable database? A. Automatc Storage Management (ASM) B. OS fle system C. logical volume (LVM) D. clustered fle system E. RAW
Answer: E Question: 11 Which two statements about ADDM are true? A. Real-Time ADDM uses AWR snapshots of the last 1_ minutes. B. Real-Time ADDM uses ASH recent actvity from SGA data. C. Real-Time ADDM analyzes performance in a completely diferent fashion than regular ADDM. D. Regular ADDM uses AWR snapshots that are not yet purged.
Answer: C Question: 12 Which two items are key for maintaining data consistency in Oracle Database 12c? A. undo data B. isolaton level C. lock mechanism D. serializability
TestWarrior.com
6
Questions And Answers PDF
Answer: C Explanatonn Referencen htpn::docs.oracle.com:cd:E11TT25_1:server.112:e261T8:consist.htmmCCCPTTT818(overview the oracle database locking mechanism)
of
Question: 13 You are about to install Oracle Database 12c Enterprise Editon. Which statement is true? A. You should not install the Oracle Database sofware into an existng Oracle home from a diferent release. B. A multtenant container database (CDB) can have several pluggable databases (PDBs) with diferent character sets. C. Oracle recommends that you back up the root. sh script afer you complete the installaton. D. Cloning an Oracle home is useful if you are performing multple Oracle Database Installatons. E. You can stop existng Oracle processes, including the listener and the database running in the Oracle home, before the database sofware installaton.
Answer: E Question: 14 Which logical storage relatonship 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
Answer: A Explanatonn Referencen htpn::www.dummies.com:how-to:content:basics-of-logical-structures-in-oracle-12c.html
Question: 15 Which two statements about multtenant architecture are true? A. Multple PDBs on a single server need multple database instances and multple sets of database fles. 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-tme recovery to retrieve lost data from a PDB, only by shutng 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 tme to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.
TestWarrior.com
1
Questions And Answers PDF
Answer: D
TestWarrior.com
1
Questions And Answers PDF
Thank You for Trying Our Product Visit Our Site to Purchase the Full Set of Actual 1Z0-497 Exam Questions With Answers.
http://www.TestWarrior.com/1Z0-497-practice-exam.html We Also Provide Practice Exam Software That Simulates Real Exam Environment And Has Many Self-Assessment Features. Download Free Product Demo From:
Download Free Product Demo from: http://www.TestWarrior.com/1Z0-497-practice-exam.html
Check Out Our Customer Testimonials
TestWarrior.com
T