Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
Oracle Database 12c Certified Implementation Specialist
1z0-497
Oracle Database 12c Essentials Questions and Answers

Pass the Oracle Database 12c Certified Implementation Specialist 1z0-497 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-497 Premium Access

View all detail and faqs for the 1z0-497 exam

Go to Exam

666 Students Passed

85% Average Score

98% Same Questions

Viewing page 2 out of 5 pages

Viewing questions 11-20 out of questions

Questions # 11:

After a ___________ statement is issued, a transaction ends. (select three)

Options:

COMMIT

ROLLBACK

SAVEPOINT

SELECT

CREATE

Answer

A, B, E

Explanation

A transaction ends when any of the following actions occurs:

* (AB) A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.

* (E) A user runs a DDL command such as CREATE, DROP, RENAME, or ALTER.

Etc.

[Reference: Oracle Database Concepts, 12c, End of a Transaction, ]

Questions # 12:

Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?

Options:

The DML operations re-create the bitmap index blocks.

The bitmap index is rebuilt automatically after a DML operation.

The smallest amount of a bitmap that can be locked is a bitmap segment.

Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

Answer

Explanation

Bitmap indexes in currently “supported” versions of Oracle are maintained in a much more efficient manner than they were previously, to the point where the need for frequently rebuilds has been much reduced, even in tables in which such indexes are not dropped during heavy loads.

That said, Bitmap indexes are still unsuitable in OLTP type environments (even in 11g or later) due to the locking implications associated with them.

Note: bitmap indexes are only suitable for static tables and materialized views which are updated at nigh and rebuilt after batch row loading.

Not B: Like b-tree indexes, bitmap indexes should be rebuilt (ALTER INDEX . . . REBUILD) if there is a lot of DML (UPDATE, INSERT, DELETE) activity.

Not A: Since 10g, Oracle is significantly more efficient and where possible will simply adjust the current rowid range of the Bitmap index entry and modify the bitmap string accordingly to accommodate a new row value (resulting in an overall increase of just 2 bytes overall in this example) rather than create a totally new index entry (which required an additional 21 bytes in the 9i example).

Questions # 13:

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

Options:

You can drop the PDB only if it is closed.

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

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

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

Answer

A, C

Explanation

https://docs.oracle.com/database/121/SQLRF/statements_8028.htm#SQLRF55699

Questions # 14:

Which process is responsible for writing the contents of database buffers to data files?

Options:

Process Monitor process (PMON)

Listener Registration process (LREG)

System Monitor process (SMON)

Database Writer process (DBW)

Log Writer process (LGWR)

Checkpoint process (CKPT)

Answer

Explanation

[Reference: http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#CNCPT1254 (see database writer process (DBW))]

Questions # 15:

There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:

lsnrctl start listener2

What would be the outcome?

Options:

It starts the second listener without affecting current sessions.

It starts the second listener and terminates all current sessions.

It gives an error because multiple listeners cannot run simultaneously.

It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

Answer

Explanation

[Reference: https://blogs.oracle.com/rtsai/entry/how_to_configure_multiple_oracle, , ]

Questions # 16:

Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

Options:

the CDB as the ROOT user

the CDB as the CDBADMIN user

the PDB as the ROOT user

the PDB as the PDB Admin user

Answer

Explanation

https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV81511

Questions # 17:

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?

Options:

The instance is started.

The CDB control files are opened for the instance.

The root is mounted.

The root is opened.

The PDBs are mounted.

The PDBs are mounted, and the seed is opened in READ ONLY mode.

The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

Answer

A, B, C, E

Questions # 18:

Which two statements correctly distinguish between undo and redo data?

Options:

Undo reverses a change, whereas redo re-creates a change.

Redo reverses a change, whereas undo re-creates a change.

Undo protects against inconsistent reads, whereas redo protects against data loss.

Redo protects against inconsistent reads, whereas undo protects against data loss.

Answer

A, C

Questions # 19:

Your database is open and the listener is running. The DBA stops the listener by using the command:

LSNRCTL> STOP

What happens to the sessions that are currently connected to the database instance?

Options:

They can perform only queries.

They are not affected and continue to function normally.

They are terminated and the active transactions are rolled back.

They are not allowed to perform any operations till the listener is started.

Answer

Questions # 20:

Which two statements are true when you execute an invoker's rights procedure?

Options:

The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.

Invoking users can control who can access their privileges when they run an invoker's rights procedure.

The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

Answer

A, B

Explanation

[Reference: http://docs.oracle.com/cd/E16655_01/network.121/e17607/dr_ir.htm#DBSEG661, , ]

Viewing page 2 out of 5 pages

Viewing questions 11-20 out of questions

Modal title

Registered Required

In order to participate in the comments you need to be logged-in.
You can sign-up or login (it's free).

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25

ADM-201

Agentforce-Specialist

CMMC-CCP

Data-Cloud-Consultant

PDI

PSE-Strata-Pro-24

Secure-Software-Design

Sharing-and-Visibility-Architect

Workday-Pro-Integrations

ZDTA