Oracle Database 12c Essentials (1z0-497) Free Practice Test

Question 1

When you start up a CDB, which operations are performed automatically and in what order?
a - The instance is started.
b - Control files are opened.
c - The root container is opened (redo logs and root data files).
d - Seed pluggable database is in READ ONLY mode.
e - Other PDBs are still in MOUNTED mode.
f - Triggers may fire if they exist to open other PDBs.

A. a, b, c, d, e, f

B. a, b, c, d

C. c, b, a, d, f, e

D. b, c, a, d, e, f

E. b, c, a, d

Correct Answer: B

Question 2

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. Oracle Cloud Platform as a Service

B. Oracle GoldenGate

C. Active Data Guard

D. Oracle Real Application Clusters

E. Oracle Transportable Tablespaces

Correct Answer: B

Question 3

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

A. S sqlplus / as sysdba SQL> startup open recover;

B. S sqlplus / as sysdba SQL> startup immediate;

C. S sqlplus / as sysdba SQL> restart;

D. S rman target / RMAN> Startup

E. S srvctl start database -db SORACLE_SID

Correct Answer: A,D,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?

A. Active sessions were more than 10% of total load and CPU utilization was more than 50%.

B. Memory allocations were more than 95% of physical memory.

C. A deadlock was detected.

D. The average active sessions were more than three times the number of CPU cores.

E. Hung sessions were more than 10% of total sessions.

F. The session limit was close to 100%.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Examine the table: Table name: PRODUCTS
Schema: SCOTT
Tablespace: USERS
Organization: Standard (Heap Organized)
This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

A. PROD_ID can be changed from CHAR to NUMBER data type.

B. New columns can be added only if they have a NOT NULL constraint.

C. PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).

D. None of the existing columns can be dropped because they contain data.

E. PROD_NAME size can be increased from five to 10 characters.

Correct Answer: C,E

Question 6

Which three statements about replication options are true?

A. Oracle Database Advanced Queuing is independent of Oracle Streams.

B. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

C. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

D. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

E. Oracle Streams is deprecated in Oracle Database 12c Release 1.

Correct Answer: A,D,E

Question 7

Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

A. control_files

B. instance_name

C. db_name

D. maxdatafiles

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

Examine the statements:
SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;
SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )
PARTITION BY RANGE(id) (
partition pi values loss than (100000) tablespacemytbs storage (initial lm),
partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m)
);
When inserting data, you get the error:
ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS
Which three operations would allow you to insert data without getting the error message?

A. Add a data file:
SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

B. Extend the logical volume by 10 MB where the data files are stored;
# lvextend -L+10M /diskl

C. Move a partition to another tablespace:
SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE
10M;
SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;

D. Resize the existing data file:
SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M;
E) Remove a data file:
SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';

Correct Answer: A,C,D

Question 9

Which two are client-side components of Oracle Data Guard Broker?

A. Oracle Enterprise Manager Cloud Control

B. Oracle Data Guard Broker Manager

C. Oracle Data Guard command-line interface (DGMGRL)

D. Oracle Data Guard monitor

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Database 12c Essentials (1z0-497) Free Practice Test