次の認定試験に速く合格する！

簡単に認定試験を準備し、学び、そして合格するためにすべてが必要だ。

会員センターカート (0)

1z1-071 無料問題集「Oracle Database SQL」

ページ: 1 / 20
トータル 325 問

サインアップ、ログインされた後に、試験全体を無料で表示できるようになります。

完全版を入手する

質問 1

Which two statements will return the names of the three employees with the lowest salaries?

（A）SELECT last_name,salary
FROM (SELECT * FROM employees ORDER BY salary)

（B）SELECT last_name,salary
FROM employees
WHERE ROWNUM<=3
ORDER BY (SELECT salary FROM employees);

（C）SELECT last_name,salary
FROM employees
FETCH FIRST 3 ROWS ONLY
ORDER BY salary;

（D）SELECT last_name,salary
FROM employees
ORDER BY salary
FETCH FIRST 3 ROWS ONLY;

（E）SELECT last_name, salary
FROM employees
WHERE ROWNUM<=3

正解：D 解答を投票する

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

質問 2

Which three statements are true about views in an Oracle database?

（A）Date Manipulation Language (DML) can always be used on views.

（B）The WITH CHECK clause prevents certain rows from being displayed when querying the view.

（C）The WITH CHECK clause prevents certain rows from being updated or inserted.

（D）Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

（E）Tables in the defining query of a view must always exist in order to create the view.

（F）Views can be updated without the need to re-grant privileges on the view.

（G）Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

正解：C、D、G 解答を投票する

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

質問 3

Which three are true about multiple INSERT statements?

（A）They can be performed only by using a subquery.

（B）They can be performed on views.

（C）They can be performed on external tables using SQL*Loader.

（D）They can be performed on remote tables.

（E）They can be performed on relational tables.

（F）They can insert each computed row into more than one table.

正解：B、D、E 解答を投票する

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

質問 4

Which two statements are true?

（A）Neither CASE nor DECODE is a function.

（B）AIl conditions evaluated using DECODE can also be evaluated using CASE.

（C）DECODE is a function and CASE is not.

（D）All conditions evaluated using CASE can also be evaluated using DECODE.

（E）CASE is a function and DECODE is not.

（F）Both CASE and DECODE are functions.

正解：B、C 解答を投票する

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

質問 5

Which two are true about the data dictionary?

（A）All users have permissions to access all information in the data dictionary by default

（B）Base tables in the data dictionary have the prefix DBA_.

（C）The SYS user owns all base tables and user-accessible views in the data dictionary.

（D）The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

（E）All user actions are recorded in the data dictionary.

正解：C、D 解答を投票する

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

質問 6

Which two statements are true about a self join?

（A）It can be an inner join.

（B）The join key column must have an index.

（C）It can be a left outer join.

（D）It must be an equijoin.

（E）It must be a full outer join.

正解：A、C 解答を投票する

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

質問 7

Examine this SQL statement:
SELECT cust_id, cus_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.

（A）ORDER BY 2,cust_id

（B）ORDER BY "CUST_NO"

（C）ORDERBY 2, 1

（D）ORDER BY CUST_NO

（E）ORDER BY "Last Name"

正解：C、E 解答を投票する

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

質問 8

Examine the description of the ORDER_ITEMS table:

Examine this incomplete query:
SELECT DISTINCT quantity * unit_price total_paid FROM order_items ORDER BY <clause>; Which two can replace <clause> so the query completes successfully?

（A）product_id

（B）total_paid

（C）quantity * unit_price

（D）quantity, unit_price

（E）quantity

正解：C、D 解答を投票する

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

質問 9

Examine the description of EMPLOYEES table:
Which three queries return all rows for which SALARY+COMMISSION is greate than 20000?

（A）SELECT * FROM employees WHERE salary+NVL2(commission,commission,0)>=20000;

（B）SELECT * FROM employees WHERE salary+NULLF(commission,0)>=20000;

（C）SELECT * FROM employees WHERE salary+NVL(commission,0)>=20000;

（D）SELECT * FROM employees WHERE NVL2(salary)+commission,salary+commission,

（E）SELECT * FROM employees WHERE NVL(salary+commission,0)>=20000;

（F）SELECT * FROM employees WHERE NVL(salary+commission,0)>==20000;

正解：A、B、C 解答を投票する

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

質問 10

Which three actions can you perform on an existing table containing date?

（A）Add a new NOT NULL Column with a DEFAULT value.

（B）Increase the width of a numeric column.

（C）Change the default value of a column.

（D）Add a new column as the table's first column.

（E）Change a DATE Column containing data to a NUMBER data type.

