Introduction to SQL (Part I)

Front

What is a query in SQL?

Back

A specific request for data manipulation issued by the end-user or the application to the DBMS.

Front

What does SQL stand for?

Back

Structured Query Language.

Front

How is SQL pronounced?

Back

As S-Q-L or 'sequel'.

Front

What are the main functions of SQL commands?

Back

Create database and table structures, perform various types of data manipulation and data administration, and query the database to extract useful information.

Front

Name some popular Database Management Tools.

Back

Microsoft SQL Server, MySQL, Oracle RDBMS, Microsoft Access.

Front

What are the common exact numeric data types in SQL?

Back

bigint, bit, decimal, int, money, numeric.

Front

What are the approximate numeric data types in SQL?

Back

float, real.

Front

What are the character string data types in SQL?

Back

char, text, varchar.

Front

What are the Unicode character string data types in SQL?

Back

nchar, ntext, nvarchar.

Front

What are the binary string data types in SQL?

Back

binary, image, varbinary.