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

質問 1

Which two statements are true regarding the UNION ALL operators?

（A）The number of columns selected in each SELECT statement must be identical

（B）The output is sorted by the UNION ALL operator.

（C）NULLS are not ignored during duplicate checking.

（D）Duplicates are eliminated automatically by the UNION ALL operator

（E）The names of columns selected in each SELECT statement must be identical.

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

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

質問 2

Which three statements are true regarding indexes?

（A）An update to a table can result in updates to any or all of the table's indexes.

（B）A SELECT statement can access one or more indices without accessing any tables.

（C）When a table is dropped and is moved to the RECYCLE BIN, all Indexes built on that table are permanently dropped.

（D）A UNIQUE index can be altered to be non-unique.

（E）An update to a table can result in no updates to any of the table's indexes.

（F）A table belonging to one user can have an index that belongs to a different user,

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

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

質問 3

Which two statements are true about INTERVAL data types

（A）INTERVAL DAY TO SECOND columns support fractions of seconds.

（B）INTERVAL YEAR TO MONTH columns support yearly intervals.

（C）INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

（D）The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

（E）The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

（F）INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

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

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

質問 4

Examine the description of the BOOKS_TRANSACTIONS table:

Which two WHERE conditions give the same result?

（A）WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' OR member_id IN ('A101','A102'));

（B）WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' AND (member_id ='A101' OR member_id ='A102') );

（C）WHERE borrowed_date = SYSDATE AND transaction_type ='RM' OR member_id IN ('A101','A102');

（D）WHERE (borrowed_date = SYSDATE AND transaction_type ='RM') OR member_id IN ('A101','A102');

（E）WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' AND member_id='A101' OR member_id ='A102'));

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

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

質問 5

You execute this command:
TRUNCATE TABIE depts;
Which two are true?

（A）It retains the indexes defined on the table.

（B）A FLASHBACK TABLE statement can be used to retrieve the deleted data.

（C）It drops any triggers defined on the table.

（D）It retains the integrity constraints defined on the table,

（E）It always retains the space used by the removed rows.

（F）A ROLLBACK statement can be used to retrieve the deleted data.

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

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

質問 6

Which two statements cause changes to the data dictionary?

（A）DELETE FROM scott. emp;

（B）TRUNCATE TABLE emp:

（C）SELECT * FROM user_ tab._ privs;

（D）AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

（E）GRANT UPDATE ON scott. emp TO fin manager;

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

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

質問 7

Examine this description of the PRODUCTS table:
You successfully execute this command:
CREATE TALE new_prices(prod_id NUBER(2),price NUMBER(8,2));
Which two statements execute without errors?

（A）MERGE INTO new_prices n
USING products p
WHEN NOT NATCHED THEN
INSERT (n.prod_id, n.price)VALUES (p.prod_id,cost*.01)
WHERE (p.cost <200);

（B）MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id=p.prod_id)
WHEN NATCHED THEN
UPDATE SET n.price=p.cost*.01
DELETE WHERE (p.cost<200);

（C）MERGE INTO new_prices n
USING(SELECT*FROM products)p
WHEN MATECHED THEN
UPDATE SET n.price=p.cost*.01
WHEN NOT MATCHED THEN
INSERT(n.prod_id,n.price)VALUES (p.prod_id,cost*01)
WHERE(p.cost<200);

（D）MERGE INTO new_prices n
USING(SELECT*FROM product WHERE cost>150) p
ON (n.prod_id=p.prod_id)
WHEN NATCHED THEN
DELETE WHERE(p.cost<200)
WHEN NOT MATCHED THEN
INSERT (n.prod_id,n.price)VALUES (p.prod_id,p.cost*.01);

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

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

質問 8

Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

（A）A table can have only one primary key and one foreign key.

（B）A table can have only one primary key but multiple foreign keys.

（C）Only the primary key can be defined the column and table level.

（D）The foreign key columns and parent table primary key columns must have the same names.

（E）It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted.

（F）Primary key and foreign key constraints can be defined at both the column and table level.

（G）It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.

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

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

質問 9

In your session, the NLS._DAE_FORMAT is DD- MM- YYYY.There are 86400 seconds in a day.Examine this result:
DATE
02-JAN-2020
Which statement returns this?

（A）SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '6' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

（B）SELECT TO_ CHAR(TO_ DATE('29-10-2019') +INTERVAL '2'; MONTH + INTERVAL '5'; DAY - INTERVAL '86410' SECOND, ' DD-MON-YYYY') AS "date" FROM DUAL;

（C）SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '4' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

