Database Fundamentals Quiz
Database Fundamentals Quiz
Test your knowledge of database fundamentals with our comprehensive quiz! Covering a variety of essential topics, you'll assess your skills in SQL, database management, and data manipulation commands.
Key features of this quiz include:
- 36 challenging questions
- Multiple choice format
- Immediate scoring
1. What is SQL Server?
A) SQL Server is a relational database management system
B) SQL Server is a software whose main purpose is to store and retrieve data
C) SQL Server is a highly secure server and does not allow any database file manipulation during execution
Which Is The Subset Of SQL Commands Used To Manipulate Database Structures, Including Tables?
Data Manipulation Language(DML)
Data Definition Language(DDL)
Both
In SQL, Which Command(s) Is(are) Used To Change A Table's Storage Characteristics?
MODIFY TABLE
CHANGE TABLE
ALTER TABLE
All Of The Above
In SQL, Which Command Is Used To SELECT Only One Copy Of Each Set Of Duplicable Rows
SELECT DISTINCT
SELECT UNIQUE
SELECT DIFFERENT
Which Of The SQL Statements Is Correct?
SELECT Username, Password WHERE Username = 'user1'
SELECT Username AND Password FROM Users
SELECT Username, Password FROM Users
None Of These
Which Of The Following Is Illegal?
SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
SELECT SYSDATE - SYSDATE FROM DUAL;
SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
None Of These
Which Of The Following Is NOT A Type Of SQL Constraint?
PRIMARY KEY
ALTERNATE KEY
UNIQUE
FOREIGN KEY
What SQL Command Can Be Used To Delete Columns From A Table?
MODIFY TABLE TableName DROP ColumnName
MODIFY TABLE TableName DROP COLUMN ColumnName
ALTER TABLE TableName DROP ColumnName
ALTER TABLE TableName DROP COLUMN ColumnName
A Subquery In An SQL SELECT Statement Is Enclosed In:
Brackets -- [...].
Parenthesis -- (...).
Braces -- {...}.
CAPITAL LETTERS.
Which Operator Performs Pattern Matching?
LIKE Operator
BETWEEN Operator
EXISTS Operator
None Of These
Which Of The Following Is A SQL Aggregate Function?
AVG
LEFT
JOIN
LEN
The SQL WHERE Clause:
Limits The Row Data Are Returned
Limits The Column Data That Are Returned.
Both A And B Are Correct.
Neither A Nor B Are Correct.
What is the full form of SQL?
Structured Query List
Structure Query Language
Sample Query Language
None of these.
Which of the following is not a valid SQL type?
FLOAT
NUMERIC
DECIMAL
CHARACTER
Which of the following is not a DDL command?
TRUNCATE
ALTER
CREATE
UPDATE
How many Primary keys can have in a table?
Only 1
Only 2
Depends on no of Columns
Depends on DBA
Which data manipulation command is used to combines the records from one or more tables?
SELECT
PROJECT
JOIN
PRODUCT
Which operator is used to compare a value to a specified list of values?
ANY
BETWEEN
ALL
IN
What operator tests column for absence of data?
NOT Operator
Exists Operator
IS NULL Operator
None of the above
In which of the following cases a DML statement is not executed?
When existing rows are modified
When a table is deleted
When some rows are deleted
All of the above
If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default
DESC
ASC
There is no default value
None of the mentioned
Which of the following is true about the SQL AS clause?
The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.
The SQL AS clause can only be used with the JOIN clause.
The AS clause in SQL is used to defines a search condition.
All of the mentioned
How can you change "Thomas" into "Michel" in the "LastName" column in the Users table?
UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'
MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'
MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'
UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'
Which command is used to change the definition of a table in SQL?
CREATE
UPDATE
ALTER
SELECT
Which type of JOIN is used to returns rows that do not have matching values?
Natural JOIN
Outer JOIN
EQUI JOIN
All of the above
Which of the following is the correct order of a SQL statement?
SELECT, GROUP BY, WHERE, HAVING
SELECT, WHERE, GROUP BY, HAVING
SELECT, HAVING, WHERE, GROUP BY
SELECT, WHERE, HAVING, GROUP BY
What is the difference between a PRIMARY KEY and a UNIQUE KEY?
Primary key can store null value, whereas a unique key cannot store null value.
We can have only one primary key in a table while we can have multiple unique keys
Primary key cannot be a date variable whereas unique key can be
None of these
Which of the following are the synonyms for Column and ROW of a table? 1-Row = [Tuple, Record] 2-Column = [Field, Attribute] 3-Row = [Tuple, Attribute] 4-Columns = [Field, Record]
1 and 2
3 and 4
Only 1
Only 2
Find the cities name with the condition and temperature from table 'whether' where condition = sunny or cloudy but temperature >= 60
SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' AND condition = 'sunny' OR temperature >= 60
SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' OR condition = 'sunny' OR temperature >= 60
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature >= 60
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature >= 60
Which statement is used to get all data from the student table whose name starts with p?
SELECT * FROM student WHERE name LIKE '%p%';
SELECT * FROM student WHERE name LIKE 'p%';
SELECT * FROM student WHERE name LIKE '_p%';
SELECT * FROM student WHERE name LIKE '%p';
In the given query which of the keyword has to be inserted? ( INSERT INTO employee _____ (1002,Joey,2000); )
Table
Values
Relation
Field
Which of the following commands is used to delete all rows and free up space from a table?
Truncate
Drop
Delete
Alter
Which of the following are some common RDBMS in use?
Oracle
MySQL
SQL Server
All of the above
Which SQL constraint do we use to set some value to a field whose value has not been added explicitly?
Unique
Not Null
Default
Check
To select some particular columns, which of the following commands is used?
Projection
Selection
Join
Union
{"name":"Database Fundamentals Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of database fundamentals with our comprehensive quiz! Covering a variety of essential topics, you'll assess your skills in SQL, database management, and data manipulation commands.Key features of this quiz include:36 challenging questionsMultiple choice formatImmediate scoring","img":"https:/images/course7.png"}