Examine this command and some partial output:

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

• A.The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
• B.The listener is not listening on the default port 1521
• C.The service DB01.abc.com is dynamically registered
• D.The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
• E.The service DB01.abc.com is statically registered

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about views in an Oracle database? (Choose three.)

• A.The WITH CHECK clause prevents certain rows from being updated or inserted
• B.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• C.Views can be updated without the need to re-grant privileges on the view
• D.The WITH CHECK clause prevents certain rows from being displayed when querying the view
• E.Data Manipulation Language (DML) can always be used on views
• F.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• G.Tables in the defining query of a view must always exist in order to create the view

Comment: *

Name: *

Email: *

Verification: *

Examine this command:

Which two statements are true? (Choose two.)

• A.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• B.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• C.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• D.The file is renamed and stored in the same location
• E.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

Comment: *

Name: *

Email: *

Verification: *

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• B.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• C.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• D.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• E.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the PMON background process? (Choose two.)

• A.It registers database services with all local and remote listeners known to the database instance
• B.It frees resources held by abnormally terminated processes
• C.It records checkpoint information in the control file
• D.It frees unused temporary segments
• E.It kills sessions that exceed idle time

Comment: *

Name: *

Email: *

Verification: *