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

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

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.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• C.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• D.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• 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: *

Which three statements are true about sequences in a single instance Oracle database?

• A.Two or more tables cannot have keys generated from the same sequence.
• B.A sequence number that was allocated can be rolled back if a transaction fails.
• C.A sequence can Issue duplicate values.
• D.A sequence's unallocated cached values are lost if the instance shuts down.
• E.A sequence can only be dropped by a DBA.
• F.Sequences can always have gaps.

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, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
• D.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

Comment: *

Name: *

Email: *

Verification: *

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A.T1, an index segment for the primary key, and a LOB segment only
• B.T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• C.T1 only
• D.T1 and an index segment created for the primary key only
• E.no segments are created

Comment: *

Name: *

Email: *

Verification: *