|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions An access path is the method used to access data specified in DB2 sql statements. Latest Answer : BIND command reads the SQL statements from the DBRM and produces a mechanism to access data(access path), in an efficient manner, as directed by the SQL statements being bound. ... An application plan or package is generated by the bind to define an access path. Latest Answer : DB2 plan is executable form of sql staements(DBRM).you can define DB2 plan as set of pointers to packages. And package contains machine code of best access paths. ... 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. Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement? 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 ... To maintain the integrity of DB2 objects the DBD permits access to only on object at a time. Lock contention happens if several objects are required by contending application processes simultaneously. 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 A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value. It's the DB2 equivalent of TBD on an organizational chart and often correctly Latest Answer : A NULL value is different from a blank or a zeroA NULL value can be inserted into columns of any data typeA NULL value will evaluate to NULL in any expression (e.g.NULL multiplied by 10 is NULL)If a column has a NULL value, Oracle ignores any UNIQUE, ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
