logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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

  • ORDER
  • SORT
  • ARRANGE
  • GROUP
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 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

What is the SQL command to create a view?

  • CREATE VIEW
  • ADD VIEW
  • NEW VIEW
  • MAKE VIEW
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 SQL keyword is used to remove duplicate records from a result set?

  • UNIQUE
  • DISTINCT
  • DIFFERENT
  • DELETE DUPLICATES
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

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

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

What is the default sorting order in SQL?

  • Ascending
  • Descending
  • Random
  • None
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 command is used to change data in an existing record?

  • MODIFY
  • CHANGE
  • UPDATE
  • SAVE
Mark for review

Which SQL keyword is used to add a new column to an existing table?

  • ADD COLUMN
  • NEW COLUMN
  • INSERT COLUMN
  • ALTER TABLE ADD
Mark for review

What does SQL stand for?

  • Structured Query Language
  • Structured Question Language
  • Simple Query Language
  • Simple Question Language
Mark for review

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

  • REMOVE
  • DELETE
  • CLEAR
  • ERASE
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

What does the SQL HAVING clause do?

  • Filters groups
  • Filters columns
  • Filters rows
  • Filters tables
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

What is a JOIN in SQL?

  • Combining data from multiple tables
  • Summing up data
  • Filtering data
  • Sorting data
Mark for review

What does the SQL CASE statement do?

  • Switches the result set based on a condition
  • Joins tables
  • Groups data
  • Sorts data
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

Which SQL statement is used to update data in a database?

  • MODIFY
  • CHANGE
  • UPDATE
  • SAVE
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

What is a primary key in SQL?

  • A unique identifier for a record
  • A duplicate identifier for a record
  • An index key
  • A foreign key
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 function is used to round a number to the nearest integer?

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

Which SQL statement is used to modify the structure of an existing table?

  • MODIFY TABLE
  • UPDATE TABLE
  • ALTER TABLE
  • CHANGE TABLE
Mark for review

Which SQL statement is used to insert new data into a database?

  • ADD
  • INSERT
  • INCLUDE
  • APPEND
Mark for review

Which SQL keyword is used to combine two result sets?

  • UNION
  • JOIN
  • MERGE
  • COMBINE
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 SQL command to create a new database?

  • CREATE DATABASE
  • ADD DATABASE
  • NEW DATABASE
  • MAKE DATABASE
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