Why was the discovery of Chinese oracle bones so important?
The discovery of Chinese oracle bones was crucial because they represent the earliest known form of Chinese writing, dating back to the Shang Dynasty (c. 1600-1046 BCE). These artifacts provided significant insights into ancient Chinese culture, religion, and divination practices, revealing how early Chinese societies communicated with their ancestors and sought guidance for future events. Additionally, they have allowed historians and linguists to trace the evolution of the Chinese language and script. Overall, oracle bones are vital for understanding the foundations of Chinese civilization.
What is an oracle and what does it do?
Oracle is one of the popular database. It grows by adding many supporting tools like client tools (Developer 2000), Enterprise manager (admin), Designer tools,ERP etc.
In simple, it stores your data, manipulate.
You may check my profile there is a link to my oracle faq site. It will give you some idea about oracle. Also google to more information.
What is static table in oracle?
A Dynamics chart is used to recreate, after the fact, essential elements of I"ll give the most familiar example, automobile accidents. This is essentially a limited use map with symbols and direction angles markers indicating vehicles involved, impact velocities, traffic direction ( normal and off-flow) and so on. as these are all quantities in motion, they are dynamic, hence the name. Most frequently used with courtroom investigations of automobile accidents.
What are Different types of keys in DBMS?
* Alternate key - An alternate key is any candidate key which is not selected to be the primary key
* Candidate key - A candidate key is a field or combination of fields that can act as a primary key field for that table to uniquely identify each record in that table.
For Eg:
The table:
Emloyee(Name,Address,Ssn,Employee_Idprimary_key,Phone_ext)
In the above example Ssn no. and employee identity are ccandidate keys.
* Compound key - compound key (also called a composite key or concatenated key) is a key that consists of 2 or more attributes.
* Primary key - a primary key is a value that can be used to identify a unique row in a table. Attributes are associated with it. Examples of primary keys are Social Security numbers (associated to a specific person) or ISBNs (associated to a specific book).
In the relational model of data, a primary key is a candidate key chosen as the main method of uniquely identifying a tuple in a relation.
For Eg:
Emloyee(Name,Address,Ssn,Employee_Idprimary_key,Phone_ext)
* Superkey - A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. Equivalently a superkey can also be defined as a set of attributes of a relvar upon which all attributes of the relvar are functionally dependent.
For Eg:
Emloyee(Name,Address,Ssn,Employee_Idprimary_key,Phone_ext)
<Ssn,Name,Address>
<Ssn,Name>
<Ssn>
All the above are super keys.
* Foreign key - a foreign key (FK) is a field or group of fields in a database record that points to a key field or group of fields forming a key of another database record in some (usually different) table. Usually a foreign key in one table refers to the primary key (PK) of another table. This way references can be made to link information together and it is an essential part of database normalization.
For Eg:
For a Student....
School(Name,Address,Phone,School_Reg_noprimary_key
If you are talking about Oracle Database then some of them are:
Microsoft SQL Server
IBM UDB
Mysql (Which is also owned by Oracle)
If you meant Oracle as a company then the list is huge, Oracle Corporate have many solutions in many areas, Software (Databases, Security, Monitoring and more) and Hardware (Sun).
sql allow their implementation using various sql commands
Is a primary key a unique identifier?
NO, unique identifier allows null values.. so u dont called as primary key...
primary key means it doesn't allow null n repeated values....
so we dont call unqiue identifier is a primary key...
Different types of automation?
computer system, distributed control system, operating system, lighting system e.t.c
What is the fullform of oracle?
Oak Ridge Automatic Computer and Logical Engine
Regards,
Manikandan Selvarajan
dB Professionals India Pvt Ltd,
Chennai-40,
India.
What are the advantages and disadvantages of billing system?
Computerized billing systems:
Advantages:
Generates the claim
Records all charges & payments in the system
Automatically posts to patients accounts
Reduces paperwork
Minimized errors
Disadvantages:
High Initial Cost
Special Trainings for Personnel
Viruses
Losing data from power failure
Hackers
Computer fraud
Sequential data is when things are stored and accessed in order, starting from the beginning (or end) of the file. So to access a given record, you would have to access everything before that point. Sometimes this is the only way to access things, such as items stored on tape.
E-R diagram for library management system?
An ER-Diagram is used for developing databases.
But if you want us, to develop an database for an library management system - then you are at the wrong forum.
How you create er diagram for shopping cart?
An ergonomic diagram for a shopping cart can be made by using a map of the store where purchases will be made. Many major grocery stores have printed maps for customers. Another way to diagram a shopping cart is to make a grocery list while in the store, noting the different things in each department and the store layout.
Advantage and disadvantage of oracle dbms?
Advantages:
Disadvantages:
What is the difference between mysql server and oracle server?
While these three products are very similar, there are some differences. MySQL does not have a GUI interface while the other two do, it is also the only open source product of the three. SQL Server only runs on Windows, while the other two run on a variety of operating systems. Language support differs among the three, with each having some unique language support.
Where can one download Oracle 11i?
To get Oracle 9i, go to www.oracle.com. Go to the downloads page for 11g, scroll to the bottom, and select Previous database releases, Oracle 9i.
What is a n Er diagram for payroll system?
Drawing Entity Relationship diagram between the various entities of any Payroll System. Example relationship between departments and employee, Leaves and Employee, etc., Drawing the same will help to normalize and improve the Database Design.
What is Oracle's stock symbol?
The stock symbol for software and technology company Oracle Corporation is ORCL.
Advantages and disadvantages of management information system?
A good information system allows the user to access, understand and respond to information quickly and effectively. Whenever necessary, users can get the most accurate information needed to do an activity. A good information system also offers users a variety of ways to change and present information, as well as perform different tasks.
Information systems may not always function properly. This happens for a number of reasons. Systems break down, interrupting smooth operations and causing customer dissatisfaction. For instance, customers may be charged for the wrong services or for merchandise that they did not order. Also, defective information systems can deliver the wrong information to other systems, which could create further problems for the company and its customer
Why we are using oracle instead of mysql?
This question is very broad subject and in few lines, we should not answer... For the answer, you must have through idea/knowledge about the Organization like, Budget, IT, Technical Competencies, Capacity Planning, IT infrastructure... If any of the above mentioned area is lacking with funds then you may compromizing with the quality, security or the productivity... In the market, you may find so many products which are promising to handle your organizations Data Management but the best RDBMS is Oracle... Hope it helps... Cheers !!
Star Nirav
+91 9227258878
Different types of canvas in oracle forms?
A canvas view is the background object on which you layout the interface items(textitems,check boxes,radio groups and so on)and boilerplate objects that operators see and intaract with as they run you form.At runtime ,operators cansee only those items that have been assigned to specific canvas.each canvas,interm,must be displayed in specific window
Difference between Oracle 11g and 11i?
1.Simplified and improved automatic memory management
2.New fault diagnosability infrastructure to prevent, detect, diagnose, and help
resolve critical database errors
3.Invisible Indexes
4.Virtual columns
5.Enhanced security for password-based authentication by enabling use of mixed
case in passwords.
6.Tablespace-level encryption
7.Ability to online redefine tables that have materialized view logs
Thease are only few enhancements , you can find more detail in the doc suggested by SaRa.
What is the classification of DBMS and its interfaces?
DBMS Interfaces
User-friendly interfaces provided by a DBMS may include the following. � Menu-Based interfaces for Web Clients or Browsing: These interfaces present user with lists of options, called menus, that lead the user through the formulation a request. Menus do away with the need to memorize the specific commands and syntax of a query language. Pull-down menus are a very popular technique in Web based user interfaces. They are also often used in browsing interfaces, which allows a user to look through the contents of a database. � Forms-Based Interfaces: A forms-based interface displays a form to each user. Forms are usually designed and programmed for naive users as interfaces to canned transactions. Some systems have utilities that define a form by letting the end user interactively construct a sample form on the screen. � Graphical User Interfaces: A graphical interface (GUI) typically displays a schema to the user in diagrammatic form. The user can then specify a query by manipulating diagram. In many cases, GUls utilize both menus and forms. Most GUls use a pointing device, such as a mouse, to pick certain parts of the displayed schema diagram. � Natural Language Interfaces: These interfaces accept requests written in English, Hindi or some other language and attempt to "understand" them. A natural language interface usually has its own "schema," which is similar to the database conceptual schema, as well as a dictionary of important words. � Interfaces for Parametric Users: Parametric users, such as bank tellers, often have a small set of operations that they must perform repeatedly. Systems analysts and programmers design and implement a special interface for each known class of na�ve users. Usually, a small set of abbreviated commands is included, with the goal of minimizing the number of keystrokes required for each request. For example, function keys in a terminal can be programmed to initiate the various commands. � Interfaces for the DBA. Most database systems contain privileged commands that can be used only by the DBA's staff. These include commands for creating account, setting system parameters, granting account authorization, changing a schema, and reorganizing the storage structures of a database.