1Z0-497 Exam Questions
166 real 1Z0-497 exam questions with expert-verified answers and explanations. Page 2 of 4.
- Question #51
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...
- Question #52
Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from loc...
- Question #53
Your database instance is running. db01 is a net service name. You issue a connection request by using the command: SQL> CONNECT scott/tiger@db01 Which component receives the reque...
- Question #54
Which statement about Online Move Data file is true?
- Question #55
You execute the following command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are correct?
- Question #56
Examine the statements: SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M; SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) ) PARTITION BY RANGE(id) ( pa...
- Question #57
Which two statements about Automatic Data Optimization (ADO) are true?
- Question #58
Which statement about Oracle patches is false?
- Question #59
Which three statements represent the difference between a container database (CDB)and a non- container database?
- Question #60
The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource...
- Question #61
Examine the command: SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccodeNUMBER (6), oamt NUMBER (10, 2)) TABLESPACEusers ; Which two statements are true about th...
- Question #62
Which three options correctly match environment variables with their specific functionality?
- Question #63
Identify the correct order of consolidation density, from worst to best.
- Question #64
Examine the commands: SQL> CONNECT sys@CDBl AS SYSDBA $QL>STARTUP MOUNT SQL> ALTER DATABASE cdbl MOUNT; Which four options represent what happens when these commands are executed?
- Question #65
Which two statements about switchover and failover are true?
- Question #66
Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.
- Question #67
You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?
- Question #68
Which statement about a server parameter file (SPFILE) is false?
- Question #69
Which statement about the Queryable Patch inventory feature is false?
- Question #71
Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.
- Question #72
Which three statements are true regarding database recovery operations? (Choose three.)
- Question #73
Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQLAccess Advisor? (Choose two.)
- Question #74
Which two options describe the features of simple views? (Choose two.)
- Question #75
The RECYCLEBIN parameter is set to onfor your database. You drop a table, PRODUCTS, from the SCOTTschema. Which two statements are true regarding the outcome of this action? (Choos...
- Question #76
You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?
- Question #77
You are in the middle of transaction, updating a table. The machine on which the database is running reboots because of a power outage. This causes a database instance failure. Whi...
- Question #78
Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?
- Question #79
For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?
- Question #80
Which two statements about multi section backup are true?
- Question #81
Which tablespace contains the data dictionary, being automatically created at database creation?
- Question #82
Which three tasks can you perform in Database Express?
- Question #83
Which two statements are true about the B-tree Index?
- Question #84
Which two statements are true about listeners?
- Question #85
You want to start a global service on your database. Which three conditions must be met?
- Question #86
What must you do to an application for it to take advantage of partitioning?
- Question #87
Which three statements about common and local roles are true?
- Question #88
Which statement regarding Oracle Active Data Guard 12c is false?
- Question #89
Examine the command: sqlplus /nolog In which scenario would this command execute successfully?
- Question #90
John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may...
- Question #91
In this SQL statement, what is the partitioning criteria? CREATE TABLE books_part PARTITION BY RANGE (cell_id) ( PARTITION p0l VALUES LESS THAN (2), PARTITION p02 VALUES LESS THAN...
- Question #92
Which four statements about users in Oracle Database 12c are correct?
- Question #93
Which three DBA operations can be performed by using Oracle SQL Developer?
- Question #94
Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared serve...
- Question #95
When executing shutdown abort in a pluggable database (PDB), you ____________.
- Question #96
Which is the default isolation level in Oracle Database 12c?
- Question #97
Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs. Consider these...
- Question #98
Which two statements are true about Oracle Data Pump?
- Question #99
Which two statements correctly distinguish between undo and redo data?
- Question #100
After a ___________ statement is issued, a transaction ends.
- Question #101
Which statement about Storage Snapshot Optimization is correct?