Evaluate these commands which execute successfully:

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

• A.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
• 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.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• E.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

Comment: *

Name: *

Email: *

Verification: *

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A.INTERVAL YEAR TO MONTH
• B.TIMESTAMP
• C.TIMESTAMP WITH LOCAL TIMEZONE
• D.TIMESTAMP WITH TIMEZONE
• E.INTERVAL DAY TO SECOND

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

• A.The Oracle join syntax supports creation of a Cartesian product of two tables
• B.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• C.The SQL:1999 compliant ANSI join syntax supports natural joins
• D.The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
• E.The Oracle join syntax only supports right outer joins
• F.The Oracle join syntax supports natural joins
• G.The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Comment: *

Name: *

Email: *

Verification: *

Which three are types of segments in an Oracle Database? (Choose three.)

• A.undo
• B.index
• C.stored procedures
• D.sequences
• E.tables
• F.clusters

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about single-row functions? (Choose three.)

• A.They can be used only in the WHERE clause of a SELECT statement
• B.The argument can be a column name, variable, literal or an expression
• C.The data type returned can be different from the data type of the argument
• D.They can be nested to any level
• E.They can accept only one argument
• F.They return a single result row per table

Comment: *

Name: *

Email: *

Verification: *