SQL Quiz - Common Jobs

SQL

1 / 39

What is the advantage of the clustered index?

It is fast to update the records.

It does not need extra work for SQL queries.

It minimizes the page transfer and maximizes the cache hits.

None

2 / 39

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';

3 / 39

________ is a program that performs some common action on database data and also stored in the database.

Stored Procedure

Trigger

Stored Function

None

4 / 39

Which of the following statement is correct to display all the cities with the condition, temperature, and humidity whose humidity is in the range of 60 to 75 from the 'whether' table?

SELECT * FROM weather WHERE humidity IN (60 to 75)

SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75

SELECT * FROM weather WHERE humidity NOT IN (60 AND 75)

SELECT * FROM weather WHERE humidity NOT BETWEEN 60 AND 75

5 / 39

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

6 / 39

______ is NOT a type of constraint in SQL language?

FOREIGN KEY

PRIMARY KEY

UNIQUE

ALTERNATE KEY

7 / 39

When the wildcard in a WHERE clause is useful?

When an exact match is required in a SELECT statement.

When an exact match is not possible in a SELECT statement.

When an exact match is required in a CREATE statement.

When an exact match is not possible in a CREATE statement.

8 / 39

Which of the following options are correct regarding these three keys (Primary Key, Super Key, and Candidate Key) in a database?

Minimal super key is a candidate key
II. Only one candidate key can be a primary key
III. All super keys can be a candidate key
IV. We cannot find a primary key from the candidate key

I and II

II and III

I and III

II and IV

9 / 39

Which of the following statement is correct regarding the difference between TRUNCATE, DELETE and DROP command?

DELETE operation can be rolled back but TRUNCATE and DROP operations cannot be rolled back.
II. TRUNCATE and DROP operations can be rolled back but DELETE operations cannot be rolled back.
III. DELETE is an example of DML, but TRUNCATE and DROP are examples of DDL.
IV. All are an example of DDL.

I and III

II and III

II and IV

III and IV

10 / 39

Which operator is used to compare the NULL values in SQL?

Equal

NONE

11 / 39

Which of the following are the synonyms for Column and ROW of a table?

Row = [Tuple, Record]
Column = [Field, Attribute]
Row = [Tuple, Attribute]
Columns = [Field, Record]

1 and 2

3 and 4

Only 1

Only 2

12 / 39

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

13 / 39

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

14 / 39

A sequence in SQL can generate a maximum number

39 digits

38 digits

40 digits

37 digits

15 / 39

Sequence can generate

Numeric value

Alphanumeric value

both

None

16 / 39

Shared locks are applied while performing

Read operations

Write operations

Both

None

17 / 39

Group of operations that form a single logical unit of work is known as

View

Network

Unit

Transaction

18 / 39

Why we need to create an index if the primary key is already present in a table?

Index improves the speed of data retrieval operations on a table.

Indexes are special lookup tables that will be used by the database search engine.

Indexes are synonyms of a column in a table.

All

19 / 39

Which of the following is the basic approaches for joining tables?

Union JOIN

Natural JOIN

Subqueries

All

20 / 39

Which statement is true regarding routines and triggers?

Both run automatically.

Both are stored in the database.

Both consist of procedural code.

Both have to be called to operate.

21 / 39

A CASE SQL statement is ________?

A way to establish a loop in SQL.

A way to establish an IF-THEN-ELSE in SQL

A way to establish a data definition in SQL

All

22 / 39

Which type of JOIN is used to returns rows that do not have matching values?

Natural JOIN

Outer JOIN

EQUI JOIN

All

23 / 39

Which command is used to change the definition of a table in SQL?

CREATE

UPDATE

ALTER

SELECT

24 / 39

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'

25 / 39

_________ command makes the updates performed by the transaction permanent in the database?

ROLLBACK

COMMIT

TRUNCATE

DELETE

26 / 39

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

27 / 39

_______ clause creates temporary relation for the query on which it is defined.

WITH

FROM

WHERE

SELECT

28 / 39

The SQL statement:

SELECT ROUND (65.726, -1) FROM DUAL;

Prints:

is illegal

garbage

726

29 / 39

Which of the following is true about the HAVING clause?

Similar to the WHERE clause but is used for columns rather than groups.

Similar to WHERE clause but is used for rows rather than columns.

Similar to WHERE clause but is used for groups rather than rows.

Acts exactly like a WHERE clause.

30 / 39

Which of the following is also called an INNER JOIN?

SELF JOIN

EQUI JOIN

NON-EQUI JOIN

None

31 / 39

A command that lets you change one or more field in a table is:

INSERT

MODIFY

LOOK-UP

All

32 / 39

What is returned by INSTR ('JAVAT POINT', 'P')?

POINT

JAVAT

33 / 39

Which of the following statement is true?

TRUNCATE free the table space while DELETE does not.

Both TRUNCATE and DELETE statements free the table's space.

Both TRUNCATE and DELETE statement does not free the table's space.

DELETE free the table space while TRUNCATE does not.

34 / 39

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

35 / 39

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

36 / 39

What operator tests column for absence of data

NOT Operator

Exists Operator

IS NULL Operator

None

37 / 39

Which operator is used to compare a value to a specified list of values?

ANY

BETWEEN

ALL

38 / 39

Which data manipulation command is used to combines the records from one or more tables?

SELECT

PROJECT

JOIN

PRODUCT

39 / 39

Which of the following is not a valid aggregate function?

COUNT

COMPUTE

SUM

MAX

Your score is

The average score is 35%

About Us

Company

Education

Quick Links

Get latest job updates

Connect With Us