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
30 questions
เทคโนโลยีสารสนเทศเพื่อการจัดการอาชีพ
Quiz
•
1st Grade - Professio...
34 questions
MOS Word 2016 - Quiz 2
Quiz
•
University
30 questions
Quiz 1
Quiz
•
University
30 questions
ACA 1
Quiz
•
University
30 questions
Blank Quiz
Quiz
•
University
30 questions
untitled
Quiz
•
9th Grade - University
40 questions
Post test Keamanan Jaringan
Quiz
•
University
30 questions
Freehand and Digital Drawing Midterm Exam 2021-2022
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade