1. MySQL is ACID compliant False 1. The COUNT, MAX, and MIN functions can be app

Question

1. MySQL is ACID compliant False 1. The COUNT, MAX, and MIN functions can be applied to any datatype. False When selecting data, you should: O Get as much as possible - more is always better o Use GROUP BY clause o Be selective to narrow the results o Join at least three table:s You can only have one subquery within a query 1. 1. False 1. Which of the following is a correct example to remove an index from a table? o DROP INDEX Index.Name ON Column Name DELETE INDEX Index Name ON Table Name RoP INDEx lndexName ON Table Nane O DROP INDEX ON Table Name 1. By issuing the MAX USER_CONNECTIONS 1'limitation on a user account, you are effectively limiting a user's ability to o log in more than once o work efficiently o steal your data o change data 0.25 points QUESTION 41 1. A subquery contains a within al GROUP BWclause WHERE clause HAVING clause SELECT statement

Explanation / Answer

1 Answer) True
2 Answer) True
3 Answer) Be selective to narrow the results
4 Answer) False
5 Answer) DROP INDEX Index_Name ON Table_Name;
6 Answer) log in more than once
7 Answer) SELECT stament, query

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.