Question 1

Select the best answer.

SQL Server Management Server is a client that allows you to connect to and manage

		a client on another computer
		a spreadsheet
		an Oracle Database
		a SQL Server Database Server

10 points

Question 2

Select the valid SQL Server Data Types

		bit, smallmoney, varchar(n)
		boolean, money, int
		bit, string, number
		bit, varbinary, number

10 points

Question 3

There are several distinct types of Database Management Systems (DBMS). Select the correct type for Microsoft SQL Server.

		Flat
		Multi Dimensional
		Relational
		NoSQL

10 points

Question 4

What are the 2 authentication types used to log into SQL Server Management Studio?

		username and password
		Windows Authentication and SQL Server Authentication
		Server Authentication and Client Authentication
		Database Authentication and Server Authentication

10 points

Question 5

In order to run a SQL Statement in SQL Server Management Studio against the correct database, I need to either make sure the database name is showing in the Available Databases drop down or have what statement above the SQL Statement.

[Database Name] is used in place of your database name.

		Select [Database Name];
		Choose [Database Name];
		Set [Database Name];
		Use [Database Name];

10 points

Question 6

What is the correct SQL Statement to use to retrieve information from a table?

		create
		select
		update
		insert

10 points

Question 7

When we are writing SQL to create or modify the structure of a database, we are using Data Definition Language or DDL statements. When we are writing SQL to access or manipulate data in an existing database, we are using what type of statements.

		Database Manipulation Language or DML
		Structured Query Language or SQL
		Procedural Language/Structured Query Language or PL/SQL
		Transact Structured Query Language or T-SQL

10 points

Question 8

Choose the valid Select statementt. Only 1 of these statements is correct.

		Select % from table1;
		Select * table1;
		Select col1, col2 from table1;
		Select col1 col2 from table1;

10 points

Question 9

I execute the following statement in SQL Server Management Studio.

Select * from invoices;

I receive the following error.

"Invalid object name 'invoices'."

The invoices table exists in my database. What is the most likely issue?

		The login doesn't have permission to select from tables.
		The select statement is not being executed on the database in which the invoices table exists.
		The select statement is not written correctly.
		There are too many results to return.

10 points

Question 10

Choose the select statement that will return a result set in which the last name is sorted alphabetically descending first and then, if the last name is the same, the first name is then sorted alphabetically ascending.

		use ap; select vendorcontactlname,vendorcontactfname from vendors;
		use ap; select * from vendors order by vendorcontactlname desc, vendorcontactfname;
		use ap; select * from vendors order by vendorcontactlname desc, vendorcontactfname ascending;
		use ap; select * from vendors order by vendorcontactlname, vendorcontactfname;

Need help ASAP! please make sure you are 100% correct!!

Thank you!!!!!