Information Management Prefinals

It is a specific request for data manipulation issued by the end-user or the application to the DBMS

• Query

• Structured Query Language

• DBMS

• Server

SQL stands for?

• Structured Query Language

• Structure Queries Language

• Sequential Query Language

• System Query Language

How is SQL commonly pronounced?

• Only as "sequel"

• Only as individual letters: "S-Q-L"

• Both as "S-Q-L" and "sequel", depending on preference

• As "Squeal", following standard acronym pronunciation rules

Which of the following is not a function of SQL?

• Create database and table structures

• Perform various types of data manipulation and data administration

• Query the database to extract useful information

• Design the user interface for database applications

Among are the popular Database Management tools EXCEPT

• Microsoft SQL Server

• MySQL

• Oracle RDBMS

• Microsoft Access

• Netbeans

SQL Data Types

---

Exact Numeric

• bigint, bit, decimal, int, money, numeric

• float, real

• date, datetime, time

• char, text, varchar

• nchar, ntext, nvarchar

SQL Data Types

---

Approximate Numeric

• bigint, bit, decimal, int, money, numeric

• float, real

• date, datetime, time

• char, text, varchar

• nchar, ntext, nvarchar

SQL Data Types

---

Date and Time

• binary, image, varbinary

• float, real

• date, datetime, time

• char, text, varchar

• nchar, ntext, nvarchar

SQL Data Types

---

Character Strings

• binary, image, varbinary

• float, real

• date, datetime, time

• char, text, varchar

• nchar, ntext, nvarchar

SQL Data Types

---

Unicode character strings

• binary, image, varbinary

• float, real

• date, datetime, time

• char, text, varchar

• nchar, ntext, nvarchar