[QUIZ] Test Your Understanding of SQL - Part 4

This article presents [QUIZ] Test Your Understanding of SQL - Part 4 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding [QUIZ] Test Your Understanding of SQL

• Question 1: BETWEEN in SQL used to.
  • Specify a column as the primary key.
  • Specify the tables to use.
  • Specify a range to test.
• Question 2: What is the LIKE used with?
  • WHERE clause
  • GROUP BY clause
  • JOIN clause
  • ORDER BY clause
• Question 3: What is the ABS function in SQL used for?
  • Returns the absolute value of the numeric expression.
  • Returns the minimum value of the numeric expression.
  • Returns the maximum value of a numeric expression.
  • Returns the average of a numeric expression.
• Question 4: Where is not a keyword or clause in SQL?
  • INSERT
  • SELECT
  • INVERT
  • UPDATE
• Question 5: What is the right assertion when talking about AS in SQL?
  • The AS clause is only used with the JOIN clause.
  • The AS clause declares a search condition.
  • The AS clause is used to change the name of a column in the result set or to assign a name to a derived column.
• Question 6: Can you use both SQL HAVING and WHERE clauses in the same SQL statement?
  • May
  • Can not
• Question 7: If no ASC or DESC is specified after the ORDER BY clause, which keyword is used by default?
  • ASC
  • DESC
  • DOWN
  • There is no default value.
• Question 8: What is Index in SQL?
  • Is a database table attribute, which helps speed up the search of data in a table.
  • Is a method to join 2 or more tables together.
  • Function similar to Alias
• Question 9: Which element is behind the SELECT statement in SQL?
  • The table name in the database will retrieve the records.
  • List of selected columns or symbols *.
  • JOIN clause.
• Question 9: What does TRANSACTION in SQL have attributes commonly abbreviated as ACID?
  • Access. Consistency. Isolation. Data.
  • Access. Constraint. Index. Data.
  • Atomicity. Consistency. Isolation. Durability.
  1. Atomicity - Conservative 2. Consistency - Consistency 3. Isolation - Independence 4. Durability - Sustainability
• Question 10: Which SQL statement selects all rows from the table named Contest, with ContestDate columns with values greater than or equal to March 25, 2019?
  • SELECT * FROM Contest WHERE ContestDate> = '03/25/2019 '.
  • SELECT * FROM Contest WHERE ContestDate <'03/25/2019 '.
  • SELECT * FROM Contest HAVING ContestDate> = '03/25/2019'.
• Question 12: What is the keyword that determines the sort of result set retrieved in the ORDER BY clause?
  • HIGH and LOW
  • ASC and DESC
  • UP and DOWN
• Question 12: What does SQL mean?
  • Structured Query Language
  • Strong Query Language
  • Standard Query Language
  • Strict Query Language
• Question 14: Which of the following SQL statements is used to select data from 2 or more tables?
  • WHERE
  • JOIN
  • HAVING
• Question 15: Which SQL statement selects all rows from the Products table and sorts the results by ProductID column?
  • SELECT * FROM Products ORDERED BY ProductID.
  • SELECT * FROM Products ORDER BY ProductID.
  • SELECT * FROM Products WHERE ProductID> 200.
  • SELECT ProductID FROM Products