1Z0-497 Exam Questions

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...

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...

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...

Which statement about Online Move Data file is true?

You execute the following command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are correct?

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...

Which two statements about Automatic Data Optimization (ADO) are true?

Which statement about Oracle patches is false?

Which three statements represent the difference between a container database (CDB)and a non- container database?

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...

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...

Which three options correctly match environment variables with their specific functionality?

Identify the correct order of consolidation density, from worst to best.

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?

Which two statements about switchover and failover are true?

Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

Which statement about a server parameter file (SPFILE) is false?

Which statement about the Queryable Patch inventory feature is false?

Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.

Which three statements are true regarding database recovery operations? (Choose three.)

Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQLAccess Advisor? (Choose two.)

Which two options describe the features of simple views? (Choose two.)

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...

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?

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...

Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?

For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?

Which two statements about multi section backup are true?

Which tablespace contains the data dictionary, being automatically created at database creation?

Which three tasks can you perform in Database Express?

Which two statements are true about the B-tree Index?

Which two statements are true about listeners?

You want to start a global service on your database. Which three conditions must be met?

What must you do to an application for it to take advantage of partitioning?

Which three statements about common and local roles are true?

Which statement regarding Oracle Active Data Guard 12c is false?

Examine the command: sqlplus /nolog In which scenario would this command execute successfully?

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...

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...

Which four statements about users in Oracle Database 12c are correct?

Which three DBA operations can be performed by using Oracle SQL Developer?

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...

When executing shutdown abort in a pluggable database (PDB), you ____________.

Which is the default isolation level in Oracle Database 12c?

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...

Which two statements are true about Oracle Data Pump?

Which two statements correctly distinguish between undo and redo data?

After a ___________ statement is issued, a transaction ends.

Which statement about Storage Snapshot Optimization is correct?