Oracle Sql

Exam 1 oracle sql

23 cards   |   Total Attempts: 182
  

Cards In This Set

Front Back
Data is?
Raw material, from which you can draw conclusions
A database is a?
A centralized and structured set of data stored on a computer system.
A database is usually managed by a?
Database Administrator (DBA).
Inside the database, data is stored in a?
A “raw” form.
When this raw data is queried or retrieved, it is transformed into?
Into more useful output or information.
E.F. Codd proposes the relational model for?
Databases,
disconnecting the logical organization from the physical storage.
SQL (structured query language) becomes "intergalactic standard. in ?
1980
Data modeling is the?
First part of the database development process.
An entity relationship model should accurately model the?
Organization’s information needs and support the functions of the business.
In database design, the information requirements reflected in the entity relationship model are mapped into?
A relational database design using a table instance chart
A table instance chart has the following components:
Table name, Column names, Keys, Nulls, Unique, Datatype
Datatype refers to?
He format and definition of the data in each column
Structured Query Language (SQL) is used to create?
Create and manipulate relational databases.
Hardware:
The physical “bits and pieces” of a computer
Software:
Programs (sets of instructions) which tell the hardware what to do.