最新的Oracle Database認證 1z1-061考試題庫

問題1

A SELECT statement can be used to perform these three functions:
Which set of keywords describes these capabilities?

A. difference, projection, join

B. selection, projection, join

C. difference, projection, product

D. selection, intersection, join

E. intersection, projection, join

正確答案: B

說明：（僅 VCESoft 成員可見）

問題2

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

A. You have too many columns in your tables.

B. Your tables have difficult names.

C. You have too many tables.

D. You want to work on your own tables.

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

F. Your tables names are too long.

正確答案: B,F

說明：（僅 VCESoft 成員可見）

問題3

Which three are true? (Choose three.)

A. A MERGE statement can be used to update existing rows in a table.

B. A MERGE statement can be used to insert new rows into a table.

C. A MERGE statement is used to merge the data of one table with data from another.

D. A MERGE statement replaces the data of one table with that of another.

正確答案: A,B,C

說明：（僅 VCESoft 成員可見）

問題4

View the Exhibit and examine the structure of the PRODUCTS, SALES, and
SALE_SUMMARY tables.
SALE_VW is a view created using the following command:
SQL>CREATE VIEW sale_vw AS
SELECT prod_id, SUM(quantity_sold) QTY_SOLD
FROM sales GROUP BY prod_id;
You issue the following command to add a row to the SALE_SUMMARY table:
SQL>INSERT INTO sale_summary
SELECT prod_id, prod_name, qty_sold FROM sale_vw JOIN products
USING (prod_id) WHERE prod_id = 16;
What is the outcome?

A. It executes successfully.

B. It gives an error because a complex view cannot be used to add data into the SALE_SUMMARY table.

C. It gives an error because the number of columns to be inserted does not match with the number of columns in the SALE_SUMMARY table.

D. It gives an error because the column names in the subquery and the SALE_SUMMARY table do not match.

正確答案: C

問題5

You need to calculate the number of days from 1st Jan 2007 till date.
Dates are stored in the default format of dd-mon-rr.
Which two SQL statements would give the required output? (Choose two.)

A. SELECT TO_DATE (SYSDATE, 'DD/MONTH/YYYY')-'01/JANUARY/2007' FROM
DUAL;

B. SELECT SYSDATE - TO_DATE ('01-JANUARY-2007') FROM DUAL;

C. SELECT SYSDATE - '01-JAN-2007' FROM DUAL;

D. SELECT SYSDATE - TO_DATE ('01/JANUARY/2007') FROM DUAL;

E. SELECT TO_CHAR (SYSDATE, 'DD-MON-YYYY')-'01-JAN-2007' FROM DUAL;

正確答案: B,D

問題6

EMPLOYEES and DEPARTMENTS data:
EMPLOYEES

DEPARTMENTS

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID.
On the DEPARTMENTS table DEPARTMENT_ID is the primary key.
Evaluate this UPDATE statement.
UPDATE employees
SET mgr_id
. (SELECT mgr_id
. FROM. employees
. WHERE dept_id
. (SELECT department_id
. FROM departments
. WHERE department_name = 'Administration')),
. Salary = (SELECT salary
. . FROM employees
. . WHERE emp_name = 'Smith')
WHERE job_id = 'IT_ADMIN';
What happens when the statement is executed?

A. The statement fails because there is more than one row matching the employee name Smith.

B. The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.

C. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.

D. The statement fails because there is no 'Administration' department in the DEPARTMENTS table.

E. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.

F. The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題7

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

Using the products table, you issue the following query to generate the names, current list price, and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it.

The query generates an error. What is the reason for the error?

A. The double quotation marks should be removed from the column alias.

B. The parenthesis should be added to enclose the entire expression.

C. The column alias should be put in uppercase and enclosed within double quotation marks in the where clause.

D. The column alias should be replaced with the expression in the where clause.

正確答案: D

問題8

The CUSTOMERS table has these columns:

A promotional sale is being advertised to the customers in France.
Which WHERE clause identifies customers that are located in France?

A. WHERE lower(country_address) = 'france'

B. WHERE lower(country_address) LIKE %france%

C. WHERE lower(country_address) = "france"

D. WHERE lower(country_address) = '%france%'

E. WHERE lower(country_address) IS 'france'

正確答案: A

說明：（僅 VCESoft 成員可見）

問題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. A report is produced that matches the first report produced.

B. You are prompted to enter a new value.

C. An error is returned.

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

正確答案: A

說明：（僅 VCESoft 成員可見）

問題10

View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

A. It returns an error because WHERE and HAVING clauses cannot be used to apply conditions on the same column.

B. It returns an error because the BETWEEN operator cannot be used in the HAVING clause.

C. It executes successfully.

D. It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statement.

正確答案: C

最新的Oracle Database 12c: SQL Fundamentals - 1z1-061免費考試真題

最新更新

站內鏈接

聯系我們