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

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
• B.SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
• C.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• D.SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;
• E.SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

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

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

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

• A.The primary key constraint will be enabled and immediate.
• B.The foreign key constraint will be enabled and immediate.
• C.The primary key constraint will be enabled and deferred.
• D.The foreign key constraint will be enabled and deferred.
• E.The foreign key constraint will be disabled.

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1?
(Choose three.)

• A.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• B.The sales user must have been granted the CREATE SESSION privilege
• C.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• D.The sales user must have their quota on the users tablespace removed
• E.The sales user must have a quota on the TEMP tablespace
• F.The sales user must have been granted the CREATE TABLE privilege

Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A.It can be used in SQL Developer and SQL*Plus
• B.It can be used only in SQL*Plus
• C.It displays values for variables prefixed with &&
• D.It displays values for variables used only in the WHERE clause of a query
• E.It displays values for variables created by the DEFINE command