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 are the advantages of data verification in database system?
Yalla Zeyd is X2 plus abu Zeyd and Um Zeyd
Zeyd 7AMEL
Name 3 types of software used to create databases?
tHE MOSt COMMONlY USEd tYPES Of SOftWARE ARE RESEARCh
What is the difference between function and stored procedure?
we cant use DML operations in functions where as it is possible in sp. Procedure can return zero or n values whereas function can return one value which is mandatory. error handling can be done in sp, but not possible in function. functions can be called from select statements, where clause and case but not possible in sp. Procedures can have input,output parameters for it whereas functions can have only input parameters Functions can be called from procedure whereas procedures cannot be called from function. We can go for transaction management in procedure whereas we can't go in function.
Is a hotel reservation system an example of a management information system?
No the Management Information System is more like an analytics/statics for management to have a quck view of what is happening under their functional area. So a Analytics run over the Holel Reservation System will be used for MIS and not the system itself.
How many gigabytes are in a Carl Sagan byte?
According to wikipedia: "sagan has been defined as a unit of measurement equal to at least four billion, since the smallest number that may be described as billions and billions must be two billion plus two billion".
According to google calculator: "four billion bytes = 3.7252903 gigabytes".
So sagan byte is at least 3.7252903 gigabytes.
Database administration
What are the advantages and disadvantages of the Logical Data Modeling Methodology?
ahsan is the best.
Which SQL statement is used to extract data from a database?
"SELECT" statement is used to extract the infromation from a database.
What are the advantages of computer based training?
If it's for collage or something like that, it can be very beneficial if you don't have the time to go out to train and learn. It can also sometimes be cheaper.
Integrated circuits on a silicon chip and encapsulated with pinouts, to solder into a circuit.
They are dedicated to do one job, but may contain a microprocessor within them.
The input lines allow commands to be set up and modified.
The output lines control something, like a motor, servo, display, lights etc.
The web host server may bog down and not be able to accept any more access requests at that time.
What is the difference between rollback and savepoint in sql with examples?
Rollback:
This is used for undoing the work done in the current transaction. This command also releases the locks if any hold by the current transaction. The command used in SQL for this is simply:
ROLLBACK;
Savepoint:
This is used for identifying a point in the transaction to which a programmer can later roll back. That is it is possible for the programmer to divide a big transaction into subsections each having a savepoint defined in it. The command used in SQL for this is simply:
SAVEPOINT savepointname;
For example:
UPDATE…..
DELETE….
SAVEPOINT e1;
INSERT….
UPDATE….
SAVEPOINT e2;
……
It is also possible to define savepoint and rollback together so that programmer can achieve rollback of part o a transaction. Say for instance in the above
ROLLBACK TO SAVEPOINT e2;
This results in the rollback of all statements after savepoint e2
Commit:
This is used to end the transaction and make the changes permanent. When commit is performed all save points are erased and transaction locks are released. In other words commit ends a transaction and marks the beginning of a new transaction. The command used in SQL for this is simply:
COMMIT;
What is Oracle Spatial Databas Engine server?
Oracle Spatial is an option of the Oracle Database Enterprise Edition. Its core component is a new datatype called SDO_GEOMETRY that is used to store geometric figures (points, lines and polygons) defined by one or more coordinates.
This allows you to create "spatial" tables, i.e. tables that contain any number of regular columns and one column of type SDO_GEOMETRY (or even multiple such columns).
You can then query those tables using spatial predicates (like CONTAINS, TOUCHES, INSIDE, WITHIN_DISTANCE etc). Things like "get me the land parcels of a certain type that are on the path of this pipeline", or "get the list of customers that live within 10km of a store".
Databases that use Oracle Spatial are commonly used by commercial or open source GIS tools to store and manage their spatial data.
Advanced capabilities include the storage of raster data (imagery), network searches, geocoding, routing, topology etc.
Functions of database manager in Database management system. explain the functions with example.?
functions of DBA in DBMS
What part of the computer controls the clipboard?
Two parts. On the software side of things, the operating system defines or allocates space for whatever you have cut or copied to put on the clipboard. On the hardware side of things, clipboard contents are held in memory.
So if you highlight this text, right-click, and choose copy, your operating system will take the text highlighted by the mouse, allocate enough space in physical memory to hold that data, and then store it in the space allocated.
Can you give me some examples of everyday databases?
Many of your activities throughout the day use databases. Here are some common examples.
If you purchase something at the grocery store, the price is being looked up in a database based on the UPC (Universal Product Code)
When you watch TV, and see the stock market prices at the bottom of the screen, that is coming from a database (that a friend of mine administers, as a matter of fact) :)
When you make a phone call, a database is being accessed for information on how to route the call. Caller ID information is also looked up in a database.
This web site runs on a database (as do most others)
If you call 411, a database is used to find the phone number you are looking for.
If you call 911, a database is used to cross-reference the calling number to your address.
Your car (if it's less than 20 years old) will have a small database that a technician can read that gives the reason that the "Check Engine" light came on last.
table area
Why did you choose a career in Oracle DBA?
I had always found DBA job very challenging and interseting. Another reason is lot of opportunities.
How can you install squid in windows xp professional?
Download SQUID Windows version. Place it under c:\squid\... Run C:\squid\sbin\squid.exe -i Start the squid service. If the service failed to start view the log file under C:\squid\sbin\
What is the workgroup database?
In work group database approach , consists 20-25 members those team of people will develop a database of an organization . The work group database is designed to support to maintain database by a group of people.
Is schema a logical structure or physical structure in oracle database?
the schema can be termed either conceptual or logical or physical.
But mostly speaking, the term schema is used to refer to a logical structure.
Is a personal computer and microcomputer the same?
No.
- a microcomputer is any computer implemented with a microprocessor
- a personal computer is a type of microcomputer designed for personal use (i.e. the set of personal computers is a subsetof the set of microcomputers)
