最新的11g認證 1Z0-051考試題庫

問題1

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

問題2

View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.)

A. CREATE VIEW v4 AS SELECT prod_id, cust_id, SUM(quantity_sold) FROM SALES WHERE time_id <= SYSDATE - 2*365 GROUP BY prod_id, cust_id WITH CHECK OPTION;

B. CREATE VIEW v1 AS SELECT * FROM SALES WHERE time_id <= SYSDATE - 2*365 WITH CHECK OPTION;

C. CREATE VIEW v3 AS SELECT * FROM SALES WHERE cust_id = 2034 WITH CHECK OPTION;

D. CREATE VIEW v2 AS SELECT prod_id, cust_id, time_id FROM SALES WHERE time_id <= SYSDATE - 2*365 WITH CHECK OPTION;

正確答案: B,C

說明：（僅 VCESoft 成員可見）

問題3

You need to create a table for a banking application. One of the columns in the table has the following requirements:
You want a column in the table to store the duration of the credit period
The data in the column should be stored in a format such that it can be easily added and subtracted with DATE data type without using conversion The maximum period of the credit provision in the application is 30 days the interest has to be calculated for the number of days an individual has taken a credit for
Which data type would you use for such a column in the table?

A. DATE

B. TIMESTAMP

C. INTERVAL YEAR TO MONTH

D. INTERVAL DAY TO SECOND

E. NUMBER

正確答案: D

問題4

Which two statements are true regarding constraints? (Choose two.)

A. All constraints can be defined at the column level as well as the table level

B. A constraint can be disabled even if the constraint column contains data

C. A columns with the UNIQUE constraint can contain NULL values

D. A constraint is enforced only for the INSERT operation on a table

E. A foreign key cannot contain NULL values

正確答案: B,C

問題5

Which statement is true regarding the INTERSECT operator?

A. It ignores NULL values

B. The number of columns and data types must be identical for all SELECT statements in the query

C. The names of columns in all SELECT statements must be identical

D. Reversing the order of the intersected tables the result

正確答案: B

說明：（僅 VCESoft 成員可見）

問題6

Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.)

A. removing trailing, leading, and embedded characters from a character string

B. finding the remainder of a division

C. comparing two expressions to check whether they are equal

D. checking whether a specified character exists in a given string

E. adding a number to a date for a resultant date value

正確答案: B,C,D

問題7

The PRODUCTS table has the following structure:

Evaluate the following two SQL statements:

Which statement is true regarding the outcome?

A. Both the statements execute and give the same result

B. Only the first SQL statement executes successfully

C. Both the statements execute and give different results

D. Only the second SQL statement executes successfully

正確答案: C

說明：（僅 VCESoft 成員可見）

問題8

Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to extract only those customer names that have three names and display the * symbol in place of the
first name as follows:
CUST NAME
*** De Haan
**** Manuel Urman
Which two queries give the required output? (Choose two.)

A. SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*')
"CUST NAME" FROM customers
WHERE INSTR(cust_name, ' ',1,2)<>0;

B. SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*')
"CUST NAME" FROM customers
WHERE INSTR(cust_name, ' ',-1,2)<>0;

C. SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name)-
INSTR(cust_name,''),'*') "CUST NAME"
FROM customers
WHERE INSTR(cust_name, ' ',-1,-2)<>0;

D. SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name)-
INSTR(cust_name,' '),'*') "CUST NAME"
FROM customers
WHERE INSTR(cust_name, ' ',1,2)<>0 ;

正確答案: A,B

問題9

You need to display the date ll-oct-2007 in words as "Eleventh of October, Two Thousand Seven'. Which SQL statement would give the required result?

A. SELECT TO_DATE(TO_CHAR('ll-oct-20077fiiiDdspth "of" Month. Year')) FROM DUAL:

