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
I DON't NO.
IF FOUND PLS LET ME KNOW
What is the algorithm to count no of nodes in singly linked list?
int numNodes = 0;
Node current = root;
// if root is null, the number of nodes is 0
if(current != null) {
// if root is not null, we have at least one node
numNodes = 1;
// count all nodes
while(current .next != null) {
++numNodes;
current = current.next;
}
}
A foreign key field is a reference to data in another table. For example, assume that that government has a big list of names and social security numbers (or social insurance numbers, if you live in Canada). They have your SSN/SIN in one field and your name in another field and your address in a third field. Your SSN/SIN is a unique key that can be used to track data associated with you. Suppose now that the government wanted to put data about you in another table. Rather than copy all of your information, they decide that they are just going to put your SSN/SIN number in that other table instead. This is a good move, as they don't have to repeat data. But what if they enter the SSN/SIN incorrectly? That would cause trouble in the database. In order to solve this problem, foreign key fields are used. In the second table, the SSN/SIN field would be a foreign key field, meaning that whenever data is entered into that field, the database management system will automatically look up the data in the main database table to make sure that the SSN/SIN number exists. This allows the database management system to make sure that incorrect data is not added to a database table by mistake.
The noun exception is a singular, common, abstract noun; a word for a person or thing that is excluded from a general statement or does not follow a rule, something that cannot be included in a general statement.
In computer programming, the term exception is shorthand for the phrase "exceptional event", which occurs during the execution of a program, that disrupts the normal flow of the program's instructions.
What is the advantage and disadvantage of sql server 2000 and sql server 2005?
The list of changes is too long to type so here is a website that has everything you ned to know:http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/
What systems implement access controls using a two-phase process called what?
identification and authentication
DBMS facilities required for Recovery and back up?
1.The data definition facility or data definition language (DDL).
2.The data manipulation facility or data manipulation language (DML).
3.The data query facility or data query language [DQL].
4.The data control facility or data control language [DCL].
5.The transaction control facility or data control language [TCL].
Could you explain the purpose of logical database design?
Logical database design is the process of designing the database at a conceptual level as opposed to a physical level. There are many advantages of conceptual database design, such as the ability to design the database without having to commit to a particular database management system, to produce a document that is readable and understandable to everyone in the company (not just the database person) and to produce an overall design document that can be saved as a part of the documentation of the database for future enhancement, maintenance and support work. Logical database design produces documents for use in the same way that architects produce blueprints for building purposes.
What is the abbreviation of unsigned?
In php you don't have to (and can't) specify the type or size of integers, tis is made automatically. therefore there isn't an unsigned keyword and no abbrevation for it.
Communication privacy management theory?
Communication Privacy Management theory (CPM) (Published in 2002) Theory (Petronio)
Disclosure in relationships requires managing private and public boundaries. These boundaries are between those feelings that one wants to disclose and those one wants to keep private. Disclosure in relationship development is more than revealing private information to another. Negotiation and coordination of boundaries is required. Decisions regarding disclosure require close monitoring.
5 Instances in the theory are
1. She worries about someone at work finding out about the pornographic e-mails
2. She engages in conversation with co-workers without telling them that she's feeling harried
3. She confines confides in a friend about feeling unbalanced in her work and personal life
4. She listen her mother voice-mail-recorded complaints
5. She hears her roommate's discloser without telling her what she really thinks about her boyfriend
Human Choice ------ Relational life characterized by change
Human - made rules ------ Contradiction as the fundamental fact of relational life
Social concerns
CertoSQL is a powerful, reliable, advanced object oriented relational database system developed on PostgreSQL, which has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
It is highly scalable both in the quantity of data it can manage and the number of concurrent users it can accomodate. Designed for high volume enterprises, CertoSQL can easily handle large tables and databases.
For more information please visit www.certoSQL.com
Prime attribute are part of any candidate key. Non-prime attribute are not part of any candidate key.
What are the cost and risk of using databases?
THE COSTS AND RISKS OF USING A DATA BASE ARE AS FOLLOWS
-cost
-complexity
-size
-high impact of failure
What is the basic terminology of dbms?
Acid
cursor
data
database
field
primary & foreign keys
procedure & function
odbc & oledb
normalization
trigger
the coordinator conculde incorrectly that a deadlock exist and kills some process
---------------------------
Detecting a non existent deadlock in distributed system has been referred as false deadlock and it may occur due to communication delay..
---->Ashok Paranjothi
Four differences between fileprocessing system and database management system?
four differences between fileprocessing system and database management system
Hello where can i find the old dbase iii plus software for free?
dBase III plus can be dowloaded from internet for free
Google the following :
dBase III plus free down load.
You will get many sites choose and download.
G.BADARIVISHAL
Mysore
South India
13-05-2013
What does the term field mean in relation to databases?
The field is where data is entered. For example, a phone book database may have fields such as LName, FName, Add1, Add2, City, ST, ZIP, AC, Phone. Also, for the phone company's version of said database, they may have some additional fields such as Unlisted, NoAddr (as not everyone wants their addresses in the phone book), FInit (since some want only their first initials rather than their names in the phone book), etc. Fields can be of various types, of course, such as numeric, string/text, boolean, time/date, and more. What data types are allowed depend on what type of database software you are using or whether you are custom designing your own software by programming in C, Pascal, or another such language.
