1z1-071 무료 덤프문제 온라인 액세스

Which three actions can you perform by using the ORACLE_DATAPUMP access driver?
(Choose three.)

• A.Read data from an external table and load it into a table in the database
• B.Execute DML statements on an external table
• C.Create a directory object for an external table
• D.Read data from a table in the database and insert it into an external table
• E.Query data from an external table
• F.Create a directory object for a flat file

A session's NLS_DATE_FORMAT is set to DD Mon YYYY.
Which two queries return the value 1 Jan 2019?

• A.SELECT TO_CHAR(`2019-01-01') FROM DUAL;
• B.SELECT TO_DATE(`2019-01-01', `YYYY-MM-DD') FROM DUAL;
• C.SELECT `2019-01-01' FROM DUAL;
• D.SELECT TO_DATE(`2019-01-01') FROM DUAL;
• E.SELECT DATE `2019-01-01' FROM DUAL;

Which two statements are true about INTERVAL data types? (Choose two.)

• A.INTERVAL YEAR TO MONTH columns support yearly intervals.
• B.The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.
• C.INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.
• D.The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.
• E.INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.
• F.INTERVAL DAY TO SECOND columns support fractions of seconds.

View the Exhibit and examine the data in the PRODUCT_INFORMATION table.

Which two tasks would require subqueries? (Choose two.)

• A.displaying the minimum list price for each product status
• B.displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
• C.displaying the number of products whose list prices are more than the average list price
• D.displaying all supplier IDs whose average list price is more than 500
• E.displaying all the products whose minimum list prices are more than average list price of products having the status orderable

Examine the description of the CUSTOMERStable:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:

Which two WHEREconditions give the required result? (Choose two.)

• A.
• B.
• C.
• D.
• E.