Attention please! Here is the shortcut to pass your Hotest 1Z0-497 practice exam! Get yourself well prepared for the Oracle Partner Network Newest 1Z0-497 pdf Oracle Database 12c Essentials exam is really a hard job. But don’t worry! We We, provides the most update 1Z0-497 dumps. With We latest 1Z0-497 exam questions, you’ll pass the Oracle Partner Network Apr 05,2022 Newest 1Z0-497 practice Oracle Database 12c Essentials exam in an easy way
We Geekcert has our own expert team. They selected and published the latest 1Z0-497 preparation materials from Official Exam-Center.
The following are the 1Z0-497 free dumps. Go through and check the validity and accuracy of our 1Z0-497 dumps.Questions and answers from 1Z0-497 free dumps are 100% free and guaranteed. See our full 1Z0-497 dumps if you want to get a further understanding of the materials.
Question 1:
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 ORA-00028 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 2:
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- practicesv2-1493383.pdf (page 3, second bulleted point, last couple of sentences)
Question 3:
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 4:
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
Question 5:
Which is the default port number for Database Express?
A. 7801
B. 5500
C. 2243
D. 1521
E. 22
Correct Answer: D
Reference: http://docs.oracle.com/cd/B25329_01/doc/install.102/b25143.pdf (page 4, first bulleted point)
Question 6:
Your customer is looking for a solution to address these downtime needs:
– Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.
-Dynamically add or remove clustered nodes without disrupting the database or applications.
-Automate the sizing and distribution of shared memory.
-Add a column with a default value without disrupting the database or applications.
-Perform rolling patch upgrades.
Which four would you recommend to address those needs?
A. Automatic Storage Management (ASM)
B. Online Data and Application change
C. Global Data Services (GDS)
D. Real Application Clusters (RAC)
E. Oracle Streams
F. Online Table Redefinition
G. Oracle Database Vault
Correct Answer: ACDE
Question 7:
Which option represents a function of Global Data Services (GDS)?
A. performs data replication
B. performs database failovers
C. replaces the functionality of Oracle Clusterware and Oracle RAC
D. coordinates site failovers
E. works seamlessly with Oracle Site Guard
Correct Answer: AB
Question 8:
Which two statements represent where Oracle Net must reside?
A. Only on the client for traditional client/server applications
B. Only on the database server for web-based applications
C. On both the web server and database server for web-based applications
D. On both the client and database server for traditional client/server applications.
Correct Answer: BD
Question 9:
Which two statements are true about this common user?
A. SQL> conn c##usr/pwd@pdb1 You are connected to PDB1 successfully.
B. SQL> conn c##usr/pwd@pdb2 You are connected to PDB2 successfully.
C. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You first need to sync PDB2 by executing: SQL> conn / as sysdba SQL>exec DBMS_PDB.SYNC_PDB;
D. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing: SQL>conn system/pwd@pdb2 SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT; Now you are able to connect as common user c##usr to PDB2.
Correct Answer: AD
Question 10:
You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?
A. You cannot do this, because you can only clone PDBs into another CDB.
B. You can clone only one PDB (either PDB1 or PDB2) into the same CDB.
C. Cloning a PDB can use the source files copy method to the target PDB files.
D. Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.
Correct Answer: D
Question 11:
A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?
A. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword
B. ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements
C. ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword
D. D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements
Correct Answer: A
Question 12:
You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer (OUI) shows a message that says one of the product-specific prerequisite checks has failed:
Checking available swap space requirements…
Expected result: 1512MB
Actual Result: 1018MB
Check complete. The overall result of this check is: failed Problem: The system does not have the required swap space.
What happens to the installation in this situation?
A. It can be continued.
B. It resizes the swap space automatically when you proceed further.
C. It can be continued, but the instance cannot be started without increasing swap space.
D. It shows a message saying one or more prerequisite checks have failed and the installation aborts.
Correct Answer: C
Reference: https://bugs.kde.org/show_bug.cgi?id=111460
Question 13:
Examine the command below:
LSNRCTL> SERVICES LISTENER2
Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb. us. abc.com)
(PORT=1525)))
Services Summary. . .
Service “orcl.oracle.com” has 1 instance(s).
Instance “oracle”, status UNKNOWN, has 1 handler(s) for this service… Handler(s):
“DEDICATED” established:2 refused:0 LOCAL SERVER The command completed successfully
Which two statements are true about LISTENER2?
A. The ORCL instance is registered dynamically with the listener.
B. The ORCL instance is registered statically in the listener.ora file.
C. The number of current client connections handled by the service handler is two.
D. The total number of client connections handled so far by the service handler is two.
Correct Answer: AC
Question 14:
View the current parameter settings shown in the output below.
NAMETYPEVALUE db_file_multiblock_read_count integer 107 ddl_lock_timeout integer 60 Distributed_lock_timeout integer 60 dml_locks integer 748 lock_sga boolean FALS E enab1e_dd1_1ogging boolean FALS E resumable_timeout integer 0
A user logs in to the HRschema and issues the following commands:
SQL> CREATE TABLE emp (empno NUMBER(3), enamo VARCHAR2(20), sal NUMBER (8, 2));
SQL> INSERT INTO emp (empno, ename) VALUES(1, \’JAMES\’);
At this moment, a second user also logs in to the HRschema and issues the following command:
SQL> ALTER TABLE emp MODIFY salNUMBER(10, 2);
What happens in this scenario?
A. The second user\’s session immediately produces a “resource busy” error.
B. The second user\’s command executes successfully.
C. The second user\’s session waits for a time before producing a “resource busy” error.
D. A deadlock is created.
Correct Answer: A
Question 15:
Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?
A. Oracle Data Guard
B. Oracle Streams
C. Oracle Real Application Clusters
D. Oracle GoldenGate
Correct Answer: C
Reference: http://www.oracle.com/technetwork/database/availability/maximum-availability-wp- 12c-1896116.pdf (page 5, Server HA: Oracle Real Application Clusters)