Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
1z0-071
Free trial
By oracle
Verified
25Q per page
Question 51
Examine this query:
What is the result?
- A: an error
- B: no rows
- C: 1 row
- D: 3 rows
- E: 6 rows
- F: 8 rows
—
Question 52
Which two object privileges can be restricted to a subset of columns in a table? (Choose two.)
- A: INDEX
- B: ALTER
- C: UPDATE
- D: INSERT
- E: DELETE
—
Question 53
Examine the description of the BOOKS table:
Examine these requirements:
- Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.
- Sort the titles by date of purchase, starting with the most recently purchased book.
Which two queries can be used? (Choose two.)
- A:
- B:
- C:
- D:
- E:
—
Question 54
View the Exhibit and examine the description of the tables.
You execute this SQL statement:
Which three statements are true? (Choose three.)
- A: The statement will execute successfully and a new row will be inserted into the SALES table.
- B: A product can have a different unit price at different times.
- C: The statement will fail if a row already exists in the SALES table for product 23.
- D: The statement will fail because a subquery may not be contained in a VALUES clause.
- E: A customer can exist in many countries.
- F: The SALES table has five foreign keys.
—
That’s the end of your free questions
You’ve reached the preview limit for 1z0-071Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!