QUESTION: 69

Which three statements are true regarding group functions? (Choose three.)

They can be used on columns or expressions.
They can be passed as an argument to another group function.
They can be used only with a SQL statement that has the GROUP BY clause.
They can be used on only one column in the SELECT clause of a SQL statement.
They can be used along with the single-row function in the SELECT clause of a SQL statement.

Answer(s): A,B,E

Reference:

https://www.safaribooksonline.com/library/view/mastering-oracle-sql/0596006322/ch04.html

Show Answer Next Question

QUESTION: 70

Which three statements are true? (Choose three.)

The data dictionary is created and maintained by the database administrator.
The data dictionary views consist of joins of dictionary base tables and user-defined tables.
The usernames of all the users including database administrators are stored in the data dictionary.
The USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.
Both USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.
Views with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.

Answer(s): C,D,F

Reference:

https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm

Show Answer Next Question

QUESTION: 71

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.

Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

It displays prod IDs in the promo with the lowest cost.
It displays prod IDs in the promos with the lowest cost in the same time interval.
It displays prod IDs in the promos with the highest cost in the same time interval.
It displays prod IDs in the promos which cost less than the highest cost in the same time interval.

Answer(s): D

Show Answer Next Question

View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.

Which SQL statement would you execute to accomplish the task?

UPDATE dept d
SET city = ALL (SELECT city
FROM locations 1
WHERE d.location_id = l.location_id);
UPDATE dept d
SET city = (SELECT city
FROM locations 1)
WHERE d.location_id = l.location_id;
UPDATE dept d
SET city = ANY (SELECT city
FROM locations 1)
UPDATE dept d
SET city = (SELECT city
FROM locations 1
WHERE d.location_id = 1.location_id);

Answer(s): D

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps (page: 30)

QUESTION: 69

Reference:

QUESTION: 70

Reference:

QUESTION: 71

QUESTION: 72

1Z0-071 Exam Discussions & Posts