1Z1-082 무료 덤프문제 온라인 액세스

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• B.SYSDATE can be queried only from the DUAL table
• C.SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• D.CURRENT_DATE returns the current date and time as per the session time zone
• E.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• F.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A.sending each connection input request to the appropriate shared server input queue
• B.receiving inbound requests from processes using shared server connections
• C.checking for outbound shared server responses on the common outbound response queue
• D.sending shared server session responses back to requesters on the appropriate connection
• E.writing inbound request to the common request queue from all shared server connections
• F.broadcasting shared server session responses back to requesters on all connections

Which three statements are true regarding indexes? (Choose three.)

• A.When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
• B.An update to a table can result in no updates to any of the table's indexes
• C.A SELECT statement can access one or more indices without accessing any tables
• D.A UNIQUE index can be altered to be non-unique
• E.An update to a table can result in updates to any or all of the table's indexes
• F.A table belonging to one user can have an index that belongs to a different user

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.Sequences can always have gaps.
• D.A sequence can Issue duplicate values.
• E.A sequence's unallocated cached values are lost if the instance shuts down.
• F.A sequence can only be dropped by a DBA.

View the Exhibit and examine the description of the tables.
You execute this SQL statement:

Which three statements are true?

• A.The statement will execute successfully and a new row will be inserted into the sales table.
• B.The statement will fall if a row already exists in the sales table for product 23.
• C.The sales table has five foreign keys.
• D.The statement will fail because a subquery may not be contained in a values clause.
• E.A product can have a different unit price at different times.
• F.A customer can exist in many countries.