DBMS CHAPTER2 QUIZ

A visually engaging image that depicts various database symbols, SQL command lines, and data elements, creating a tech-savvy atmosphere suitable for a quiz on database management systems.

Master Your DBMS Knowledge

Test your understanding of Database Management Systems with this comprehensive quiz! Designed for students, educators, and professionals, this quiz covers essential concepts in SQL and DML commands.

20 multiple-choice questions
Covers key topics in SQL
Improve your database skills

20 Questions5 MinutesCreated by QueryMaster542

DML standas for

Database Manipulation Language

Data Manupulation Language

Both a and b

None

You can add a row using SQL in a database with which of the following?

ADD

CREATE

INSERT

MAKE

The command to remove rows from a table 'CUSTOMER' is:

REMOVE FROM CUSTOMER ...

DELETE FROM CUSTOMER WHERE ...

UPDATE FROM CUSTOMER ...

DROP FROM CUSTOMER ...

Which of the following is an aggregrate function in SQL?

STDDEV

UNION

INTERSECT

REMOVE

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

SINGLE

DISTINCT

ONLY

ONLY ONE

The SQL statement that queries or reads data from a table is ________ .

SELECT

QUERY

* FROM

REAR

The SQL keyword BETWEEN is used:

To limit the columns displayed.

For ranges.

As a wildcard.

None of the above is correct.

The DMLs which require user to specify what data is needed and how to get it, is called

Non-Procedural

Procedural

DML

Both A and B

Which one of the following aggregate function returns the number of rows?

TOTAL

MAX

COUNT

ALL

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

SELECT * FROM Persons

SELECT FirstName FROM Persons

SELECT FirstName.Persons

None of the above

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT all FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName='Peter

SELECT FirstName WHERE FirstName='Peter'

SELECT * FROM Persons

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" ends with an "a"?

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName = '%a'

SELECT * FROM Persons WHERE FirstName <> '%a

With SQL, how do you select all the records from a table named "Persons" where the marks between (and including) "80" and "90"?

SELECT * FROM Persons WHERE marks BETWEEN 80 AND 90

SELECT * FROM Persons WHERE marks BETWEEN 80 TO 90

SELECT * FROM Persons WHERE marks BETWEEN 80..90

NONE

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

True

False

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons SORT BY FirstName DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons BY FirstName DESC

SELECT * FROM Persons SORT FirstName DESC

Which operator is used to search for a specified pattern in a column?

SET

WHERE

FROM

Which SQL statement is used to create a table in a database?

CREATE DATABASE TABLENAME

CREATE DATABASE TABLE TABLENAME

CREATE TABLENAME

CREATE TABLE TABLENAME

DBMS CHAPTER2 QUIZ

Master Your DBMS Knowledge

More Surveys