0
What else can I help you with?
Which data collection method accurately measures all variables important to OD?
None, no single method can fully measure the kinds of variables important to OD because each has certain strengths and weaknesses.
What is the difference between single threaded and multi threaded process?
A write-up of the answer to this question can be found here:http://msdn.microsoft.com/en-us/library/ms693344(VS.85).aspx"There are two types of apartments: single-threaded apartments, and multithreaded apartments. * Single-threaded Apartments-Single-threaded apartments consist of exactly one thread, so all COM objects that live in a single-threaded apartment can receive method calls only from the one thread that belongs to that apartment. All method calls to a COM object in a single-threaded apartment are synchronized with the windows message queue for the single-threaded apartment's thread. A process with a single thread of execution is simply a special case of this model.* Multithreaded Apartments-Multithreaded apartments consist of one or more threads, so all COM objects that live in an multithreaded apartment can receive method calls directly from any of the threads that belong to the multithreaded apartment. Threads in a multithreaded apartment use a model called free-threading. Calls to COM objects in a multithreaded apartment are synchronized by the objects themselves."
What is unnormalized relation in dbms?
An unnormalized relation in a Database Management System (DBMS) is a table that does not conform to the rules of normalization, meaning it may contain repeating groups or arrays of values within a single column. This structure can lead to data redundancy and anomalies during data manipulation. To improve data integrity and efficiency, unnormalized relations should be transformed into normalized forms, which separate data into distinct tables with relationships defined among them. Normalization helps eliminate redundancy and ensures consistency in the database.
What is scalability of SQL?
Scalability of SQL refers to the ability of a SQL database to handle increasing amounts of data and user load without compromising performance. This can be achieved through vertical scaling (adding more resources to a single server) or horizontal scaling (distributing the database load across multiple servers). While SQL databases traditionally excel at vertical scaling, they can also be optimized for horizontal scaling through techniques like sharding and replication. However, scalability can be limited by factors such as schema rigidity and ACID compliance requirements.
What difference between data warehouse and traditional database used OLTP?
{| |+ Differences |- | Data warehouse database OLTP database Designed for analysis of business measures by categories and attributes Designed for real time business operations. Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table. Optimized for a common set of transactions, usually adding or retrieving a single row at a time per table. Loaded with consistent, valid data; requires no real time validation Optimized for validation of incoming data during transactions; uses validation data tables. Supports few concurrent users relative to OLTP Supports thousands of concurrent users. |}http://www.geekinterview.com/question_details/15800
Definition of database field?
A database field is a specific piece of information within a database table that holds data of a particular type, such as text, numbers, dates, or binary data. It represents a single attribute of an entity or object being stored in the database and is used to organize and retrieve information efficiently.
What is data replication?
The process of creating and managing duplicate versions of a database. Replication not only copies a database but also synchronizes a set of replicasso that changes made to one replica are reflected in all the others. The beauty of replication is that it enables many users to work with their own local copy of a database but have the database updated as if they were working on a single, centralized database.For database applications where users are geographically widely distributed, replication is often the most efficient method of database access.
Where can you find a comparison between oracle snapshot replication and oracle streams replication?
The process of creating and managing duplicate versions of a database. Replication not only copies a database but also synchronizes a set of replicas so that changes made to one replica are reflected in all the others. The beauty of replication is that it enables many users to work with their own local copy of a database but have the database updated as if they were working on a single, centralized database. For database applications where users are geographically widely distributed, replication is often the most efficient method of database access.
How is data organized in a database?
Data in a database is organized into tables, which consist of rows and columns. Each row represents a single record, while each column represents a specific attribute of that record. Relationships between tables can be established through keys to organize and retrieve data efficiently.
What is a row in a database?
A row in a database represents a single record or entry within a table. It contains a set of related data fields that are organized into columns, with each column representing a different attribute or variable associated with that record. Rows are used to store and retrieve information in a structured manner within a database.
What is single-user database?
Single-user database support only one user at a time
What does the term keys mean in database?
There are six keys in database that we use . Each key serves specific functions like primary is used to identify a tuple uniquely. Keys in database are Primary, surrogate, foreign, alternate , candidate, super.
What is the example of single user database?
single-user database supports only one user at a time. In other words, if user A is using the database, users B and C must wait until user A is done. A single-user database that runs on a personal computer is called a desktop database.
What is a centralised database?
A centralised database is a single database under the control of a single Database Management System. All users and client applications connect directly to the DBMS. This means that the database is stored in only one location and everyone in the system is directly connected to it. Unlike a distributeddatabase which is a set of connected databases stored on multiple computers that appears to users as a single database.
You wants to print a single record in crystal report using vb6 but you don't where and how you write query to retreive single from database?
As you enter Visual Basics select windows form applications. Name form, select single or multiple. After selecting what sort of form you like to create proceed to link your contacts page or table to database. Apply filter query and select printer action.
Any large single block of data stored in a database such as a picture or sound file which does not include record fields and cannot be directly searched by the databases search engine?
A binary large object (BLOB) is a data type used to store large amounts of binary data in a database, such as images or audio files. BLOBs are typically indexed but are not directly searchable by the database search engine, as they are stored as a single entity rather than separate fields. To retrieve or access the contents of a BLOB, you typically need to reference it using its identifier.
In access each row in a table contains a what?
In Access a table has records which are the rows and fields which are columns. To retrieve specific data in a database you have to use a query.
