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