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
DBMS has replaced the traditional file system?
Yes. Database Management Systems (DBMS) have replaced the traditional file based data storage systems. This is because they are:
- More powerful
- Easier to manange
- Can store large volumnes of data
- Manipulation & fetching of data from a DBMS is many times easier than doing so from a file based data storage system
- Faster
How cost effective is a database system?
This is proportional to the intrinsic value of the data, need and method for accesing such data, and the need to keep data organized.
What are disadvantages data capture?
EXPENSIVE..
why..
-COST of buying it
-ACCESSORISES (you know like memory card)
-when something goes wrong COSTS to fix
OR if not expensive
-Bad quality
A drum trigger converts energy produced by stick attack into electrical impulses. The impulses are then supplied to the drum module (brain of the system) via cables.
The trigger can also be called a transducer. By definition, a transducer is "a device that is stimulated by power from one system and supplies power to second system - usually in another form".
Answer By :
Suresh Saxena , Sybase Developer
suresh1_saxena@rediffmail.com
How does a theme park use ICT to promote itself?
ICT is used in theme parks by tills in gift shops and in the computers that control and program the different rides.
ISOPREP, or Isolated Personnel Report, is a type of data card for those considered "at risk." It serves recovery purposes for soldiers that would be MIA since it contains their personal information.
You can relate the data present in multiple tables by using the concept of Foreign Keys. for example if we have an employee database that contains various details of an employee scattered in multiple tables, one column in each table can be used to logically group the data in all these tables. For example, the employee number column in each of these tables can be used to relate the data present in these tables.
What is teradata in data warehousing?
Teradata is a RDBMS system like Oracle or SQL Server but designed specifically for use in data warehousing. Data Warehouses contain extremely large amounts of data that normal RDBMS systems like oracle or sql server cannot handle comfortably. They may eventually be able handle the data but their performance may not be the best. Teradata is a system that is specifically designed for handling such extremely high volumnes of data.
What is the defintion of database?
Database can be defined as an organized collection of data. I t stores a huge amount of data. The objective of database is to store whole the data at one place and can be accessed when needed.
What are the alternatives to oracle database?
Reasonable alternatives would be MS/SQL, MySQL, PostgreSQL, and other server-based relational databases. Somewhat less reasonable options that might work for small single-user applications are FileMaker Pro and Microsoft Access (among others).
The i stands for "Internet". Oracle 8i and 9i has the i suffix because it was released during the Internet boom and it's trying to capitalize it. Since 10 the suffix has becoming "g" which stands for grid. Again, it's try to ride the whole grid computing marketing that's happening throughout the IT industry.
A LEG INSTANCE is an instance of a FLIGHT LEG on a specific Date (for example,
CO1223 leg 1 on July 30, 1989). The actual Departure and Arrival AIRPORTs and
Times are recorded for each flight leg after the flight leg has been concluded. The
Number of available seats and the AIRPLANE used in the LEG INSTANCE are also
kept.
Pl sql programs executes in sql server?
PL\SQL is an Oracle product (the PL stands for procedural language), while Sql Server most commonly refers to Microsoft SQL Server, although at one point Sybase also marketed its product as Sql Server. Microsoft and Sybase both have a procedural language feature, called T-SQL (Transact-SQL), which is similar in concept to PL\SQL, but there are significant differences in syntax and structure. An experienced developer could convert PL\SQL to T-SQL readily, but conversion would be required. It would not run without conversion.
What are the parts of a basic SQL query?
The basic parts of a SQL Select query are:
SELECT column names FROM table name
WHERE conditions
ORDER BY column names
The basic parts of an insert query would be:
INSERT INTO table name (VALUES)
The basic parts of a delete query would be
DELETE FROM table name WHERE conditions
The basic parts of an update query would be
UPDATE TABLE table name SET column name = value WHERE conditions
Well... they do not appear to be selling anything so what would you need it for? Lots of legitimate service websites do not post their address or telephone number to prevent unwanted solicitation. Ebay did not have any contact information until recently and they are considered by most people to be legitimate.
Update: Check the FAQ on their site. That question is answered there.
What is strong entities vs weak entities?
The table that has primary key is strong entity and the table that has no primary key is weak entity
What is the difference between a Production DBA and an Application DBA?
Production DBAs take over after applications have been created, keeping the server running smoothly, backing it up, and planning for future capacity needs. Network administrators that want to become DBAs get their start by becoming the de facto DBA for backups, restores, and managing the server as an appliance.
Development/Application DBA Career PathDevelopment DBAs are more like cooks: they don't necessarily know anything about Freon, but they know how to whip up a mean dish, and they know what needs to go into the fridge. They decide what food to bring home and put in the chill chest, what should go into the fridge and what should go into the freezer.Development DBAs focus on the creation process, working with programmers and architects to build solutions. Programmers that want to become DBAs usually get a head start on the development role because of their programming experience. They end up doing the development DBA position by default when their team needs database work done.
