Which two statements are true regarding a SAVEPOINT? (Choose two.)

• A.Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• B.Only one SAVEPOINT may be issued in a transaction
• C.Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• D.A SAVEPOINT does not issue a COMMIT
• E.Rolling back to a SAVEPOINT can undo a DELETE statement

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.Alter user KING to be IDENTIFIED EXTERNALLY
• D.Grant DBA to KING
• E.Unset REMOTE_LOGIN_PASSWORDFILE

Comment: *

Name: *

Email: *

Verification: *

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100

• A.DUES FROM transactions;
  SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount +
• B.transactions;
  SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100
• C."DUES" FROM transactions;
  SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100
• D.100 "DUES AMOUNT" FROM transactions;
  SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM
• E.'DUES AMOUNT' FROM transactions;

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 not associated with any database
• B.one instance on one server associated with two or more databases on separate servers
• C.one instance on one server associated with one database
• D.two or more instances on separate servers all associated with one database
• E.one instance on one server associated with two or more databases on the same server

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

• A.A RAC database can have instances on separate servers.
• B.A RAC database must have two or more instances.
• C.Two RAC databases can share their instances.
• D.A RAC database can have one Instance.
• E.A RAC database must have three or more Instances.

Comment: *

Name: *

Email: *

Verification: *