Please login

Prime

Prepinsta Prime

Video courses for company/skill based Preparation

(Check all courses)
Get Prime Video
Prime

Prepinsta Prime

Purchase mock tests for company/skill building

(Check all mocks)
Get Prime mock

InfyTQ SQL Basics Quiz 1

Question 1

Time: 00:00:00
Which of the following SQL Command is used to display the data of the table from the database ?

SELECT

SELECT

GET

GET

OPEN

OPEN

EXTRACT

EXTRACT

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

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
Which of the following SQL Command is used to modify the data in the table?

UPDATE

UPDATE

MODIFY

MODIFY

SAVE

SAVE

SAVE AS

SAVE AS

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 remove the data in the table?

DELETE

DELETE

COLLAPSE

COLLAPSE

REMOVE

REMOVE

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 4

Time: 00:00:00
Which of the following SQL Command is used to extract the column_name from the table in the database ?

SELECT column_name FROM TABLE_NAME;

SELECT column_name FROM TABLE_NAME;

SELECT TABLE column_name;

SELECT TABLE column_name;

EXTRACT column_name FROM TABLE;

EXTRACT column_name FROM TABLE;

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 5

Time: 00:00:00
Which of the following SQL Command is used to extract all the columns from the table in the database ?

SELECT * FROM TABLE_NAME;

SELECT * FROM TABLE_NAME;

SELECT [ALL] COLUMNS FROM TABLE;

SELECT [ALL] COLUMNS FROM TABLE;

SELECT *. FROM TABLE

SELECT *. FROM TABLE

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 6

Time: 00:00:00
Which of the following SQL Command is used to select all the records from a table named "Students” where the value of the column "First_Name" is "Navin"?

SELECT [ALL] FROM Students WHERE First_Name = ‘Navin’;

SELECT [ALL] FROM Students WHERE First_Name = ‘Navin’;

SELECT * FROM Students WHERE First_Name = ‘Navin’;

SELECT * FROM Students WHERE First_Name = ‘Navin’;

SELECT [ALL] FROM Students WHERE First_Name LIKE ‘Navin’;

SELECT [ALL] FROM Students WHERE First_Name LIKE ‘Navin’;

SELECT * FROM Students WHERE First_Name < > ‘Navin’;

SELECT * 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 7

Time: 00:00:00
Which of the following SQL Commands is used to select all the records from a table named "Students" where the value of the column "First_Name" starts with an "a" ?

SELECT * FROM Students WHERE First_Name LIKE ‘a%’;

SELECT * FROM Students WHERE First_Name LIKE ‘a%’;

SELECT * FROM Students WHERE First_Name = ‘%a%’;

SELECT * FROM Students WHERE First_Name = ‘%a%’;

SELECT * FROM Students WHERE First_Name LIKE ‘%a’;

SELECT * FROM Students WHERE First_Name LIKE ‘%a’;

SELECT * FROM Students WHERE First_Name LIKE ‘a’;

SELECT * FROM Students WHERE First_Name LIKE ‘a’;

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 SQL Command is used to select all the records from a table named "Students” where the value of the column "First_Name" is "Navin" and “Last_name” is “Singh” ?

SELECT [ALL] FROM Students WHERE First_Name = ‘Navin’ AND Last_Name = ‘Singh’;

SELECT [ALL] FROM Students WHERE First_Name = ‘Navin’ AND Last_Name = ‘Singh’;

SELECT * FROM Students WHERE First_Name = ‘Navin’ AND Last_Name = ‘Singh’;

SELECT * FROM Students WHERE First_Name = ‘Navin’ AND Last_Name = ‘Singh’;

SELECT [ALL] FROM Students WHERE First_Name LIKE ‘Navin’ AND Last_Name LIKE ‘Singh’;

SELECT [ALL] FROM Students WHERE First_Name LIKE ‘Navin’ AND Last_Name LIKE ‘Singh’;

SELECT * FROM Students WHERE First_Name < > ‘Navin’ AND Last_Name < > ‘Singh’;

SELECT * FROM Students WHERE First_Name < > ‘Navin’ AND Last_Name < > ‘Singh’;

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 Keyword is used to sort the results obtained from the database ?

ORDER

ORDER

ORDER BY

ORDER BY

SORT

SORT

SORT BY

SORT BY

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Which of the following SQL Command is used to Sort all the records obtained from a table named "Students” by First_Name in Descending order ?

SELECT [ALL] FROM Students ORDER BY First_Name DESC;

SELECT [ALL] FROM Students ORDER BY First_Name DESC;

SELECT * FROM Students ORDER BY First_Name DESC;

SELECT * FROM Students ORDER BY First_Name DESC;

SELECT [ALL] FROM Students SORT BY First_Name DESC;

SELECT [ALL] FROM Students SORT BY First_Name DESC;

SELECT * FROM Students SORT First_Name DESC’’;

SELECT * FROM Students SORT First_Name DESC’’;

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!"]

Completed

0/0

Accuracy

0%

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%