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 DML Statements Quiz 2

Question 1

Time: 00:00:00
In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.

Descriptive

Descriptive

Derived

Derived

Recursive

Recursive

Relative

Relative

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

Please login to submit your explanation

Start

Question 2

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

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
How can we select the elements which have common Dept_name in both the relation ?

Select * from instructor i , course c where i.Dept_name=c.Dept_name;

Select * from instructor i , course c where i.Dept_name=c.Dept_name;

Select Dept name from instructor ,Course

Select Dept name from instructor ,Course

Select * from instructor i , course c ;

Select * from instructor i , course c ;

Select Dept_name from instructor where Dept_name = NULL;

Select Dept_name from instructor where Dept_name = NULL;

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

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Select distinct Dept_name from instructor ;
How many row(s) are displayed ?

4

4

3

3

5

5

Error

Error

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
Suppose the Authority want to include a new instructor for the title Neuroscience what command should be inserted ?

Insert into instructor values(12111,Emma,NeuroScience,200000);

Insert into instructor values(12111,Emma,NeuroScience,200000);

Insert into course values(12111,Introduction,NeuroScience,2);

Insert into course values(12111,Introduction,NeuroScience,2);

Insert into instructor values(12111,Emma,Biology,200000); Insert into course values(BIO-112,Introduction to Neuro Science,NeuroScience,2);

Insert into instructor values(12111,Emma,Biology,200000); Insert into course values(BIO-112,Introduction to Neuro Science,NeuroScience,2);

Insert into course values(12111,Emma,NeuroScience,200000);

Insert into course values(12111,Emma,NeuroScience,200000);

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
If a person all the people in Music department gets fired which of the following has to be performed on the instructor relation ?

Delete Dept_name=Music in instructor;

Delete Dept_name=Music in instructor;

Delete from instructor where Dept_name=Music

Delete from instructor where Dept_name=Music

Remove Dept_name= Music

Remove Dept_name= Music

All of the mentioned

All of the mentioned

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

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
SELECT DISTINCT T.name
FROM instructor AS T, instructor AS S
WHERE T.salary > S.salary AND S.dept name = ’Comp.Sci.’;
What will be displayed as the value of name for the above query?

Hayley

Hayley

Jackson

Jackson

Crick

Crick

Hayley and Crick

Hayley and Crick

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
How will you select the Names whose first letter is E ?

SELECT Name FROM instructor WHERE Name LIKE ’A%;

SELECT Name FROM instructor WHERE Name LIKE ’A%;

SELECT Name FROM course WHERE Name LIKE ’A%;

SELECT Name FROM course WHERE Name LIKE ’A%;

SELECT Dept_name FROM instructor WHERE Name LIKE ’A%;

SELECT Dept_name FROM instructor WHERE Name LIKE ’A%;

SELECT Name FROM instructor WHERE Dept_name LIKE ’A%;

SELECT Name FROM instructor WHERE Dept_name LIKE ’A%;

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 function is used to find the count of distinct departments?

Dist

Dist

Distinct

Distinct

Count

Count

Count,dist

Count,dist

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 function is used to identify the title with Least scope?

Min(Credits)

Min(Credits)

Max(credits)

Max(credits)

Min(Title)

Min(Title)

Max(Salary)

Max(Salary)

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%