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.
Which three statements are true about a database instance that has mounted a database but has not opened it?
A. System administrators and users with the CREATE SESSION system privilege may connect to the instance.
B. Data files are open in read-only mode.
C. A control file is open.
D. System Global Area (SGA) is allocated and background processes are started.
E. An alert log and trace files are open.
F. Instance recovery is performed for the database.
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.
Which two statements about multitenant architecture are true?
A. It ensures full backward compatibility with non-CDBs.
B. It fully operates with RAC.
C. It is integrated with Enterprise Manager, but not with the Resource Manager.
D. It allows central management and administration of single databases.
Which two statements are true about transactions in Oracle Database 12c?
A. Multiple transactions can use the same undo segment.
B. A transaction is assigned an undo segment when it is started.
C. Multiple transactions cannot share the same extent in an undo tablespace.
D. If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.
Which two statements about Data Recovery Advisor are true?
A. Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.
B. Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CDB.
C. Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.
D. You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an RMAN session.
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.
Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?
A. addition or removal of nodes, memory, or disks
B. changing configuration parameters, upgrading, or patching Oracle software
C. file deletion
D. migrating to cluster architecture
E. dropped database object
F. table definition changes
G. runaway processes that consume system resources
H. adding table partitioning
I. operating system or storage device / driver failure
J. database or application deadlocks
What happens if you execute these SQL statements?
SQL> show con_name
CON_NAME
CDB$ROOT
SQL> create user 1_freed identified by y container=current; A. A common user is created in the root container.
B. A local user is created in the root container.
C. A local user is created in all the PDBs.
D. The second SQL statement fails because a local user cannot be created in the root container.
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
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-497 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.