Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Write a short note on QBE?
Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running database queries. Typically without QBE, a user must write input commands using right SQL (Structured Query Language) syntax. This is a standard language in which nearly all database programs support. Therefore, if the syntax is slightly incorrect the query might return the wrong results or may not run at all. The Query By Example feature gives a simple interface for a user to enter queries. Instead of writing an whole SQL command, the user can just fill in blanks or select items to describe the query she needs to perform. For instance, a user may need to select an entry from a table called "Table1" with an ID of 123. Using SQL, the user would required to input the command, "SELECT * FROM Table1 WHERE ID = 123". The QBE interface might permit the user to just click on Table1, type in "123" in the ID field and click "Search." QBE is offered along with most database programs, by the interface is often different among applications. For example, Microsoft Access has a QBE interface known as "Query Design View" which is totally graphical. The phpMyAdmin application used along with MySQL, offers a Web-based interface whereas users can choose a query operator and fill in blanks with search terms. Whatever QBE implementation is given with a program, the purpose is the similar - to make it easier to run database queries and to prevent the frustrations of SQL errors
Explain data dictonary on oracle ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.
The Conceptual Level or Global level The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in th
a) Suppose we updated the catalog tables in real time, that is, after every update, insert, or delete SQL statement were executed-rather than only running RUNSTATS once every few
Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have
What is OLTP (Online Transaction Processing)? In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follo
Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen
a set of possible data value of an attribute is called??
Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs
Explain query execution plan? - Optimizer available in SQL Server optimizes code to be effectively executed. - A query execution plan demonstrates how this optimizer would r
What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd