6. Beginning SQL Server

Beginning SQL Server

by Coursera Project Network

Graded Quiz Answers :

1.Question 1

Where will you find the option to add line numbers to the New Query window? 

1 / 1 point

Under Tools, Options, Text Editor, All Languages 

By right-clicking Databases in the Object Explorer

Under View, Other windows.

Under the Help menu 

2.Question 2

What is the SQL statement to make a new database?

1 / 1 point

SELECT DATABASE

CREATE DATABASE

CREATE

MAKE DATABASE

3.Question 3

What is the SQL statement to make a new table?

1 / 1 point

CREATE TABLE

CREATE COLUMNS

MAKE TABLE

CREATE

4.Question 4

How do you add a column to a table?

1 / 1 point

Right click the table, select Design, then select Insert Column

Right click the table, select Design, then right click and select Insert Row

Right click the table, select Design, then right click and select Insert Column

Right click the table, select Insert Column

5.Question 5

What two methods can be used to change a users password?

1 / 1 point

Use the SQL Statement ALTER or from the Edit menu.

Use the SQL statement ALTER or double-click username in Object Explorer 

Use the SQL statement CHANGE or double-click username in Object Explorer.

Use the SQL Statement SELECT or from the File menu.

6.Question 6

What statement should be used to create a table with columns?

1 / 1 point

Create table with columns 

CREATE TABLE [name of table] [column names and type]; 

CreatTblColumns [column1, column2...] 

Createdb 

7.Question 7

A transaction statement is a

1 / 1 point

method to combine two queries into one

way to execute two queries at the same time and lock the second query until the first query finishes

note from your bank

method to transact two SQL statements

8.Question 8

What is the SQL statement to backup your database?

1 / 1 point

BACKUP DATABSE [your name] TO DISK=’C:\[folder name]\[name of database.bak

BACKUP [name of database] TO [folder name] 

BACKUP DATABSE [your name] TO DISK=’C:\[folder name]\[name of database

BACKUP DATABSE [your name] TO ’C:\[folder name]\[name of database]