Similar Collections

    No collections found

questions

Title
Which one is not the OPTIONAL Clause in SELECT statement?

Which one is not the OPTIONAL Clause in SELECT statement?

  1. WHERE
  2. ORDER BY
  3. HAVE
  4. HAVING
discuss
Which statement is TRUE about the WHERE Clause?

Which statement is TRUE about the WHERE Clause?

  1. In order to retrieve rows, WHERE Clause is used.
  2. In order to group the rows, WHERE Clause is used.
  3. In order to select the defined groups, WHERE Clause is used.
  4. In order to return the rows, WHERE Clause is used.
discuss
Which statement is TRUE about the GROUP BY Clause?

Which statement is TRUE about the GROUP BY Clause?

  1. In order to retrieve rows, GROUP BY Clause is used.
  2. In order to group the rows that share the same property, GROUP BY Clause is used.
  3. In order to select the defined groups, GROUP BY Clause is used.
  4. In order to return the rows, GROUP BY Clause is used.
discuss
Which statement is TRUE about the HAVING Clause?

Which statement is TRUE about the HAVING Clause?

  1. In order to group the rows, HAVING Clause is used.
  2. In order to return the rows, HAVING Clause is used.
  3. In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
  4. None of the above
discuss
Which statement is TRUE about the ORDER BY Clause?

Which statement is TRUE about the ORDER BY Clause?

  1. In order to return the rows in a specific order, ORDER BY Clause is used.
  2. In order to group the rows, ORDER BY Clause is used.
  3. In order to select the defined groups, ORDER BY Clause is used.
  4. None of the above
discuss
Which of the following clause cannot be optional in SQL SELECT Statement?

Which of the following clause cannot be optional in SQL SELECT Statement?

  1. WHERE
  2. GROUP BY
  3. ORDER BY
  4. None of the above
discuss
Which of the following clause is optional in SQL SELECT Statement?

Which of the following clause is optional in SQL SELECT Statement?

  1. SELECT
  2. FROM
  3. HAVING
  4. None of the above
discuss
Which clause is used to retrieve a unique element from the table?

Which clause is used to retrieve a unique element from the table?

  1. SELECT UNIQUE
  2. SELECT DISTINCT
  3. Both A) and B)
  4. None of the above
discuss
What is the functionality of SQL COUNT?

What is the functionality of SQL COUNT?

  1. It returns the no of record of table
  2. It returns the no of record of database
  3. It returns the no of record of row
  4. It returns the no of record of column
discuss
In SQL SELECT COUNT, one needs to specify the –

In SQL SELECT COUNT, one needs to specify the –

  1. Column Name
  2. Row Name
  3. Table Name
  4. None of the above
discuss
The SELECT TOP statement shows the limited number of:

The SELECT TOP statement shows the limited number of:

  1. Rows
  2. Columns
  3. Tables
  4. None of the above
discuss
Select the correct syntax of SELECT TOP clause?

Select the correct syntax of SELECT TOP clause?

  1. SELECT TOP name
  2. SELECT TOP column
  3. SELECT TOP FROM
  4. SELECT TOP Number
discuss
Using the SQL first() function, one can return the ____ value of the selected column

Using the SQL first() function, one can return the ____ value of the selected column.

  1. First
  2. Second
  3. Third
  4. Last
discuss
Using the SQL last() function, one can return the ______ value of the selected column

Using the SQL last() function, one can return the ______ value of the selected column.

  1. First
  2. Second
  3. Third
  4. Last
discuss
Using SQL SELECT RANDOM() function, one can return the random –

Using SQL SELECT RANDOM() function, one can return the random –

  1. Table
  2. Database
  3. Row
  4. Column
discuss
In order to assign a random name to a column or table, which SQL SELECT Clause is used?

In order to assign a random name to a column or table, which SQL SELECT Clause is used?

  1. FROM
  2. WHERE
  3. HAVING
  4. AS
discuss
Which function combines the two different columns?

Which function combines the two different columns?

  1. ADD
  2. MERGE
  3. CONCAT
  4. None of the above
discuss
What is the difference between HAVING and WHERE clause?

What is the difference between HAVING and WHERE clause?

  1. HAVING clause is used in column operation whereas WHERE clause is used in row operation.
  2. HAVING clause is post-filter whereas WHERE clause is pre-filter.
  3. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.
  4. All of the above
discuss
What is the difference between MIN and MAX function?

What is the difference between MIN and MAX function?

  1. MIN function is used to show the minimum data and MAX function is used to show the maximum data.
  2. MIN function is used to show the maximum data and MAX function is used to show the minimum data.
  3. Both of the above
  4. None of the above
discuss
In order to sort the records according to the columns, which clause is used?

In order to sort the records according to the columns, which clause is used?

  1. HAVING
  2. GROUP BY
  3. ORDER BY
  4. None of the above
discuss
total MCQs: 30

MCQs

30

Views

205

Best Answers

299

Points

5