1. Home
  2. Oracle
  3. Oracle Database 12c Certified Implementation Specialist
  4. 1z0-497
  5. Oracle Database 12c Essentials Questions and Answers

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

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 5 pages
Viewing questions 1-10 out of questions
Questions # 1:

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

Options:
A.

S sqlplus / as sysdba

SQL> restart;

B.

S sqlplus / as sysdba

SQL> startup immediate;

C.

S rman target /

RMAN> Startup

D.

S sqlplus / as sysdba

SQL> startup open recover;

E.

S srvctl start database -db SORACLE_SID

Questions # 2:

Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

Options:
A.

Asynchronous redo transport with Data Guard

B.

Synchronous redo transport with Data Guard

C.

Active Data Guard Far Sync

D.

Data Guard SQL Apply

Questions # 3:

Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

Options:
A.

Oracle Database alert.log file

B.

object-level statistics

C.

Automatic SGA Memory Management

D.

Oracle Database Trace files

E.

all server-generated alerts

Questions # 4:

Which statement about Storage Snapshot Optimization is correct?

Options:
A.

It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.

B.

It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

C.

It enables you to use RMAN to take a storage snapshot of your database. The database doesn't have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

D.

It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

Questions # 5:

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.

Questions # 6:

Which type of information is included in dynamic performance views?

1 - System and session parameters

2 - Memory usage and allocation

3 - File states (including RMAN backup files)

4 - Progress of jobs and tasks

5 - SQL execution

6 - Statistics and metrics

Options:
A.

3, 4, and 5

B.

1, 2, 5, and 6

C.

1, 2, 3, and 4

D.

2, 3, 5, and 6

E.

2, 3, 4, 5, and 6

F.

1, 2, 3, 4, 5, and 6

Questions # 7:

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:
A.

They can perform only queries.

B.

They are not affected and continue to function normally.

C.

They are terminated and the active transactions are rolled back.

D.

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

Questions # 8:

Which two statements are true regarding SQL*Plus?

Options:
A.

It has commands for performing database administration operations.

B.

It can be used in interactive but not batch mode for SQL commands.

C.

It has to be installed separately after the Oracle Database 12c installation.

D.

Operating system commands can be executed from the SQL*Plus command prompt.

Questions # 9:

Examine the command:

sqlplus /nolog

In which scenario would this command execute successfully?

Options:
A.

only from the server, if the database instance is not up

B.

from either a client or server, even if the database instance is not up

C.

from either a client or server, only if the database instance is up, and the command connects the session to the instance

D.

from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

Questions # 10:

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?

Options:
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.

Viewing page 1 out of 5 pages
Viewing questions 1-10 out of questions