VMware MySql Questions and Answers Quiz-1

Question 1

Time: 00:00:00
Which SQL keyword is used to retrieve a maximum value ?

MOST

MOST

TOP

TOP

MAX

MAX

UPPER

UPPER

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
________________ is not a category of SQL command.

TCL

TCL

SCL

SCL

DCL

DCL

DDL

DDL

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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 statement is true ?

DELETE does not free the space containing the table and TRUNCATE free the space containing the table

DELETE does not free the space containing the table and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE does not free the space containing the table

Both DELETE and TRUNCATE does not free the space containing the table

DELETE free the space containing the table and TRUNCATE does not free the space containing the table

DELETE free the space containing the table and TRUNCATE does not free the space containing the table

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
What is the purpose of the SQL AS clause?

The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column

The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column

The AS clause is used with the JOIN clause only

The AS clause is used with the JOIN clause only

The AS clause defines a search condition

The AS clause defines a search condition

All of the mentioned

All of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’%a%’

SELECT * FROM Persons WHERE FirstName=’%a%’

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
What does the ALTER TABLE clause do ?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause is used to insert data into database table

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database tablebase table

THE SQL ALTER TABLE deletes data from database tablebase table

The SQL ALTER TABLE clause is used to delete a data

The SQL ALTER TABLE clause is used to delete a data

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
The UNION SQL clause can be used with

SELECT clause only

SELECT clause only

DELETE and UPDATE clauses

DELETE and UPDATE clauses

UPDATE clause only

UPDATE clause only

All oF the mentioned

All oF the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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 can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
The command to remove rows from a table ‘CUSTOMER’ is

DROP FROM CUSTOMER

DROP FROM CUSTOMER

UPDATE FROM CUSTOMER

UPDATE FROM CUSTOMER

REMOVE FROM CUSTOMER

REMOVE FROM CUSTOMER

DELETE FROM CUSTOMER WHERE

DELETE FROM CUSTOMER WHERE

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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! \r\n","Keep trying! \r\n","Not bad! \r\n","Good work! \r\n","Perfect! \r\n"]
×

Please login to report

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%

Start Preparing
Detailed performance

Completed

0/10

Accuracy

0%

Related Banners
prepinsta
prepinsta
Prepinsta Prime
Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Explore Prime or check Course List
Check out our instagram

Never Miss an OffCampus Update

Get OffCampus Updates on Social Media from PrepInsta

Follow us on our Media Handles, we post out OffCampus drives on our Instagram, Telegram, Discord, Whatsdapp etc.

Instagram Whatsapp Telegram Linkedin
Get Hiring Updates
Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta
prepinsta
prepinsta
prepinsta
prepinsta

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.
Get Prime Course List

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.
Get Prime Course List

Get PrepInsta Prime Subscription

Get access to all the courses that PrepInsta offers, check the out below -

Companies

TCS, Cognizant, Delloite, Infosys, Wipro, CoCubes, KPMG, Amazone, ZS Associates, Accenture, Congnizant & other 50+ companies

See Full list here
Get Prime

Programming

Data Structures, Top 500 Codes, C, C++, Java Python & other 10+ subjects

See Full list here
Get Prime

Skills

Full Stack Web Development, Data Science, Machine Learning, AWS Cloud, & other 10+ skills and 20+ projects

See Full list here
Get Prime

Related Pages

June 24, 2019

Comments