In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

• A.It succeeds and the generated undo is stored in SYSTEM.
• B.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".
• C.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• D.It succeeds and the generated undo is stored in SYSAUX.
• E.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A.Base tables can be queried directly
• B.Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• C.Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• D.It is owned by the SYSTEM user
• E.The data dictionary is created and maintained by the database administrator
• F.Usernames of all users including database administrators are stored in the data dictionary

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

• A.MINUS
• B.UNION
• C.SUBTRACT
• D.UNION ALL
• E.INTERSECT

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqiidr execution?

• A.It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.
• B.It overwrites the data for Alan and adds data for Curl and Bob
• C.It overwrites all data in emp with data from emp.dat.
• D.It generates a sqi script that it uses to load data from EMP.DAT TO EMP.
• E.It appends data from EMP.DAT TO EMP.

Comment: *

Name: *

Email: *

Verification: *

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)

• A.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• B.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• C.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• D.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• E.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

Comment: *

Name: *

Email: *

Verification: *