1Z1-051試験無料問題集（254題）「Oracle Database: SQL Fundamentals I 認定」

出題：1

Examine the structure of the TRANSACTIONS table:
Name Null Type
TRANS_ID NOT NULL NUMBER(3)
CUST_NAME VARCHAR2(30)
TRANS_DATE DATE
TRANS_AMT NUMBER(10,2)
You want to display the transaction date and specify whether it is a weekday or weekend.
Evaluate the following two queries:

Which statement is true regarding the above queries?

A. Both give the correct result.

B. Both give wrong results.

C. Only the first query gives the correct result.

D. Only the second query gives the correct result.

正解：C 解答を投票する

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

出題：2

Evaluate the following query:

What would be the outcome of the above query?

A. It produces an error because the data types are not matching.

B. It executes successfully and introduces an 's at the end of each promo_name in the output.

C. It executes successfully and displays the literal" {'s start date was} " for each row in theoutput.

D. It produces an error because flower braces have been used.

正解：B 解答を投票する

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

出題：3

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

A. SELECT TO_CHAR(1890.55,'$9,999D99') FROM DUAL;

B. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;

C. SELECT TO_CHAR(1890.55,'$99G999D99') FROM DUAL;

D. SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL;

E. SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;

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

出題：4

Which two statements complete a transaction? (Choose two)

A. GRANT SELECT ON employees TO SCOTT;

B. DELETE employees;

C. DESCRIBE employees;

D. Select MAX(sal)FROM employeesWHERE department_id = 20;

E. ALTER TABLE employeesSET UNUSED COLUMN sal;

F. ROLLBACK TO SAVEPOINT C;

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

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

出題：5

Which two statements are true about constraints? (Choose two.)

A. The UNIQUE constraint does not permit a null value for the column.

B. The NOT NULL constraint ensures that null values are not permitted for the column.

C. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

D. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

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

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

出題：6

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cus_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

A. INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer_id FROM customers WHERE cust_last_iiame='Roberts' AND credit_limit=600).order_total)
VALUES(l.'10-mar-2007\ 'direct'. &customer_id. 1000):

B. INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer id FROM customers WHERE cust_last_iiame='Roberts' AND redit_limit=600).order_total) VALUES(L'10-mar-2007'. 'direct', &&customer_id, 1000):

C. INSERT INTO orders VALUES (l.'10-mar-2007\ 'direct'. (SELECT customerid FROM customers WHERE cust_last_iiame='Roberts' AND credit_limit=600). 1000);

D. INSERT INTO(SELECT o.order_id. o.order_date.o.order_modex.customer_id. o.ordertotal FROM orders o. customers c WHERE o.customer_id = c.customerid AND c.cust_la$t_name-RoberTs' ANDc.credit_liinit=600) VALUES (L'10-mar-2007\ 'direct'.( SELECT customer_id FROM customers WHERE cust_last_iiame='Roberts' AND credit_limit=600). 1000);

正解：C 解答を投票する

出題：7

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

Examine the data in the ENAME and HIREDATE columns of the EMPLOYEES table: ENAME HIREDATE
SMITH 17-DEC-80 ALLEN 20-FEB-81 WARD 22-FEB-81
You want to generate a list of user IDs as follows:
USERID
Smi17DEC80
All20FEB81
War22FEB81
You issue the following query:
SQL>SELECT CONCAT(SUBSTR(INITCAP(ename),1,3), REPLACE(hiredate,'-')) "USERID"
FROM employees;
What is the outcome?

A. It executes successfully and gives the correct output.

B. It generates an error because the REPLACE function is not valid.

C. It generates an error because the SUBSTR function cannot be nested in the CONCAT function.

D. It executes successfully but does not give the correct output.

正解：A 解答を投票する

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

出題：8

View the Exhibit and examine the structure of the PROMOTIONS table.
Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV' and 'internet' that ended in the time interval 15th March '00 to 15th October '00. Which two queries would give the required result? (Choose two.)

A. SELECT promo_name, promo_cost FROM promotions WHERE promo_category IN ('TV', 'internet') AND promo_end_date BETWEEN '15-MAR-00' AND '15-OCT-00';

B. SELECT promo_name, promo_cost FROM promotions WHERE (promo_category BETWEEN 'TV' AND 'internet') AND (promo_end_date IN ('15-MAR-00','15-OCT-00'));

C. SELECT promo_name, promo_cost FROM promotions WHERE (promo_category = 'TV' OR promo_category ='internet') AND (promo_end_date >='15MAR-00'AND promo_end_date <='15-OCT-00');

D. SELECT promo_name, promo_cost FROM promotions WHERE promo_category = 'TV' OR promo_category ='internet' AND promo_end_date >='15MAR-00' ORpromo_end_date <='15-OCT-00';

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

出題：9

Which two statements are true regarding single row functions? (Choose two.)

A. They always return a single result row for every row of a queried table

B. They can be nested only to two levels

C. They can return a data type value different from the one that is referenced

D. Arguments can only be column values or constant

E. They accept only a single argument

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

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

出題：10

The PRODUCTS table has these columns:
PRODUCT_ID NUMBER(4)
PRODUCT_NAME VARCHAR2(45)
PRICE NUMBER(8,2)
Evaluate this SQL statement:
SELECT *
FROM PRODUCTS
ORDER BY price, product_name;
What is true about the SQL statement?

A. The results are sorted numerically and then alphabetically.

B. The results are sorted alphabetically.

C. The results are not sorted.

D. The results are sorted numerically.

正解：A 解答を投票する

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

出題：11

SLS is a private synonym for the SH.SALES table.
The user SH issues the following command:
DROP SYNONYM sls;
Which statement is true regarding the above SQL statement?

A. The synonym would be dropped and any PUBLIC synonym with the same name becomes invalid.

B. Only the synonym would be dropped.

C. The synonym would be dropped and the packages referring to the synonym would be dropped.

D. The synonym would be dropped and the corresponding table would become invalid.

正解：B 解答を投票する

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

出題：12

View the Exhibit and examine the structure of the PROMOTIONS table.
You need to generate a report of all promos from the PROMOTIONS table based on the following conditions:
1.The promo name should not begin with 'T' or 'N'.
2.The promo should cost more than $20000.
3.The promo should have ended after 1st January 2001.
Which WHERE clause would give the required result?

A. WHERE (promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%')OR promo_cost > 20000 OR promo_end_date > '1-JAN-01'

B. WHERE promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01'

C. WHERE promo_name NOT LIKE 'T%' OR promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01'

D. WHERE (promo_name NOT LIKE '%T%' OR promo_name NOT LIKE '%N%') AND(promo_cost > 20000 AND promo_end_date > '1-JAN-01')

正解：B 解答を投票する

1Z1-051試験無料問題集「Oracle Database: SQL Fundamentals I 認定」