Microsoft SQL Server Database Administrator Exam

Are you a Database Administrator? Need to update DBA technical knowledge or need to prepare for a job interview? Check out this collection of Microsoft SQL Server Database Administrator Exam...

Is T-SQL language syntax case-sensitive?
When "SET CONCAT_NULL_YIELDS_NULL ON", concatenating a null value with a string will yield a NULL result. But this only applies to the current session if you use in Query Analyzer. Is this true?
What two categories you can divide T-SQL statements into?
What is the fully qualified naming convention to specify a table in a linked Oracle database from MS SQL server?
What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
What are distributed queries?
What is the meaning of an Inner Join operatin of two tables?
What is default sorting order when you use "ORDER BY" clause in a query statement?
What is the meaning of an Outer Join operatin of two tables?
What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
What is a simple way to rename a database in MS SQL Server?
What is a simple way to detach a database that is not in use in MS SQL Server?
What is the meaning of the following T-SQL command: SELECT * FROM users WHERE first_name LIKE 'M%'
Can MS SQL Server be used for transation processing as well as data warehousing database?
What is a Rule is MS SQL Server?
What is a Torn Page in MS SQL Server?
Is it true that MS SQL Server is sharing work load between the server and client computers?
What is a Stored Procedure in MS SQL Server?
What is the meaning of Data Normalization?
What is the meaning of the following T-SQL command: CREATE TABLE orders ...
What is an Index in MS SQL Server?
What is a Page in MS SQL Server?
What does Extend refer to in MS SQL Server?
What does Default Object refers to in MS SQL Server?
What is the size a Page in MS SQL Server?
What does Trigger refers to in MS SQL Server?
What does Field refers to in MS SQL Server?
What does RDBMS stand for?
What does Constraint refer to in MS SQL Server?
What is the size of an Extent in MS SQL Server?
On MS SQL Server management tool, how would you find what actions you can perform for a particular object?
What is setup.iss file used for during MS SQL Server installation?
By default, MS SQL Server sets the index fill factor to 100%. What does this mean?
What is the default login account used by the installation process, when you are doing an unattended installation of MS SQL Server?
What is the main limitation of the MS SQL Server Developer Edition?
What can you do with the "ALTER DATABASE ..." T-SQL command?
What is the difference between a "User DSN" and a "System DSN" ODBC connection?
What is a Named Pipe in MS SQL Server?
Does MS SQL Server support IPX/SPX?
What is the meaning of the following T-SQL command: DBCC SHRINKDATABASE ( Database, 10%)
What is the T-SQL command to create a new login in MS SQL Server?
In what situation you should the "sp_showfilegroup" stored procedure?
What is the difference between a Default Instance and a Named Instance of MS SQL Server?
What is the "master" database? Can I delete it to save disk space?
What should you do to prepare for MS SQL Server upgrade?
What is the different between concurrent connections and concurrent user logins?
If you finish installing MS SQL Server as Named Instance, what would be the default path name on the hard disk where the server will be installed to?
How do you describe a field in a table in the database?
Where are database files and backup files of a MS SQL Server database located?
What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
Is MS SQL Server compliant to ANSI SQL standards?
What is the minimum RAM required to run SQL Server 2014?
What can you do with the Bulk Copy operation in MS SQL Server?
Is it secure to use Windows Authentication to establish a connection to MS SQL Server?
What can you do with the "BULK INSERT" T-SQL command in MS SQL Server?
What information do you need to identify a remote MS SQL Server to make a connection request?
What is the main purpose of assigning a user with the "processadmin" role?
What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
What is "osql"? What can you do with "osql"?
What is the main feature of the "RAID 0" disk configuration?
What is the minimum of hard disk space required by MS SQL Server?
What is the default TCP/IP port # used by MS SQL Server to receive connection requests?
What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
When revoking one security role from a user, does it affect other security roles granted to same user?
During a BULK INSERT operation, are triggers and contraints enforced by default?
What is the use of *.ndf files in MS SQL Server?
What is the meaning of the NOTRUNCATE option in the "DBCC SHRINKDATABASE" command?
What is "bcp"?
What stored procedure you can execute to find out if a database is set to single-user or multi-user mode?
What is the purpose of supporting mixed mode authentication (Windows Authentication and SQL Server Authentication)?