gs gs116 Laying the Foundation - Basic SQL - Quiz No.1
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: Which SQL function is used to count the number of rows in a SQL query?
COUNT()
NUMBER()
SUM()
COUNT(*)
Question 2: Which SQL keyword is used to retrieve a maximum value?
MOST
TOP
MAX
UPPER
Question 3: Which of the following SQL clauses is used to DELETE tuples from a database table?
DELETE
REMOVE
DROP
CLEAR
Question 4: ___________removes all rows from a table without logging the individual row deletions.
DELETE
REMOVE
DROP
TRUNCATE
Question 5: Which of the following is not a DDL command?
UPDATE
TRUNCATE
ALTER
None of the Mentioned
Question 6: Which of the following are TCL commands?
UPDATE and TRUNCATE
SELECT and INSERT
GRANT and REVOKE
ROLLBACK and SAVEPOINT
Question 7: ________________ is not a category of SQL command.
TCL
SCL
DCL
DDL
Question 8: If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________
ASC
DESC
There is no default value
None of the mentioned
Question 9: Which of the following statement is true?
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 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
Question 10: What is the purpose of the SQL AS clause?
The AS SQL clause is used to 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 defines a search condition
All of the mentioned
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
