Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE `undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A.Add the SEGMENT SPACE MANAGEMENT AUTO clause
• B.Make certain that the database operates in automatic undo management mode
• C.Set UNDO_TABLESPACE to UNDOTBS01
• D.Add the ONLINE clause
• E.Add the NOLOGGING clause

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A.Set OS_AUTHENT_PREFIX to OPS$
• B.Have the OS administrator add KING to the OSDBA group
• C.Grant DBA to KING
• D.Unset REMOTE_LOGIN_PASSWORDFILE
• E.Alter user KING to be IDENTIFIED EXTERNALLY

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can you perform using DBCA for databases? (Choose two.)

• A.Configure a nonstandard block size for a new database
• B.Register a new database with an available Enterprise Manager Management server
• C.Change the standard block size of an existing database
• D.Configure incremental backups for a new database
• E.Enable flashback database for an existing database

Comment: *

Name: *

Email: *

Verification: *

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

• A.WHERE TO_XUMBER(start_date - SYSDATE) <= 25
• B.WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
• C.WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
• D.WHERE ADD_MONTHS<start_date, 25) <= SYSDATE

Comment: *

Name: *

Email: *

Verification: *

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A.Dynamic service registration cannot be used for this database instance
• B.The LREG process registers services dynamically with the LISTENER_1 listener
• C.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• D.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
• E.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

Comment: *

Name: *

Email: *

Verification: *