SZ-082-1/3

LSNRCTL> start LISTENER_1

Listening Endpoints Summary…

(DESCRITION=(ADDRESS=(PROTOCOL=tcp)(HOST=host01.abc.com )(PORT=1562)))

Service Summary…

Service " DB01.abc.com " has 1 instance(s).

Instance " DB01 ", status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully

Why does the DB01.abc.com service show unknown status?

The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

LISTENER_1 =

        (ADDRESS =

                (PROTOCOL = TCP)

                (HOST = host1.abc.com)

                (PORT = 1521)

        )

Which statement is true?

1，NOT a DBA user

2，An operating system (OS) user

Examine this command and its output:

SHOW PARAMETER OS_AUTHENT_PREFIX；

NAME                           TYPE                     VALUE

----------------------     ----------------     ------------------

Os_authent_prefix        string

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

You want to connect to a database instance whose listener listens on port 1531 by using this statement:

CONNECT HR/HRMGR@orcl

No name server is used.

Which statement is true about ORCL?

$ sqlplus hr/hr@orcl @abc.sql；

What will happen upon execution?

In which three situations does the transaction complete thereby committing the updates?

1，A size of 100 MB

2，AUTOEXTEND is off

3，UNDO_RETENTION is set to 15 minutes

4，It has RETENTION GUARANTEE

UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens

What will happen when the next update is attempted by any transaction?

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?