Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Database Concepts Study Set 1

Computing

Quiz 9 :

Learn how to create a database in SQL Server 2016

Quiz 9 :

Learn how to create a database in SQL Server 2016

search
arrow
To start working with SQL Server 2016 in Windows 10,use the command Start | All Apps | Microsoft SQL Server 2016 | Microsoft SQL Server Management Studio.
Free
True False
Answer:

Answer:

True

arrow
Database objects are displayed in the Object Explorer window in the SQL Server Management Studio.
Free
True False
Answer:

Answer:

True

arrow
SQL Server 2016 uses ________ authentication by default.
Free
Short Answer
Answer:

Answer:

Windows

arrow
SQL Server 2016 uses DBMS authentication by default.
True False
Answer:
arrow
A new SQL Server database is created using the ________ dialog box.
Short Answer
Answer:
arrow
SQL Server 2016 requires that ________ be installed.
Short Answer
Answer:
arrow
A new SQL Server database is created using the New Database dialog box.
True False
Answer:
arrow
An important reason for using SQL Server 2016 Express is that it has full SQL capabilities.
True False
Answer:
arrow
Microsoft .NET Framework 4.6.1 is provided by Windows 10.
True False
Answer:
arrow
A new SQL Server database is created using ________.
Multiple Choice
Answer:
arrow
SQL Server DBMS objects are displayed ________.
Multiple Choice
Answer:
arrow
SQL Server 2016 Express requires that the .NET Framework version 3.5 be automatically installed.
True False
Answer:
arrow
Users log into SQL Server 2016 Express using the ________ dialog box.
Short Answer
Answer:
arrow
Logging into the SQL Server 2016 Express DBMS is done using ________.
Multiple Choice
Answer:
arrow
To properly import a table from Microsoft Excel 2016,which of the following steps is not taken?
Multiple Choice
Answer:
arrow
The ________ edition is a free,single-user version of the Enterprise Edition.
Short Answer
Answer:
arrow
Database objects are displayed in the ________ window in the SQL Server Management Studio.
Short Answer
Answer:
arrow
Microsoft SQL Server 2016 Express Advanced includes ________.
Multiple Choice
Answer:
arrow
Users log into SQL Server 2016 using the Connect to Server dialog box.
True False
Answer:
arrow
Describe how to create a new database in SQL Server 2016 Express.
Essay
Answer:
Showing 1 - 20 of 43