SQL Server and Database

The "import flat tile" task wizard allows you to append data to an existing table. a) True b) False

False

In order to relate records together, primary key columns and foreign key columns must? a) not allow null values b) be integers c) have the same data type d) have the same name

c) have the same data type

Unique constraints are added to a table via a table ___? a) verification rule b) check c) index d) differentiator

c) index

Sample databases are added to a SQL Server instance by right-clicking the "Databases" folder and choosing? a) load b) add database c) restore database d) attach

c) restore database

When using the "Is Identity" property, the ___ sets the starting value and the ___ establishes how much each successive value will increase by. a) initial value; additional value b) first; next c) seed; increment d) core; pattern

c) seed; increment

What command-line utility does SQL Server install for sending commands directly to the server? a) Query Engine b) PowerShell c) sqlcmd d) prompt

c) sqlcmd

What is the shortcut key used to execute a T-SQL Query? a) F5 b) Ctrl-E c) F1 d) Shift + Enter

a) F5

Sorting records returned by a SELECT statement is done with a ___ clause. a) ORDER BY b) SORT ON c) ASCENDING d) GROUP BY

a) ORDER BY

SQL Server is an example of what? a) RDBMS (Relational Database Management) b) database c) data table d) SSMS (SQL Server Management Studio)

a) RDBMS

When deleting records from a table, it is very important to include which clause in the DELETE FROM statement? a) WHERE b) FROM c) ON d) FILTER

a) WHERE

Which of these limit results to just the employees named Brandon with a salary over $50,000? a) WHERE EmployeeFirstName = 'Brandon' and Salary > 50000 b) WHERE EmployeeFirstName = 'Brandon', Salary > 50,000 c) WHERE EmployeeFirstName = 'Brandon' and WHERE Salary > 50000 d) WHERE EmployeeFirstName = 'Bradon' WITH Salary > 50000

a) WHERE EmployeeFirstName = 'Brandon' and Salary > 50000

For a table with only one primary key column, the values stored must be? a) integers b) indentities c) alphanumeric d) unique

d) unique

Query Stores saves execution plan performance information to in-memory tables so that they're very quick to access. a) True b) False

b) False

Table joins can only be created between fields with the same name. a) True b) False

b) False Joins can be created as long as the data is of the same type. The actual names of the columns is irrelevant.

To modify data stored in a table, use an UPDATE statement paired with a ___ clause. a) VALUE b) SET c) STORE d) SAVE

b) SET

What programs should you use to start, stop, and restart SQL Server instances? a) SQL Server Connection Wizard b) SQL Server Configuration Manager c) SQL Server Agent d) SQL Server Instance Maintenance

b) SQL Server Configuration Manager

The ___ command will delete all data from a table, while the ___ command is used to delete a table from the database. a) REMOVE; DROP b) TRUNCATE; DROP c) RESET; DELETE d) TRUNCATE; REMOVE

b) TRUNCATE; DROP

The ___ data type will store the largest integer values that SQL Server is capable of working with. a) largeint b) bigint c) int(max) d) hugeint

b) bigint

What command will end your sqlcmd session and close the connection to the SQL Server instance? a) stop b) exit c) ^x d) end

b) exit

In the design pan of the view designer, what indicates the foreign key side of a one-to-many relationship? a) key icon b) infinity symbol c) the letter 'n' d) the initials 'FK'

b) infinity symbol

Indexes on columns that aren't the primary key are called what? a) subordinate b) nonclustered c) insubordinate d) clustered

b) nonclustered

Horizontal rows in a data table are called? a) data b) records c) attributes d) fields

b) records

What search method does SQL Server perform when locating table records without the assistance of an index? a) heap b) scan c) sort d) seek

b) scan

On the command line, which command can you run to view the syntax summary for sqlcmd? a) sqlcmd -h b) sqlcmd -? c) sqlcmd -docs d) sqlcmd --help

b) sqlcmd -?

After saving a .sql script file, colored bars will display in the editor to indicate the status of the file. What color indicates lines that have been modified? a) green b) yellow c) black d) red

b) yellow

Which execution plan can you view after a query is run? a) Executed b) Physical c) Actual d) Estimated

c) Actual

T-SQL SELECT statements always include what clause? a) WITH b) INTO c) FROM d) VALUES

c) FROM

Which T-SQL keyword is used to add new records to a table? a) APPEND b) RECORD c) INSERT d) SAVE

c) INSERT

Which of the following statements is correct about Microsoft's Transact-SQL language? a) It was developed before the ANSI standard for SQL. b) It is fully compatible with ANSI SQL. c) It is not compliant with the ANSI SQL standard. d) It can be used along side ANSI SQL in SQL Server.

c) It is not compliant with the ANSI SQL standard.

Which join type will return all of the records from the right table and only matching information from the table on the left? a) OUTER JOIN b) LEFT JOIN c) RIGHT JOIN d) INNER JOIN

c) RIGHT JOIN

When importing data into a SQL Server database using the "import data" task, what destination option should you choose? a) Transfer Wizard b) Local Database c) Management Studio Importer c) SQL Server Native Client

c) SQL Server Native Client

When entering data into a new record in the SSMS graphical interface, at what point does that data get saved into the database? a) Data is saved to the database immediately after each fields is validated. b) When the save button is clicked in the toolbar. c) When all fields have valid data and the row is deselected. d) When all records for that session are entered and the tab is closed.

c) When all fields have valid data and the row is deselected.

Which property of a foreign key will ensure that data relates back to a record in the primary key table? a) enable primary key check b) verify relationship c) enforce foreign key constraint d) enforce relationship parameter

c) enforce foreign key constraint

In a relational database, data stored in a primary key column in one table relates to data stored in a ___ column in another table. a) secondary key b) subordinate key c) foreign key d) encryption key

c) foreign key

Which SQL Server function will return the current system date and time? a) now( ) b) datetime2( ) c) getdate( ) d) fetchdatetime( )

c) getdate( )

What file extension does the primary SQL Server data file use? a) .data b) .pdb c) .ssdb d) .mdf

d) .mdf

Which index maintenance task discards the entire index and recreates it? a) Refresh b) Remake c) Reorganize d) Rebuild

d) Rebuild

To ensure that data meets your requirements before allowing it into the database, you can add a(n) ___ to the table. a) index b) primary key c) validation rule d) check constraint

d) check constraint

Which three pieces of information do you need to provide to create a table column? a) primary key, identity length b) name, data type, properties c) data type, alias, precision d) name data type, allow nulls

d) name data type, allow nulls

With a columnstore index, how many table columns are stored in a single page on disk? a) zero b) the first two c) all of them d) one

d) one