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
Text that is in excess of 255 characters of alphanumeric data can be entered into this data type.?
Short text
What is the role of information systems in today competitive business environment?
There are following roles of Information system in Business environment:
1.) In the today's competitive world Information System in Business Environment Environment acts as goal oriented process.
2.) Information system acts as a big revolutionary change in Business Environment.
3.) Information system also play a very important role in decision making process.
What are the functions of a database administrator?
data base administrator is the person who control the data in the organisation its main function to control the information of the particular enterprise
1.3 Functions of a DBMS
The functions performed by a typical DBMS are the following:
· Data Definition
The DBMS provides functions to define the structure of the data in the
application. These include defining and modifying the record structure, the
type and size of fields and the various constraints/conditions to be satisfied by
the data in each field.
· Data Manipulation
Once the data structure is defined, data needs to be inserted, modified or
deleted. The functions which perform these operations are also part of the
DBMS. These function can handle planned and unplanned data manipulation
needs. Planned queries are those which form part of the application.
Unplanned queries are ad-hoc queries which are performed on a need basis.
· Data Security & Integrity
The DBMS contains functions which handle the security and integrity of data
in the application. These can be easily invoked by the application and hence
the application programmer need not code these functions in his/her
programs.
· Data Recovery & Concurrency
Recovery of data after a system failure and concurrent access of records by
multiple users are also handled by the DBMS.
· Data Dictionary Maintenance
Maintaining the Data Dictionary which contains the data definition of the
application is also one of the functions of a DBMS.
· Performance
Optimizing the performance of the queries is one of the important functions of
a DBMS. Hence the DBMS has a set of programs forming the Query Optimizer
which evaluates the different implementations of a query and chooses the
best among them.
Thus the DBMS provides an environment that is both convenient and efficient to use
when there is a large volume of data and many transactions to be processed.
Can data be stored in ascending order?
Data can be stored in ascending order, descending order or no particular order.
What is The purpose of a report in a database?
The purpose for the reports is so that it will show you how many reports you have.
Is true about database queries?
queries are always saved and can therefore be run on the most up to date database information
Why is it desirable to enforce the referential integrity rules and entity integrity rules?
Database Management Systems ensure consistent data if the database is modeled using proper referential integrity. For example, if a Customer record is deleted from the system, all Orders and Order Items pertaining to that Customer should ideally be cleaned up. Same thing is true for a specific Order. Such logic need not be in the application, instead you can set up database referential integrity rules to perform these cascading actions automatically for you.
What two conditions must be met before an entity can be classified as a weak entity?
In contrast to the strong or regular entity, a weak entity is one that meets two conditions:
1. The entity is existence-dependent; that is, it cannot exist without the entity with which it has a relationship.
2. The entity has a primary key that is partially or totally derived from the parent entity in the relationship.
The 2's complement of the binary number 1101100 in BCD is?
I want answer bcd
This in (a) 12 b() 13 (c)14 (d)15
How can data from VLBI be used in mapmaking?
The Data from VLBI can be used for various vital data such as spreedsheets, information that can be used for today.
Difference between dataflow diagram and sequence diagram?
The purpose of a data flow diagram is to show you how the data flows through an information system. A sequence diagram shows you information regarding how the processes work together and in what order they operate.
What is difference between MS Outlook and Lotus Notes?
In simple words, MS Outlook and Lotus Notes both are highly popular email client applications among all others. MS Outlook is hosted by Microsoft and it stores information in PST or Personal Storage Table files. On The other hand, Lotus Notes is hosted by IBM Lotus Domino and it uses NSF files to store information.
When need to retrieve only a single value from the database which method is efficient?
ExecuteScalar()
Who is responsible for updating data for all in-use serialized records?
The owning Equipment Custodian
What are the disadvantages of traditional file management?
Data Redundancy and Inconsistency:
Data redundancy: The presence of duplicate data in multiple data files so that the same data are stored in more than one place or location.
Data inconsistency: The same attribute may have different values.
Program-Data dependency
The coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data.
Lack of flexibility
A traditional file system can deliver routine scheduled reports after extensive programming efforts, but it cannot deliver ad-hoc reports or respond to unanticipated information requirements in a timely fashion.
What is the difference between a session key and a master key?
A session key is a temporary encryption key
used between two principals.
A master key is a long-lasting key that is
used between a key distribution centre and a
principal for the purpose of encoding the
transmission of session keys.
Typically, the master keys are distributed by
noncryptographic means.
What are the features and data management strategies of SQL Server?
SQL is one of the most demanding skill in the current world. Every day a huge amount of data is collected and one have to deal with these databases to make an insightful information. Hence it is important for us to learn SQL as it is a special-purpose database programming language which help to generate useful strategies from a database and can easily interact with large and massive database, no matter what is the size. These features of SQL make SQL a most powerful tool. Hence, here are some of the major SQL features which makes it a successful database programming language:
- High Performance
- High Availability
- Scalability and Flexibility
- Robust Transactional Support
- High Security
- Management Ease
- Open Source
