最新的Oracle 1z0-071免費考試真題

問題1

View the Exhibit and examine the structure of the CUSTOMERStable.

CUSTOMER_VUis a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERStable.
CUSTOMERSneed to be updated to reflect the latest information about the customers.
What is the error in the following MERGEstatement?

A. The WHERE clause cannot be used with INSERT.

B. The CUSTOMER_ID column cannot be updated.

C. CUSTOMER_VU cannot be used as a data source.

D. The INTO clause is misplaced in the command.

正確答案: B

問題2

Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

A. SELECT

B. UPDATE

C. ALTER

D. INSERT

E. INDEX

F. DELETE

G. REFERENCES

正確答案: A,B,F

問題3

View the Exhibit and examine the structure of the ORDERStable.

Which UPDATE statement is valid?

A. UPDATE orders
SET order_date = TO_DATE('12-mar-2007','dd-mon-yyyy'), SET order_total = TO_NUMBER (NULL) WHERE order_id = 2455;

B. UPDATE orders
SET order_date = '12-mar-2007',
order_total IS NULL
WHERE order_id = 2455;

C. UPDATE orders
SET order_date = '12-mar-2007',
order_total = NULL
WHERE order_id = 2455;

D. UPDATE orders
SET order_date = '12-mar-2007',
AND order_total = TO_NUMBER(NULL)
WHERE order_id = 2455;

正確答案: C

問題4

Examine the structure and data in the PRICE_LIST table:
name Null Type
------ --------- -------
PROD_ID NOT NULL NUMBER(3)
PROD_PRICE VARCHAR2(10)
PROD_ID PROD_PRICE
---------- ------------
100 $234.55
101 $6,509.75
102 $1,234
You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE.
Which SQL statement would give the required result?

A. SELECT TO_NUMBER(TO_NUMBER(prod_price,'$99,999.99')* .25,'$99,999.00') FROM PRICEJLIST;

B. SELECT TO_CHAR(TO_NUMBER(prod_price)* .25,'$99,999.00') FROM PRICEJLIST;

C. SELECT TO_CHAR(TO_NUMBER(prod_price,'$99,999.99')* .25,'$99,999.00') FROM PRICEJLIST;

D. SELECT TO_CHAR(prod_price* .25,'$99,999.99') FROM PRICEJJST;

正確答案: C

說明：（僅 Fast2test 成員可見）

問題5

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

A. First normal form

B. Third normal form

C. Fourth normal form

D. Second normal form

正確答案: D

問題6

Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level.
Which query would give the required result?

A. SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers

B. SELECT cust_income_level || ` ' || cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers.

C. SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers.

D. SELECT DISTINCT cust_income_level || ` ' || cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers.

正確答案: D

問題7

Which two are true about granting privileges on objects? (Choose two.)

A. A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table.

B. The owner of an object acquires all object privileges on that object by default.

C. An object privilege can be granted to a role only by the owner of that object.

D. The WITH GRANT OPTION clause can be used only by DBA users.

E. An object privilege can be granted to other users only by the owner of that object.

正確答案: A,B

說明：（僅 Fast2test 成員可見）

問題8

Which three are true about privileges? (Choose three.)

A. Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges from other users.

B. Object privileges granted on a table automatically apply to all synonyms for that table.

C. Schema owners can grant any object privilege on any object in their schema to any other user or role.

D. A combination of object and system privileges can be granted to a role.

E. Only users with the DBA role can create roles.

F. All schema objects have associated object privileges.

正確答案: A,B,C

說明：（僅 Fast2test 成員可見）

問題9

View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. (Choose the best answer.)

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?

A. SELECT product_id
FROM product_information
WHERE UPPER(product_name) IN ('LASERPRO', 'CABLE');

B. SELECT product_id, UPPER(product_name)
FROM product_information
WHERE UPPER(product_name) = 'LASERPRO' OR list_price > 1000;

C. SELECT UPPER(product_name)
FROM product_information;

D. SELECT UPPER(product_name)
FROM product_information
WHERE product_id = 2254;

正確答案: A

問題10

Which two statements are true about single-row functions? (Choose two.)

A. MOD: returns the quotient of a division operation

B. FLOOR: returns the smallest integer greater than or equal to a specified number

C. CEIL: can be used for positive and negative numbers

D. CONCAT: can be used to combine any number of values

E. TRUNC: can be used with NUMBER and DATE values

正確答案: A,E

說明：（僅 Fast2test 成員可見）

問題11

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?

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

B. Disable the primary key in the STORES table.

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

D. Use CASCADE keyword with DELETE statement.

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

正確答案: A,C,E

問題12

Which three statements are true regarding the data types?

A. The value for a CHAR data type column is blank-padded to the maximum defined column width.

B. The minimum column width that can be specified for a varchar2 data type column is one.

C. ATIMESTAMP data type column stores only time values with fractional seconds.

D. Only one LONG column can be used per table.

E. The BLOB data type column is used to store binary data in an operating system file.

正確答案: A,B,D

問題13

Which statements are true? (Choose all that apply.)

A. The usernames of all the users including the database administrators are stored in the data dictionary.

B. Both USER_OBJECTS and CAT views provide the same information about all the objects that are owned by the user.

C. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.

D. Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables from the data dictionary

E. The data dictionary views can consist of joins of dictionary base tables and user-defined tables.

F. The data dictionary is created and maintained by the database administrator.

正確答案: A,C,D

問題14

Examine the description of the EMPLOYEES table:

Which two queries will result in an error? (Choose two.)

A.

B.

C.

D.

E.

F.

正確答案: A,B

問題15

View the Exhibit and examine the data in the EMPLOYEES table.
Exhibit

You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:

What is the outcome?

A. It generates an error because the usage of the ROUND function in the expression is not valid.

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

C. It generates an error because the concatenation operator can be used to combine only two items.

D. IT executes successfully and gives the correct output.

E. It generates an error because the alias is not valid.

正確答案: B

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

聯系我們

站內鏈接

最新更新