Evaluate these commands which execute successfully:

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

• A.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• B.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• C.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• D.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• 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: *

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?

• A.SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK
• B.SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';
• C.SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;
• D.SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';
• E.SELECT prod_id I I q' ('s not available) * 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK
• F.SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

Comment: *

Name: *

Email: *

Verification: *

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully?
(Choose two.)

• A.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• B.Add the AUTOEXTEND ON clause with NEXT set to 100M.
• C.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
• D.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
• E.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• B.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• C.GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• D.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• E.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
• F.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Comment: *

Name: *

Email: *

Verification: *

Which two actions can you perform using DBCA for an existing database?

• A.Create a template that can be used to clone the database.
• B.Change the character set.
• C.Change the server mode from dedicated to shared, and vice versa.
• D.Create nonstandard block size tablespaces.
• E.Create an additional listener.

Comment: *

Name: *

Email: *

Verification: *