CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle 1z0-497 Dumps

Page: 1 / 6
Total 150 questions
Get 1z0-497 Full Access Download 1z0-497 PDF

Oracle Database 12c Essentials Questions and Answers

Question 1

Which three statements about replication options are true?

Options:

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.

Question 2

Which two statements about switchover and failover are true?

Options:

A.

A snapshot standby can be the target of a switchover or fast-start failover operation.

B.

Neither a switchover nor a failover is possible to a far sync instance.

C.

For fast-start failover, you must preselect the target standby database that will be used.

D.

You can activate a standby database to test whether it is being updated correctly.

Question 3

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 (3) ,

. . .

PARTITION pl4 VALUES LESS THAN (15),

PARTITION pl5 VALUES LESS THAN (16),

PARTITION pl6 VALUES LESS THAN (MAXVALUE)

)

AS SELECT * FROM books;

Options:

A.

books

B.

pxx

C.

MAXVALUE

D.

cell_id

E.

There is no partitioning criteria.

Question 4

Which tool is recommended for moving a PDB to a non-CDB?

Options:

A.

RMAN

B.

Cold Backup

C.

Traditional Export / Import

D.

Data Pump

E.

SQL*Plus

Question 5

You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

Options:

A.

You can drop the PDB only if it is closed.

B.

You can drop the seed PDB, but you cannot create any other PDB within the CDB.

C.

You can drop the PDB and keep the data files to be reused by another PDB.

D.

When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.

Question 6

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 servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?

Options:

A.

615 MB

B.

2.5 GB

C.

4 GB

D.

12 GB

E.

22 GB

Question 7

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

Question 8

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?

Options:

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

Question 9

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

Options:

A.

a solution that provides zero-data-loss protection at any distance without impacting database performance

B.

a solution for disaster protection and database rolling upgrades for a mission-critical OLTP database, where you also want to extract data from a data guard primary database for ETL update o' an enterprise data warehouse

C.

a solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrations

D.

a solution that helps with integrated automatic database and client failover between source and target, where you also need to establish advanced replication (such as multi master and bidirectional replication and data transformations)

Question 10

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

Options:

A.

ADO policies can automatically compress data when it qualifies.

B.

ADO policies can automatically move segments when necessary.

C.

ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

D.

You cannot compress at block level, but you can compress at segment level.

E.

You can compress at row level only for QUERY LOW.

Question 11

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

Options:

A.

These administrative privileges enable you to connect to the database only if the database is open.

B.

After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

C.

These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

D.

Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

Question 12

Which command do you use to create a local role while you are connected as the local user?

Options:

A.

create local role l_hr;

B.

create role c##_hr container=current;

C.

create role l_hr container=current;

D.

create role l_hr container=all;

Question 13

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.

Question 14

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 need point-in-time recovery of their PDBs. Which statement is true?

Options:

A.

Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.

B.

Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.

C.

Mike and Tim do not need to worry, because recovery of individual PDBs is possible.

D.

Recovery of individual PDBs is not possible at all.

Question 15

Which three tasks can you perform in Database Express?

Options:

A.

View performance and status information about the database instance.

B.

Start up the database.

C.

Shut down the database.

D.

Create database structures.

E.

Manage users and security.

Question 16

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?

Options:

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

Question 17

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

Options:

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

Question 18

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.

Question 19

Which two statements about PDBs and CDBs are true?

Options:

A.

There is only one SYSTEM tablespace per CDB.

B.

There is only one instance per PDB.

C.

There is a set of redo log files per PDB.

D.

There is only one UNDO tablespace per CDB.

E.

There is one SYSAUXtablespace per PDB.

Question 20

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.

Question 21

Which two statements represent where Oracle Net must reside?

Options:

A.

Only on the client for traditional client/server applications

B.

Only on the database server for web-based applications

C.

On both the web server and database server for web-based applications

D.

On both the client and database server for traditional client/server applications.

Question 22

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?

a - Shut down the database.

b - Restart the database.

c - Copy an existing control file to a new location by using operating system commands.

d - Edit the CONTROL_FILESparameter in the database initialization parameter file to add the new control file name, or to change the existingcontrol file name.

Options:

A.

b, c, d

B.

a, c, d, b

C.

a, d, b, c

D.

c, d, b

Page: 1 / 6
Total 150 questions
Get 1z0-497 Full Access Download 1z0-497 PDF