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 difference between a statement and a clause in SQL?
An SQL statement is a complete set of clauses which returns a value and ends with a semicolon(;)
A statement is made up of several clauses
Ex: select * from person where f_name='me';
In this ex ' select * from person where f_name='me';' is the statement and select*, from person, where f_name= are the clauses
No, not if you're using a default Windows operating system.
After all, it wouldn't sell very well if people found out you deliberately installed features that damages your own product(s).
Define and explain Database management systems?
A collection of programs that allow a user to extensively modify, store, and extract information from a database is called a database management system. Also knows as "DBMSs," these systems vary in size and function. They range from those operating on personal computers to mainframe-based systems utilized solely by large companies. Examples include Oracle, RDBMS, dBase Clipper and FoxPro.
i want to find the function of the page break view of the power point!
What is heuristic optimization?
Where the 'query tree' or 'algebra tree' is transformed using a set of predefined rules that will improve the queries performance. Performing the selections as early as possible to reduce load. It is a form of Query Processing.
EMC2 is the leading provider of networked Storage (computer networks hard disk storage) for Enterprise sized Companies....think Fortune 2000...
They make Data information available to the Network Computers in a Fault tolerant and Highly Available environment.
What are examples of minicomputer?
Minicomputers were developed in the 1960s and were roughly 19 inches long. A few examples are MAI Basic4, DEC PDP and VAX series, and Prime Computer Prime 50.
Sort Groups with Crystal Reports?
Crystal reports features a group sort expert. Sorting options within this group include No sort, All, Top N, Bottom N, and Top and Bottom percentages.
What are the various types of database users?
1) End User
2) Database Admin
3) Database Designer
4) System Analysts and Programmers
5) System Administrator
*Database Systems 8th Edition
A network model is actually a flexible database method of representing objects and their relationships to each other. Its graph is not restricted to a specific hierarchy. Each individual record is not restricted by a finite number of parent and child groups.
Advantage of database management system?
One advantage of having a database management system is the fact that it can store a lot of information about customers. Another advantage is the fact that businesses can easily secure these systems while they secure their other systems.
What are different types of file organizing?
There are two types of file organization associated with computer programming. The first is sequential filing where files are arranged in a sequence order in which they are written. The second file type is relative filing where files are recorded based on their consecutive numbered position which is referred to as the cell number.
What is the full form of EDVAC?
The meaning or EDVAC is Electronic Discrete Variable Automatic Computer.
Difference between database administrator and system administrator?
A System Administrator is generically responsible for all parts of the computer network, such as user accounts, computer accounts, domain trusts, email accounts, etc. The System Administrator is probably specialized in the network server operating systems and user administration. A Database Administrator would deal specifically and in depth with all aspects of one or more databases. The Database Administrator will be highly specialized with the specific database server and client software.
ER Diagram for a medical store system?
medical store system is the system in which the medicals are arranged in manner that they are kept differen recks for the different categories
How does computer help in education?
Computers have been helping people with their education for many years. Computers help people write papers properly, and neatly. It gives them access to math calculations, and access to the Internet where they can research information.
Why is naive Bayesian classification called naive?
Naive Bayesian Classification (NBC) isreferred to as naive since it makes tha assumption that each of its inputs are independent of each other, an assumption which rarely holds true, and hence the word naive. Research has however shown that even though this assumption is often false, the technique still performs well, and hence NBC is seen as a simple yet powerful tool in the world of classification and machine learning.
What is ACID test in application in database system?
The ACID model is one of the oldest and most important concepts of database theory. It sets forward four goals that every database management system must strive to achieve: atomicity, consistency, isolation and durability. No database that fails to meet any of these four goals can be considered reliable.
Let's take a moment to examine each one of these characteristics in detail: * Atomicity states that database modifications must follow an "all or nothing" rule. Each transaction is said to be "atomic." If one part of the transaction fails, the entire transaction fails. It is critical that the database management system maintain the atomic nature of transactions in spite of any DBMS, operating system or hardware failure. * Consistencystates that only valid data will be written to the database. If, for some reason, a transaction is executed that violates the database's consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules. On the other hand, if a transaction successfully executes, it will take the database from one state that is consistent with the rules to another state that is also consistent with the rules. * Isolation requires that multiple transactions occurring at the same time not impact each other's execution. For example, if Joe issues a transaction against a database at the same time that Mary issues a different transaction, both transactions should operate on the database in an isolated manner. The database should either perform Joe's entire transaction before executing Mary's or vice-versa. This prevents Joe's transaction from reading intermediate data produced as a side effect of part of Mary's transaction that will not eventually be committed to the database. Note that the isolation property does not ensure which transaction will execute first, merely that they will not interfere with each other. * Durability ensures that any transaction committed to the database will not be lost. Durability is ensured through the use of database backups and transaction logs that facilitate the restoration of committed transactions in spite of any subsequent software or hardware failures. Take a few minutes to review these characteristics and commit them to memory. If you spend any significant portion of your career working with databases, you'll see them again and again. They provide the basic building blocks of any database transaction model.
Uses of databases in the business world?
http://www.businessintelligencelowdown.com/2007/02/top_10_largest_.html
Advantages Cost and Risk of Database Approach?
The advantages of Cost and Risk Database Approach include being personalized and specialized. It also involves conversion costs and management cost.
There are two distinct sides to being a SQL Developer. The easiest side is writing applications that are able to interface with an SQL database.
The more complicated role requires the actual development of the SQL database; designing the tables, stored procedures, views, functions, etc.
Most SQL Developers will have a foot in both camps - doing some of the database design and then writing applications to interface with it.
an ict formula is something that can caluculate a sum faster than usuall, it will work out the sum ,, and the software that is used is Microsoft excel.
Distributed and Centralized Databases Distributed data is defined as collection of logically distributed database which are connected with each other through a network. A distributed database management system is used for managing distributed database. Each side has its own database and operating system.
A centralized database has all its data on one place. As it is totally different from distributed database which has data on different places. In centralized database as all the data reside on one place so problem of bottle-neck can occur, and data availability is not efficient as in distributed database. Let me define some advantages of distributed database, it will clear the difference between centralized and distributed database.
Users can issue commands from any location to access data and it does not affect the working of database. Distributed database allows us to store one copy of data at different locations. Its advantage is that if a user wants to access data then the nearest site (location) will provide data so it takes less time.
There are multiple sites (computers) in a distributed database so if one site fails then system will not be useless, because other sites can do their job because as I earlier said that same copy of data is installed on every location. You will not find this thing in centralized database.
Any time new nodes (computers) can be added to the network without any difficulty.
Users do not know about the physical storage of data and it is known as distribution transparency, as we know that ideally, a DBMS must not show the details of where each file is stored or we can say that a DBMS should be distribution transparent.
