InfyTQ SQL Basics Quiz 3

Question 1

Time: 00:00:00
Which of the following SQL Command is used to insert the new data into the ‘Students’ table ?

INSERT INTO Students VALUES (‘Navin’,’Ojha’);

INSERT INTO Students VALUES (‘Navin’,’Ojha’);

INSERT Students VALUES (‘Navin’,’Ojha’);

INSERT Students VALUES (‘Navin’,’Ojha’);

INSERT VALUES (‘Navin’,’Ojha’);

INSERT VALUES (‘Navin’,’Ojha’);

None of  These.

None of  These.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
How can you change "Singh" into "Chauhan" in the "Last_Name" column in the Students table?

MODIFY Students SET Last_Name = ‘Singh’ INTO Last_Name = ‘Chauhan’;

MODIFY Students SET Last_Name = ‘Singh’ INTO Last_Name = ‘Chauhan’;

UPDATE Students SET Last_Name = ‘Singh’ INTO Last_Name = ‘Chauhan’;

UPDATE Students SET Last_Name = ‘Singh’ INTO Last_Name = ‘Chauhan’;

MODIFY Students SET Last_Name = ‘Singh’ WHERE Last_Name = ‘Chauhan’;

MODIFY Students SET Last_Name = ‘Singh’ WHERE Last_Name = ‘Chauhan’;

UPDATE Students SET Last_Name = ‘Chauhan’ WHERE Last_Name = ‘Singh’;

UPDATE Students SET Last_Name = ‘Chauhan’ WHERE Last_Name = ‘Singh’;

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
Which of the following SQL Command is used to delete the records where the "First_Name" is "Navin" in the Students Table?

DELETE FROM Students WHERE First_Name = “Navin”;

DELETE FROM Students WHERE First_Name = “Navin”;

REMOVE INTO Students WHERE First_Name = “Navin”;

REMOVE INTO Students WHERE First_Name = “Navin”;

DELETE INTO Students WHERE First_Name = “Navin”;

DELETE INTO Students WHERE First_Name = “Navin”;

REMOVE FROM Students WHERE First_Name = “Navin”;

REMOVE FROM Students WHERE First_Name = “Navin”;

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Which of the following SQL Command is used to return the number of records in the "Students" table ?

SELECT COLUMNS(*) FROM Students;

SELECT COLUMNS(*) FROM Students;

SELECT NO(*) FROM Students;

SELECT NO(*) FROM Students;

SELECT COUNT(*) FROM Students;

SELECT COUNT(*) FROM Students;

SELECT LEN(*) FROM Students;

SELECT LEN(*) FROM Students;

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
Which among the following is the most common type of join ?

JOINED TABLE

JOINED TABLE

JOIN

JOIN

INNER JOIN

INNER JOIN

INSIDE JOIN

INSIDE JOIN

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Which of the following operators is used to select the range of values from the database ?

WITHIN

WITHIN

BETWEEN

BETWEEN

RANGE

RANGE

None of the above.

None of the above.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
What is the value returned by SUBSTR(‘Navin Ojha’, -1, 1) ?

T

T

NULL

NULL

N

N

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
Which of the following is false about subqueries of multiple rows ?

Multiple row Subqueries return multiple rows from the OUTER SELECT Statement.

Multiple row Subqueries return multiple rows from the OUTER SELECT Statement.

Multiple row Subqueries return multiple rows from the INNER SELECT Statements.

Multiple row Subqueries return multiple rows from the INNER SELECT Statements.

Multiple row Subqueries return multiple rows comparison operators.

Multiple row Subqueries return multiple rows comparison operators.

All of the above.

All of the above.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
Which of the following is true about FOREIGN KEY Constraints ?

It is a referential integrity constraint.

It is a referential integrity constraint.

It establishes a relationship between a primary key or a unique key in a different table

It establishes a relationship between a primary key or a unique key in a different table

A Foreign key cannot be NULL.

A Foreign key cannot be NULL.

A Foreign value must match an existing value in the parent table.

A Foreign value must match an existing value in the parent table.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Can a Primary Key have a NULL Value ?

YES

YES

NO

NO

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%