Free 1Z0-497 Exam Dumps PDF Preview

Question 1

Multiple choice

Which two statements are true about the B-tree Index?

A
The leaf blocks in the index are doubly linked.
B
The leaf node stores a bitmap for each key value.
C
Rows with a NULL value in key columns also have entries in the Index.
D
The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.

Reveal answer details Close answer details

Correct answersB, D

Explanation

References:
http://www.siue.edu/~dbock/cmis565/module12-indexes.htm

Question 2

Multiple choice

Which three options correctly match environment variables with their specific functionality?

A
ORACLE_SID specifies the instance name.
B
ORACLE_SID specifies the global database name.
C
ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.
D
ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.
E
ORACLE_HOME specifies the directory containing the Oracle software executables and network files.
F
ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.

Reveal answer details Close answer details

Correct answersA, C, E

Question 3

Single choice

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

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

Reveal answer details Close answer details

Correct answerE

Explanation

To enable or disable archiving, the database must be mounted but not open.

Note: See step 5 below.
Changing the Database Archiving Mode

To change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause. To change the archiving mode, you must be connected to the database with administrator privileges (AS SYSDBA).

The following steps switch the database archiving mode from NOARCHIVELOG to ARCHIVELOG:

1. Shut down the database instance

2. Back up the database.
3. Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files 4. Start a new instance and mount, but do not open, the database.

STARTUP MOUNT
To enable or disable archiving, the database must be mounted but not open.

5. Change the database archiving mode. Then open the database for normal operations.
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;

6. Shut down the database.
SHUTDOWN IMMEDIATE

7. Back up the database.

Question 4

Multiple choice

Which two statements are true about this common user?

A
SQL> conn c##usr/pwd@pdb1
You are connected to PDB1 successfully.
B
SQL> conn c##usr/pwd@pdb2
You are connected to PDB2 successfully.
C
SQL> conn c##usr/pwd@pdb2
You are unable to create a connection. You first need to sync PDB2 by executing:
SQL> conn / as sysdba
SQL>exec DBMS_PDB.SYNC_PDB;
D
SQL> conn c##usr/pwd@pdb2
You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing:
SQL>conn system/pwd@pdb2
SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT; Now you are able to
connect as common user c##usr to PDB2.

Reveal answer details Close answer details

Correct answersA, D

Question 5

Single choice

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

A
RMAN
B
Cold Backup
C
Traditional Export / Import
D
Data Pump
E
SQL*Plus

Reveal answer details Close answer details

Correct answerE

Explanation

Creating a PDB by Plugging an Unplugged PDB into a CDB

An unplugged PDB consists of an XML file that describes the PDB and the PDB's files (such as the data files and wallet file). You can use the CREATE PLUGGABLE DATABASE statement to plug in an unplugged PDB. To do so, you must include a USING clause that specifies the XML file that describes the
PDB.

The source CDB is the CDB from which the PDB was unplugged. The target CDB is the CDB into which you are plugging the PDB. The source CDB and target CDB can be the same CDB or different CDBs.

Question 6

Multiple choice

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.

Reveal answer details Close answer details

Correct answersA, D

Question 7

Single choice

When executing shutdown abort in a pluggable database (PDB), you ____________.

A
shut down abort the CDB
B
shut down abort the PDB
C
shut down immediate the PDB
D
shut down immediate the CDB

Reveal answer details Close answer details

Correct answerB

Question 8

Multiple choice

Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd).

Which two options would accomplish this?

A
You copy all the PDBSSEEDdata files from the production CDB into the development CDB and
execute this on the development CDB;
SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;
B
You alter the salesprd source database to open in read-only mode, and start cloning the source database:
SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY; SQL> CREATE PLUGGABLE
DATABASE salesdev FROM salesprd;
C
You alter the salesprd source database to open in read-only mode:
SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY; In the development CDB, you
create a databaselink "PRD" that connects to the root of the source CDB, and start cloning the source
PDB:
SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;
D
Connected as the salesprd local DBA, you create an XML using:
SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ; Copy the XML
file and all salesprd-related files to the target CDB and start plugging the copy into the development
CDB using:
SQL> CREATE PLUGGABLE DATABASE salesdev USING' /tmp/salesprd.xml';

Reveal answer details Close answer details

Correct answersA, D

Explanation

A: Creating a PDB Using the Seed
You can use the CREATE PLUGGABLE DATABASE statement to create a PDB in a CDB using the files of the seed.

D: Plugging In an Unplugged PDB
To plug in an unplugged PDB, the following prerequisites must be met:
* Complete the prerequisites described in "Preparing for PDBs".
* The XML file that describes the PDB must exist in a location that is accessible to the CDB.
The USING clause must specify the XML file.
Etc

Question 9

Single choice

Which is the default port number for Database Express?

A
7801
B
5500
C
2243
D
1521
E
22

Reveal answer details Close answer details

Correct answerD

Explanation

References:
http://docs.oracle.com/cd/B25329_01/doc/install.102/b25143.pdf
(page 4, first bulleted point)

Question 10

Multiple choice

Identify three key properties of a transaction in Oracle Database 12c.

A
durability
B
consistency
C
concurrency
D
isolation
E
scalability
F
manageability

Reveal answer details Close answer details

