QUESTION: 33

Examine the structure of the MEMBERS table.

Which query can be used to display the last names and city names only for members from the states MO and MI?

SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';
SELECT last_name, city FROM members WHERE state LIKE 'M%';
SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');
SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state ='MI';

Answer(s): C

Show Answer Next Question

QUESTION: 34

Which statement is true about an inner join specified in a query’s WHERE clause?

It only applies for equijoin conditions.
It applies for equijoin and nonequijoin conditions.
It requires column names to be the same in all tables being joined.
It must have primary-key and foreign-key constraints defined on the join columns.

Answer(s): B

Show Answer Next Question

QUESTION: 35

Which task can be performed by using a single Data Manipulation Language (DML) statement?

adding a column constraint while inserting a row into a table
adding a column with a default value while inserting a row into a table
removing all data only from a single column on which a unique constraint is defined
removing all data only from a single column on which a primary key constraint is defined

Answer(s): C

Show Answer Next Question

QUESTION: 36

Examine the structure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM
BOOKS_TRANSACTIONS;
SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;
SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE"
FROM BOOKS_TRANSACTIONS;
SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

Answer(s): C

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps

QUESTION: 33

QUESTION: 34

QUESTION: 35

QUESTION: 36

1Z0-071 Exam Discussions & Posts