Examine these commands:

Which two statements are true about the sqiidr execution?

• A.It appends data from EMP.DAT TO EMP.
• B.It overwrites all data in emp with data from emp.dat.
• C.It overwrites the data for Alan and adds data for Curl and Bob
• D.It generates a sqi script that it uses to load data from EMP.DAT TO EMP.
• E.It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.

Comment: *

Name: *

Email: *

Verification: *

In which three situations does a new transaction always start? (Choose three.)

• A.when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
• B.when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
• C.when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
• D.when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
• E.when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
• F.when issuing a DML statement after a DML statement failed in the same session

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldrexecution? (Choose two.)

• A.It overwrites data in EMP with data in EMP.DAT
• B.It uses the database buffer cache to load data
• C.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• D.It appends data from EMP.DAT to EMP
• E.It generates a sql script that it uses to load data from EMP.DAT to EMP

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the DUAL table? (Choose two.)

• A.It can be accessed only by the SYS user
• B.It consists of a single row and single column of VARCHAR2 data type
• C.It can display multiple rows but only a single column
• D.It can be used to display only constants or pseudo columns
• E.It can be accessed by any user who has the SELECT privilege in any schema
• F.It can display multiple rows and columns

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

Comment: *

Name: *

Email: *

Verification: *