Difference between Query and ad hoc query

A query is a specific request for data manipulation issued to the DBMS. Simply put, a query is a question and an ad hoc query is a spur -of-the-moment question. A query language is a nonprocedural language- one that let the user specify what must be done without having to specify how it is to be done. Structured query language is the de facto query language and data access standard supported by the majority of DBMS vendors.

MetaData

It is the data about the data, through which the end user data are integrated and managed. The metadat provide a description of the data characteristics and the set of relationships that link the data found within the database. The DBMS stores definitions of the data elements and their relationships(metadata) in a data dictionary.

 


Elements of a ASP.NETpage | ASP.NET General Test Questions | ASP.net 2.0 DataControls | Client/Server Software Architecture | Configure Microsoft SQL Server for Mixed Mode Authentication | Connection Pooling | Cookies | Create Table and Insert table command | Database Life Cycle | Data Source Controls in ASP.net2 | Difference between DLL and exe? | Difference between Interface and Class? | Difference between Query and ad hoc query | Difference between Truncate and delete command | Using Microsoft Visio for ERD drawing | Event Bubbling | Functions and Delegates in ASP.NET | Global assembly Cache(GAC) | Input Validation Controls in ASP | Vb Interview Questions | What are Joins? | What is an N-tier application? | Outer Join and Inner Joins | Pascal Notation | What is a Process? | Resources | ASP.net 2 SqlDataSource Control | System Development Life Cycle | Table structure | Thread | Transaction Control Statements | Triggers and Stored procedure and difference between them | Notations used in Visual Basic | RadioButton in Visual Basic | Structure in Visual Basic | What is a 3 -tier architecture? | What is ASP.NET? | What is Boxing and Unboxing | What is Data Dictionary? | Function | Reflection | Difference between XHTML and HTML