answersLogoWhite

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

Difference between DBMS flat file system?

In DBMS Multiple user can access file at a time. but in flat file system only one user can access file at a time

What are Time sensitive queries?

The queries for which the result documents tend to concentrate on restricted time interval.

ER diagram of telephone billing system?

how to draw a telephone billing system in huge and sparse datacubes in datamining

Difference between roll back and commit in sql?

in sql commit is used for saving the changes made in database and roll back is to roll back them , changes will not get saved in the database

What is patterns in data mining?

A pattern, from the French patron, is a type of theme of recurring events or objects, sometimes referred to as elements of a set of objects.

The elements of a pattern repeat in a predictable manner. Patterns can be based on a template or model which generates pattern elements, especially if the elements have enough in common for the underlying pattern to be inferred, in which case the things are said to exhibit the unique pattern.

http://en.wikipedia.org/wiki/Pattern

What routine functions does a transaction processing system support?

TPS provides support to the monitoring, collection, storage, processing, and dissemination need for these routine business processes.

What is the difference between encapsulation and data hiding?

While many people cite private class members as being an example of information hiding (another term for data hiding) this is not strictly true. In C++, for instance, the use of the private keyword does not hide any information, it simply limits access to that information. After all, the fact something is inaccessible does not mean it is hidden. The private keyword simply means the information has been placed in a cage but only members of the class have access inside that cage; neither the cage nor the information are hidden in any way, shape or form. The same analogy is also true of many other languages. So when we speak of data or information hiding we simply mean limiting access to that information.



In some programming languages this is also referred to as encapsulation. However, in object-oriented programming, encapsulation has another meaning altogether: it is the means by which data and the methods that operate upon that data are combined into a self-contained entity, an object. Encapsulation in this sense typically incorporates data hiding, but it is the encapsulation itself that provides the means by which that data has limited access. However, encapsulation goes beyond mere data hiding in that it also provides an interface to some or all of the hidden data. This not only allows the data to be manipulated in a highly-controllable and robust manner, but also permits the underlying data storage mechanism as well as the methods that operate upon that data to be altered without affecting the object's existing consumers. In other words, the underlying implementations may change quite drastically, but their effects are limited to the class of object itself. If you think of an object as being a protective capsule that can be internally altered without affecting the outside world, the notion of encapsulation becomes that much clearer (it is no coincidence that the verb encapsulatederives from the French noun capsule).



What is the management by exception?

Management by exception and/or reporting by exception is a process by which top management is spared from routine, planned, expected and irrelevant information or situation. however, it initiates feedback and reporting in the event of any extra ordinary situation or circumstance that would be out of the scope of the junior management as they still lack the expertise in important strategic matters.

Why do you use mega hertz and gega hertz to measure the speed of the processor?

Turns out that if you put electricity into quertz - Silicon dioxide(thats why the meca of computers is silicon valley)- it shakes hitting sensors in the processer creating On/Off 1/0 binary. The speed at which the quertz shakes is hertz. A single hertz represents 1 bit. so 2 gigahertz = 2,000,000,000 bits of data.

What are three reasons to use PC wizard 2008 when troubleshooting or upgrading a PC?

If you are new to computers then this will help you install and upgrade stuff on your computer greatly and it will prevent you from damaging anything. Computer parts are very expensive, you don't want to mess anything up!

What options do you have in mainframe ADABAS to explore data directly or extract or export data to an Excel spreadsheet?

I am not sure of options within ADABAS to export data directly to excel.

But using a programing language (eg: Natural) mainframe ADABAS data can be read and then ConnectDirected to excel.

Please revert in case of any details qureies

What is a field in a database?

In a doctor's database, there would be several fields. The fields could contain the patient's name, address, telephone or mobile number, their Name,Age,Date of birth,allergies, and the doctor's name. Each thing would have a field of its own. So the patient's name and the doctor's name would be in two separate fields. When the data is viewed, the fields would appear as columns within the data. The fields need to be defined before any data is put in. So you would specify that you want a field for a phone number and a field for a doctor's name etc. when you are designing the database.

Key words:

Field: A field is in a database, it contains important information.

Your stomach is getting bigger and something keeps bumping you on the inside are you pregnant?

Maybe you have trapped gas. You could possibly have trapped gas. Yes there is a baby in you.

Yes or you could have stomach problems. I would check with a doctor.

What Access object holds the data in your database?

The access object that holds data in your database is called a table. It stores it in rows and columns.

Explain the disadvantages of partitioning as a means of implementing multilevel security for databases?

The dis advantage is that you will break down the original database into many smaller data bases just to protect some of the data that no one other than those who are concerned are allowed to viewl.

The problem with this is that the original benefits that come to our mind whenever we think of Data Base Management Systems like e.g. central control of data, elemination of redundancy to improve accuracy also it does not address the problem of a high level user who needs access to some low level data combined with high level data.

So the better approach is to use integrity lock and sensitivity lock together this way you will get multilevel security in your data bases.

SECURITY IN COMPUTING

by CHARLES P. PLEEGER fourth edition

Chapter#6 PROPOSALS FOR MULTILEVEL SECURITY

By what stages was the computerized management information system developed?

In the 1970s, personal computers were first built by hobbyists. Then Apple computer developed one of the first practical personal computers (PC). In the early 1980s, IBM developed its PC

Is management a system of authority?

a manager is supposed to get things done, rather than doing and things himself. authority is the right to give orders and the power to obtain obedience from subordinates. in this sense, an roganisation. according to drucker, management is a multi-purpose organ that manages a business, manager and manager works and work," managers operating at higher level ,of course, possess more authority than those working at the lower level