1Z0-007無料問題集「Oracle Introduction to Oracle9i: SQL」

質問 1

Examine the data of the EMPLOYEES table.
EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)

Evaluate this SQL statement:
SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary,
m.employee_id "Mgr_id", m.emp_name "Manager"
FROM employees e, employees m
WHERE e.mgr_id = m.employee_id
AND e.salary > 4000;
What is its output?

（A）Option D

（B）Option B

（C）Option C

（D）Option A

正解：B 解答を投票する

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

質問 2

In which two cases would you use an outer join? (Choose two.)

（A）The tables being joined have only unmatched data.

（B）The tables being joined have NOT NULL columns.

（C）The tables being joined have both matched and unmatched data.

（D）The tables being joined have only matched data.

（E）Only when the tables have a primary key/foreign key relationship.

（F）The columns being joined have NULL values.

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

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

質問 3

The STUDENT_GRADES table has these columns
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?

（A）SELECT student_id, gpa
FROM student_grades
WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001'
AND gpa > 3.0;

（B）SELECT student_id, gpa
FROM student_grades
WHERE semester_end > '01-JAN-2001' OR semester_end < '31-DEC-2001' AND gpa >= 3.0;

（C）SELECT student_id, gpa
FROM student_grades
WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001'
AND gpa gt 3.0;

（D）SELECT student_id, gpa
FROM student_grades
WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001'
OR gpa > 3.;

（E）SELECT student_id, gpa
FROM student_grades
WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001'
OR gpa > 3.0;

正解：A 解答を投票する

質問 4

Examine the structure of the EMPLOYEES table:

You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:

Which UPDATE statement meets the requirements?

（A）UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';

（B）UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = &did WHERE employee_id IN (103,115);

（C）UPDATE employees
SET job_id = DEFAULT,
Sal = MAX(sal),
comm_pct = DEFAULT,
department_id = &did
WHERE employee_id IN (103,115)
AND job_id = 'SA_REP';

（D）UPDATE employees
SET job_id = DEFAULT,
Sal = (SELECT MAX(sal)
FROM employees
WHERE job_id = 'SA_REP')
comm_pct = DEFAULT OR NULL,
department_id = &did
WHERE employee_id IN (103,115);

（E）UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal)
FROM employees
WHERE job_id = 'SA_REP'),
comm_pct = DEFAULT,
department_id = &did
WHERE employee_id IN (103,115);

正解：E 解答を投票する

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

質問 5

In which scenario would index be most useful?

（A）The indexed columns are used in the FROM clause.

（B）The indexed column contains a wide range of values.

（C）The indexed columns are part of an expression.

（D）The indexed column is declared as NOT NULL.

正解：B 解答を投票する

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

質問 6

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?

（A）Before the FROM clause

（B）Before the WHERE clause

（C）After the WHERE clause

（D）Immediately after the SELECT clause

（E）After the ORDER BY clause

正解：C 解答を投票する

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

質問 7

Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)

（A）It releases the storage space used by the table.

（B）You can NOT roll back the deletion of rows after the statement executes.

（C）You can roll back the deletion of rows after the statement executes.

（D）An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

（E）It does not release the storage space used by the table.

（F）You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

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

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

質問 8

You need to calculate the total of all salaries in the accounting department. Which group function should you use?

（A）TOTAL

（B）SUM

（C）LARGEST

（D）MAX

（E）MIN

（F）COUNT

正解：B 解答を投票する

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

質問 9

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:

Which statement ensures that a value is displayed in the calculated columns for all employees?

（A）SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

（B）SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;

（C）SELECT last_name, 12*salary* commission_pct FROM emp;

（D）SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

正解：B 解答を投票する

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

質問 10

The CUSTOMERS table has these columns:

The CUSTOMER_ID column is the primary key for the table.
You need to determine how dispersed your customer base is.
Which expression finds the number of different countries represented in the CUSTOMERS table?

（A）COUNT DISTINCT UPPER(country_address)

（B）COUNT(DIFF(UPPER(country_address)))

（C）COUNT(UNIQUE(UPPER(country_address)))

（D）COUNT(DISTINCT (UPPER(country_address)))

（E）COUNT(UPPER(country_address))

正解：D 解答を投票する

1Z0-007 無料問題集「Oracle Introduction to Oracle9i: SQL」

弊社を連絡する

関連リンク

トップ試験