An access path is the method used to access data specified in DB2 sql statements.
Normalization is a design procedure for representing data in tabular format. The five normal forms are progressive rules to represent the data with minimal redundancy.
Joins, unions and nested selects are used to retrieve data.
Latest Answer : The two tables has to be linked.EXEC SQL
SELECT A.EMP_ID, B.WAGE FROM Table1 A, Table2 B WHERE A.EMP_ID = B.EMP_ID
AND A.EMP_ID = ...
DDL is data definition language and DML is data manipulation language. DDL statements are CREATE, ALTER, TRUNCATE. DML statements are SELECT, INSERT, DELETE and UPDATE.
Latest Answer : DDL(data definition language)DDL Statement are · Create· Alter and· Drop DML(data ...
A view is a virtual table made up of data from base tables and other views, but not stored separately.
Latest Answer : View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating ...
The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between
An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.
Latest Answer : An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.Cheers,Sithu ...
A LIKE table is created by using the LIKE parameter in a CREATE table statement. LIKE tables are typically created for a test environment from the production environment.
The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for
The three data types are DATE, TIME and TIMESTAMP. CHAR can be used to specify the format of each type. The DAYS function calculates the number of days between two dates. (It's Y2K compliant).
Latest Answer : DATE PIC X(10)TIME PIC X(8)TIMESTAMP PIC X(26) ...
