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

問題1

You need to display the first names of all customers from the customers table that contain the character 'e' and have the character 'a' in the second last position.
Which query would give the required output?

A. Option B

B. Option D

C. Option C

D. Option A

正確答案: D

說明：（僅 VCESoft 成員可見）

問題2

Examine the structure of the INVOICE table:
Exhibit:

Which two SQL statements would execute successfully? (Choose two.)

A. SELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available')FROM invoice;

B. SELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available')FROM invoice;

C. SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')FROM invoice;

D. SELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate)FROM invoice;

正確答案: C,D

說明：（僅 VCESoft 成員可見）

問題3

Which two statements are true about WHERE and HAVING clauses? (Choose two)

A. A WHERE clause can be used to restrict rows only.

B. A HAVING clause CANNOT be used in sub queries.

C. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.

D. A HAVING clause can be used to restrict both rows and groups.

E. A WHERE clause can be used to restrict both rows and groups.

F. A HAVING clause can be used to restrict groups only.

正確答案: A,F

說明：（僅 VCESoft 成員可見）

問題4

Evaluate the following SQL statements:
Exhibit:

You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization.
Exhibit:

Which two statements are true regarding the above view? (Choose two.)

A. It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in multitable INSERT statements

B. It allows you to delete details of the existing sales staff from the EMPLOYEES table

C. It allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES table

D. It allows you to insert rows into the EMPLOYEES table

正確答案: A,B

問題5

Examine the create table statements for the stores and sales tables.
SQL> CREATE TABLE stores (store_id NUMBER(4)CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12, store_address VARCHAR2(20, start_date DATE); SQL> CREATE TABLE sales (sales_id NUMBER(4)CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4,quantity NUMBER(10), sales_date DATE, store_id NUMBER(4, CONSTRAINT store_id_fk FOREIGN KEY(store_id)REFERENCES stores(store_id)); You executed the following statement:
SQL> DELETE from stores
WHERE store_id=900;
The statement fails due to the integrity constraint error:
ORA-02292: integrity constraint (HR.STORE_ID_FK) violated
Which three options ensure that the statement will execute successfully? (Choose three.)

A. Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.

B. Use CASCADE keyword with DELETE statement.

C. Disable the FOREIGN KEY in SALES table and then delete the rows.

D. DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.

E. Disable the primary key in the STORES table.

正確答案: C,D,E

問題6

You need to create a table named ORDERS that contain four columns:
1 . AN ORDER_ID column of number data type
2 . A CUSTOMER_ID column of number data type
3 . AN ORDER_STATUS column that contains a character data type
4 . A DATE_ORDERED column to contain the date the order was placed.
When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead.
Which statement accomplishes this?

A. CREATE OR REPLACE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

B. CREATE OR REPLACE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

C. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

D. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

E. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status NUMBER (10), date_ordered DATE = SYSDATE);

F. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

正確答案: F

說明：（僅 VCESoft 成員可見）

問題7

Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

A. The WHERE clause can be used to exclude rows before dividing them into groups.

B. The WHERE clause can be used to exclude rows after dividing them into groups.

C. The HAVING clause can be used with aggregate functions in subqueries.

D. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.

E. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.

正確答案: A,C

問題8

You issue the following query:
SQL> SELECT AVG(MAX(qty))
FROM ord_items
GROUP BY item_no
HAVING AVG(MAX(qty))>50;
Which statement is true regarding the outcome of this query?

A. It executes successfully and gives the correct output.

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

C. It gives an error because the GROUP BY expression is not valid.

D. It gives an error because the HAVING clause is not valid.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題9

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

Which two tasks would require subqueries? (Choose two.)

A. Display all suppliers whose list price is less than 1000.

B. Display the number of products whose list price is more than the average list price.

C. Display the minimum list price for each product status.

D. Display the total number of products supplied by supplier 102 and have product status as 'obsolete'.

E. Display all products whose minimum list price is more than the average list price of products and have the status 'orderable'.

正確答案: B,E

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

最新更新

站內鏈接

聯系我們