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

ページ: 1 / 15
トータル 254 問

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

出題：1

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.
Evaluate the following two queries:
SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code"
FROM promotions
ORDER BY code;
SQL>SELECT DISTINCT promo_category promo_cost "code"
FROM promotions
ORDER BY 1;
Which statement is true regarding the execution of the above queries?

A. Only the second query executes successfully.

B. Only the first query executes successfully.

C. Both queries execute successfully but give different results.

D. Both queries execute successfully and give the same result.

正解：A 解答を投票する

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

出題：2

You own a table called EMPLOYEES with this table structure:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
What happens when you execute this DELETE statement?
DELETE employees;

A. You get an error because of a primary key violation.

B. You get an error because the statement is not syntactically correct.

C. The data in the EMPLOYEES table is deleted but not the structure.

D. The data and structure of the EMPLOYEES table are deleted.

正解：C 解答を投票する

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

出題：3

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

出題：4

The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?

A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_' ESCAPE '\';

D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\";

正解：C 解答を投票する

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

出題：5

View the Exhibit and examine the structure of the PRODUCT, COMPONENT, and PDT_COMP tables.

In PRODUCT table, PDTNO is the primary key.
In COMPONENT table, COMPNO is the primary key.
In PDT_COMP table, (PDTNO,COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in PRODUCT table and COMPNO is the foreign key referencing the COMPNO in COMPONENT table.
You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist.
Evaluate the following query:
SQL>SELECT pdtno,pdtname, compno,compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING(compno)
WHERE compname IS NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct output?

A. LEFT OUTER JOIN; RIGHT OUTER JOIN

B. JOIN; JOIN

C. FULL OUTER JOIN; FULL OUTER JOIN

D. RIGHT OUTER JOIN; LEFT OUTER JOIN

正解：D 解答を投票する

出題：6

Which statement is true regarding the UNION operator?

A. By default, the output is not sorted

B. The number of columns selected in all SELECT statements need to be the same

C. NULL values are not ignored during duplicate checking

D. Names of all columns must be identical across all SELECT statements

正解：C 解答を投票する

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

出題：7

Examine the statement:
Create synonym emp for hr.employees;
What happens when you issue the statement?

A. You will have two identical tables in the HR schema with different names.

B. You create a table called employees in the HR schema based on you EMP table.

C. You create an alternative name for the employees table in the HR schema in your own schema.

D. An error is generated.

正解：C 解答を投票する

出題：8

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

出題：9

Examine this statement:
SELECT student_id, gpa FROM student_grades WHERE gpa > &&value;
You run the statement once, and when prompted you enter a value of 2.0. A report is produced.
What happens when you run the statement a second time?

A. You are asked whether you want a new value or if you want to run the report based on the previous value.

B. An error is returned.

C. You are prompted to enter a new value.

D. A report is produced that matches the first report produced.

正解：D 解答を投票する

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

出題：10

Which statement correctly describes SQL and /SQL*Plus?

A. SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database.

B. Both SQL and /SQL*plus allow manipulation of values in the database.

C. /SQL*Plus is a language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

D. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

正解：B 解答を投票する

出題：11

The PRODUCTS table has the following structure:

Evaluate the following two SQL statements:

Which statement is true regarding the outcome?

A. Only the first SQL statement executes successfully

B. Both the statements execute and give different results

C. Only the second SQL statement executes successfully

D. Both the statements execute and give the same result

正解：B 解答を投票する

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

出題：12

The following data exists in the PRODUCTS table:
PROD_ID PROD_LIST_PRICE
123456 152525.99
You issue the following query:
SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')
FROM products
WHERE prod_id = 123456; What would be the outcome?

A. 152526****

B. **152525.99

C. 152525**

D. an error message

正解：A 解答を投票する

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

出題：13

View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTIONS table, and the required output format.

Which two queries give the correct result? (Choose two.)

A. SELECT promo_name, TO_CHAR(promo_end_date,'Day') ', '
TO_CHAR(promo_end_date,'Month') ' '
TO_CHAR(promo_end_date,'DD, YYYY') AS last_day
FROM promotions;

B. SELECT promo_name,TO_CHAR (promo_end_date,'fxDay') ', '
TO_CHAR(promo_end_date,'fxMonth') ' '
TO_CHAR(promo_end_date,'fxDD, YYYY') AS last_day
FROM promotions;

C. SELECT promo_name, TRIM(TO_CHAR(promo_end_date,'Day')) ', ' TRIM(TO_CHAR
(promo_end_date,'Month')) ' '
TRIM(TO_CHAR(promo_end_date,'DD, YYYY')) AS last_day
FROM promotions;

D. SELECTpromo_name,TO_CHAR(promo_end_date,'fmDay')','
TO_CHAR(promo_end_date,'fmMonth') ' '
TO_CHAR(promo_end_date,'fmDD, YYYY') AS last_day
FROM promotions;

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

出題：14

Which SQL statement returns a numeric value?

A. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;

B. SELECT TO_NUMBER(hire_date + 7) FROM EMP;

C. SELECT ROUND(hire_date) FROM EMP;

D. SELECT sysdate-hire_date FROM EMP;

正解：D 解答を投票する

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

出題：15

You need to display the date 11-Oct-2007 in words as 'Eleventh of October, Two Thousand Seven'. Which SQL statement would give the required result?

A. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL;

B. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdspth of month, year') FROM DUAL;

C. SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year') FROM DUAL;

D. SELECT TO_DATE(TO_CHAR('11-oct-2007','fmDdspth ''of'' Month, Year')) FROM DUAL;

正解：A 解答を投票する

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

出題：16

What are two reasons to create synonyms? (Choose two.)

A. Your tables names are too long.

B. You want to work on your own tables.

C. You want to use another schema's tables.

D. You have too many columns in your tables.

E. You have too many tables.

F. Your tables have difficult names.

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

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

出題：17

You work as a database administrator at ABC.com. You study the exhibit carefully and examine the structure of CUSTOMRS AND SALES tables.

Evaluate the following SQL statement:
Exhibit:

Which statement is true regarding the execution of the above UPDATE statement?

A. It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement

B. It would not execute because the SELECT statement cannot be used in place of the table name

C. It would execute and restrict modifications to only the column specified in the SELECT statement

D. It would not execute because two tables cannot be used in a single UPDATE statement

正解：C 解答を投票する

出題：18

Where can sub queries be used? (Choose all that apply)

A. field names in the SELECT statement

B. the FROM clause in the SELECT statement

C. the WHERE clause in only the SELECT statement

D. the GROUP BY clause in the SELECT statement

E. the HAVING clause in the SELECT statement

F. the WHERE clause in SELECT as well as all DML statements

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

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

ページ: 1 / 15
トータル 254 問

1Z1-051 の機能をすべて解除する

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

完全版を入手する

弊社のサイトにはあなたの試験合格を助けるために研究された効果的な知能問題集を提供しています。材料はすべてのユーザーによって称賛されています。弊社のサイトは、最短時間で多くの証明書を取得するのに役立つ学習プラットフォームになります。

掲示板

試験FAAA_005 トピック1 問題6 スレッド
試験1Z0-1122-25 トピック4 問題10 スレッド
試験1Z0-997-JPN トピック8 問題31 スレッド
試験1z0-915-1 トピック5 問題12 スレッド
試験SIE トピック4 問題108 スレッド
試験SC-300J トピック2 問題94 スレッド
試験1z0-915-1 トピック9 問題66 スレッド

弊社を連絡する

我々の働いている時間：( UTC+9 ) 9:00-24:00

月曜日から土曜日まで

サポート：現在連絡

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