30 Questions
What is the precision and scale of a field defined as precision 5 and scale 2?
Precision 5, scale 2
What data type accurately stores monetary values up to a ten-thousandth of a monetary unit?
Smallmoney
Which system data type accurately represents floating precision numbers equivalent to float(24)?
Real
What is the range of values that can be stored in a datetime data type?
January 1, 1753 - December 31, 9999
Which text data type is fixed-length and non-Unicode with a maximum capacity of 8000 characters?
Char
What is the purpose of the NEWID() function in SQL Server?
To create globally unique identifiers for tracking numbers
What does the system datatype 'float(2)' indicate about the precision of the stored values?
It stores up to two decimal places
Which data type in SQL Server is suitable for variable-length binary data with a maximum size declared as (2,147,483,677) bytes?
varbinary(max)
What is the main advantage of using varbinary over binary in SQL Server?
Uses less hard-disk space
What type of SQL Server authentication involves clicking on 'Connect' after selecting 'Windows Authentication'?
Windows Authentication
Which of the following is NOT considered a database object that can be modified using a Data Definition Language (DDL) in SQL Server?
Binary Data
What is the maximum length for fixed-length binary data stored using the 'binary' type in SQL Server?
8000 bytes
Which datatype is used to store entire XML documents or fragments?
xml
What is the purpose of using nvarchar over nchar?
It uses less disk space when there are fewer characters.
Which datatype allows storing values of different datatypes except for certain specified ones?
sql_variant
What is the maximum length of characters that nchar can hold?
4000 characters
Which datatype is used to track changes to data by timestamping records?
timestamp
What differentiates nvarchar from nvarchar(max)?
nvarchar(max) can hold up to 2,147,483,677 bytes of data
What is the maximum database size supported by SQL Server?
1,000,000 terabytes
How many simultaneous instances of SQL Server can run on a single computer?
16
What data type in SQL Server can contain only a value of 1 or 0?
bit
What is the purpose of the SQL statement 'create database friends_information;'?
To create a new database
Which statement controls whether you can use the equality operator to test for null?
SET ANSI_NULLS ON/OFF
In SQL, what does the 'not null' concept imply?
Fields must not be empty
What is the range of values for the 'int' data type in SQL Server?
-2,147,483,648 to 2,147,483,647
Which part is not considered as a component of a database in SQL Server?
Indexes
Which SQL statement is used to open a table for viewing data?
Right-Click on the Table Name Click on Open Table
What is the function of the 'default' concept in SQL?
It sets a default value for a field if no value is specified
What does the SQL statement 'create table information(...);' primarily do?
Define the structure of a new table
Which SQL statement allows you to execute a SQL query in SQL Management Studio?
Click on New Query Type your SQL statement inside the SQLQuery Windows Click on Execute
This quiz covers the concepts related to Data Definition Language (DDL) in SQL Server, including database size, record size, maximum instances, processor support, and more. It also discusses the different parts of a database like tables, functions, views, rules, stored procedures, and more.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free