자료의 품질이 걱정되신다면 확인 방법은 간단합니다. KoreaDumps에서 1z1-061 무료 샘플을 내려받아 Oracle Database 12c: SQL Fundamentals 대비 문제의 일부를 직접 살펴보시기 바랍니다.

Oracle 1z1-061 시험 개요:

Oracle 1z1-061 시험 요강 주제:

Oracle 1z1-061 시험 궁금증 해소 코너

최신 Oracle Database 1z1-061 무료샘플문제

문제 #1

The DBA issues this SQL command:
CREATE USER scott IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

A. only the CONNECT privilege
B. no privileges
C. all the privileges of a default user
D. only the SELECT privilege

문제 #2

View the Exhibit and examine the structure of the PRODUCTS table.

You want to display the category with the maximum number of items.
You issue the following query:
SQL>SELECT COUNT(*), prod_category_id
FROM products
GROUP BY prod_category_id
HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM products);
What is the outcome?

A. It generates an error because = is not valid and should be replaced by the IN operator.
B. It executes successfully and gives the correct output.
C. It generates an error because the subquery does not have a GROUP BY clause.
D. It executes successfully but does not give the correct output.

문제 #3

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, col2FROM &&tableWHERE &condition = &&cond;
B. SELECT &col1, col2FROM "&&table"WHERE &condition = &cond;
C. SELECT &col1, col2FROM &&tableWHERE &condition = &cond;
D. SELECT &col1, 'col2'FROM &tableWHERE &&condition = '&cond';

문제 #4

Examine the description of the EMP_DETAILS table given below:

Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table? (Choose two.)

A. An EMP_IMAGE column cannot be included in the ORDER BY clause
B. An EMP_IMAGE column can be included in the GROUP BY clause
C. You cannot add a new column to the table with LONG as the data type
D. You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column

문제 #5

Examine the structure and data of the CUST_TRANS table:

Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table. Which three SQL statements would execute successfully?

A. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;
B. SELECT transdate + '10' FROM cust_trans;
C. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
D. SELECT * FROM cust_trans WHERE transdate = '01-01-07';
E. SELECT transamt FROM cust_trans WHERE custno > '11';

질문과 대답: