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