1Z0-061 Free Practice Test

- (Topic 4)
What is true about updates through a view?

1. A. You cannot update a view with group functions.
2. B. When you update a view group functions are automatically computed.
3. C. When you update a view only the constraints on the underlying table will be in effect.
4. D. When you update a view the constraints on the views always override the constraints on the underlying tables.

Correct Answer: A

- (Topic 2)
Which statement correctly describes SQL and /SQL*Plus?

1. A. Both SQL and /SQL*plus allow manipulation of values in the database.
2. B. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
3. C. /SQL*Plus is a language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
4. D. SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database.

Correct Answer: A

- (Topic 3)
Which two statements are true regarding the USING clause in table joins? (Choose two.)

1. A. It can be used to join a maximum of three tables.
2. B. It can be used to restrict the number of columns used in a NATURAL join.
3. C. It can be used to access data from tables through equijoins as well as nonequijoins.
4. D. It can be used to join tables that have columns with the same name and compatible data types.

Correct Answer: BD
NATURAL JOIN operation
A NATURAL JOIN is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined. Common columns are columns that have the same name in both tables.
If the SELECT statement in which the NATURAL JOIN operation appears has an asterisk (*) in the select list, the asterisk will be expanded to the following list of columns (in this order):
All the common columns
Every column in the first (left) table that is not a common column Every column in the second (right) table that is not a common column
An asterisk qualified by a table name (for example, COUNTRIES.*) will be expanded to every column of that table that is not a common column.
If a common column is referenced without being qualified by a table name, the column reference points to the column in the first (left) table if the join is an INNER JOIN or a LEFT OUTER JOIN. If it is a RIGHT OUTER JOIN, unqualified references to a common column point to the column in the second (right) table.
Syntax
TableExpression NATURAL [ { LEFT | RIGHT } [ OUTER ] | INNER ] JOIN {
TableViewOrFunctionExpression | ( TableExpression ) }
Examples
If the tables COUNTRIES and CITIES have two common columns named COUNTRY and COUNTRY_ISO_CODE, the following two SELECT statements are equivalent:
SELECT * FROM COUNTRIES NATURAL JOIN CITIES SELECT * FROM COUNTRIES JOIN CITIES
USING (COUNTRY, COUNTRY_ISO_CODE)

- (Topic 2)
Which statement is true regarding synonyms?

1. A. Synonyms can be created only for a table
2. B. Synonyms are used to reference only those tables that are owned by another user
3. C. The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid
4. D. A public synonym and a private synonym can exist with the same name for the same table

Correct Answer: D

- (Topic 1)
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.
< ><>>< >

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: CD