SQL Server Exam Questions
Authored by Ryan Jay Villastique
Computers
University
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
35 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
is the language supported by almost all database systems, and is the subject of published industry standards.
Structured Query Language
Data Definition Language
Data Manipulation Language
Data Control Language
Transact-SQL
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
used to define and manage all the objects in an SQL Server such as databases, tables and view.
Structured Query Language
Data Definition Language
Data Manipulation Language
Data Control Language
Transact-SQL
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
used to SELECT, INSERT, UPDATE and DELETE data in the objects defined by DDL.
Structured Query Language
Data Definition Language
Data Manipulation Language
Data Control Language
Transact-SQL
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Security commands such as GRANT, REVOKE, and DENY that control how a principal (user or role) can access a securable (object or data.)
Structured Query Language
Data Definition Language
Data Manipulation Language
Data Control Language
Transact-SQL
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
is the language containing the commands used to administer SQL Server, to create and manage all objects in SQL Server, and to insert, retrieve, modify, and delete all data in tables.
Structured Query Language
Data Definition Language
Data Manipulation Language
Data Control Language
Transact-SQL
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
is how SQL Server processes usernames and passwords
Authentication Mode
Windows Authentication Mode
SQL Server Management Studio
Object/Template Explorer
System Database
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
With this mode, a user can sit down at their computer, log in to the Windows domain, and gain access to SQL Server.
Authentication Mode
Windows Authentication Mode
SQL Server Management Studio
Object/Template Explorer
System Database
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
35 questions
FINAL_EXAM (CFP_122)
Quiz
•
University
40 questions
Computer Network
Quiz
•
12th Grade - University
30 questions
Python Function
Quiz
•
University
30 questions
UT-SQL
Quiz
•
University
30 questions
OODP_Batch 1_Quiz
Quiz
•
University
35 questions
JAVA BASIC 2
Quiz
•
University
40 questions
MS office 2016
Quiz
•
1st Grade - Professio...
30 questions
blitz
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade