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 restrictions apply to the use of aggregate function within the select?
Aggregate functions:
COUNT, SUM, MIN, MAX, AVG
NOTE: It can be used only in the SELECT list and in the HAVING clause. Using it anywhere else will be incorrect; also you cannot nest aggregate functions.
The Cloze procedure was developed by Taylor in 1953, to determine the extent that a students' reading abilities match those required for technical materials. The Cloze procedure permits the instructor to measure the compatibility.
Of what hypothetical use are management information systems in manufacturing operations?
upgrade computer
The current answer above is incorrect. The correct answer for this question is REFRESH COMPUTER. This preserves only user profile information; it does not migrate applications or other files. The upgrade computer scenario requires no special workstation preparation, but it is limited only to systems running Windows Vista using the LT1 deployment.
What is composite data type in plsql?
Composite types have internal components that can be manipulated individually, such as the elements of an array, record, or table.
Oracle TimesTen In-Memory supports the following composite data types:
Associative array (index-by table)
Nested table
Varray
Record
Event refers to Action... maybe action(event) occurred in Form ....
What is the file index system that stores clip art photographs and movies called?
its c you idiot looking up answers for Microsoft office xp edition book
What are the advantages of DBMS Approach in managing data?
Advantages of the Database Approach
· Data Independence
The data is held in such a way that changes to the structure of the database do not effect any of the programs used to access the data.
· Consistency of Data
Each item of data is held only once therefore no danger of item being updated on one system and not on another.
· Control Over Redundancy
In a non-database system, the same information may be held on several files. This wastes space and makes updating more time-consuming. A database system minimizes these effects.
Integrity of Data
The DBMS provides users with the ability to specify constraints on data such as making a field entry essential or using a validation routine.
Greater Security of Data
The DBMS can ensure only authorized users are allowed access to the data.
Centralized Control of Data
The Database Administrator will control who has access to what and will structure the database with the needs of the
More Information Available to Users
Users have access to a wider range of data that was previously held in separate departments andsometimes on incompatible systems.
Increased Productivity
The DBMS provides an easy to use query language that allows users to get immediate response from their queries rather than having to use a specialist "programmer" to write queries for them. whole department in mind
What is a database field size?
Field size defines the maximum number of characters or numbers that a particular field can hold
What is the purpose of the isolated personnel report information ISOPREP data?
For use by recovery forces to identify personell prior to recovery
Which type of software stores client information in one central database?
A lot of applications store information about clients, but Customer Relationship Management (CRM) software is specifically designed to allow organisations to store information about their clients.
In vb6.0 difference between bas file and cls file?
Deciding between a standard module and a class module is not a decision based on performance, but one of design. The main difference between the two is in the way that they handle data. A standard module stores only one copy of the data. A class module encapsulates the data within each instance of the class. That is, for each instance of the class, the data exists separately.
The other main difference is the scope of variables and procedures within the module. In general, any variables and procedures declared as Public within a standard module are visible anywhere in the project or external programs if the standard module is in a component. Variables and procedures declared as Public within a class module can only be seen through a reference to an instance of the class module.
The lifetime of data and procedures stored within a module is affected by which type of module is used. The lifetime of the data and procedures in a class module is defined by the lifetime of the object. So data and procedures are available only if a reference to the object exists. Data and procedures declared within standard modules are available for the lifetime of the program.
Therefore, to answer your question, if you are writing a function that you want available throughout the lifetime of the program and visible to all code in the application, then place the function within a standard module.
How is database security different from system security?
System security is OS level security like you have username password to logon on your system.
Database security is db level security governed by your database software.like you have different schemas that have different passwords.You can decide grants and permissions for various db objects based on these db level users.
What are the different ways of classifying data base management system?
DBMS can be classified in the following ways,
1. Based on Data Model
- Relational Data Model
- Object Data Model
- Object Relational Data Model
- Extended Relational Data Model
- XML Model
- Hierarchical Data Model
- Network data Model
2. Based on Number of Users
- Single User System
- Multi-User System
3. Based on Number of Sites
- Centeralized systems
- Distributed DBMSs(DDMSs)
Homogeneous DDMS
Hetrogeneous DDMS
Alter table command is not a part of the ANSI standard, but is widely available. Its form is fairly consistent, although its capabilities vary considerably.
What is the meaning of durability in DBMS?
Durability is the part of recovery system ,it has response to recover the failure data,it also comes under transaction managment
What is deductive database system?
A deductive database system is a database system that contains so-called deductive rules like
connected(x,y) :- connected(x,z),connected(z,y).
See also the Wikipedia entry on Datalog.
