What is all about oracle 10g and oracle8i?
The oracle 10g and oracle 8i there is a minor difference that is oracle 8i doesn't support flash back command
once we drop the table in database the message is table dropped
but we can use flashback command we can retrieve the drop table once in database
What is one to one relationship in ER diagram?
One-to-one relationships are use to separate data that could be located in the same table as the other data into multiple tables.
How do you find your Dell computer model?
Go to the following link and enter your Dell Service Tag http://support.dell.com/support/topics/global.aspx/support/my_systems_info/en/details?servicetag= You will see the Dell Model under System Type. Example: 'System Type: Latitude E5400' You can also use the following link to see the model directly but replace the 7 X's with your service tag: http://support.dell.com/support/topics/global.aspx/support/my_systems_info/en/details?servicetag=XXXXXXX -Hubert Louis
What is a geographic information system GIS explain advantage of such system?
A geographic information system differs from other computerized information systems in two major respects. First, the information in this type of system is geographically referenced (geocoded). Second, a geographic information system has considerable capabilities for data analysis and scientific modeling, in addition to the usual data input, storage, retrieval, and output functions.
A geographic information system is composed of software, hardware, and data. The notion of data layer (or coverage) and overlay operation lies at the heart of most software designed for geographic information systems.
Why is it important to know where the PATA pin 1 is located?
It generally isn't important to know these days unless you are changing the jumpers or attempting to repair the drive. There is generally a key pin and a notch to keep you from plugging it up backwards. Just don't force the cable if it won't fit, since you could break off the DMA mode enable pin and permanently cripple the performance of the drive. If you use a very old cable without a key pin and notch, then knowing the pin orientation is important. In the past, there were no key pins, so you had to look for the red stripe on the cable and make sure you attached it to pin 1 on the drive and the motherboard. Otherwise, the drive would not work. Even worse is if you had a PATA drive with 44-46 pins instead 40, and no key pins. Then you could fry to drive if you hook the cable up backwards. The extra wires besides the standard 40 were for power.
What type of database is MySQL?
MySQL databases are relational. A relational database does not store all the data in one large store, but stores the data in separate tables. It is an organized collection of data stored in tables that relate to others. It is optimal for extensive volumes of data.
Depending on the type of database, the approach to its development, management and administration differs. A database management system can be very feature rich, but it also needs to be simple and fast. Database professionals can manage their DBMS manually through the command line, but it's easier and faster to complete tasks through a dedicated interface. One of the most popular of these is the tools of the dbForge MySQL product line, they can perform all tasks related to database development, administration, design, and maintenance, as well as data analysis and reporting. Among them, dbForge Studio for MySQL is the most multifunctional.
Blood bank management system-UML diagram?
The UML are behavioral diagram used to describe a set of actions that some systems(s) should or can perform in collaboration with one or more external users of the system. In this case, blood bank management systems.
Can you have a DFD for a Document Management System?
A Data Flow Diagram is not limited to problem analysis and by definition shows the flow of data through a system (meaning a manula procedure, software system, mechanical system, a hardware system or any combination of these. To create a DFD for any system, the major things that one has to understand are * Identify Inputs to the system * Outputs required/proposed from the system * Processes involved to get the required output with the specified inputs. * Control logic should never be a part of your DFD (no loops/no conditions)
How do you calculate age in reports object in ms access?
Are you trying to calculate the age of a person with a specific date in mind? This one stumped me for the longest time, but it is possible using the following formula in a query:
Age: DateDiff("d",[date_of_birth],#9/20/2008#)/365.25
[date_of_birth] is of course the name of the field from which I have pulled the birth date of participants on a table. #9/20/2008# is the date that I am seeking to find the age of the person at that time. If you were to want to see what is was as of now, then you would replace #9/20/2008# with date()
This gets the the age field as accurate as possible. You will need to be sure to have the field allow decimals, otherwise it will round up the amount in the calculated field (for example, 39.6 would round to 40 which would make the participant really adamant about telling you that you're wrong!!)
Be sure to shrink the size of the field in your report to only show the first two digits of age, and you're done! I don't know, there may be a simpler way, but this is how I got through the problem for myself.
How do you create a web application using a payment gateway?
There is a large and diverse variety of payment gateways -- most of which should have a well-documented (and heavily customized) API. Find more information about your payment gateway to fully answer this question, as the existing amount of payment gateways makes it too broad to generalize.
The most critical software facilities is the system software particularly the operating system for this systems are the one responsible for the operations and the proper running of all the hardware and the correct execution of tasks given by a program.
How do you find the title of publication on a web database?
How do I turn my scientific articles in the database of publications of your laboratories
How do you draw componant diagram for library management system?
component diagram for library managment system
Parallel Processing in Business?
What good did Parallel processing do to Computer Science and Business What good did Parallel processing do to Computer Science and Business?
A set of rules that Access uses to ensure that the data between related tables is valid?
Referential integrity.
How real-time systems ensure that deadlock never occurs?
Real-time systems prevent deadlock through strategies such as resource allocation protocols, priority scheduling, and timeout mechanisms. Techniques like the Banker’s Algorithm or Wait-Die/Wound-Wait schemes help manage resource requests and ensure that resources are allocated based on predefined priorities, preventing circular wait conditions. Additionally, implementing strict resource ordering and using non-blocking algorithms can further reduce the risk of deadlocks. By enforcing these rules, real-time systems maintain predictable behavior and ensure that critical tasks meet their deadlines without getting stuck in deadlock situations.
Some organizations may intentionally avoid cleaning their database information due to resource constraints, such as limited time, budget, or personnel. They might also prioritize immediate operational needs over long-term data integrity, believing that the cost of cleaning doesn't justify the benefits. Additionally, some organizations may lack awareness of the importance of data hygiene or fear disrupting current processes that rely on existing data. Lastly, they might assume that their data is "good enough" for their current objectives, leading them to deprioritize data cleaning efforts.
Backup and Recovery methods in Oracle 10g?
In Oracle 10g, backup and recovery methods primarily involve two approaches: physical and logical backups. Physical backups can be performed using RMAN (Recovery Manager) or through operating system commands, allowing for full or incremental backups of the database files. Logical backups, on the other hand, can be achieved using the Data Pump utility or the Export/Import utilities, which focus on backing up and restoring database objects. RMAN provides advanced features for automating backup processes, validating backups, and performing point-in-time recovery, making it a preferred choice for many database administrators.
How do you draw e-r diagram for ticketing system for a movie theatre?
To draw an Entity-Relationship (E-R) diagram for a ticketing system in a movie theatre, first identify the key entities such as Movie, Theatre, Show, Ticket, Customer, and Payment. Define the relationships between these entities, such as a Movie can have multiple Shows, a Show can have many Tickets, and a Customer can purchase multiple Tickets. Specify attributes for each entity, like Movie title, Show time, Ticket price, Customer name, and Payment method. Finally, use appropriate notation to represent these entities, relationships, and their cardinalities, ensuring clarity in how they interact.