oracle 1z0-497 practice test

Oracle Database 12c Essentials Exam

Last exam update: Sep 29 ,2024
Page 1 out of 10. Viewing questions 1-15 out of 150

Question 1

Which four items exist in the root of a CDB, but not in the PDBs?

  • A. shared UNDO and default database temporary tablespace
  • B. Oracle-supplied metadata
  • C. shared Oracle-supplied data
  • D. CDB views providing information across PDBs
  • E. application tablespaces
  • F. local temporary tablespaces
  • G. local users and local roles
  • H. non-shared local metadata
Answer:

A, B, C, D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%
H
50%
Discussions
vote your answer:
A
B
C
D
E
F
G
H
0 / 1000

Question 2

Which database feature can be used for organizing data when there is a very large amount of data?

  • A. Index
  • B. Partitioning
  • C. Triggers
  • D. Row-level security
  • E. Database vault
Answer:

B


Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT999 (see very large
databases)

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 3

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?

  • 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
Answer:

BC


Explanation:
http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c-1896127.pdf

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

In Oracle Database 12c, when does a transaction begin?

  • A. when a transaction ID is allocated for it.
  • B. when a user explicitly issues a "begin" statement
  • C. when a transaction is assigned to an available undo data segment to record undo entries for the new transaction
  • D. when the first executable SQL statement is encountered
Answer:

D


Explanation:
https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

You connect to a database instance and execute a DML command that changes one data block. The
block is read from the buffer cache, modified, and modified, and marked as dirty. You commit the
transaction. What must take place before the block can be written to disk?

  • A. The buffer must be written to flash cache.
  • B. A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.
  • C. The modified data block must be moved from the LRU list to the write queue.
  • D. The database must advance the checkpoint.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

Which statement is true regarding this connect string?
(DESCRIPTION
(FAILOVER=on)
(ADDRESS_LIST=
(LOAD_BALANCE=ON)
(ADDRESS=(host=sales-east1) (port=1522) )
(ADDRESS=(host=sales-east2)(port=1522))
(ADDRESS=(host=sales-east3) (port=1522) ))
(ADDRESS_LIST=
(LOAD_BALANCE=ON)
(ADDRESS=(host=sales-west1) (port=1522) )
(ADDRESS=(host=sales-west2) (port=JS22))
(ADDRESS=(host=sales-west3) (port=lS22) ) )
(CONNECT_DATA=
(SERVICE_NAME=sales)
(REGION=east)))

  • A. It contains three global service managers in the client's local region (east).
  • B. Client-side load balancing has been enabled only for the global service managers within the client's buddy (west).
  • C. Connect-time failover between regions has not been enabled.
  • D. The REGION parameter is optional.
Answer:

D


Explanation:
https://docs.oracle.com/database/121/GSMUG/globser.htm#GSMUG650

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

  • A. less instance overhead
  • B. increased storage cost
  • C. minor application changes
  • D. fast and easy provisioning
  • E. same time needed for patching and upgrade as in the previous release
  • F. isolation
Answer:

A, D, F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 8

Which three statements about replication options are true?

  • A. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.
  • B. Oracle Streams is deprecated in Oracle Database 12c Release 1.
  • C. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.
  • D. Oracle Database Advanced Queuing is independent of Oracle Streams.
  • E. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.
Answer:

B, C, E


Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e10705/prep_rep.htm#STREP220
http://www.oracle.com/technetwork/database/multitenant/overview/index.html
https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60159
http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-
2030490.pdf

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 9

All database users are currently connected to the database instance and are working. The HR user
opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option
represents the sessions that can see the effect of the UPDATE and DELETE commands?

  • A. all sessions of the HR user
  • B. all sessions of the HR user and the SYS user
  • C. the session of the HR user that executed the commands
  • D. all sessions for which database users have access privileges to the PERSONS table
Answer:

C


Explanation:
Without issue of commit by the HR user, the other users are unable to see the changes even though
they have access.

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

Examine the output:
SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE;
INDEX_NAME STATUS
--------------------- -----------------
EIND UNUSABLE
Which two statements about this index are true?

  • A. It is ignored by the query optimizer.
  • B. It is not used while the index is being rebuilt.
  • C. The index cannot be rebuilt, and has to be re-created.
  • D. The index is automatically rebuilt when used the next time.
Answer:

AB


Explanation:
* Oracle indexes can go into a UNUSABLE state after maintenance operation on the table or if the
index is marked as 'unusable' with an ALTER INDEX command. A direct path load against a table or
partition will also leave its indexes unusable.
Queries and other operations agains a table with unuable indexes will generate errors:
ORA-01502: index string.string or partition of such index is in unusable state
* The following SQL will print out a list of alter commands that can be executed to fix unusable
indexes:
Indexes:
SELECT 'alter index '||index_name||' rebuild tablespace '||tablespace_name ||';'
FROM dba_indexes
WHERE status = 'UNUSABLE';

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11

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?

  • 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.
Answer:

BD


Explanation:
https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11052

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

Which three background processes are mandatory in a database Instance started with a minimally
configured Initialization parameter file?

  • A. Process Monitor Process (PMON)
  • B. Flashback Data Archive process (FBDA)
  • C. Space Management Coordinator process (SMCO)
  • D. Recoverer process (RECO)
  • E. Listener Registration process (LREG)
  • F. Checkpoint Process
Answer:

D, E, F


Explanation:
Reference:
Oracle Database Concepts 12c, Mandatory Background Processes
http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT008

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 13

Which three events signal a database writer (DWR) to write buffers to disk?

  • A. The database advances a checkpoint.
  • B. A client process commits a transaction.
  • C. The redo log buffer becomes full.
  • D. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.
  • E. A tablespace is changed to read-only status.
  • F. The database is shut down in immediate mode.
Answer:

ADF


Explanation:
When tablespace is changed to read only status it will issue a Partial checkpoint. During db shutdown
a checkpoint is also issued. DWR writes when there is a checkpoint.

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 14

Examine the error:
GSM-45054: GSM error or NET-40006: unable to start GSH
What is the cause of this error, and what troubleshooting steps should you perform?

  • A. The GDS catalog database of its listener may be down. Verify that the GDS catalog database and its local listener are running.
  • B. The GDS pool database may be down. Make sure that the GDS pool databases are up and the service is enabled and started.
  • C. The GDS pool database's local listener may be down. Make sure that it is running.
  • D. The global service may be down. Verify that the pool databases are up and the service is started.
  • E. The global service may be disabled. Make sure that the pool databases are up and the service is enabled and started.
Answer:

A


Explanation:
https://docs.oracle.com/database/121/GSMUG/trouble.htm#GSMUG706

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 15

Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?

  • A. The analyzed result is lost when the database instance is restarted.
  • B. It runs every 1 hour automatically.
  • C. It is shipped only with Oracle Enterprise Manager 12c.
  • D. It analyzes high CPU trend and identifies problems before they can threaten application performance.
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2