Question 1 Select the best answer. SQL Server Management Server is a client that

Question

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!!!!!

a client on another computer

a spreadsheet

an Oracle Database

a SQL Server Database Server

Explanation / Answer

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

Ans. a SQL Server Database Server; it monitors the performance and availability of production databases. It is an agentless monitoring solution that provides out-of-the-box performance metrics making sure that the SQL server runs efficiently.

Question 2: Select the valid SQL Server Data Types

Ans. bit, smallmoney, varchar(n)

string, boolean and number are not valid data types

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

Ans. Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments.

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

Ans. Windows Authentication and SQL Server Authentication

To connect to your database through Microsoft SQL Server Management Studio, you have 2 Authentication choices. Windows Authentication and SQL Server Authentication.

If you are connecting to your database from a remote location, such as your Home or Office, you are going to want to use SQL Server Authentication.

An alternative to SQL Server Authentication, is Windows Authentication. This is useful if you are logged directly into your Database Server through Remote Desktop.

Hope it helps...

BEST WISHES!

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.