Examine these commands:

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

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

Comment: *

Name: *

Email: *

Verification: *

A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

• A.The command succeeds and HR will be connected to the orcl and abc.sql databases
• B.The command fails because the script must refer to the full path name
• C.The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
• D.The command fails and reports an error because @ is used twice

Comment: *

Name: *

Email: *

Verification: *

Which two are true about complete recovery? (Choose two.)

• A.The database must have FLASHBACK enabled in order to perform it.
• B.Uncommitted transactions will be rolled back after it completes.
• C.It is possible only when the database is in MOUNT state
• D.Incremental backups can be used to roll forward the database while performing it.
• E.Only RMAN backupsets can be used to restore a database as part of it.

Comment: *

Name: *

Email: *

Verification: *

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A.T1 only
• B.no segments are created
• C.T1, an index segment for the primary key, and a LOB segment only
• D.T1 and an index segment created for the primary key only
• E.T1, an index segment for the primary key, a LOB segment, and a lobindex segment

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning logical and physical database structures? (Choose three.)

• A.The extents of a segment must always reside in the same datafile
• B.A segment's blocks can be of different sizes
• C.A segment can span multiple data files in some tablespaces
• D.A smallfile tablespace might be bigger than a bigfile tablespace
• E.All tablespaces may have one or more data files
• F.A segment might have only one extent
• G.Segments can span multiple tablespaces

Comment: *

Name: *

Email: *

Verification: *