What is a query?
A query with respect to DBMS relates to user commands that are used to interact with a data base. The query language can be classified into data definition language and data manipulation language.
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
Explain about XQuery? 22.11.08
Xquery is a useful query language which is designed to query XML data and it is very useful in making changes to query. Its subset is Xpath. This XQuery is form...Temp tables vs. subqueries - what is faster ? 23.07.08
Generally, try never to explicitly use Temp tables. If you do, you might be missing out on a query that SQL couple execute, based on it's plans, that is far m...What are record groups? 15.05.08
A record group is an internal Oracle Forms data structure that has a column/row framework similar to a database table. However, unlike database tables, record...What are the steps you will take to improve performance of a poor performing query? 09.05.08
This is a very open ended question and there could be a lot of reasons behind the poor performance of a query. But some general issues that you could talk about...I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this ? 21.03.08
The query SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR = 'owner id' This displays the table names with that If you want only the number of tables give the follo...What is the DIFFERENCE between PRE-QUERY and POST-QUERY ? 16.03.06
PRE-QUERYÂ fires ONLY ONCE during EXECUTE-QUERY or COUNT-QUERY processing, just before Oracle Forms constructs and issues the SELECT statement to identify rows...What is the wildcard character in SQL? 14.03.06
Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would invo...What is an ABAP/4 Query? 12.03.06
ABAP/4 Query is a powerful tool to generate simple reports without any coding. ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the s...What is DML Compiler? 11.03.06
It translates DML statements in a query language into low-level instruction that the query evaluation engine can understand....What do you mean by Correlated subquery? 08.03.06
Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is written, it can be executed...