Unanswered | Answered

Database Programming

~9000 answered questions
Parent Category: Computer 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.

Subcategories

In most raw (not formatted) text, such as the text in a simple HTML input element, new lines are denoted by a special "newline" character (commonly referred to as \n). When the text reaches this character, it pulls the text following it to the next line. For example, the string "hello\nworld" would…
Popularity: 214
You can you just have to Norton anti-virus the file let it run a complete check up on your computer
Popularity: 85
%DETAILS% There are many advantages of salt (saline) over manual chlorination. Check out http://salinepoolsystems.com for detailed advantages and to learn more about hte saline system.   i am using a saline system and it is wonderfull. I do not run the clormatic(cell) 24/7. I only use it…
Popularity: 1
Answer I had a great uncle serve on the Tacoma. Out of curiosity what name is on the keys? Answer My grandfather had a tattoo that said USS Tacoma. He was born in 1898. Name George Parks. This was probably the cruiser USS Tacoma (CL-20), guessing that he served in his early twenties Answer…
Popularity: 173
These are computer measurements of the size of a folder, file, hard drive, etc. A bit is a binary digit.A byte is 8 bits.A kilobyte (kB) is 1,000 bytes.A megabyte (MB) is 1,000,000 bytes. It also makes a difference if the "B" is in capital or small letters. A capitalized B means bytes, a small b me…
Popularity: 151
Computer data processing is any computering process that converts datas into information or knowledge. The processing is usually assumed to be automated and running on a computer. Because datas are most useful when well-presented and actually informative, data-processing systems are often referred t…
Popularity: 126
U need to find the DRIVER for C language that will connect to Oracle or Access Database and then access that driver through C program.
Popularity: 80
In short, the SQL database column has to be defined as either an image column or a binary column (SQL2k) In earlier versions, 6.5 & 7, they should have been defined as a BLOB (Binary Large Object). A more precise answer can be given if you supply additional information such as DB version, progra…
Popularity: 55
Simple. Your files on a network will be stored on a server. All the server operator has to do is look on the server for the files... They will have access to all files on the server. Your company may also use monitoring software.
Popularity: 61
Here is how to open a Windows Shortcut file Using VB6. This is a safe and documented method.   Create a New VB6 Project In the Project References Add "Windows Script Host Object Model" Place a Command Button on the form named CommandButton1 Click on CommandButton1     Privat…
Popularity: 174
DBMS stands for Database Management System which is a general term for a set of software dedicated to controlling the storage of data. RDMBS stand for Relational DataBase Management System. This is the most common form of DBMS. Invented by E.F. Codd, the only way to view the data is as a set of tab…
Popularity: 568
The C and C++ languages do not have standard libraries to manage databases, you need to use the libraries provided by the compiler, or database vendors or any 3rd party libraries to connect and manage databases. You can find libraries and examples of connecting to MySQL, Oracle and Sybase database…
Popularity: 28
It depends on the database implementation. Some use individual files to represent each table, others allocate blocks of storage and use proprietary storage methods that include concepts such as linked lists and the like.
Popularity: 34
The information entered and how the information is entered is a very dominate role in field/record level validation. However they share the same goal to enforce rules consistently, to write less code.
Popularity: 33
struct node { int payload; struct node *left, *right; };int height(struct node *tree) { if (tree == NULL) return 0; return 1 + max (height (tree->left), height (tree->right)); }
Popularity: 54
Answer To my knowledge, yes. You didn't ask if it would be a good idea. If you had, I would say maybe not. The Oracle database includes its own web server, which possibly could conflict with the IIS web server (which is what IIS is).
Popularity: 60
RDBMS. RDBMS is based on relation between data. Data the "belongs together", are "related" and where multiple data are related in the same way, one way of viewing these is as a row in a table, and where data of the same category are placed underneath one another as column. A single row is here calle…
Popularity: 50
Answer A trigger is defined for and connected to a RDBMS table. A trigger can be defined to do a particular job (typically insert audit records in another table or perform some validations) whenever the original table (on which the trigger is created) is selected or inserted, updated or deleted. …
Popularity: 57
A database can be consider as a group of file which allow us the multiple ways of accessing the data stored while for a particular file system there is a fixed path of accessing data. Answer Simply put, a file is a collection of bytes stored together. An example of a file could be a Text Fil…
Popularity: 38
To put it simply there are many types of data systems. But we'll just talk about two of the most common here: The first is commonly known as flatfile. The flat file is pretty simple: Each major category of data (e.g. Employees) is contained in a single file. If that employee can have multiple phone …
Popularity: 55
In VHDL, entity is the keyword for defining a new object. In SGML and its derived markup languages HTML and XML, an entity is a named body of data associated with a document. Once defined, an entity can be referenced any number of times within the document, via entity references. An entity typically…
Popularity: 85
Anything is possible and I've seen stranger things occur. If the person is dedicated in other areas in their life, more than likely they can be helped. If they are fighters and think THEY are always right, won't listen to reason then don't expect any changes anytime soon. Look at this person and try…
Popularity: 56
Turning a PC into a Web Server You can turn any PC into a server. A server is basically a software which you run on a PC. To answer your question, an ASP will run in an IIS (or PWS on older computers) web server from Microsoft. To link your ASP to a database there should be another application i…
Popularity: 73
Entity Relationship Diagram is a high-level description of a conceptual data model.
Popularity: 50
Answer Database is a collection of related data while database management system is a software which is use to access the database. A database is an accumulation of data, for storage and future use. The database management system would be the software you use to..this is too easy...manage the d…
Popularity: 35
Normalization is a process in database design which groups data into various tables which are then crosslinked by a particular field. In a properly normalized database, there will be only one field in one table for a particular piece of data, eliminating possibility for conflicting values for the sa…
Popularity: 67
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.
Popularity: 13
Yes, you can very definitely use transactions within a trigger in one of two common ways; 1. As with any other use of transactions - to ensure a collection of commands within the trigger are executed in a repeatable way in the event of failure. 2. To 'undo' the process that caused the trigger to …
Popularity: 87
Answer The easiest way to access an Access database from C++ is to use ODBC. An access database can easily be setup as an ODBC data source. The "Connection Strings" website provides you with many alternatives and 'connection string' syntax to complete this, too. Try; http://www.connectionstrings…
Popularity: 82
Pure integrity of data refers to the property which determines that data, once stored, has not been altered in an unauthorised way -- either by a person, or by the malfunctioning of hardware. An example is used to illustrate the point. Suppose your name is stored on some computer somewhere as "Har…
Popularity: 55
Field and Record are database terms. If you look at it from the top-down, a database consists of records--a collection of data, all of which belongs to one person or account or business or other unique entity; and each record consists of a collection of fields, each of which contains a chunk of da…
Popularity: 36
DBMS Interfaces User-friendly interfaces provided by a DBMS may include the following. � Menu-Based interfaces for Web Clients or Browsing: These interfaces present user with lists of options, called menus, that lead the user through the formulation a request. Menus do away with the need to memor…
Popularity: 50
first open a data application in the opening window there is a dataenviroment and bind your database to the environment you can select a text box and in the property table under the data there is data sourse and field l after run the application it will bind whithout any code first of all create…
Popularity: 54
The database holds the records, fields, cells ..with data. The DBMS is the "tools" used to manipulate the data in the database. An example of a DBMS is SQL Server. The DBMS is the database engine itself. This is the core, the actual program that contains the logic to execute your SQL statements. per…
Popularity: 52
An unsigned char is a byte; its value can be between 0 and (2^8) - 1 (i.e., 0-255).
Popularity: 39
When a computer user wants to store data electronically they must do so by placing data in files. Files are stored in specific locations on the hard disk (directories). The user can create new files to place data in, delete a file that contains data, rename the file, etc -- all known as file manage…
Popularity: 34
IT and ManagementInformation technology (IT) has changed the way the world does business and has had a great affect on traditional management functions. Management no longer has to rely on manual processes and a paper trail to perform everyday transactions. IT has automated many of these key managem…
Popularity: 100
Answer One can always declare a datatype as static which will limit the scope to the file only. this way data hiding can be achived. For more clearance on the same please refer 'the C programming language'. Answer Data hiding means only relevant data is visible to the user and all the back…
Popularity: 67
Answer ObjectReference.MemberName Objectname :: memberfunction
Popularity: 48
There are cataloging FREEWARE programs that you can download that will store the location, name and file info to a database. It's not worth your time to create this yourself when there are many freeware programs that provide astounding results and flexibility using the freeware. Check download.com. …
Popularity: 25
Answer It depends on what version of VB you are using, and what version of SQL Server you're attempting to connect to. Also, there are several ways to connect from each version of VB to each version of SQL Server (ODBC, ADODB, DSN-less, etc.). Since your question does not provide enough specific…
Popularity: 54
The database did not find the text of a page that it should have found, named "The distinction between DBMS and Dabase Content". This is usually caused by following an outdated diff or history link to a page that has been deleted. If this is not the case, you may have found a bug in the software. …
Popularity: 28
Well in a distributed environment there is still a master computer(server) that gives all of the other slave computers their IP addressed (sometimes) and the work to be crunched.
Popularity: 13
Most database vendors offer an API for this purpose. The usage will vary by vendor, but generally you open a connection, query (or runcommand), check or step through results, close connection. In the MS Windows environment, you can also use ODBC (Open Database Connectivity), which is an API that ab…
Popularity: 22
Answer The differences between the three approaches Table 1: A Comparison of Database Management Systems Criteria RDBMS ODBMS ORDBMS Defining standard SQL2 ODMG-2.0 SQL3 (in process) Support for object-oriented features Does not support; It is difficult to map program object to the database Suppo…
Popularity: 40
Oracle is a software company. SQL (Structured Query Language) is a language for manipulating or retrieving information from a Relational Database system.
Popularity: 2
Functions return a value.  NoteThere are no procedures in C, only functions with no return value (type void is used to indicate that).In general a function is the purpose or what a system actually does( what output it returns) and a procedure is how that output is returned.
Popularity: 23
Advantages : 1. Uses OOPs concept. 2. Highly secured 3. Multiple users can access which is not possible in DBMS. 4. It is relational. 5. Avoids data redundancy problems using NORMAL FORMS 6. It performs all DML operations which is not possible with ordineray DBMS (it performs only INSERT n RETRIEVE…
Popularity: 28
A data structure is the way you define a certain object in a program language. If you define a data structure for a contact in a contact list, you would have members of that data structure such as name, company, address, phone number, etc. The data structure is defined by what you need the program …
Popularity: 28
Table: In a table each column attributes are independent, In a table row order & column order are mandatory & that cannot be changed, Table can be of more than 2 dimentions, There may be of rows and columns duplication in a table. Relation: In a Relation in which all attributes are d…
Popularity: 30
menifest also reffered to as assembly metadata(data about data),contains all information related to assembly like identity section,version number,strong name (optional),culture.so menifest contains information related to the identification assembly or it is a part of assembly where assembly is self …
Popularity: 26
Answer
Popularity: 30
I can tell you (only one that is from philippines)she is JANE MARIE but i dont know the others they are many I was talking to the USA scouts for their olympic squad and Jake Thomas is an early favorite to be their number 1 player this year.
Popularity: 34
No, the difference is how the data is stored and presented to the user. A RDBMS is a relational Database Management System, which means that the data to be stored is split in to separate tables of information and links between related information allow for retrieval. The overall concept is for the d…
Popularity: 154
This is the most common of all the different types of databases. In this, the data in a relational database is stored in various data tables. Each table has a key field which is used to connect it to other tables. Hence all the tables are related to each other through several key fields.
Popularity: 39
There are presently two types. (A) Analytic Databases - read only and used to store archived data for analysis work and (B) Operational Databases - Operational databases - Theseallow you to modify the data (add, change or delete data). These types of databases are usually used to track real-time in…
Popularity: 0
In a strict sense, prototyping involves creating the system with a subset of requirements/functionality, and refining it over time as requirements become more clear. An advantage is that users get to actually use the system and give you real feedback. Disadvantage is that you may end-up with a mess …
Popularity: 14
No matter what the database or application, these are some basics (I have been a database administrator for over 10 years).1. A test environment is necessary. You do not want to test or implement changes in a production environment. But, the test environment must be close enough to the production en…
Popularity: 16
You are entitled to a FREE annual report from chexsystems. To order your report, go to www.chexhelp.com
Popularity: 62
A primary key is the unique identifier for a row in a database table. It is formed into a unique index constraint, so that access to the row in question can be quick. It is usually preferred by the optimizer as the primary join predicate. Presence of the primary key is usually a prerequiste for bui…
Popularity: 17
The term information system has the following meanings: An information system consists of three components: human, task, application system. In this view information are defined in the three levels of semiotics. Data which can be automatically processed by the application system correspond to the …
Popularity: 43
From my experience and reading, I have found that narcissists switch roles. My N would switch between being somatic to cerebral. For instance, he would go through periods of time when he wanted to be very sexual then we would go without sex for a very long time. Sometimes he would care about his app…
Popularity: 8
Answer Queries of a database can be fast or slow. Depends on a lot of things. The size of the table, the amount of data you are requesting from the query, etc. One of the ways a dba can help query optimization, is by "updating statistics" on a table. Statistics of a table allows the query to fin…
Popularity: 60
Answer This can be different depending on the SQL server involved. Please specify the Database being used (ie, mysql, postgresql, oracle, ms SQL Server) I am using SQL 2005 express, what is the command, i can only get... delete... and what else? lets say i want to delete a duplicate row that is …
Popularity: 28
A view is generally used to provide a subset view of a table. This can be for security or clarity. For example, you have a payroll table like so:nameaddresscitystatezipphonesupervisorsalarylast_paycheck_dateno_demeritsnotesAnd you only want to have an employee see name, address, phone number, and su…
Popularity: 23
The following are some of the benefits of normalization:removes redundanciesachieves consistency.improves data accessing speedimproves the performance of the serverdecreases time accessing from the database.generally efficient working of the applicationNormalization was introduced just to have CONSI…
Popularity: 19
this amendment prevents government from claiming that the only right people have are those listed in the bill of rights. your welcome
Popularity: 2
dick brothers mad science
Popularity: 3
Answer I'm not familiar with MS SQL Server in particular, but all the SQL databases I've worked with are something like this: SELECT * FROM table WHERE date > '2006-12-01' AND date < '2006-12-31'; Double-check the date format - most are set to use a Year-Month-Day format, but some are dif…
Popularity: 15
There are 4 normal forms in databases. First normal form, second, third and fourth normal forms are there.
Popularity: 7
1. <algorithm, hardware> Any program, circuit or algorithm which encodes. Example usages: "MPEG encoder", "NTSC encoder", "RealAudio encoder". 2. <hardware> A sensor or transducer for converting rotary motion or position to a series of electronic pulses. An encoder is a device used …
Popularity: 48
The most important thing here is to know that unix and cobol is a good platform to work in that to with Oracle as the database. The mf cobol is almost a standard cobol that is followed these days, and many banks want to migrate to this version of cobol(as it is perfectly suited to Unix systems)the a…
Popularity: 18
Files is any set of information or commands stored on your computer.A database is a collection of "files" that are interconnected or along the same subject...think customer's account information.While a database on a computer is a file, or set of files, a file does not have to be a database.
Popularity: 14
Econometric is a mathematical and statistical tool for empirical economic analysis. An econometric model is a set of equations that depict the major relationship in the economy. It is usually used in economic analysis to illustrate cause-effect relations and to help to predict the future tendencies …
Popularity: 13
Procedural languages are used in the traditional programming that is based on algorithms or a logical step-by-step process for solving a problem.A procedural programming language provides a programmer a means to define precisely each step in the performance of a task Non-procedural programming lang…
Popularity: 47
take it to your near autozone,they started making some aftermarket products,if they don't have one for your vehicle take it to a Chrysler dealership and they will match one up but if they have to reprogram it, it will cost extra along with the keyless entry,sometimes they don't have to reprogram the…
Popularity: 8
Microsoft Access, MySQL, Microsoft SQL Server, Oracle, FileMaker Pro, FoxPro, dBASE are all examples of database management systems. A DBMS, or database Management System, is a collection of programs that enables you to store, modify, and extract information from a database.
Popularity: 3
Entity Relationship (ER) diagrams are drawn when designing a database system, After the systems specification, an ER diagram is drawn showing the conceptual design of the database, this diagram shows the type of information that is to be stored in the system and how these information associate with …
Popularity: 30
Difference between dB SPL and dB SL There are several types of dB. dB SPL are decibels measuring sound pressure levels. There is an accepted reference point of 0 dB SPL which equals 20 micropascals = 2 × 10-5 pascals. dB SL are decibels measuring a signal relative to an individuals auditory th…
Popularity: 26
England - long, powerful passes Spain - speed Italy - short, accurate passes
Popularity: 3
Functions of a DB programIn it's most basic form, a database program must be able to add, delete and edit records in the tables which make up the database and also to search for specific records in the tables by using different search criteria. Also, in most cases, user authentication is required.Fu…
Popularity: 21
Data type: a set of values together with a set of operations Answer A category of storing information/data that may or may not be interchangeable. An int is a data type, as is boolean. Each class is also considered its own data type. In real life, "fruit" would be considered a data type, as w…
Popularity: 25
RDBMS - Relational Database Management System - Multiple users can access and there will be relationships between the tables, security is increased DBMS - Database Mangement system - small number of users DBMS is the Database Engine itself like MySql Server RDBMS is the GUI (Graphical user in…
Popularity: 14
Relational Database is collection of interrelated data managed with their relations. Database holds both the structure (schema) of the relations and the data itself. These structures are usually called tables. For example, a to represent people working in different organizations, we could have a P…
Popularity: 48
JDBC mean Java Database Connectivity. In java, using JDBC drivers, we can connect to database. Steps to connect to JDBC. 1) Load the driver, using Class.forName(DriverName); 2) Get the connection object, Connection con = Driver.getConnection(loaded driver name); 3) Create a SQL statement, Statem…
Popularity: 23
This can be achieved with a recursive-traversal function starting at the root. Binary tree nodes use the following shorthand form (using tertiary conditional operator): int Node::GetNodeCount(){return( 1 +( left ? left.GetNodeCount() : 0 ) + ( right ? right.GetNodeCount() : 0 ));} Or in longhand:in…
Popularity: 3
Answer Schema name or database qualifier indicates the ownership of the object. Schema name for a database object can be found using below sql - SELECT owner FROM all_objects WHERE object_name = 'tablename';
Popularity: 25
basically there are two types of data structure, 1) linear : array, stack, queue 2)non linear : linked list, tree...
Popularity: 16
The answer is simply if you tell me what is the meaning of ejb
Popularity: 11
Answer If your talking about the thing in answers.com,you have to go to change top list then you press select all then delete or what ever at the bottom
Popularity: 10
Probably refers to frequent changes in the line-up of batters, the term was used in slot racing for arbitrary lane changes to even out the competition- the Orange track or lane , in the center, had the tactical , road-holding advantage. I have heard it applied to a rotation of Pitchers in baseball, …
Popularity: 14
Answer Static method cannot be overwritten because it belongs to the class and not to the Object Answer If you're asking about overriding or overloading, then yes. Static methods can be overridden and overloaded just like any other methods.
Popularity: 29
During interviews, you may be asked to describe your typical day as a system administrator. Your answer should be honest and include the tasks that your do as well as highlight your skills.
Popularity: 1
This is part of SQL. It allows you to control access to the database. 'DCL' commands include- 'GRANT' to allow specific users to perform specified tasks 'REVOKE' to cancel previously denied or granted permissions GAYSON
Popularity: 24
It is more so that the host finds a hookworm in Hot Humid regions of the earth in soil fertile in human excrement.
Popularity: 5
Each database will have documentation and the maximum number of schemas will be listed in the documentation--specific to that software product.
Popularity: 5
Answer Hi, The abbrevation of basis is Business Application Software Integrated solution. Basis is a function/module (like Finance, Materials, Quality, Production etc)in SAP. Basis is the Administoring programs which administer the SAP Application. Basis Administrator administers the SAP applic…
Popularity: 20