The HR user receives the following error while inserting data into the sales table:

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)

• A.Changing segment space management for the USERS tablespace to manual
• B.Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value
• C.Adding a data file to the USERS tablespace
• D.Altering the data file associated with the USERS tablespace to extend automatically
• E.Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace

Comment: *

Name: *

Email: *

Verification: *

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

• A.A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
• B.All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
• C.A TOP-N query is created to limit the rows to 20 percent of the total rows
• D.A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about adaptive SQL plan management? (Choose three.)

• A.It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
• B.The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
• C.It adds new, bettor plans automatically as fixed plans to the baseline.
• D.The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
• E.The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Comment: *

Name: *

Email: *

Verification: *

You install Oracle Grid Infrastructure for a standalone server.
Which two components are automatically included in the Oracle Restart configuration? (Choose two.)

• A.A pre-existing Oracle Net Listener
• B.Oracle Notification services
• C.A pre-existing database
• D.A pre-existing Oracle management agent
• E.Oracle CSSDservice

Comment: *

Name: *

Email: *

Verification: *

The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.
You execute the following command to create a table:

Which two statements are true? (Choose two.)

• A.A segment is allocated for the table if the ALTER TABLE... ALLOCATE EXTENT command is issued.
• B.A segment is allocated when the first row is inserted in the table.
• C.The table is created without a segment because the storage clause is missing.
• D.The table is created and extents are immediately allocated as per the default storage defined for its tablespace.
• E.A segment is allocated when an index is created for any column in the table.

Comment: *

Name: *

Email: *

Verification: *