最新的Oracle PL/SQL Developer Certified Associate認證 1z1-071考試題庫

問題1

Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)

A. DELETE and TRUNCATE can be used on a table that is a parent of a referential integrity constraint having ON DELETE rule.

B. DELETE can be used toremove data from specific columns as well as complete rows.

C. DELETE can be used toremove only rows from multiple tables at a time.

D. DELETE can be used only on a table that is a parent of a referential integrity constraint.

E. DELETE can be used toremove only rows from only one table at a time.

正確答案: A,E

說明：（僅 VCESoft 成員可見）

問題2

View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.

You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or
1 in the ORDERS table.
Which two DELETE statements are valid (Choose two.)

A. DELETE FROM order_items i
WHERE order_id = (SELECT order_id FROM orders o
WHERE i.order_id = o.order_id AND order_status IN (0,1));

B. DELETE
* FROM order_items
WHERE order_id IN (SELECT order_id)
FROM orders
WHERE order_status IN (0,1));

C. DELETE
FROM (SELECT * FROM order_items I,orders o
WHERE i.order_id = o.order_id AND order_status IN (0,1));

D. DELETE
FROM order_items
WHERE order_id IN (SELECT order_id
FROM orders
WHERE orders_status in (0,1));

正確答案: C,D

問題3

Which three statements are true regarding the WHEREand HAVINGclauses in a SQL statement?
(Choose three.)

A. The HAVINGclause conditions can use aliases for the columns.

B. The HAVINGclause conditions can have aggregate functions.

C. WHEREand HAVINGclauses cannot be used together in a SQL statement.

D. The HAVINGclause is used to exclude one or more aggregated results after grouping data.

E. The WHEREclause is used to exclude rows before the grouping of data.

正確答案: C,D,E

問題4

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. SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, `e')<>0 AND
SUBSTR(cust_first_name, -2, 1)='a';

B. SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, `e')IS NOT NULL AND
SUBSTR(cust_first_name, 1, -2)='a';

C. SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, `e')<>0 AND
SUBSTR(cust_first_name, LENGTH(cust_first_name), -2)='a';

D. SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, `e')<>'' AND
SUBSTR(cust_first_name, -2, 1)='a';

正確答案: A

問題5

Examine this query:

Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)

A. Store the query in a script and pass the substitution value to the script when executing it.

B. Use the UNDEFINE command before executing the query.

C. Execute the SET VERIFY ON command before executing the query.

D. Use the DEFINE command before executing the query.

E. Replace `&1' with `&&1' in the query.

F. Execute the SET VERIFY OFF command before executing the query.

正確答案: A,D

問題6

Which two commands execute successfully? (Choose two.)
- MANAGER is an existing role with no privileges or roles.
- EMP is an existing role containing the CREATE TABLEprivilege.
- EMPLOYEES is an existing table in the HR schema.

A. GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;

B. GRANT CREATE SEQUENCE TO manager, emp;

C. GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;

D. GRANT CREATE TABLE, SELECT ON hr.employees TO manager;

E. GRANT CREATE TABLE, emp TP manager;

正確答案: B,C

問題7

Examine this statement:

What is returned upon execution?

A. an error

B. 2 rows

C. 0 rows

D. 1 row

正確答案: D

問題8

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

A. A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

B. A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.

C. A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.

D. A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parent table must have the same names.

E. PRIMARY KEY and FOREIGN KEY constraints can be specified at the column and at the table level.

F. NOT NULL can be specified at the column and at the table level.

正確答案: A,E

問題9

Examine the data in the CUSTOMERStable:

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:

Which two JOIN options can be used in the blank in the above query to give the correct output?
(Choose two.)

A. FULL OUTER JOIN

B. LEFT OUTER JOIN

C. JOIN

D. NATURAL JOIN

E. RIGHT OUTER JOIN

正確答案: C,E

問題10

In your session, the NLS_DATE_FORMATis DD-MM-YYYY.
There are 86400 seconds in a day.
Examine this result:
DATE
-----------
02-JAN-2020
Which statement returns this?

A. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

B. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

C. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '86410' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

D. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

E. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

正確答案: B

問題11

Which statement is true about TRUNCATE and DELETE?

A. You can DELETE rows from a table with referential integrity constraints.

B. You can never TRUNCATE a table if foreign key constraints will be violated.

C. For tables with multiple indexes and triggers, DELETE is faster than TRUNCATE.

D. For large tables, DELETE is faster than TRUNCATE.

正確答案: B

說明：（僅 VCESoft 成員可見）

問題12

In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained a query? (Choose two.)

A. PROMO_BEGIN_DATE ?5 will return a date.

B. TO_NUMBER(PROMO_BEGIN_DATE) ?5 will return a number.

C. PROMO_BEGIN_DATE ?SYSDATE will return an error.

D. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.

E. PROMO_BEGIN_DATE ?SYSDATE will return a number.

正確答案: D,E

問題13

Evaluate the following SQL query;

What would be the outcome?

A. 100

B. 150

C. 200

D. 16

E. 160

正確答案: E

說明：（僅 VCESoft 成員可見）

問題14

Which two statements are true regarding working with dates? (Choose two.)

A. The RR date format automatically calculates the century from the SYSDATE function and does not allow a session user to enter the century.

B. The default internal storage of dates is in character format.

C. The RR date format automatically calculates the century from the SYSDATE function but allows the session user to enter the century.

D. The default internal storage of dates is in numeric format.

正確答案: C,D

最新的Oracle Database SQL - 1z1-071免費考試真題

最新更新

站內鏈接

聯系我們