SQL and DB2 常见面试题及解答.docVIP

SQL(Structured Query Language): Structured Query Language (SQL) provides the ability to create and define relational database objects. After these objects are defined, the language permits one to add data to these objects. Once data has been added, one can modify, retrieve, or delete that data. The language provides the capability of defining what type of authority one might have when accessing the data. Data Definition Language As the name implies, there is a group of SQL statements that allows one to define the relational structures that will manage the data placed in them. The “CREATE” statements brings Relational Database Management System (RDMS) objects into existence. The types of objects one can create are STOGROUP, Database, Table space, Table, Index, View, Synonym, and Alias. The definitions of these objects are as follows: STOGROUP: A storage group is a list of disk volume names to which one can assign a name. One defines the list of disk volumes and assigns the STOGROUP name with the Create STOGROUP statement. Database: A database is a logical structure in which tables and indexes are later created. The database is defined and associated with a STOGROUP with a Create Database statement. Tablespace: A tablespace is an area on disk that is allocated and formatted by the Create Table space statement. Table: A table is an organizational structure which is defined in a Create Table statement. In this statement, the data attributes are defined by column, giving each column its own unique name within the table. Index: A index is used in conjuction with the “Primary Key” parameter of the Create Table statement. It is made with the Create Index statement and provides the duplicate record-checking necessary for a unique key. View: A view is an alternative perspective of the data present in a database. It is made with the Create View statement and can represent a subset of the columns defined in a table. It can also represents a set of columns combined from more tha