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
FOS 313 Online Task (Finals)
Quiz
•
University
40 questions
Grade 6-Sistem Komputer
Quiz
•
6th Grade - University
30 questions
UAS Praktikum Adm Server
Quiz
•
University
30 questions
Siskomdig
Quiz
•
University
35 questions
Kuis Aplikasi Kamus Digital
Quiz
•
8th Grade - University
40 questions
SIMULASI DIGITAL - X
Quiz
•
KG - Professional Dev...
30 questions
Google Form
Quiz
•
10th Grade - University
30 questions
Living in the IT Era QUIZ 1
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