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 sql script that it uses to load data from EMP.DAT to EMP
• D.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• E.It appends data from EMP.DAT to EMP

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

• A.It can be used to switch a database into ARCHIVELOGMODE
• B.It is available only when the database is open
• C.The same port number can be used for Database Express configurations for databases on different hosts
• D.The same port number can be used for multiple Database Express configurations for multiple databases on the same host
• E.It can be used to perform database recovery

Comment: *

Name: *

Email: *

Verification: *

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.
Which query can be used?

• A.SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), `MONDAY') FROM employees;
• B.SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
• C.SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(`MONDAY') FROM employees;
• D.SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

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 succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
• C.The command fails because the script must refer to the full path name
• D.The command fails and reports an error because @ is used twice

Comment: *

Name: *

Email: *

Verification: *