Database Fundamentals Quiz

A visually engaging illustration of a database with SQL commands and concepts represented, including graphs and charts, in a modern digital style.

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

36 Questions9 MinutesCreated by QueryFox123

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

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.

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.

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 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 SQL constraint do we use to set some value to a field whose value has not been added explicitly?

Unique

Not Null

Default

Check

Unlock and Upgrade

Remove all limits from your Quizzes

Database Fundamentals Quiz

Database Fundamentals Quiz

More Quizzes