Free Oracle 1Z0-497 Exam Actual Questions

The questions for 1Z0-497 were last updated On Nov 20, 2024

Question No. 1

Identify the correct order of consolidation density.

Show Answer Hide Answer
Correct Answer: D

Question No. 2

What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

Show Answer Hide Answer
Correct Answer: D

http://docs.oracle.com/cd/E16655_01/backup.121/e17631/release_changes.htm#RCMRF90521 (sys backup privilege)

Question No. 3

A DBA informs you that an Oracle instance has started. What does this imply?

Show Answer Hide Answer
Correct Answer: D

Question No. 4

YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

Show Answer Hide Answer
Correct Answer: C, D, E

The following command starts an instance, reads the initialization parameters from the default location, and then mounts and opens the database. (You can optionally specify a PFILE clause.)

STARTUP

If you know that media recovery is required, you can start an instance, mount a database to the instance, and have the recovery process automatically start by using the STARTUP command with the RECOVER clause:

STARTUP OPEN RECOVER

To start or stop your entire cluster database, that is, all of the instances and its enabled services, enter the following SRVCTL commands:

$ srvctl start database -db db_unique_name [-startoption start_options]


Question No. 5

Which statement about the Oracle Advanced Security Data Redaction feature is true?

Show Answer Hide Answer
Correct Answer: E

Redacting Sensitive Data for Display

Data Redaction provides selective, on-the-fly redaction of sensitive data in query results prior

to display by applications so that unauthorized users cannot view the sensitive data. It enables

consistent redaction of database columns across application modules accessing the same data.

Data Redaction minimizes changes to applications because it does not alter actual data in

internal database buffers, caches, or storage, and it preserves the original data type and

formatting when transformed data is returned to the application. Data Redaction has no

impact on database operational activities such as backup and restore, upgrade and patch, and

high availability clusters.


Oracle Advanced Security, 12c, Oracle Data Sheet