March Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netbudy65

1z0-497 Oracle Database 12c Essentials Questions and Answers

Questions 4

Exhibit below:

Which three statements are true about terminating a session?

Options:

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.

Buy Now
Questions 5

Examine the output:

SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE’;

INDEX_NAME STATUS

--------------------- -----------------

EIND UNUSABLE

Which two statements about this index are true?

Options:

A.

It is ignored by the query optimizer.

B.

It is not used while the index is being rebuilt.

C.

The index cannot be rebuilt, and has to be re-created.

D.

The index is automatically rebuilt when used the next time.

Buy Now
Questions 6

There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:

lsnrctl start listener2

What would be the outcome?

Options:

A.

It starts the second listener without affecting current sessions.

B.

It starts the second listener and terminates all current sessions.

C.

It gives an error because multiple listeners cannot run simultaneously.

D.

It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

Buy Now
Questions 7

Which statement about Online Move Data file is true?

Options:

A.

Moving a data file online prevents DML operations on segments stored in the data file.

B.

Flashing back a database to a point in time before a data file had been renamed online retains the new name.

C.

Moving a data file online can be performed if the data file is in OFFLINE mode.

D.

Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.

Buy Now
Questions 8

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 request and establishes the appropriate connection?

Options:

A.

listener

B.

user process

C.

service name

D.

server process

Buy Now
Questions 9

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?

Options:

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

Buy Now
Questions 10

Which two statements about this policy are true?

Options:

A.

It replaces the first four digits of the value from the SALARY column with the number 9.

B.

It replaces the first digit of the value from the SALARY column with the number 4.

C.

It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.

D.

It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.

E.

It uses the full data redaction method.

F.

It uses the random redaction method.

Buy Now
Questions 11

Your customer is looking for a solution that meets these four needs:

1 - Replicate data from source to target for reporting purposes.

2 -Replicate data from one source to multiple targets.

3 - Replicate data between two databases for instant failover.

4 - Replicate data from multiple sources to a single target for a data warehouse.

Which GoldenGate-supported topology would you recommended?

Options:

A.

Uni-directional for 1

Peer-to-peer for 2

Bi-directional for 3

Consolidation for 4

B.

Peer-to-peer for 1

Broadcast for 2

Bi-directional for 3

Consolidation for 4

C.

Uni-directional for 1

Broadcast for 2

Bi-directional for 3

Consolidation for 4

D.

Peer-to-peer for 1

Consolidation for 2

Broadcast for 3

Cascading for 4

Buy Now
Questions 12

You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

Options:

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.

Buy Now
Questions 13

Which statement about CDB architecture is true?

Options:

A.

Oracle-supplied metadata resides only in the root container.

B.

A seed PDB can sometimes be opened for particular operations.

C.

Multiple PDBs with the same name can reside in the same CDB.

D.

A CDB can have an infinite number of PDBs.

E.

You can create common users in PDBs.

Buy Now
Questions 14

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;

Options:

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.

Buy Now
Questions 15

Your database is down. You log in as the SYS user and issue this command:

SQL> STARTUP

What happens after the instance is started?

Options:

A.

Nothing else happens.

B.

The database is mounted but not opened.

C.

The database is mounted and finally opened.

D.

The database is opened and finally mounted.

Buy Now
Questions 16

Which three events signal a database writer (DWR) to write buffers to disk?

Options:

A.

The database advances a checkpoint.

B.

A client process commits a transaction.

C.

The redo log buffer becomes full.

D.

A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

E.

A tablespace is changed to read-only status.

F.

The database is shut down in immediate mode.

Buy Now
Questions 17

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

Options:

A.

when upgrading from Oracle Database 12c to the first patch set of Oracle Database 12c

B.

when upgrading from Oracle Database 10g to Oracle Database 12c

C.

when upgrading from Oracle Database 11g to Oracle Database 12c

D.

when upgrading from any previous version of Oracle Database to Oracle Database 12c

Buy Now
Questions 18

Which two statements about ADDM are true?

Options:

A.

Real-Time ADDM uses AWR snapshots of the last 10 minutes.

B.

Real-Time ADDM uses ASH recent activity from SGA data.

C.

Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

D.

Regular ADDM uses AWR snapshots that are not yet purged.

Questions 19

Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?

Options:

A.

select patch from vSoption where opatch_data=' 333333' ;

B.

select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual

C.

select opatch from vSpatchsets where opatch_number = '333333';

D.

opatchlsinventory -xml

Buy Now
Questions 20

Which two statements are true about listeners?

Options:

A.

Listeners use only the TCP/IP protocol.

B.

Multiple listener processes can run simultaneously on a host.

C.

Multiple database instances can be registered with a single listener,

D.

Listener-related errors can be traced only at the administrative level.

E.

Only one database instance can be registered with a single listener at any time.

Questions 21

Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

Options:

A.

db_name

B.

maxdatafiles

C.

control_files

D.

instance_name

Buy Now
Questions 22

Your database is open and the listener is running. The DBA stops the listener by using the command:

LSNRCTL> STOP

What happens to the sessions that are currently connected to the database instance?

Options:

A.

They can perform only queries.

B.

They are not affected and continue to function normally.

C.

They are terminated and the active transactions are rolled back.

D.

They are not allowed to perform any operations till the listener is started.

Buy Now
Exam Code: 1z0-497
Exam Name: Oracle Database 12c Essentials
Last Update: Mar 29, 2024
Questions: 150

PDF + Testing Engine

$140

Testing Engine

$105

PDF (Q&A)

$90