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
Which report creation tool will automatically pull in all the fields from a table or query access?
Report tool
In order to create a query using the Simple Query Wizard you choose the?
data source and the field name
Data mining just means gathering information. The purpose of data mining is to collect as much information as possible about any particular issue so that analysts can spot trends and predict what is likely to happen next. It is useful for companies because it helps them tailor their goods and services for the market.
What is difference between multimedia file system and traditional file system?
Files are generally stored in secondary storage devices, traditional file system employs contigious placement or non contigious placement in the disc space, however the challange in multimedia file systems are they are large and may have real time characterstics therefore they need separate paradiagm for file systems .some of them are Vedio servers , symphony, fellini .they support video , realtime multimedia parameters.
What are similarities of a floppy disk and a hard disk?
In their basic form, floppy discs are common hard disks are the same technology. They both use magnetism to store and read data. They both use a spinning platter read by a horizontally moving read head.
The key differences are that hard disks have the data and reader in the same package, this is why hard discs have evolved in storage capacity while floppy disks remained the same. It was necessary for the written layer of a floppy disk to have the same data density and dimensions as they had to be compatible with floppy disk drives. However with hard discs the drives and read heads could evolve along side the data layer.
Hard discs now have metal platers, and store data at a much higher density. The speed of the mechanisms are much much faster. New technologies such as perpendicular storage can be added and have no impact on compatibility.
A file is nothing but a term used by database administrators and programmers where data is stored in a specific format. In short, a file is where in all the records or sets of records are stored on a computer.
What is remote transaction processing?
A remote transaction contains one or more remote statements, all of which reference a single remote node. For example, the following transaction contains two statements, each of which accesses the remote sales database:
UPDATE scott.dept@sales.us.americas.acme_auto.com
SET loc = 'NEW YORK'
WHERE deptno = 10;
UPDATE scott.emp@sales.us.americas.acme_auto.com
SET deptno = 11
WHERE deptno = 10;
COMMIT;
Why is file management important for overall sYstem performance?
A well manged, carefully arranged, files make it easy to obtain data for business decisions in an organization.
It also provides the users with timely, acurate and relevant information. It reduces costs, and there is flexibility in information processing.
Can you draw dfd without database?
DFD means data flow diagram and database is an integral part of the DFD. It is not possible to draw a DFD without a database, since there has to be a place for data storage in the overall business process flow.
Should a prosecutor have direct access to an criminal intelligence database?
No, only federal agents and police officers. Now, if the prosecutor has perismission from the government (local, state or federal), than its okay.
What Is the process of collecting data from the Internet as a source for the data warehouse?
Web Farming.
What is the DBMS evaluation features?
It's divide into few parts. 1. Data Definition 2. Physical Definition 3. Accessibility 4. Transaction Handling 5. Utilities 6. Development 7. Others feature such as : Upgradibility, Vendor Stability, User Base, Cost etc.
What database object allows you to select specific information from one or many tables?
You are referring to the Microsoft Access Database. This allows you the ability to select specific information from one or many tables.
What is Difference between real time database and simple database?
the difference is about the transactions. the normal database is not included deadline, but the real time database is.
Entity Relationship Diagrams (ERD's) are a way of diagrammatically showing entities in an organisations and how they relate to each other. ERD's show detailed representations of the information that is used in a system and how it relates to other data. There are a number of symbols that represent the entities and the relationships between them; the relationship can be a one to many relationship, many to many or one to one.
What is the difference between mysql connect and mysql pconnect in PHP?
The difference between connect() and pconnect, it is simply like a shop when u entering in shop you will open the door and take your iteam come out and close the door that is called connect() in mysql the connection to the mysql database will be automatically closed when the script terminates.
when the door of the shop is already opend and never close it is called pconnect(), open a connection with mysql_pconnect(), the connection will not be closed and will "persist" for future use.
