DBMS CHAPTER2 QUIZ
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
DML standas for
Database Manipulation Language
Data Manupulation Language
Both a and b
None
Which of the following is a DDL command
SELECT
INSERT
CREATE
DELETE
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
Which one of the following sorts rows in SQL?
ALIGN BY
SORT BY
GROUP BY
ORDER BY
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
The NOT NULL constraint enforces a column to not accept null values.
True
False
Which operator is used to search for a specified pattern in a column?
SET
WHERE
LIKE
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
{"name":"DBMS CHAPTER2 QUIZ", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsCovers key topics in SQLImprove your database skills","img":"https:/images/course8.png"}