SQL, MS SQL Server

What is a view?

- A virtual table which results from executing a pre-compiled query

Syntax for creating views

CREATE VIEW AS SELECT

What is Microsoft SQL Management Studio

A front end tool used for the development of an SQL server database

Outer Join

A join that includes rows that do not have matching values*

In MS SQL Server, what is used to build SQL statements without writing any code

Query Designer

TCL commands

ROLLBACK, SAVEPOINT

Which of the following is one of the basic approaches for joining tables? Select one: a. Subqueries b. Union Join c. Natural join d. All of the Mentioned

d. All of the above

Which of the following is a database object? Select one: a. Tables b. Triggers c. Functions d. All of the mentioned

d. All of the mentioned

Which of the following statement is true? Select one: a. Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our needs b. Views are virtual tables that are compiled at run time c. Creating views can improve query response time d. All of the Mentioned

d. all

If you don't specify ASC or DESC after an SQL ORDER BY clause, what is used by default?

ASC

SQL clause to delete tuples from a database

DELETE

How to delete a view?

DROP VIEW

DML

Data Manipulation Language

TRUNCATE

Removes all rows from a table without logging the individual row deletions

SQL: MAX

Returns the largest value in a given column

SQL: COUNT()

Returns the number of records

What is SQL?

Structured Query Language (SQL) is used to create and use databases, tables, and relationships. SQL is divided into two categories: SQL statements for database definition and SQL statements for database processing (querying and updating). The database definition commands are referred to as a data definition language (DDL), and the database query and update commands are referred to as a data manipulation language (DML). SQL was developed by IBM, and is endorsed as a national standard by the American National Standards Institute (ANSI). Although a newer standard, SQL3, exists, the most widely implemented version of SQL is the ANSI SQL-92 standard. SQL is not a full-featured programming language, but rather it is considered to be a data sublanguage.

The AFTER trigger in SQL Server can be applied to what?

Tables and Views

Which of the following tool is used for designing schema of the database in SSMS? Select one: a. Query Designer b. Database Diagrams c. Table designer d. Query Editor

c. Table designer

SQL Server has how many types of views?

two