Which four items exist in the root of a CDB, but not in the PDBs?
A, B, C, D
None
Which database feature can be used for organizing data when there is a very large amount of data?
B
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT999 (see very large
databases)
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?
BC
Explanation:
http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c-1896127.pdf
In Oracle Database 12c, when does a transaction begin?
D
Explanation:
https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038
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?
B
None
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)))
D
Explanation:
https://docs.oracle.com/database/121/GSMUG/globser.htm#GSMUG650
Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.
A, D, F
None
Which three statements about replication options are true?
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
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?
C
Explanation:
Without issue of commit by the HR user, the other users are unable to see the changes even though
they have access.
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?
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';
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?
BD
Explanation:
https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11052
Which three background processes are mandatory in a database Instance started with a minimally
configured Initialization parameter file?
D, E, F
Explanation:
Reference:
Oracle Database Concepts 12c, Mandatory Background Processes
http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT008
Which three events signal a database writer (DWR) to write buffers to disk?
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.
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
Explanation:
https://docs.oracle.com/database/121/GSMUG/trouble.htm#GSMUG706
Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?
D
None