logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

Which SQL statement is used to extract data from a database?

  • GET
  • OPEN
  • EXTRACT
  • SELECT
Mark for review

Which SQL keyword is used to combine two result sets?

  • UNION
  • JOIN
  • MERGE
  • COMBINE
Mark for review

Which SQL statement is used to create an index?

  • CREATE INDEX
  • ADD INDEX
  • NEW INDEX
  • MAKE INDEX
Mark for review

Which SQL clause is used to specify the condition for grouping rows?

  • GROUP BY
  • ORDER BY
  • HAVING
  • WHERE
Mark for review

What is the SQL command to create a new database?

  • CREATE DATABASE
  • ADD DATABASE
  • NEW DATABASE
  • MAKE DATABASE
Mark for review

What is the purpose of the SQL COALESCE function?

  • Returns the first non-null value
  • Counts non-null values
  • Returns the sum of values
  • Returns the last non-null value
Mark for review

What is the result of the SQL statement SELECT 2 + 3;?

  • 2
  • 5
  • 23
  • Error
Mark for review

What does the SQL MIN() function do?

  • Returns the maximum value
  • Returns the minimum value
  • Returns the average value
  • Returns the sum of values
Mark for review

What does the SQL ALTER TABLE command do?

  • Changes the table structure
  • Deletes the table
  • Creates a new table
  • Inserts data into a table
Mark for review

Which SQL keyword is used to create a relationship between tables?

  • RELATE
  • LINK
  • CONNECT
  • JOIN
Mark for review

Which SQL function is used to count non-NULL values in a column?

  • COUNT()
  • COUNT(*)
  • COUNT(column)
  • COUNT NOT NULL
Mark for review

Which type of join returns all rows when there is a match in either table?

  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL OUTER JOIN
Mark for review

What is the purpose of the SQL IS NULL operator?

  • Filters rows that are null
  • Filters rows that are not null
  • Filters columns that are null
  • Filters columns that are not null
Mark for review

Which SQL clause is used to group rows that have the same values?

  • GROUP BY
  • ORDER BY
  • SORT BY
  • COLLECT BY
Mark for review

What is the SQL command to create a new table?

  • CREATE TABLE
  • ADD TABLE
  • NEW TABLE
  • MAKE TABLE
Mark for review

What does the SQL BETWEEN operator do?

  • Matches a pattern
  • Filters data within a range
  • Selects records if any conditions are met
  • Inserts data into a table
Mark for review

What does the SQL IN operator do?

  • Matches a pattern
  • Selects columns
  • Selects records if any conditions are met
  • Inserts data into a table
Mark for review

Which command is used to remove a table and all its data from the database?

  • DROP TABLE
  • DELETE TABLE
  • ERASE TABLE
  • CLEAR TABLE
Mark for review

Which SQL statement is used to remove privileges from a user?

  • REMOVE
  • REVOKE
  • DELETE PRIVILEGE
  • DISALLOW
Mark for review

Which SQL keyword is used to sort the result-set?

  • ORDER
  • SORT
  • ARRANGE
  • GROUP
Mark for review

Which SQL keyword is used to retrieve a unique record?

  • SELECT DISTINCT
  • SELECT UNIQUE
  • SELECT DIFFERENT
  • SELECT ONLY
Mark for review

What is the default sorting order in SQL?

  • Ascending
  • Descending
  • Random
  • None
Mark for review

The SQL WHERE clause is used to:

  • Select columns
  • Filter records
  • Join tables
  • Group results
Mark for review

Which SQL function is used to round a number to the nearest integer?

  • ROUND()
  • FLOOR()
  • CEIL()
  • TRUNCATE()
Mark for review

How do you select all the columns from a table named "Users"?

  • SELECT all FROM Users
  • SELECT * FROM Users
  • SELECT Users
  • SELECT all_columns FROM Users
Mark for review

What is the purpose of the SQL LIMIT clause?

  • Limits the columns returned
  • Limits the rows returned
  • Limits the data size
  • Limits the query execution time
Mark for review

Which SQL function is used to count the number of rows in a query?

  • COUNT()
  • SUM()
  • TOTAL()
  • NUMBER()
Mark for review

Which SQL function returns the current date?

  • NOW()
  • CURRENT_DATE()
  • GETDATE()
  • SYSDATE()
Mark for review

What does the SQL LIKE operator do?

  • Matches a pattern
  • Selects columns
  • Selects records if all conditions are met
  • Inserts data into a table
Mark for review

Which SQL statement is used to extract data from multiple tables?

  • SELECT FROM
  • SELECT JOIN
  • SELECT MERGE
  • SELECT UNION
Mark for review

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session