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

質問 1

Examine these statements executed in a single Oracle session:
CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20));
INSERT INTO product VALUES(1,'pen');
INSERT INTO product VALUES (2,'pencil');
INSERT INTO product VALUES(3,'fountain pen');
SAVEPOINT a;
UPDATE product SET pcode=10 WHERE pcode =1;
COMMIT;
DELETE FROM product WHERE pcode =2;
SAVEPOINT b;
UPDATE product SET pcode=30 WHERE pcode =3;
SAVEPOINT c;
DELETE FROM product WHERE pcode =10;
ROLLBACK TO SAVEPOINT b;
COMMIT;
Which three statements are true?

（A）The code for fountain pen is 3

（B）There is no row containing pen

（C）The code for pen is 10.

（D）There is no row containing pencil.

（E）There is no row containing fountain pen.

（F）The code for pen is 1.

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

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

質問 2

Examine the description of the CUSTOMERS table:

You need to display last names and credit limits of all customers whose last name starts with A or B In lower or upper case, and whose credit limit is below 1000.
Examine this partial query:
SELECT cust_last_nare, cust_credit_limit FROM customers
Which two WHERE conditions give the required result?

（A）WHERE (INITCAP(cust_last_name) LIKE 'A%' OR ITITCAP(cust_last_name) LIKE 'B%') AND cust_credit_limit < 1000

（B）WHERE (UPPER(cust_last_name) LIKE 'A%' OR UPPER(cust_last_name) LIKE 'B%') AND ROUND(cust_credit_limit) < 1000;

（C）WHERE (UPPER(cust_last_name) like INITCAP ('A') OR UPPER(cust_last_name) like INITCAP('B')) AND ROUND(cust_credit_limit) < ROUND(1000) ;

（D）WHERE UPPER(cust_last_name) IN ('A%', 'B%') AND cust_credit_limit < 1000:

（E）WHERE UPPER(cust_last_name) BETWEEN UPPER('A%' AND 'B%') AND ROUND(cust_credit_limit) < 1000;

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

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

質問 3

Which three are true about scalar subquery expressions?

（A）They cannot be used in the values clause of an insert statement*

（B）They cannot be used in group by clauses.

（C）A scalar subquery expression that returns zero rows evaluates to zoro

（D）They can be used as default values for columns in a create table statement.

（E）A scalar subquery expression that returns zero rows evaluates to null.

（F）They can be nested.

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

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

質問 4

Examine this list of queries:
Which two statements are true?

（A）2 returns the value 20.

（B）1 and 4 give different results.

（C）3 returns an error.

（D）2 and 3 give the same result.

（E）1 and 4 give the same result.

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

質問 5

Which three are true about privileges and roles?

（A）A role can contain a combination of several privileges and roles.

（B）PUBLIC can be revoked from a user.

（C）All roles are owned by the SYS schema.

（D）A role is owned by the user who created it.

（E）A user has all object privileges for every object in their schema by default.

（F）PUBLIC acts as a default role granted to every user in a database

（G）System privileges always set privileges for an entire database.

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

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

質問 6

Which three statements are true regarding single row subqueries?

（A）They must be placed on the right side of the comparison operator or condition.

（B）They can be used in the clause.

（C）They must be placed on the left side of the comparison operator or condition.

（D）They must return a row to prevent errors in the SQL statement.

（E）They can be used in the HAVING clause.

（F）A SQL statement may have multiple single row subquery blocks.

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

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

質問 7

Examine the description of the CUSTOMERS table:
Which three statements will do an implicit conversion?

（A）SELECT * FROM customers WHERE insert_date'01-JAN-19';

（B）SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';

（C）SELECT * FROM customers WHERE customer_id=0001;

（D）SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';

（E）SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';

（F）SELECT * FROM customers WHERE customer_id='0001';

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

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

質問 8

You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table:
1. SELECT
2. INSERT
3. UPDATE
4. DELETE
You connect to the database instance an perform an update to some of the rows in EMPLOYEE_RECORDS, but don't commit yet.
Andrew connects to the database instance and queries the table
No othet user are accessing the table
Which two statements ate true at this point?

（A）Andrew will be unable to see the changes you have made

（B）Andrew will be able to SELECT from the table, but be unable to modify any existing rows.

（C）Andrew will be able to modify any rows in the table that have not been modified by your transaction

（D）Andrew will be unable to perform any INSERT, UPDATE of DELETE on the teble

（E）Andrew will be able to see the changes you habe made

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

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

質問 9

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 メンバーにのみ表示されます)

質問 10

Examine the description of the EMPLOYEES table:

The session time zone is the same as the database server
Which two statements will list only the employees who have been working with the company for more than five years?

（A）SELECT employee_ name FROM employees WHERE (CUNACV_ DATE - hire_ data / 12> 3

（B）SELECT employee_ name FROM employees WHERE (SYSNAYW - hire_ data / 12> 3

（C）SELECT employee_ name FROM employees WHERE (CUARENT_ DATE - hire_ data / 365>5

（D）SELECT employee_ name FROM employees WHERE (SYSDATE - hire_ data) / 365>5

（E）There are typos in this option (CUNACV_DATE should be CURRENT_DATE and hire_data should be hire_date). Additionally, dividing by 12 incorrectly assumes that a month is equivalent to a year.

（F）SELECT employee_ name FROM employees WHERE (SYSNAYW - hire_ data / 12> 3

（G）SELECT employee_ name FROM employees WHERE (SYSTIMESTAMP - hire_ data) / 365>

正解：D 解答を投票する

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

質問 11

Examine the description of the PRODUCT_INFORMATION table:

（A）SELECT count(nvl( list_price,0)) FROM product_information WHERE list_price is null;

（B）SELECT (COUNT(list_price) FROM Product_intormation WHERE list_price=NULL;

（C）SELECT COUNT(DISTINCT list_price) FROM product_information WHERE list_price is null.

（D）BELECT COUNT(list_price) FROM product_information where list_price is NULL;

正解：A 解答を投票する

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

質問 12

Which two are true?

（A）CONCAT joins two or more character strings together.

（B）INSTR finds the offset within a character string, starting from position 0.

（C）CONCAT joins two character strings together.

（D）FLOOR returns the largest positive integer less than or equal to a specified number.

（E）INSTR finds the offset within a string of a single character only.

（F）FLOOR returns the largest integer less than or equal to a specified number.

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

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

質問 13

Examine this statement,which executes successfully:
In which order are the rows displayed?

（A）sorted by DEPARTMENT_NAME and AVGSAL

（B）sorted by DEPARTMENT_NAME

（C）Sorted by MAXSAL

（D）sorted by DEPARTMENT_NAME and MAXSAL

（E）sorted by AVGSAL

正解：A 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験