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 is the Delorme procedure?
used to treat rectal prolapse.The Delorme procedure involves the resection of only the mucosa (inner lining) of the prolapsed rectum. The exposed muscular layer is then folded and stitched up and the cut edges of mucosa stitched together.
Describe Procedural query language and non procedural query language in DBMS?
A query language is a language in which a user requests information from the database. These languages are usually on a level higher than that of a standard
programming language. Query languages can be categorized as either procedural or non procedural.
In a procedural language, the user instructs the system to
perform a sequence of operations on the database to compute the desired result.
In a non procedural language, the user describes the desired information without
giving a specific procedure for obtaining that information.
Can you change the way data in table format is displayed?
This question is in many categories that may require different answers. In Excel you can use many formats to display your data and change whenever you like.
database
disadvantages of transaction processing system
What are the advantages and disadvantages of using different types of storage mediums?
Advantages of different types of storage mediums are having multiple backups in multiple locations that can be accessed from a variety of systems. Disadvantages are that they can be easily lost or stolen and may be more easily corruptible.
How is c language different from fuzzy logic?
fuzzy logic is a logic which we have to implement in c language
What is the need for mutual exclusion?
it really behaves like a lock on an ordinary door in the real world: You enter a room, you lock the door because you do not want to be disturbed, do whatever you need to do in there, unlock the door and only then can somebody else enter. If anybody tries to enter the room while you are still in there, he has to wait. As long as you do not forget to lock or unlock the door, this algorithms guarantees mutual exclusion and protects the so called critical region. And this is what the whole thing would look like using a parallel programming system
What are three reasons you might use Hwinfo or Hwinfo32 when troubleshooting or upgrading a PC?
1. If you want to identify a hardware component with out opening the case.. 2. To help you identify Features of a motherboard, video card, or processor. . 3. establish benchmarks for the components in
How can frontline employees be supported for decision making?
As the frontline employees have more skill and experience in the industry they are suitable for decision making. Also they are the senior employees of the company that too helps in the decision making as they very well know the culture of the company.
Give some example for primary key unique key and candidate key?
Examples:
Imagine we have a STUDENTS table that contains a record for each student at a university. The student's unique student ID number would be a good choice for a primary key in the STUDENTS table. The student's first and last name would not be a good choice, as there is always the chance that more than one student might have the same name.
Candidate key:-----Definition: A candidate key is a combination of attributes that can be uniquely used to identify a database record without any extraneous data. Each table may have one or more candidate keys. One of these candidate keys is selected as the table primary key.
A database query is a piece of code (a query) that is sent to a database in order to get information back from the database. It is used as the way of retriving the information from database
A database "query" is basically a "question" that you ask the database. The results of the query is the information that is returned by the database management system. Queries are usually constructed using SQL (structured query language) which resembles a high-level programming language.
The term 'query' means to search, to question, or to find. When you query a database, your searching for information in the database. Different query languages exist for different type of databases. MS Access uses SQL, which stands for Structured Query Language. MS Access contains Tables, Forms, and Queries. The Forms are used to enter or display the data, the Tables are where the data is saved, and the queries are used to search for specific data.
An example of an query can be this:
SELECT DISTINCT Agent FROM QAMonitoring ORDER BY Agent;
The query searches the 'Agent' field from the QAMonitoring table and sorts the list by last name. There are plenty of MS Access DB forums on the net for more info and help.
Creating a Simple Query in Microsoft AccessHave you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access offers a powerful query function with an easy-to-learn interface that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.
In this example, as with all of our Access tutorials, we will use Access 2000 and the Northwind sample database included on the installation CD-ROM. If you're using an earlier version of Access, you may find that some of the menu choices and wizard screens are slightly different. However, the same basic principles apply to all versions of Access (as well as most database systems).
Let's explore the process step-by-step. Our goal in this tutorial is to create a query listing the names of all of our company's products, current inventory levels and the name and phone number of each product's supplier.
1. Open your database. If you haven't already installed the Northwind sample database, these instructions will assist you. Otherwise, go to the File tab, select Open and locate the Northwind database on your computer.
2. Select the queries tab. This will bring up a listing of the existing queries that Microsoft included in the sample database along with two options to create new queries.
3. Double-click on "create query by using wizard". The query wizard simplifies the creation of new queries. We'll use it in this tutorial to introduce the concept of query creation. In later tutorials we'll examine the Design view which facilitates the creation of more sophisticated queries.
The data type of the Variable determines/indicates the type of data that can be stored in a field/variable
Millitarism Alliances Imperalism Nationalism
What is the concept behind dbms and rdbms?
DBMS is the Database Engine itself
like MySql Server
RDBMS is the GUI (Graphical user interface)
for any Database Engine which used in
CRUD (Create, read, update and delete)
like PHPmyAdmin
Vehicle is still under the factory warranty that you paid for when you bought the vehicle. Let the dealer figure this out. That is what you paid for.
Distinguish between continuous file allocation and chained file allocation?
Continuous File Allocation - uses continuous range of blocks in logical block space
Chained File Allocation - each block pointer to the next on disk
How can you remove your information from the Intelius public records databases?
Photocopy and fax a copy of your driver's license to 425-974-6194. Because fax quality varies, it's helpful to write your full name(please include middle initial), address(s) you want removed, date of birth, and phone number next to the photo ID so we can accurately suppress your information. You may omit your license # if you wish.
On your cover sheet please indicate you are law enforcement so we can expedite your request.
Here is a link to the World Privacy Forum, which details the best ways to protect your information: http://www.worldprivacyforum.org/toptenoptout.html
This link provides links and opt-out information for many Online Data Vendors:
http://www.privacyrights.org/ar/infobrokers-optout.htm
What is Rotating Memory Frame Buffer in computer graphics?
This is the situation when we use Screen resolution less than the maximum screen resolotion supported by the Visual Display Unit (PC Screen - VDU). In case of maximum screen resolotuin the frame buffer memory is fully utilized and only one page is available for display. For such a resolution when it is less than the maximum resolution, more than one page is available, which we often use for animation using page flipping. We keep drawing on to one page which is hidden and flash it altogether when the drawing is complete with the existing one on the screen. This avoids showing of the partially drawn images. For any particular case even 3-4 pages may be available. So the system is termed as "Rotating frame buffer" in Computer Graphics. We keep rotating the pages (full frame buffer parts) to generate animation. A different situation where the frame buffer is literally rotated to generate a rotated display of any image is also sometimes referred to as Rotating frame buffer. Just changing the signs and interchanging the X-Y coordinates may generate such an effect.
A rowlock is the same--no matter what the database. SQLServer, Oracle, Informix, Tandem, etc. A database's management system, along with the Database Administrator, is responsible for "data integrity". Here's the scenario for a rowlock: Susan is responsible for updating the "sales" table for the day's previous sales activity. Since there are not many updates, she sometimes does the inserts/updates during core business hours. One of the current rows in the "sales" table needs the data updated. The database puts a "rowlock" on this row in this table until the update is committed. If Gina is doing a query (read only) on the "sales" table at the same time Susan is updating it, the row that is being updated is "locked" and Gina will see the "before image" of the row. Once Susan commits the update the row is no longer locked and, if Gina runs her query again, she will see the update.