Correct answersA, B, D

Explanation

References:
http://docs.oracle.com/cd/E16655_01/server.121/e17633/transact.htm#CNCPT016

Question 11

Single choice

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.

Reveal answer details Close answer details

Correct answerB

Question 12

Single choice

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

Reveal answer details Close answer details

Correct answerA

Explanation

References:
http://docs.oracle.com/cd/E11882_01/network.112/e41945/trouble.htm#NETAG394

Question 13

Multiple choice

Which three statements are true about database storage structures?

A
A data file can span across tablespaces.
B
An extent contains one or more segments.
C
Tablespaces contain one or more data files.
D
Data objects are stored as segments in tablespaces.
E
Segments can span across data files within a tablespace.

Reveal answer details Close answer details

Correct answersC, D, E

Explanation

Not B: Segments contain extents.

Question 14

Single choice

Which statement about a server parameter file (SPFILE) is false?

A
An SPFILE is a binary file that cannot be edited by using a text editor.
B
You can create an SPFILE from an existing text initialization parameter file or from memory.
C
You can use the SHOW PARAMETERS command to display the values of initialization parameters in
an SPFILE.
D
The instance first searches for an SPFILE named spfileoRACLE_SID.ora and, if this is not found. It searches for spfile.ora.

Reveal answer details Close answer details

Correct answerD

Explanation

Not A, not B: SPFILE is a text file that can be created from a file or from scratch.
Not C: This shows database was started by spfile

SQL> show parameter spfile;

NAME TYPE VALUE
---- ---- ---------------------------------------------------------- spfile string /root/apps/oracle/10g/dbs/ spfile<DB_NAME>.ora No values returned means its started by pfile.

Question 15

Multiple choice

Examine the commands:
SQL> CONNECT sys@CDBl AS SYSDBA
$QL>STARTUP MOUNT
SQL> ALTER DATABASE cdbl MOUNT;

Which four options represent what happens when these commands are executed?

A
The instance is started.
B
The CDB control files are opened for the instance.
C
The root is mounted.
D
The root is opened.
E
The PDBs are mounted.
F
The PDBs are mounted, and the seed is opened in READ ONLY mode.
G
The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

Reveal answer details Close answer details

Correct answersA, B, C, F

Question 16

Single choice

Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?

A
Automatic Storage Management (ASM)
B
OS file system
C
logical volume (LVM)
D
clustered file system
E
RAW

Reveal answer details Close answer details

Correct answerE

Question 17

Single choice

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

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

Reveal answer details Close answer details

Correct answerA

Explanation

You will be able to use this feature to perform database version upgrades starting with the first patchset of Oracle Database 12c (that is, you cannot use it to upgrade from any version earlier than the first Oracle Database 12c patchset). This means that the manual Transient Logical Standby upgrade procedure must still be used when upgrading from Oracle Database 11g to Oracle Database12c, or when upgrading from the initial Oracle Database 12c release to the first patchset of Oracle Database 12c.

References:
Oracle Data Guard Concepts and Administration, 12c, Using DBMS_ROLLING to Perform a
Rolling Upgrade

Question 18

Multiple choice

Which two statements describe data dictionary views?

A
They are stored in the SYSTEM tablespace.
B
They are based on virtual tables.
C
They are owned by the SYS user.
D
They speed up query and data manipulation language (DML) operations.
E
The VSFIXED_TABLEview can be queried to list the names of these views.

Reveal answer details Close answer details

Correct answersD, E

Question 19

Single choice

Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle Database 12con Solaris, and is concerned about the downtime.

Which Oracle solution would you recommend?

A
Active Data Guard
B
Oracle GoldenGate
C
Oracle Real Application Clusters
D
Oracle Transportable Tablespaces
E
Oracle Cloud Platform as a Service

Reveal answer details Close answer details

Correct answerA

Question 20

Single choice

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;

A
books
B
pxx
C
MAXVALUE
D
cell_id
E
There is no partitioning criteria.

Reveal answer details Close answer details

Correct answerD

Question 21

Single choice

Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault.

Which product should your customer use?

A
Oracle Data Guard
B
Oracle Streams
C
Oracle Real Application Clusters
D
Oracle GoldenGate

Reveal answer details Close answer details

Correct answerC

Explanation

References:
http://www.oracle.com/technetwork/database/availability/maximum-availability-wp-
12c- 1896116. pdf (page 5, Server HA: Oracle Real Application Clusters)

Question 22

Multiple choice

Which two statements about switchover and failover are true?

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.

Reveal answer details Close answer details

Correct answersB, C

Explanation

References:
http://docs.oracle.com/cd/E16655_01/server.121/e17641/sofo.htm#DGBKR3404
http://docs.oracle.com/cd/E11882_01/server.112/e17023/sofo.htm#DGBKR3310

Question 23

Multiple choice

Which two statements represent where Oracle Net must reside?

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.

Reveal answer details Close answer details

Correct answersB, D

Free 1Z0-497 Exam Dumps Preview

Oracle Database 12c Essentials

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

QUESTION 18

QUESTION 19

QUESTION 20

QUESTION 21

QUESTION 22

QUESTION 23

VOL	TYPE	QUESTIONS
1	Single choice	12
2	Multiple choice	11