B. SELECT TO_CHAR(TO_DATE('ll-oct-2007'X 'miDdspth of month, year') FROM DUAL;

C. SELECT TO_CHAR('ll-oct-2007'. 'miDdspth "of Month. Year') FROM DUAL:

D. SELECT TO_CHAR(TO_DATE('ll-oct-2007'), 'miDdthsp "of* Month. Year') FROM DUAL;

正確答案: C

問題10

You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit

Using the PROMOTIONS table, you need to display the names of all promos done after January 1, 2001 starting with the latest promo.
Which query would give the required result? (Choose all that apply.)

A. SELECT promo_name,promo_begin_date
FROM promotions
WHERE promo_begin_date > '01-JAN-01'
ORDER BY 2 DESC;

B. SELECT promo_name,promo_begin_date "START DATE"
FROM promotions
WHERE promo_begin_date > '01-JAN-01'
ORDER BY "START DATE" DESC;

C. SELECT promo_name,promo_begin_date
FROM promotions
WHERE promo_begin_date > '01-JAN-01'
ORDER BY promo_name DESC;

D. SELECT promo_name,promo_begin_date
FROM promotions
WHERE promo_begin_date > '01-JAN-01'
ORDER BY 1 DESC;

正確答案: A,B

問題11

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?

A. SELECT &1, "&2"
FROM &3
WHERE last_name = '&4';

B. SELECT &1, '&2'
FROM EMP
WHERE last_name = '&4';

C. SELECT &1, &2
FROM &3
WHERE last_name = '&4';

D. SELECT &1, '&2'
FROM &3
WHERE '&last_name = '&4' ';

正確答案: C

說明：（僅 VCESoft 成員可見）

問題12

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? (Choose three.)

A. INSERT INTO employees VALUES ( 1000, 'John', NULL);

B. INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');

C. INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');

D. INSERT INTO employees (employee_id) VALUES (1000);

E. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');

F. INSERT INTO employees VALUES ( NULL, 'John', 'Smith');

正確答案: A,D,E

說明：（僅 VCESoft 成員可見）

問題13

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

There is only one customer with the CUST_LAST_NAME column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

A. INSERT INTO orders (order_id,order_date,order_mode,
(SELECT customer_id
FROM customers
WHERE cust_last_name='Roberts' AND
credit_limit=600),order_total)
VALUES(1,'10-mar-2007', 'direct', &customer_id, 1000);

B. INSERT INTO orders (order_id,order_date,order_mode, (SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600),order_total) VALUES(1,'10-mar-2007', 'direct', &&customer_id, 1000);

C. INSERT INTO orders VALUES (1,'10-mar-2007', 'direct', (SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);

D. INSERT INTO(SELECT o.order_id, o.order_date,o.order_mode,c.customer_id, o.order_total FROM orders o, customers c WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' ANDc.credit_limit=600 ) VALUES (1,'10-mar-2007', 'direct',(SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);

正確答案: C

問題14

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

The PROJ_TASK_DETAILS table stores information about tasks involved in a project and the relation between them.
The BASED_ON column indicates dependencies between tasks. Some tasks do not depend on the completion of any other tasks.
You need to generate a report showing all task IDs, the corresponding task ID they are dependent on, and the name of the employee in charge of the task it depends on.
Which query would give the required result?

A. SELECT p.task_id, p.based_on, d.task_in_charge FROM proj_task_details p JOIN proj_task_details d ON (p.task_id = d.task_id);

B. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p FULL OUTER JOIN proj_task_details d ON (p.based_on =
d.task_id);

C. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p LEFT OUTER JOIN proj_task_details d ON (p.based_on =
d.task_id);

D. SELECT p.task_id, p.based_on, d.task_in_charge FROM proj_task_details p JOIN proj_task_details d ON (p.based_on = d.task_id);

正確答案: C

問題15

Which object privileges can be granted on a view?

A. ALTER, DELETE, INSERT, SELECT

B. DELETE, INSERT,SELECT

C. none

D. DELETE, INSERT, SELECT, UPDATE

正確答案: D

說明：（僅 VCESoft 成員可見）

最新的Oracle Database: SQL Fundamentals I - 1Z0-051免費考試真題

最新更新

站內鏈接

聯系我們