（F）Define a default value that is automatically inserted into a column containing nulls.

正解：A、B、C 解答を投票する

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

質問 11

Which three queries execute successfully?

（A）SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

（B）SELECT SYSDATE - 1 - DATE'2019-01-01' EROM DUAL;

（C）SELECT (SYSDATE-DATE '2019-01-01') / 1 FROM DUAL;

（D）SELECT 1 - SYSDATE- DATE '2019-01-01' FROM DUAL;

（E）SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;

（F）SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL

正解：B、C、E 解答を投票する

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

質問 12

Examine the description of the EMPLOYEES table:

Which statement will execute successfully, returning distinct employees with non-null first names?

（A）SELECT first_ name, DISTNCT last_ name FROM employees WHERE first_ name IS NOT NULL;

（B）SELECT Distinct * FROM employees WHERE first_ name < > NULL;

（C）SELECT first_ name, DISTINCT last_ name FROM employees WHERE first_ name < > NULL;

（D）SELECT DISTINCT * FROM employees WHERE first_ name IS NOT NULL;

正解：D 解答を投票する

質問 13

Examine the description of the EMPLOYEES table:

Which query is valid?

（A）SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

（B）SELECT dept_id, MAX (AVG(salary)) FROM employees GROUP BY dept_id;

（C）SELECT dept_id, AVG(NAX(salary)) FROM employees GROUP BY dept_id;

（D）SELECT dept_id, join date, SUM(salary) FROM employees GROUP BY dept_id,join_date;

正解：D 解答を投票する

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

質問 14

Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name
FROM customers
WHERE countryid=10
UNION
SELECT custid CUSTNO, cust_last_name
FROM customers
WHERE countryid=30
Identify three ORDER BY clauses, any one of which can complete the query successfully.

（A）ORDER BY"CUST NO"

（B）ORDER BY CUSTNO

（C）ORDERBY2, 1

（D）ORDER BY 2, cust_id

（E）ORDER BY "Last Name"

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

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

質問 15

Which three statements are true about GLOBAL TEMPORARY TABLES?

（A）Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

（B）A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

（C）GLOBAL TEMPORARY TABLE space allocation occurs at session start.

（D）GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

（E）A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

（F）A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

正解：A、E、F 解答を投票する

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

質問 16

Examine the description of the CUSTOMERS table:

Which two SELECT statements will return these results:
CUSTOMER_ NAME
--------------------
Mandy
Mary

（A）SELECT customer_ name FROM customers WHERE customer name LIKE 'Ma%' ;

（B）SELECT customer_ name FROM customers WHERE UPPER (customer name) LIKE 'MA&';

（C）SELECT customer_ name FROM customers WHERE customer_ name LIKE ' % a % ' ;

（D）SELECT customer_ name FROM customers WHERE customer name LIKE 'Ma*';

（E）SELECT customer_ name FROM customers WHERE customer_ name='*Ma*';

（F）SELECT customer_ name FROM customers WHERE UPPER (customer_ name ) LIKE 'MA*. ;

（G）SELECT customer_ name FROM customers WHERE customer_ name KIKE .*Ma*';

正解：A、F 解答を投票する

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

質問 17

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD IDS whose promotion cost is less than the highest cost PROD ID in a pro motion time interval.
Examine this SQL statement:
SELECT prod id
FROM costs
WHERE promo id IN
(SELECT promo id
FROM promotions
WHERE promo_cost < ALL
(SELECT MAX (promo cost)
FROM promotions
GROUP BY (promo_end date-promo_begin_date)) );
What will be the result?

（A）It gives an error because the GROUP BY clause is not valid

（B）It gives an error because the ALL keyword is not valid.

（C）It executes successfully and gives the required result.

（D）It executes successfully but does not give the required result.

正解：C 解答を投票する

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

ページ: 1 / 20
トータル 325 問

1z1-071 の機能をすべて解除する

キャプチャ不要
365日無料更新サービス
希望する合格率を設定できる
時間の割り当てられる（時間：分）
1z1-071 に2つの練習用モード
サポートサービス対応

完全版を入手する

弊社を連絡する

我々は１２時間以内ですべてのお問い合わせを答えます。

オンラインサポート時間：( UTC+9 ) 9:00-24:00
月曜日から土曜日まで

サポート：現在連絡

トップ試験

MB-335 試験問題集
CInP 試験問題集
CGEIT 試験問題集
C-ARSOR-2404 試験問題集
C-HRHPC-2505 試験問題集
C_THR87_2505 試験問題集

1z1-071 無料問題集「Oracle Database SQL」

弊社を連絡する

関連リンク

トップ試験