0
When need to retrieve only a single value from the database which method is efficient?
Wiki User
∙ 10y ago
ExecuteScalar()
Wiki User
∙ 10y ago
peoplebussy
Execute
Add your answer:
Earn +20 pts
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 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
How does normalization reduce data redundancy?
Normalization is being applied for the database to reduce redundancy as in case of first normal for remove the redundant data from rows and in 2nd normal form it removes the redundant data vertically and in 3rd normal form it looks for the redundant data and whether it is non transitively depend on the primary key or not in other words it is the technique of breaking down the complex table into understandable smaller one to improve the optimization of the database structure and data redundancy is the data organization issue that allows the unnecessary duplication of data within the database. For example the first normal form where there should be one key in every table to uniquely each row thus no rows should be repeated and each entry must contain a single value and not multiple values .for instance employee, employee name, telephone numbers.
What is the probability of rolling a dice 7?
With a single throw of a normal die, the probability is 0.With a single throw of a normal die, the probability is 0.With a single throw of a normal die, the probability is 0.With a single throw of a normal die, the probability is 0.
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.
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 are the advantage of distributed database over centralized database?
Distributed databases offer advantages such as improved scalability, increased availability, and better fault tolerance compared to centralized databases. They also provide better performance by reducing network latency and enabling data to be processed closer to where it is needed. Additionally, distributed databases can offer better data security by replicating data across multiple locations.
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?
In Crystal Reports, you can write the query directly in the report designer. In the "Database Expert" window, right-click on "Add Command" and write your SQL query to retrieve the single record. After defining the query, you can link it to your report elements to display the data accordingly. Using VB6, you can then call the Crystal Report Viewer to display the report with the single record retrieved from the database.
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.
What is a single item of information in a database?
A single item of information in a database is referred to as a data field. It represents a specific piece of data stored within a record or a row in a database table. Examples of data fields include names, addresses, phone numbers, and dates.
What is all of the fields for a single database entity?
Record
What is single-user?
Single-user database support only one user at a time
