Question On DBMS Quiz-1

Question 1

Time: 00:00:00

What is the output of the following query on the table mint?

Select Id from mint order by id desc, name limit 3,1.

Name	ID
Alfred	20
Don	34
John	23
Fred	21
Glen	43

Alfred

Don

John

Fred

Glen

Good Job!

Oops!

Report the answer

PrepInsta Explanation
User Explanation

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

Please login to submit your explanation

Question 2

Time: 00:00:00

The class time, whose private attributes are the hour, minutes, second wants to display the time in the universal time format(HH,MM,SS) and standard time format (H:MM:SS AM or PM). Consider the class definition below.

Public class Time

{ Private: Int hour, minute, second;

Public:

Time(int hh, int mm, int ss){hour = hh; minute = mm; second = ss;}

String ToDisplayTimeStandard ()

{

hour = ( hour == 0 | | hour == 12) ? 12 ; hour % 12 ;

string s1= hour <12 ? "AM" : "PM" ;

string s2= hour+minute+second+s1;

Display s2;

}

String ToDisplayTimeUniversal ()

{ string s2 = hour+minute+second ; Display s2; }

}

Void main()

{ Time tobj (6,25,10);

tobj. ToDisplayTimeStandard()

}

Overloading

Abstraction

Overriding

Inheritance

Good Job!

Oops!

Report the answer

PrepInsta Explanation
User Explanation

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

Please login to submit your explanation

Question 3

Time: 00:00:00

Write a SQL query to create a user "user1" in "localhost" with the default password set to "Pass123"?

CREATE USER \'user1\'@\'localhost\' IDENTIFIED BY \'Pass123\';

CREATE \'user1\'@\'localhost\' IDENTIFIED BY \'Pass123\';

CREATE USER \'user1\'@\'localhost\' PASS BY \'Pass123\';

CREATE USER \'user1\'@\'localhost\' PASSWORD BY \'Pass123\';

Good Job!

Oops!

Report the answer

PrepInsta Explanation
User Explanation

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

Please login to submit your explanation

Question 4

Time: 00:00:00

What is the language that enables to access and operates on the data in the database?

Data Manipulation Language

Data access language

Data control language

Data Definition Language

Good Job!

Oops!

Report the answer

PrepInsta Explanation
User Explanation

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

Please login to submit your explanation

Question 5

Time: 00:00:00

Product and Manufacture table are related as 1 to many relationships, to acquire this relation which table should contain the foreign key.

Product Table

Manufacturer Table

Both the Table

None of the above

Good Job!

Oops!

Report the answer

PrepInsta Explanation
User Explanation

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

Please login to submit your explanation

Question 6

Time: 00:00:00

What is the SQL query to get the list of all the tables in a database?

SHOW TABLES;

SELECT * FROM DATABASE;

SHOW TABLES FROM DATABASE;

LIST TABLES;

Good Job!

Oops!

Report the answer

PrepInsta Explanation
User Explanation

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

Please login to submit your explanation

Question 7

Time: 00:00:00

Which of the following is the correct SQL to get the second highest "Sal" from the below table?

EID	NAME	Sal
1	Mark	12000
2	Rick	11200
3	Eden	21100
4	Rose	21300
5	Maria	14000

select max(Sal) from EmpDet limit 2

select min(Sal) from EmpDet where Sal in (select distance top 2 Sal from EmpDet order by Sal desc)

select Sal from EmpDet where Sal in (select distinct top 2 Sal from EmpDet order by Sal desc)

select min(Sal) from EmpDet where Sal in (select distance top 2 Sal from EmpDet order by Sal desc)

Good Job!

Oops!

Report the answer

PrepInsta Explanation
User Explanation

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

Please login to submit your explanation

Question 8

Time: 00:00:00

What is the SQL statement used to change the autoincrement sequence to start with 10400 for existing table named "Persons"?

ALTER TABLE Persons AUTO_INCREMENT value = 10400

ALTER TABLE Persons AUTO_INCREMENT 10400

ALTER TABLE Persons AUTO_INCREMENT= 10400

ALTER TABLE Persons AUTO_INCREMENT by 10400

Good Job!

Oops!

Report the answer

PrepInsta Explanation
User Explanation

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

Please login to submit your explanation

Question 9

Time: 00:00:00

Consider that we have a table Temp with columns as below:

Temp(C1, C2, C3)

Following are the conditions on the columns:

i.Any of the three columns can have duplicate values

ii. Any of the three columns can have NULL values

iii. The table, however, cannot have a row with all 3 columns as NULL

As per the above conditions and the Guaranteed Access rule, how many columns are required to filter a specific row in the table?

0

1

2

None of the columns of table Temp can serve as primary key, hence not possible

Good Job!

Oops!