gs gs116 Laying the Foundation - Basic SQL - Quiz No.2
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Laying the Foundation. 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: What does DML stand for?
Different Mode Level
Data Model Language
Data Mode Lane
Data Manipulation language
Question 2: 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 LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT * FROM Persons WHERE FirstName=’%a%’
Question 3: With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
SELECT * FROM Persons SORT BY ‘FirstName’ DESC
SELECT * FROM Persons ORDER FirstName DESC
SELECT * FROM Persons SORT ‘FirstName’ DESC
SELECT * FROM Persons ORDER BY FirstName DESC
Question 4: With SQL, how can you return the number of not null records in the “Persons” table?
SELECT COUNT() FROM Persons
SELECT COLUMNS() FROM Persons
SELECT COLUMNS(*) FROM Persons
SELECT COUNT(*) FROM Persons
Question 5: 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 is used to insert data into database table
THE SQL ALTER TABLE deletes data from database table
The SQL ALTER TABLE clause is used to delete a database table
Question 6: The UPDATE SQL clause can _____________
update only one row at a time
update more than one row at a time
delete more than one row at a time
delete only one row at a time
Question 7: The UNION SQL clause can be used with _____________
SELECT clause only
DELETE and UPDATE clauses
UPDATE clause only
All of the mentioned
Question 8: Which SQL statement is used to return only different values?
SELECT DIFFERENT
SELECT UNIQUE
SELECT DISTINCT
SELECT ALL
Question 9: Which SQL keyword is used to sort the result-set?
ORDER BY
SORT
ORDER
SORT BY
Question 10: How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
