1z1-061試験無料問題集（340題）「Oracle Database 12c: SQL Fundamentals 認定」

出題：1

View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.

Evaluate the following SQL statements:

Which statement is true regarding the above compound query?

A. It reduces an error

B. It shows products that were sold but have no cost recorded

C. It shows products that were sold and have a cost recorded

D. It shows products that have a cost recorded irrespective of sales

正解：B 解答を投票する

出題：2

Examine the types and examples of relationships that follow:
1 . One-to-one a) Teacher to students
2 . One-to-many b) Employees to Manager
3 . Many-to-one c) Person to SSN
4 . Many-to-many d) Customers to products
Which option indicates the correctly matched relationships?

A. 1-a, 2-b, 3-c, and 4-d

B. 1-c, 2-a, 3-b, and 4-d

C. 1-d, 2-b, 3-a, and 4-c

D. 1-c, 2-d, 3-a, and 4-b

正解：B 解答を投票する

出題：3

Examine the structure and data in the PRIC E_LIST table: Name Null? Type
------------ ------------- -------------------
PROD_D NOT NULL NUMBER(3)
PROD_PRICE VARCHAR2(10)
PROD_ID PROD PRICE
----------- ------------------------
100 $234.55
101 $6, 509.75
102 $1, 234
in the same format as the PROD_PRICE. Which SQL statement would give the required result?

A. SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM PRICE_LIST:

B. . SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST;

C. SELECT TO_NUMBER(TO_NUMBER(prod_price., $99.999.99')* .25/$99.999.00') FROM PRICE_LIST:

D. SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST:

正解：A 解答を投票する

出題：4

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

A. no privileges

B. all the privileges of a default user

C. only the SELECT privilege

D. only the CONNECT privilege

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table.
Which query will generate the required result?

A. Option D

B. Option C

C. Option A

D. Option B

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which four are attributes of single row functions? (Choose four.)

A. cannot be nested

B. accept only one argument and return only one value

C. accept arguments which can be a column or an expression

D. manipulate data items

E. return one result per row

F. act on each row returned

正解：C,D,E,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

View the Exhibit and examine the structure of the PROMOTIONS table:
Exhibit:

Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:

What would be the outcome?

A. It executes successfully and gives the required result

B. It generates an error because CASE cannot be used with group functions

C. It generates an error because multiple conditions cannot be specified for the WHEN clause

D. It generates an error because NULL cannot be specified as a return value

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?

A. SELECT &1, "&2"FROM &3WHERE last_name = '&4';

B. SELECT &1, '&2'FROM &3WHERE '&last_name = '&4' ';

C. SELECT &1, '&2'FROM EMPWHERE last_name = '&4';

D. SELECT &1, &2FROM &3WHERE last_name = '&4';

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Examine the structure of the EMPLOYEES table:

You want to generate a report that contains the department IDs and last names of employees ordered by hire date in their respective departments. Employees from one department must appear in a single row.
Which query will provide the required output?

A. SELECT department_id "Dept.",LISTAGG (last_name, ';') WITHIN GROUP (ORDER BY hire_date)" Employees")FROM employeesGROUP BY department_idORDER BY hire_date;

B. SELECT department_id "Dept.",LISTAGG (last_name, ';') WITHIN GROUP (ORDER BY hire_date)" Employees"FROM employeesGROUP BY department_idORDER BY department_id;

C. SELECT department_id "Dept.",LISTAGG (last_name, ';') WITHIN GROUP ORDER BY (hire_date)" Employees")FROM employeesGROUP BY department_idORDER BY department_id;

D. SELECT department_id "Dept.",LISTAGG (last_name, ';') WITHIN GROUP (ORDER BY hire_date)" Employees"FROM employeesGROUP BY department_idORDER BY hire_date;

正解：A 解答を投票する

出題：10

View the Exhibit and examine the structure of the CUSTOMERS table.
Exhibit:

you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country as customers with the last name 'king' and whose credit limit is less than the maximum credit limit in countries that have customers with the last name
'king'.

Which statement is true regarding the outcome of the above query?

A. It produces an error and the < operator should be replaced by < ANY to get the required output

B. It produces an error and the IN operator should be replaced by = in the WHERE clause of the main query to get the required output

C. It produces an error and the < operator should be replaced by < ALL to get the required output

D. It executes and shows the required result

正解：D 解答を投票する

出題：11

Examine the data in the CUST_NAME column of the customers table.

You need to display customers' second names where the second name starts with "Mc" or
"MC."
Which query gives the required output?

A. Option D

B. Option C

C. Option A

D. Option B

正解：D 解答を投票する

出題：12

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.
Which SQL statement can Mary use to accomplish that task?

A. CREATE PUBLIC SYNONYM EDL_VU. ON emp_dept_loc_vu;

B. CREATE PUBLIC SYNONYM EDL_VU. ON emp_dept_loc_vu. FOR ALL USERS;

C. CREATE SYNONYM EDL_VU. FOR EACH USER. ON emp_dept_loc_vu;

D. CREATE PUBLIC SYNONYM EDL_VU. FOR emp_dept_loc_vu;

E. CREATE SYNONYM EDL_VU. ON emp_dept_loc_vu. FOR EACH USER;

F. CREATE PUBLIC SYNONYM EDL:VU. FOR mary (emp_dept_loc_vu);

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：13

Examine the structure of the EMPLOYEES table:

Which INSERT statement is valid?

A. INSERT INTO employees(employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', '01 January 01');

B. INSERT INTO employees (employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', '01/01/01');

C. INSERT INTO employees(employee_id, first_name, last_name, Hire_date)VALUES (
1 000, 'John', 'Smith', To_date('01/01/01'));

D. INSERT INTO employees(employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', 01-Jan-01);

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：14

Which one is a system privilege?

A. CREATE TABLE

B. ALTER TABLE

C. SELECT

D. EXECUTE

E. DELETE

正解：A 解答を投票する

1z1-061試験無料問題集「Oracle Database 12c: SQL Fundamentals 認定」