Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

• A.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
• B.A DROP COLUMN command can be rolled back
• C.Partition key columns cannot be dropped.
• D.A column that is set to UNUSED still counts towards the limit of 1000 columns per table
• E.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
• F.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

Comment: *

Name: *

Email: *

Verification: *

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

• A.The same port number can be used for multiple Database Express configurations for multiple databases on the same host
• 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.It can be used to perform database recovery
• E.It can be used to switch a database into ARCHIVELOGMODE

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, ADD_MONTHS(hire_date, 6), NEXT_DAY(`MONDAY') FROM employees;
• B.SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
• C.SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), `MONDAY') FROM employees;
• D.SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about UNDO and REDO? (Choose two.)

• A.The generation of REDO generates UNDO
• B.DML modifies Oracle database objects and only generates REDO
• C.The generation of UNDO generates REDO
• D.DML modifies Oracle database objects and only generates UNDO

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Oracle synonyms? (Choose three.)

• A.A synonym cannot be created for a PL/SQL package
• B.A synonym can be available to all users
• C.A SEQUENCE can have a synonym
• D.A synonym created by one user can refer to an object belonging to another user
• E.Any user can drop a PUBLIC synonym

Comment: *

Name: *

Email: *

Verification: *