gs gs113 Select Statement - The Select Clauses - Quiz No.2
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 9 multiple choice questions (MCQs) to prepare and belongs to topic Select Statement. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Is there any error in executing the following MySQL command?
SELECT emp_id, ‘ACTIVE’, emp_id * 3.145, UPPER (lname) FROM Employee;
Yes
NO
Depends on condition
None of the mentioned
Question 2: Is there any error in executing the following MySQL command?
SELECT USER (), VERSION (), DATABASE ();
Yes, “FROM” is not used
No
Depends
None of the mentioned
Question 3: What is the need of “column Aliases” in “SELECT” clause?
To assign a new label to the column in result set
To overwrite the existing column name in result set
To modify the column name while using literals, Expression, built_in functions with “SELECT clause
All of the mentioned
Question 4: What will be the result of the following MySQL command?
SELECT emp_id, ‘ACTIVE’ Status, emp_id * 3.14 emp_pi, UPPER (lname) last_name FROM employee;
emp_id, ACTIVE, emp_id * 314, UPPER(lname)
emp_id, Status, emp_pi, last_name
Error
None of the mentioned
Question 5: What will be the result of the following MySQL command?
SELECT emp_id, ‘ACTIVE’ AS Status, emp_id * 3.14 AS emp_pi, UPPER (lname) AS last_name FROM employee;
emp_id, ACTIVE, emp_id * 314, UPPER(lname)
emp_id, Status, emp_pi, last_name
Error
None of the mentioned
Question 6: Which Keyword is used to remove duplicate rows in the result set?
DISTINCTS
MODIFY
DISTINCT
All of the mentioned
Question 7: If in Table “account”, a column “cust_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?
SELECT DISTINICT cust_id FROM account;
{1, 2, 2, 3, 3, 5, 6, 7, 8, 8}
{1, 2, 3, 5, 6, 7, 8}
{ }
None of the mentioned
Question 8: If in Table “employee”, a column “emp_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?
SELECT DISTINICT emp_id FROM employee;
{1,2,2,3,3,5,6,7,8,8}
{1,2,3,5,6,7,8}
{ }
None of the mentioned
Question 9: Which among the following is an optional Keyword?
DISTINICTS
ALL
AS
Both AS and ALL
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
