Create
Learn
Share

SQL

rename
zozopotu's version from 2015-06-10 16:47

SQL Server version

Question Answer
SQL Server 77
SQL Server 20008
SQL Server 20059
SQL Server 200810
SQL Server 2008R210.5
SQL Server 201211
memorize

SQL

Question Answer
What is SQLSTRUCTURAL QUERY LANGUAGE
What are the possible forms of SQLTSQL, DDL, DML ,DQL, TCL, DCL, MDX
What is TSQLTRANSACT STRUCTURAL QUERY LANGUAGE
What is DDLData Definition Language "CREATE, DROP, ALTER"
What is DMLData Manipulation Language "DELETE, INSERT, UPDATE"
What is DQLData Query Language "DELETE, INSERT, UPDATE" AKA "DELTA OPERATIONS" Δ
What is TCLTransaction Control Language "COMMIT, ROLLBACK, SAVE Transaction"
What is DCLData Control Language "GRANT, REVOKE". It's used to control access to data.
What is MDXMultidimensional Expressions. It's the querry language for OLAP
What are the most common SQL statement typesDML, DDL
memorize

 

http://www.takveen.com/z-art_comp_ora_sql_ch1_p3.html

Data Types

Question Answer
What are the most common data types in SQL ServerInt, BigInt, Small Int, Tiny Int, Bit, Char, varchar, nVarchar, Float, Money.
What is Char data type?
memorize