Online Access Free 1z0-497 Exam Questions

As part of your Oracle Database 12c post-installation tasks, you run these commands:
Cd $ORACLE_HOME/bin
srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?

• A.It generates Client Static Library.
• B.It configures one of the Oracle user accounts.
• C.It creates the Fast Recovery Area disk group.
• D.It configures Oracle Net Services.
• E.It configures Oracle Messaging Gateway.
• F.It enables the Oracle Data Mining option in your Oracle binary files.

For which database operation do you need the database to be in MOUNT state?

• A.dropping a tablespace in your database
• B.dropping a user in your database
• C.re-creating the control files
• D.configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode
• E.renaming the control files

Which two statements correctly distinguish between undo and redo data?

• A.Redo reverses a change, whereas undo re-creates a change.
• B.Undo protects against inconsistent reads, whereas redo protects against data loss.
• C.Redo protects against inconsistent reads, whereas undo protects against data loss.
• D.Undo reverses a change, whereas redo re-creates a change.

You went to create a new CDB foe your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB?

• A.The seed pluggable database can be dropped.
• B.You have to copy the seed data files yourself,
• C.The seed pluggable database is always kept in READ ONLY mode.
• D.The seed pluggable database is not required.
• E.The seed pluggable database does not require data files.
• F.You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.
• G.The seed pluggable database is not a container.

Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?

• A.It recommends solutions and quantifies expected benefits.
• B.It analyzes the performance of specified objects.
• C.It retains snapshots in the SYSAUX tablespace until the database is restarted.
• D.It implements all recommendations automatically.
• E.It requires the database to be open.
• F.It analyzes the snapshots stored in the Automatic Workload Repository (AWR).