Which three statements are true about table data storage in an Oracle Database? (Choose three.)

• A.Data block headers contain their own Data Block Address (DBA)
• B.A table row piece can be chained across several database blocks
• C.Multiple row pieces from the same row may be stored in different database blocks
• D.Multiple row pieces from the same row may be stored in the same block
• E.Data block free space is always contiguous in the middle of the block
• F.Index block free space is always contiguous in the middle of the block

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which query is valid?

• A.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• B.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• C.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
• D.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

Comment: *

Name: *

Email: *

Verification: *

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

• A.The sales user must have a quota on the TEMP tablespace
• B.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• C.The sales user must have been granted the CREATE TABLE privilege
• D.The sales user must have been granted the CREATE SESSION privilege
• E.The sales user must have their quota on the users tablespace removed
• F.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

• A.The CURRENT_TIMESTAMP function returns data without time zone information
• B.A TIMESTAMP data type column contains information about year, month, and day
• C.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• D.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• E.A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

Comment: *

Name: *

Email: *

Verification: *