Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

• A.Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• B.PCTFREE defaults to 10% for all blocks in all segments for all compression methods
• C.ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• D.A block will always be eligible for inserts if the row is short enough to fit into the block
• E.Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A.Set OS_AUTHEN_PREFIX to OPS$
• B.Grant DBA to KING
• C.Alter user KING to be IDENTIFIED EXTERNALLY
• D.Have the OS administrator add KING to the OSDBA group
• E.Unset REMOTE_LOGIN_PASSWORDFILE

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about segment types in an Oracle Database?

• A.Temporary segments are only stored in a temporary tablespace.
• B.Index segments always have two or more extents.
• C.Undo segments are only stored in an undo tablespace.
• D.Cluster segments may contain data from multiple tables.
• E.Table segments always have two or more extents.

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A.It continues to run in the background
• B.You can no longer monitor it
• C.It terminates
• D.It is paused and can be resumed
• E.You can reattach to it and monitor it

Comment: *

Name: *

Email: *

Verification: *

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employees 100 and 200 will have the same JOB_ID as before the update command
• B.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• C.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• D.Employees 100 and 200 will have the same SALARY as before the update command
• E.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• F.Employee 100 will have SALARY set to the same value as the SALARY of employee 200

Comment: *

Name: *

Email: *

Verification: *