MySQL-5-Certified-Associate-(1Z0-870).pdf - Oracle 1Z0-870 MySQL 5 Certified Associate http\/killexams.com\/exam-detail\/1Z0-870 Answer B QUESTION 222

MySQL-5-Certified-Associate-(1Z0-870).pdf - Oracle 1Z0-870...

This preview shows page 1 - 4 out of 8 pages.

1Z0-870 Oracle MySQL 5 Certified Associate
Image of page 1
Answer: B QUESTION: 222 Identify whether the given statement is true or false. "The IN operator cannot be used in a condition that involves an outer join." A. False B. True Answer: B QUESTION: 223 Identify whether the given statement is true or false. "The GROUP BY clause must use column names, as column aliases cannot be used in it." A. True B. False Answer: A QUESTION: 224 Which of the following can be used to calculate the number of joins? A. Add the number of tables used in a query and then multiply the total by 1. B. Add the number of tables used in a query and then add 1 to the total. C. Add the number of tables used in a query and then divide the total by 1. D. Add the number of tables used in a query and then subtract 1 from the total. Answer: D QUESTION: 225 All of the following are operators used in MySQL except for which one? 85
Image of page 2
A. Linear B. Comparison C. Arithmetic D. Sort Answer: A QUESTION: 226 Inner join is also known as ________ join.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '20
  • Database transaction, following functions, A. Atomicity, a. SAVEPOINT

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture