logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

Which SQL command is used to change data in an existing record?

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

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

  • RELATE
  • LINK
  • CONNECT
  • JOIN
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 statement is used to extract data from a database?

  • GET
  • OPEN
  • EXTRACT
  • SELECT
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 function is used to count the number of rows in a query?

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

What is the result of the SQL statement SELECT 10 / 2;?

  • 2
  • 5
  • 10
  • 20
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 HAVING clause do?

  • Filters groups
  • Filters columns
  • Filters rows
  • Filters tables
Mark for review

What is the SQL command to create a view?

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

  • UNIQUE
  • DISTINCT
  • DIFFERENT
  • DELETE DUPLICATES
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 statement is used to delete data from a database?

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

The SQL WHERE clause is used to:

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

What is the SQL command to create a new table?

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

Which SQL keyword is used to combine two result sets?

  • UNION
  • JOIN
  • MERGE
  • COMBINE
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 result of the SQL statement SELECT 2 + 3;?

  • 2
  • 5
  • 23
  • Error
Mark for review

Which SQL function is used to calculate the sum of a numeric column?

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

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

  • ORDER
  • SORT
  • ARRANGE
  • GROUP
Mark for review

What is a JOIN in SQL?

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

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

  • SELECT all FROM Orders
  • SELECT * FROM Orders
  • SELECT Orders
  • SELECT all_columns FROM Orders
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

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 statement is used to create a new table from an existing table?

  • CREATE TABLE AS
  • CLONE TABLE
  • DUPLICATE TABLE
  • MAKE TABLE FROM
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