0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What are the different types of database languages?
Two main types:
Relational Calculus based Language
Relational Algebra based Language.
These languages provide similar set of operations but with different syntax. Calculus based is more kind of procedural and near to English, while Algebra based uses a set of symbols for queries.
How to insert values in to a table in SQL?
SELECT columns FROM tables INTO tablename - will create and insert values
INSERT INTO table SELECT columns FROM tables - will insert from one or more tables into a table
INSERT (columns) INTO table VALUES (literals) - will insert literal values into row in a table
What is the difference between data base and data base management system?
data base means a collection of data,which may be inter related.
data base management system is a collection of programs for managing the data base.
What is directed data mining and undirected data mining?
In directed data mining, you are trying to predict a particular data point - the sales price of a house given information about other houses for sale in the neighborhood, for example.
In undirected data mining, you are trying to create groups of data, or find patterns in existing data - creating the "Soccer Mom" demographic group, for example. In effect, every U.S. census is data mining, as the government looks to gather data about everyone in the country and turn it into useful information.
When managing a company's database the database requires a technical inside view of data.?
administrator
How do you use database technology to achieve product differentiation?
The term "product differentiation" refers to making a product stand out from others, to attract buyers from a particular segment. Database technology can help if it is sorted to display potential buyers from the target market.
How database help in your life?
Lots of people use databases, teachers, doctors even librarian's. For example, a librarian uses a database to keep information of all the people who borrow books from the library, their names, address, contact numbers and so on!!:)
What are disadvantages of pl-sql?
Disadvantages of Oracle PLSQL
If you're just running Oracle databases, there are no major disadvantages to using PL/SQL as long as you're aware of its limitations.
Proprietary to Oracle
PL/SQL is proprietary to Oracle which means if you were to change database vendors then you would have to re-write all your Oracle PL/SQL programs. Also if you use a mixture of databases or develop applications to run on different databases, you will either have to support lots of source code or write your applications in a database-neutral language like Java, VB or C and use the APIs to access the database.
Poor I/O Features
The other limitation of Oracle PL/SQL is that there is very little support for i/o either to read/write files or to read from or write to a user interface. The rationale behind this is that PLSQL is designed for manipulating information from the database and not for processing files or communicating with users. These operations are possible - they just require a little bit more effort!
How does relational database relate to programming?
A relational database system is a set of generalized methods for organizing, storing and retrieving information. For certain types of computer applications, the use of a relational database greatly reduces the time and effort needed to design, write and debug new software, by eliminating the need to develop code to handle storage, sorting and retrieval for each program.
What are the problem encountered in manual billing system?
The problem encountered in manual billing system is wasting time.
What is the Vista tool that can give you a quick report of the overall performance of the?
Windows Experience Index Guide to Software Fifth Edition pg. 245
i don't have a answer
What are the two effects that can be expected by installing database system?
Improvement of independence of programs and data.
What is the purpose of the vlan database?
Vlan database is vlan.bat file which is stored in flash memory and earlier in NVRAM. It is used to store vlan information. we can take back up of this file.
What do hotels use databases for?
Hotels use databases to store the names and information of the people who are staying and when they are staying. They also use them to keep track of the hours people work, which rooms are clean and ready, which guests want wakeup calls or breakfast, and which ballrooms are going to be used for future events.
Is Ingres an open source database?
Yes. Development is managed by Ingres Corporation, but the source code is released under the GNU General Public License.
What advantages do databases have over flat files?
1. files are can easily get damaged for e.g by water or fire and etc but a data base cant so easily get damaged you can find delete or edit files on the data base easily while if you hv a big file it is hard
