How do you find the maximum value in a column ?
Use SELECT MAX(… Read more »
Archive for July, 2008
What are aggregate functions ?
Bulit-in mathematical functions for use in SELECT clause. Read more »
How do you select a row using indexes ?
Specify the indexed columns in the WHERE clause. Read more »
How do you eliminate duplicate values in SELECT ?
Use SELECT DISTINCT … Read more »
How would you find out the total number of rows in a table ?
Use SELECT COUNT(*) … Read more »
Describe a primary key ?
A primary key is a key that is unique, non-null, and is part of the definition of a table. A table must have a primary key to be defined as a parent. Read more »
Describe referential integrity ?
Referential integrity refers to a feature in DB2 that is used to ensure consistency of the data in the database. Read more »
What is an object ?
An object is anything that is managed by DB2 (that is databases, table spaces, tables, views, indexes or synonyms), but not the data itself. Read more »
What is an object ?
An object is anything that is managed by DB2 (that is databases, table spaces, tables, views, indexes or synonyms), but not the data itself. Read more »
What is meant by null ?
This is a special value that indicates the absence of data in a column. This value is indicated by a negative value, usually -1. Read more »
What is meant by locking ?
Locking is a process that is used to ensure data integrity. It also prevents concurrent users from accessing inconsistent data. The data (row) is locked until a... Read more »
What is meant by locking ?
Locking is a process that is used to ensure data integrity. It also prevents concurrent users from accessing inconsistent data. The data (row) is locked until a... Read more »
What is meant by locking
Grant privileges means giving access/authority to DB2 users. Read more »
What is meant by entity integrity ?
Entity integrity is when the primary key is in fact unique and not null. Read more »
What is meant by embedded SQL ?
They are SQL statements that are embedded with in application program and are prepared during the program preparation process before the program is executed. After... Read more »