SQL Server Exam Questions

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

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

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

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

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

is how SQL Server processes usernames and passwords

• Authentication Mode

• Windows Authentication Mode

• SQL Server Management Studio

• Object/Template Explorer

• System Database

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

enables the developer or DBA to develop database projects and manage SQL Server with either a GUI interface or T-SQL code.

• Authentication Mode

• Windows Authentication Mode

• SQL Server Management Studio

• Object/Template Explorer

• System Database

Used to create and manage T-SQL code templates. The templates are simply stored SQL scripts within a directory structure.

• Authentication Mode

• Windows Authentication Mode

• SQL Server Management Studio

• Object/Template Explorer

• System Database

The default system databases should not be deleted because they may cause failure to your instance of SQL Server.

• Authentication Mode

• Windows Authentication Mode

• SQL Server Management Studio

• Object/Template Explorer

• System Database