最新11g 1Z1-051考試題庫，Oracle 1Z1-051課程的擬真試題下載

問題1
View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query statement:

What would be the outcome of the above statement?

A. It produces an error because the condition on CUST_LAST_NAME is invalid.

B. It executes successfully.

C. It executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null values.

D. It produces an error because the AND operator cannot be used to combine multiple BETWEEN clauses.

正確答案: B

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

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

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

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

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

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

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

正確答案: B,D

說明：（僅 NewDumps 成員可見）

問題3
View the Exhibit and examine the structure of the PROMOTIONS table.

You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?

A. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ALL (SELECT MAX(promo_begin_date) FROM promotions )AND promo_category = 'INTERNET';

B. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ALL (SELECT promo_begin_date FROM promotions WHERE promo_category = 'INTERNET');

C. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date > ANY (SELECT promo_begin_date FROM promotions WHERE promo_category = 'INTERNET');

D. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begin_date IN (SELECT promo_begin_date FROM promotions WHERE promo_category='INTERNET');

正確答案: B

問題4
See the Exhibit and Examine the structure of the CUSTOMERS table:

Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

A. SELECT NVL(cust_credit_limit*.15,'Not Available') "NEW CREDIT" FROM customers;

B. SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT" FROM customers;

C. SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT" FROM customers;

D. SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT" FROM customers;

正確答案: D

說明：（僅 NewDumps 成員可見）

問題5
View the Exhibit; e xamine the structure of the PROMOTIONS table.

Each promotion has a duration of at least seven days.
Your manager has asked you to generate a report, which provides the weekly cost for each promotion done to l date.
Which query would achieve the required result?

A. SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions;

B. SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions;

C. SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions;

D. SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM promotions;

正確答案: B

問題6
View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.

Evaluate the following SQL statements:

Which statement is true regarding the above compound query?

A. It shows products that have a cost recorded irrespective of sales

B. It shows products that were sold and have a cost recorded

C. It reduces an error

D. It shows products that were sold but have no cost recorded

正確答案: D

問題7
View the Exhibit and examine the structure of the CUSTOMERS table.
You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10, 000.
Evaluate the following two queries:

Which statement is true regarding the execution of the above queries?

A. Both execute successfully and give the same result.

B. Only the first query gives the correct result.

C. Only the second query gives the correct result.

D. Both execute successfully but do not give the required result.

正確答案: B

問題8
View the exhibit and examine the description for the SALES and CHANNELS tables.

You issued the following SQL statement to insert a row in the SALES table:
INSERT INTO sales VALUES
(23, 2300, SYSDATE, (SELECT channel_id
FROM channels
WHERE channel_desc='Direct Sales'), 12, 1, 500);
Which statement is true regarding the execution of the above statement?

A. The statement will execute and the new row will be inserted in the SALES table.

B. The statement will fail because the VALUES clause is not required with subquery.

C. The statement will fail because subquery cannot be used in the VALUES clause.

D. The statement will fail because subquery in the VALUES clause is not enclosed with in single quotation marks.

正確答案: A

問題9
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID NUMBER\
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of theDEPARTMENTS table
You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table.
Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)

A. The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.

B. The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.

C. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

D. You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.

E. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.

F. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.

正確答案: A,E

說明：（僅 NewDumps 成員可見）

問題10
View the Exhibit and examine the structure and data in the INVOICE table.
Which two SQL statements would execute successfully? (Choose two.)

A. SELECT AVG(inv_date ) FROM invoice;

B. SELECT MAX(inv_date),MIN(cust_id) FROM invoice;

C. SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice;

D. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt) FROM invoice;

正確答案: B,D

說明：（僅 NewDumps 成員可見）

問題11
View the Exhibit and examine the structure of the PRODUCT, COMPONENT, and PDT_COMP tables.

In PRODUCT table, PDTNO is the primary key.
In COMPONENT table, COMPNO is the primary key.
In PDT_COMP table, (PDTNO,COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in PRODUCT table and COMPNO is the foreign key referencing the COMPNO in COMPONENT table.
You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist.
Evaluate the following query:
SQL>SELECT pdtno,pdtname, compno,compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING(compno)
WHERE compname IS NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct output?

A. JOIN; JOIN

B. LEFT OUTER JOIN; RIGHT OUTER JOIN

C. RIGHT OUTER JOIN; LEFT OUTER JOIN

D. FULL OUTER JOIN; FULL OUTER JOIN

正確答案: C

問題12
Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:

Which two expressions give the same output? (Choose two.)

A. NVL(NULLIF(list_price, min_price), 0)

B. NVL(COALESCE(list_price, min_price), 0)

C. NVL2(COALESCE(list_price, min_price), min_price, 0)

D. COALESCE(NVL2(list_price, list_price, min_price), 0)

正確答案: B,D

說明：（僅 NewDumps 成員可見）

問題13
The DBA issues this SQL command: CREATE USER Scott
IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

A. Only the SELECT privilege.

B. No privileges.

C. All the privileges of a default user.

D. Only the CONNECT privilege.

正確答案: B

說明：（僅 NewDumps 成員可見）

問題14
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which DELETE statement is valid?

A. DELETE * FROM employees WHERE employee_id =(SELECT employee_id FROM new_employees);

B. DELETE FROM employees WHERE employee_id =(SELECT employee_id FROM employees);

C. DELETE * FROM employees WHERE employee_id IN(SELECT employee_id FROM new_employees WHERE last_name = 'Carrey');

D. DELETE FROM employees WHERE employee_id IN(SELECT employee_id FROM new_employees WHERE name = 'Carrey');

正確答案: D

說明：（僅 NewDumps 成員可見）

問題15
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 ' ' cust_credit_limit * 0.50 AS "50% Credit Limit"
FROM customers;

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

正確答案: C

說明：（僅 NewDumps 成員可見）

先試後買

購買之前，你可以先嘗試下載一個試用版本。目前我們只提供PDF版本的試用DEMO，軟件版本只提供截圖。

專業認證

品質保證

輕松通過

Try Before Buy

最新的真實試題

相關鏈接

聯繫我們