![]() |
| 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 These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables. Latest Answer : Foreign Keys are keys used in a table as an attribute and are primary keys of some other table ... Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement? Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row. 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 = ... 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 ... An outer join includes rows from tables when there are no matching values in the tables. Latest Answer : 3 types. Left outer Join----left table unmatched valyes are included.Right Outer Join---right table unmatched values are included.Full outer Join----Both table unmatched values are selected. ... The explain statement provides information about the optimizer's choice of access path of the sql. Latest Answer : The EXPLAIN statement obtains information about access path selection for an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE or DELETE statement.The information obtained is placed ... 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, ... A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities Latest Answer : Also, a Synonym is specific to the DB2 subsystem. Synonym can only access the table or view in the subsystem in which it is defined. A synonym is dropped when the table is dropped.An Alias is yet another name for a table or view. But ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||