Free 1Z0-071 Exam Braindumps

View the Exhibit and examine the data in the PRODUCTS table. (Choose the best answer.)

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:
SQL > SELECT prod_name, prod_category, prod_min_price FROM products
Where prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR prod_min_price = 4000) AND prod_unit_of_measure <> ' ';
Which statement is true?

1. A. It executes successfully but returns no result.
2. B. It executes successfully and returns the required result.
3. C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
4. D. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.

Correct Answer: A

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?

1. A. SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date> ALL (SELECT MAX (promo_begin_date)FROM promotions) ANDpromo_category= ‘INTERNET’;
2. B. SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE promo_category= ‘INTERNET’);
3. C. SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE promo_category = ‘INTERNET’);
4. D. SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date> ANY (SELECT promo_begin_dateFROM promotionsWHERE promo_category= ‘INTERNET’);

Correct Answer: C

Examine the structure of the PROGRAMS table:

Which two SQL statements would execute successfully?

1. A. SELECT NVL (ADD_MONTHS (END_DATE,1) SYSDATE) FROM programs;
2. B. SELECT TO_DATE (NVL (SYSDATE-END_DATE, SYSDATE)) FROM programs;
3. C. SELECT NVL (MONTHS_BETWEEN (start_date, end_date), ‘Ongoing’) FROM programs;
4. D. SELECT NVL (TO_CHAR (MONTHS_BETWEEN (start-date, end_date)), ‘Ongoing’) FROMprograms

Correct Answer: AD

Which three statements are true about the ALTER TABLE....DROP COLUMN.... command?

1. A. A column can be dropped only if it does not contain any data.
2. B. A column can be dropped only if another column exists in the table.
3. C. A dropped column can be rolled back.
4. D. The column in a composite PRIMARY KEY with the CASCADE option can be dropped.
5. E. A parent key column in the table cannot be dropped.

Correct Answer: BDE

Examine the types and examples of relationship that follows: (Choose the best answer.)
1 One-to-one a) teacher to Student
2 One-to-many b) Employees to Manager
3 Many-to-one c) Person to SSN
4 Many-to-many d) Customers to Products
Which option indicates correctly matched relationships?

1. A. 1-d, 2-b, 3-a, and 4-c
2. B. 1-c, 2-d, 3-a, and 4-b
3. C. 1-a, 2-b, 3-c, and 4-d
4. D. 1-c, 2-a, 3-b, and 4-d

Correct Answer: C