Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Oracle 1z0-497 - Oracle Database 12c Essentials

Oracle 1z0-497 Premium Access     Download Demo    
Page: 3 / 5
Total 150 questions

Which three statements about replication options are true?

A.

The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

B.

Oracle Streams is deprecated in Oracle Database 12c Release 1.

C.

Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

D.

Oracle Database Advanced Queuing is independent of Oracle Streams.

E.

The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?

A.

The analyzed result is lost when the database instance is restarted.

B.

It runs every 1 hour automatically.

C.

It is shipped only with Oracle Enterprise Manager 12c.

D.

It analyzes high CPU trend and identifies problems before they can threaten application performance.

All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:

SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';

123 rows updated.

SQL> DELETE FROM persons WHERE exp='Y';

3 rows deleted.

The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?

A.

all sessions of the HR user

B.

all sessions of the HR user and the SYS user

C.

the session of the HR user that executed the commands

D.

all sessions for which database users have access privileges to the PERSONS table

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?

A.

listener

B.

user process

C.

service name

D.

server process

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.

Examine the command:

SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;

Which two statements are true about the execution of the command?

A.

A CHECK constraint is created on the OID column.

B.

A NOT NULL constraint is created on the OID column.

C.

The ORDERS table is the only object created in the USERS tablespace.

D.

The ORDERS table and a unique index are created in the USERS tablespace.

E.

The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

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?

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.

Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?

A.

The average active sessions were more than three times the number of CPU cores.

B.

Active sessions were more than 10% of total load and CPU utilization was more than 50%.

C.

Memory allocations were more than 95% of physical memory.

D.

Hung sessions were more than 10% of total sessions.

E.

A deadlock was detected.

F.

The session limit was close to 100%.

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

You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT's session in this scenario?

A.

The session is terminated after receiving the error and JIM can continue with his transaction.

B.

SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

C.

The session is rolled back after receiving the error and JIM can continue with his transaction.

D.

SCOTT has to re-execute the last command in the transaction after he commits the transaction.

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