What is a result table ?
A result table is the product of a query against one or more tables or views ( i.e. it is the place that holds the results of a query).
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What are the steps to transform XML into HTML using XSL? 04.12.08
An XSLT processor may output the result tree as a sequence of bytes.The xslutput element allows stylesheet authors to specify how they wish the result tree to b...How can we find the number of rows in a result set using PHP? 06.11.08
Here is how can you find the number of rows in a result set in PHP: $result = mysql_query($any_valid_sql, $database_link); $num_rows = mysql_num_rows($r...What Snow Flake Schema ? 25.09.08
Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. Fo...What is the difference between view and materialized view? 20.09.08
View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. Materialized view -...Why are recursive relationships bad? How do you resolve them 11.05.08
A recursive relationship (one where a table relates to itself) is bad when it is a hard relationship (i.e. neither side is a "may" both are "must") as this can...What is read-only cursor ? 10.04.08
A read-only cursor is one in which the result table was created by a query containing one of the following : • a DISTINCT keyword • a UNION o...Difference between Dynaset and Snapshot? 17.04.07
All Recordset objects are constructed using records (rows) and fields (columns). There are five types of Recordset objects: Table-type Recordset :: represen...What are the types of tables? 14.04.07
1) Transparent table 2) Pool table 3) Cluster table are data dictionary table objects 4) Sorted table 5) Indexed table 6) Hash table 7) Internal tables....What is a mutating and constraining table? 22.08.06
"Mutating" means "changing". A mutating table is a table that is currently being modified by an update, delete, or insert statement. When a trigger tries to ref...What is SNAPSHOT ? What is a SNAPSHOT LOG ? 16.03.06
A SNAPSHOT is a means of creating a local copy of remote data. A snapshot can be used to replicate all or part of a single table, or to replicate the result...