SQL SERVER 2012 REVIEW QNS

If you define a column with a default value, that value is used whenever a row

that doesn't include a value for that column is added to the table

Which of the following types of SQL statements isn't a DML statement? CreateTable Update Insert Select

CreateTable

SQL statements that define the tables in a database are referred to as _______________ statements.

Data Definition Language (DDL)

A database __________________ is a schematic drawing that shows you the relationships between the tables you're working with.

Diagrams

Within the Management Studio, you can build a SQL statement without having to write your own code by using the ____________________________________.

Query Designer Window

If you want to use the Management Studio to modify the data for a table, you can right-click on the table and select the...... Select Top 1000 Rows command View Top 100 Rows command Edit Top 200 Rows command Design command

Edit Top 200 Rows command

Which of the following types of statements isn't an action query? Select Insert Delete Update

SELECT

The ________________________________________ is a graphical user interface for working with the objects in a SQL Server database.

SQL Server Management Studio

If you define a column as an identity column,

a number is generated for that column whenever a row is added to the table

When you use Windows authentication to connect to a database, SQL Server...................... lets you access the database without authorization as long as you're logged on to Windows uses the login name and password that you use for your PC to authorize your connection uses both Windows and SQL Server login names and passwords for authorization requires that you use a special login name and password for your authorization

uses the login name and password that you use for your PC to authorize your connection