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

What is collection in oracle 11g?

Collection is a composite datatype in oracle and it can also be called as pl/sql table which is used to store collection of similar datas as like an array of C.There are three types in collections

1.Associative array

2.Nested Table

3.Varray

What type of safeguards does the registry editor have to keep you from making mistakes?

It doesn't! Make a registry backup before making changes to the registry. Once a change is made it's final.

What is the role of shutters?

Shutters are used to protect glass, such as windows or glass doors, from incliment weather, esp. in the case of high winds when objects could be picked up and thrown around, possibly hitting and breaking the glass.

Some shutters are merely ornamental, and are not functional, as they add a quaint appearance to a home, but the home may be located in an area where the weather rarely requires that windows and doors be protected.

What is data inconsistency?

Data inconsistency exists when different and conflicting versions of the

same data appear in different places. Data inconsistency creates

unreliable information, because it will be difficult to determine which

version of the information is correct. (It's difficult to make correct - and

timely - decisions if those decisions are based on conflicting information.)

Data inconsistency is likely to occur when there is data redundancy. Data

redundancy occurs when the data file/database file contains redundant -

unnecessarily duplicated - data. That's why one major goal of good

database design is to eliminate data redundancy.

Explain the function of network management system information model and its components-structure of management information smi and management information base mib?

A management information base (MIB) is a type of database used to manage the devices in a communications network. It comprises a collection of objects in a (virtual) database used to manage entities (such as routers and switches) in a network. The database is tree-structured and entries are addressed through http://www.answers.com/topic/object-identifier. Objects in the MIB are defined using "Structure of Management Information". The software that performs the parsing is a MIB compiler.Examples of MIB objects include: · output queue length, which has the name ifOutQLen · Address Translation table (like http://www.answers.com/topic/address-resolution-protocol tables) called atTable. MIBs are periodically updated to add new functionality, remove ambiguities and to fix defects.Simple Network Management Protocol (http://www.answers.com/topic/simple-network-management-protocol), a communication protocol between management stations, such as consoles, and managed objects (MIB objects), such as routers, gateways, and switches, makes use of MIBs. Components controlled by the management console need a so-called SNMP agent - a software module that can communicate with the SNMP manager. SNMP uses a specified set of commands and queries. A MIB should contain information on these commands and on the target objects (controllable entities or potential sources of status information) with a view to tuning the network transport to the current needs.

Basic differences between conceptual schema and a physical schema?

* Conceptual - a model that captured the essential data that needed to be stored and the relationships between elements * * ** Physical - the on disk representation of data that accounts for layout, partitioning, index, space management, etc.

A Whether backup important?

Backup is only as important as your data.

Can you easily replace everything on your hard disk? If so backup is not important. Otherwise backing up can really save your bacon.

Activity diagram for video rental system?

i knew how to draw the activity diagram fro video rental system but i dont know how to attach it here

What is the use of dbms?

DataBase Management System (DBMS)
is a software package
# it allows data to be effectively stored, retrieved and manipulated
and # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .
Types of DBMS
# Hierarachical DBMS (HDBMS)
# Network DBMS (NDBMS)
# Relational DBMS (RDBMS)
# Object Oriented DataBase(OODB)
# Distributed DBMS (DDBMS)

What is the meaning of hospital management system?

this is completely for gods sector. do what you say, serve to gods creative equal for serve to god.

How can detect the defect of DDR SLOT of PC?

The start-up utilities in Windows can run memory diagnostics for each DDR slot. Conversely, you can enter the command "mdsched.exe" in the start menu on Windows 7+ operating systems.

Magnetic card reader requires the card to make contact with the reader?

The magnetic card reader will require a credit or debit card to make contact with the reader. The magnetic card reader will read the numbers off of the card once contact is read in order to submit a debit entry from the card to the officiating bank.

How do I create a SQL Select query that will return the number of columns not rows in my query result. So if my query returns 1 row with 5 columns I want the query to generate the number 5.?

I have the same question but well a not-so-elegant solution would be to define a view within your DBMS

e.g. CREATE VIEW view_name AS (SELECT ...your_query)

and then apply a SELECT COUNT(*) FROM view_name

Difference between SQL and OQL?

in some cease both are the same they use query language but in fact the out puts are very deference