（D）SELECT To CHAR(TO _DATE('29-10-2019') + INTERVAL '2' NONTH + INTERVAL '5' DAY INEERVAL '120' SECOND, ' DD-MON-YYY) AS "date" FROM DUAL;

（E）SELECT TO_ CHAR(TO_ DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, ' DD-MON-YYYY') AS "date" FROM DUAL;

正解：E 解答を投票する

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

質問 10

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER Statement 1:
SELECT MAX (unit price*quantity) "Maximum Order FROM order items;
Statement 2:
SELECT MAX (unit price*quantity "Maximum order" FROM order items GROUP BY order id; Which two statements are true?

（A）Statement 1 returns only one row of output.

（B）Both statements will return NULL if either UNIT PRICE or QUANTITY contains NULL,

（C）Both the statement given the same output.

（D）Statement 2 returns only one row of output.

（E）Statement 2 may return multiple rows of output.

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

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

質問 11

Examine the data in the ORDERS table:

Examine the data in the INVOICES table:

Examine this query:
SELECT order_ id, order_ date FROM orders
INTERSECT
SELECT order_ 1d, order_ date FROM invoices;
Which two rows will it return?

（A）2 <null>

（B）3 01-JAN-2019

（C）1 <null>

（D）3 <null>

（E）4 01-FEB-2019

（F）5 01-MAR-2019

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

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

質問 12

The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2).
Evaluate this SQL statement:
SELECT TO_CHAR(unit_price,'$9,999') FROM PRODUCT_INFORMATION;
Which two statements are true about the output?

（A）A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.

（B）A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.

（C）A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.

（D）A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #####

（E）A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.

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

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

質問 13

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1,
Some sales data is duplicated In both tables.
You want to display the rows from the SALES1 table which are not present in the SALIES2 table.
Which set operator generates the required output?

（A）UNION ALL

（B）UNION

（C）MINUS

（D）SUBTRACT

（E）INTERSECT

正解：C 解答を投票する

質問 14

Which two statements are true? (Choose two.)

（A）The USER SYNONYMS view can provide information about private synonyms.

（B）The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.

（C）The USER OBJECTS view can provide information about the tables and views created by the user only.

（D）All the dynamic performance views prefixed with V$ are accessible to all the database users.

（E）DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.

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

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

質問 15

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

（A）The foreign key constraint will be enabled and IMMEDIATE.

（B）The primary key constraint will be enabled and IMMEDIATE.

（C）The primary key constraint will be enabled and DEFERRED.

（D）The foreign key constraint will be enabled and DEFERRED.

（E）The foreign key constraint will be disabled.

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

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

質問 16

Which three statements are true about multiple row subqueries?

（A）Two or more values are always returned from the subquery.

（B）They can return multiple columns.

（C）They cannot contain subquery.

（D）They can contain HAVING clauses.

（E）They can contain GROUP BY clauses.

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

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

質問 17

which is true about the round,truncate and mod functions>?

（A）ROUND(MOD(25,3),-1) IS INVALID

（B）ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE DIFFERENT RESULTS.

（C）TRUNC(MOD(25,3),-1) IS INVALID.

（D）ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE SAME RESULT.

正解：B 解答を投票する

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

質問 18

Which statement is true about TRUNCATE and DELETE?

（A）You can never TRUNCATE a table if foreign key constraints will be violated.

（B）You can never tows from a table if foreign key constraints will be violated.

（C）For tables with multiple indexes and triggers is faster than TRUNCATE.

（D）For large tables TRUNCATE is faster than DELETE.

正解：D 解答を投票する

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

質問 19

View the Exhibit and examine the structure of the ORDERS table.
The columns ORDER_MODE and ORDER TOTAL have the default values'direct "and respectively.
Which two INSERT statements are valid? (Choose two.)

（A）INSERT INTO orders VALUES('09-mar-2007',DEFAULT,101, DEFALLT);

（B）INSERT INTO orders (order_id, order_date, order mode,customer_id, order_total) VALUES (1, TO_DATE (NULL),'online',101, NULL) ;

（C）INSERT INTO (SELECT order_id, order date, customer_id FROM orders) VALUES (1, '09-mar-2007",101);

（D）INSERT INTO orders (order id, order_date, order mode, order_total)VALUES (1,'10-mar-2007','online', 1000)

（E）INSERT INTO orders VALUES (1, '09-mar-2007', 'online',' ',1000);

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

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

質問 20

Examine the data in the NEW_EMPLOYEES table:

Examine the data in the EMPLOYEES table:

You want to:
1. Update existing employee details in the EMPLOYEES table with data from the NEW EMPLOYEES table.
2. Add new employee detail from the NEW_ EMPLOYEES able to the EMPLOYEES table.
Which statement will do this:

（A）MERGE INTO employees e
USING new employees ne
ON (e.employee_id = ne.employee_id)
WHEN FOUND THEN
UPDATE SET e.name =ne.name, e.job_id=ne.job_id, e.salary =ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_id,ne.name,ne.job_id,ne.salary) ;

（B）MERGE INTO employees e
USING new_employees n
WHERE e.employee_id = ne.employee_id
WHEN FOUND THEN
UPDATE SET e.name=ne.name,e.job_id =ne.job_id, e.salary=ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_ id,ne.name,ne.job id,ne.salary) ;

（C）MERGE INTO employees e
USING new_employees n
ON (e.employee_id = ne.employee_id)
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name,ne.job_id,ne.salary);

（D）MERGE INTO employees e
USING new employees ne
WHERE e.employee_id = ne.employee_ id
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job_id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name, ne.job_id,ne.salary) ;

正解：C 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験