Create Next App

Exam contains 267 questions

Page 10 of 45

Question 55 🔥

Which three statements are true about multiple row subqueries? (Choose three.)

Which database solution meets these requirements?

A. Two or more values are always returned from the subquery.

Highly voted

B. They can contain HAVING clauses.

Highly voted

C. They can contain GROUP BY clauses.

Highly voted

D. They can return multiple columns.

Highly voted

E. They cannot contain a subquery.

Highly voted

Discussion of the question

Question 56 🔥

Which three actions can you perform on an existing table containing data? (Choose three.)

Which database solution meets these requirements?

A. Increase the width of a numeric column.

Highly voted

B. Add a new column as the table's first column.

Highly voted

C. Define a default value that is automatically inserted into a column containing nulls.

Highly voted

D. Change a DATE column containing data to a NUMBER data type.

Highly voted

E. Change the default value of a column.

Highly voted

F. Add a new NOT NULL column with a DEFAULT value.

Highly voted

Discussion of the question

Question 57 🔥

Which two statements are true about selecting related rows from two tables based on an Entity Relationship Diagram (ERD)? (Choose two.)

Which database solution meets these requirements?

A. Rows from unrelated tables cannot be joined.

Highly voted

B. Relating data from a table with data from the same table is implemented with a self join.

Highly voted

C. Implementing a relationship between two tables might require joining additional tables.

Highly voted

D. Every relationship between the two tables must be implemented in a join condition.

Highly voted

E. An inner join relates rows within the same table.

Highly voted

Discussion of the question

Question 58 🔥

Which three statements about roles are true? (Choose three.)

Which database solution meets these requirements?

A. Roles are assigned to users using the ALTER USER statement.

Highly voted

B. Privileges are assigned to a role using the GRANT statement.

Highly voted

C. A role is a named group of related privileges that can only be assigned to a user.

Highly voted

D. A single user can be assigned multiple roles.

Highly voted

E. Privileges are assigned to a role using the ALTER ROLE statement.

Highly voted

F. Roles are assigned to roles using the ALTER ROLE statement.

Highly voted

G. A single role can be assigned to multiple users.

Highly voted

Discussion of the question

Question 59 🔥

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.NLS_DATE_FORMAT is set to DD-MON-RR.Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

Which database solution meets these requirements?

A. invoice_date = '15-march-2019' : uses implicit conversion

Highly voted

B. qty_sold BETWEEN '101' AND '110' : uses implicit conversion

Highly voted

C. invoice_date > '01-02-2019' : uses implicit conversion

Highly voted

D. qty_sold = '0554982' : requires explicit conversion

Highly voted

E. CONCAT (qty_sold, invoice_date) : requires explicit conversion

Highly voted

Discussion of the question

Question 60 🔥

Examine the description of the PROMOTIONS table:You want to display the unique promotion costs in each promotion category.Which two queries can be used? (Choose two.)

Which database solution meets these requirements?

A. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;

Highly voted

B. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;

Highly voted

C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Highly voted

D. SELECT promo_category DISTINCT promo_cost, FROM promotions ORDER BY 2;

Highly voted

E. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_071

Exam contains 267 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us