Examine this command and some partial output:

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A.Column names in each SELECT in the compound query can be different
• B.The number of columns in each SELECT in the compound query can be different
• C.Reversing the order of the intersected tables can sometimes affect the output
• D.INTERSECT returns rows common to both sides of the compound query
• E.INTERSECT ignores NULLs

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A.Revoke the CREATE SESSION privilege from user HR
• B.Execute DDL statements in the HR schema
• C.Log in to the database instance
• D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E.Execute DML statements in the HR schema
• F.Revoke the CREATE SESSION privilege from other users

Comment: *

Name: *

Email: *

Verification: *

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

• A.one instance on one server associated with two or more databases on the same server
• B.two or more instances on separate servers all associated with one database
• C.one instance on one server not associated with any database
• D.one instance on one server associated with two or more databases on separate servers
• E.one instance on one server associated with one database

Comment: *

Name: *

Email: *

Verification: *

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
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?

• A.It succeeds and the generated undo is stored in SYSTEM.
• B.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' ".
• C.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• D.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
• E.It succeeds and the generated undo is stored in SYSAUX.

Comment: *

Name: *

Email: *

Verification: *