1z1-061 試験問題を無料オンラインアクセス

Examine the following query:

What is the output of this query?

• A.It displays 5 percent of the products with the lowest amount sold.
• B.It results in an error because the ORDER BY clause should be the last clause.
• C.It displays 5 percent of the products with the highest amount sold.
• D.It displays the first 5 percent of the rows from the SALES table.

Which three SQL statements would display the value 1890.55 as $1, 890.55? (Choose three.)

• A.SELECT TO_CHAR(1890.55, '$9, 999V99')FROM DUAL;
• B.SELECT TO_CHAR(1890.55, '$0G000D00')FROM DUAL;
• C.SELECT TO_CHAR(1890.55, '$99, 999D99')FROM DUAL;
• D.SELECT TO_CHAR(1890.55, '$99G999D99')FROM DUAL;
• E.SELECT TO_CHAR(1890.55, '$99G999D00')FROM DUAL;

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

• A.It fails because no SQL *Loader data file location is specified.
• B.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• C.It fails because no SQL *Loader control file location is specified.
• D.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

You want to write a query that accepts user input for columns and conditions every time it is executed.
The user needs to be promoted only once for the table input.
Which query provides the required result?

• A.SELECT &col1, 'col2'FROM &tableWHERE &&condition = '&cond';
• B.SELECT &col1, col2FROM &&tableWHERE &condition = &&cond;
• C.SELECT &col1, col2FROM "&&table"WHERE &condition = &cond;
• D.SELECT &col1, col2FROM &&tableWHERE &condition = &cond;

A sequence is created as follows: create sequence seq1 maxvalue 50;
If the current value is already 50, when you attempt to select SEQ1.NEXTVAL what will happen?

• A.The sequence will reissue 50.
• B.There will be an error.
• C.The sequence will cycle and issue 0.
• D.The sequence will cycle and issue 1.