최신 1Z1-051 무료덤프 - Oracle Database: SQL Fundamentals I

문제1

View the Exhibit and examine the data in the PRODUCTS table. You need to display product names from the PRODUCTS table that belong to the 'Software/Other1 category with minimum prices as either $2000 or $4000 and no unit of measure. You issue thej following query:

Which statement is true regarding the above query?

A. It executes successfully and returns the required result.

B. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

C. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.

D. It executes successfully but returns no result.

정답: D

문제2

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

A. DELETE can be used to remove data from specific columns as well as complete rows.

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

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

D. DELETE can be used to remove only rows from multiple tables at a time.

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

정답: C,E

설명: (DumpTOP 회원만 볼 수 있음)

문제3

View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTIONS table, and the required output format.

Which two queries give the correct result? (Choose two.)

A. SELECT promo_name, TRIM(TO_CHAR(promo_end_date,'Day')) ', ' TRIM(TO_CHAR
(promo_end_date,'Month')) ' '
TRIM(TO_CHAR(promo_end_date,'DD, YYYY')) AS last_day
FROM promotions;

B. SELECT promo_name,TO_CHAR (promo_end_date,'fxDay') ', '
TO_CHAR(promo_end_date,'fxMonth') ' '
TO_CHAR(promo_end_date,'fxDD, YYYY') AS last_day
FROM promotions;

C. SELECT promo_name, TO_CHAR(promo_end_date,'Day') ', '
TO_CHAR(promo_end_date,'Month') ' '
TO_CHAR(promo_end_date,'DD, YYYY') AS last_day
FROM promotions;

D. SELECTpromo_name,TO_CHAR(promo_end_date,'fmDay')','
TO_CHAR(promo_end_date,'fmMonth') ' '
TO_CHAR(promo_end_date,'fmDD, YYYY') AS last_day
FROM promotions;

정답: A,D

문제4

Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10,40)
ORDER BY dept_name; The statement fails when executed. Which change fixes the error?

A. remove the table alias from the SELECT clause

B. remove the table alias prefix from the WHERE clause

C. replace the condition
"d.department_id NOT IN (10,40)"
in the WHERE clause with
"d.department_id <> 10 AND d.department_id <> 40"

D. prefix the column in the ORDER BY clause with the table alias

E. prefix the column in the USING clause with the table alias

F. remove the ORDER BY clause

정답: A,D

설명: (DumpTOP 회원만 볼 수 있음)

문제5

Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure?
(Choose all that apply.)

A. You cannot use SYSDATE in the condition of a CHECK constraint.

B. You cannot use the BETWEEN clause in the condition of a CHECK constraint.

C. You cannot use the NEXTVAL sequence value as a DEFAULT value for a column.

D. You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD NO is also the FOREIGN KEY.

정답: A,C

설명: (DumpTOP 회원만 볼 수 있음)

문제6

Which CREATE TABLE statement is valid?

A. CREATE TABLE ord_details
(ord_no NUMBER(2),
item_no NUMBER(3),
ord_date DATE DEFAULT SYSDATE NOT NULL,
CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));

B. CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date DATE NOT NULL);

C. CREATE TABLE ord_details
(ord_no NUMBER(2) ,
item_no NUMBER(3),
ord_date DATE DEFAULT NOT NULL,
CONSTRAINT ord_uq UNIQUE (ord_no),
CONSTRAINT ord_pk PRIMARY KEY (ord_no));

D. CREATE TABLE ord_details
(ord_no NUMBER(2) UNIQUE, NOT NULL,
item_no NUMBER(3),
ord_date DATE DEFAULT SYSDATE NOT NULL);

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제7

Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

A. &&

B. PROMPT

C. &

D. ACCEPT

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제8

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

A. finding the remainder of a division

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

C. comparing two expressions to check whether they are equal

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

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

정답: A,C,D

문제9

Which four are types of functions available in SQL? (Choose 4)

A. conversion

B. translation

C. date

D. character

E. numeric

F. integer

G. calendar

H. string

정답: A,C,D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제10

Which is an iSQL*Plus command?

A. UPDATE

B. RENAME

C. INSERT

D. DELETE

E. SELECT

F. DESCRIBE

정답: F

설명: (DumpTOP 회원만 볼 수 있음)

문제11

Which object privileges can be granted on a view?

A. none

B. DELETE, INSERT,SELECT

C. DELETE, INSERT, SELECT, UPDATE

D. ALTER, DELETE, INSERT, SELECT

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제12

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. Only the second query gives the correct result.

B. Both execute successfully and give the same result.

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

D. Only the first query gives the correct result.

정답: D

문제13

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.
Evaluate the following two queries:
SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code"
FROM promotions
ORDER BY code;
SQL>SELECT DISTINCT promo_category promo_cost "code"
FROM promotions
ORDER BY 1;
Which statement is true regarding the execution of the above queries?

A. Only the first query executes successfully.

B. Both queries execute successfully and give the same result.

C. Only the second query executes successfully.

D. Both queries execute successfully but give different results.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제14

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?
-SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth
"of" Month YYYY fmHH:MI:SS AM') NEW_DATE
FROM dual;
-SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth
"of" Month YYYY fmHH:MI:SS AM') NEW_DATE
FROM dual;
-SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY
HH:MI:SS AM') NEW_DATE FROM dual; TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM') NEW_DATE FROM dual;

A. SELECT

정답: A

문제15

Evaluate the following SQL query; What would be the outcome?

A. 100

B. 160

C. 150

D. 16

E. 200

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제16

Examine the following SQL commands:

Which statement is true regarding the execution of the above SQL commands?

A. Both commands execute successfully.

B. The second CREATE TABLE command generates an error because the CHECK constraint is not valid.

C. The first CREATE TABLE command generates an error because the column PROD_ID cannot be used in the PRIMARY KEY and FOREIGN KEY constraints.

D. The first CREATE TABLE command generates an error because the NULL constraint is not
valid.

E. The first CREATE TABLE command generates an error because CHECK and PRIMARY KEY constraints cannot be used for the same column.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

최신 1Z1-051 무료덤프 - Oracle Database: SQL Fundamentals I

우리와 연락하기

유용한 링크

최신 업데이트