It is a bundle of actions which are done
Are said to exhibit physical data
within a database to bring it from one
independence if they do not depend on the
consistent state to a new consistent state.
physical schema.
Transaction
Application programs
It is a unit of data – is a symbol or a set of
It is the term generally used to describe
symbols which is used to represent
what was done by large mainframe
something.
computers from the late 1940's until the
datum early 1980's.
The overall design of the database is Data Processing
called the
It is a collection of interrelated data and a
database schema set of programs to access those data.
Is the underlying the structure of a database-management system (DBMS)
database.
It is the collection of information stored in
data models the database at a particular moment is
called
The overall logical structure schema of a
database can be expressed graphically by instance of the database
an
This describes the database design at the
E-R diagram logical level.
This describes the database design at the logical schema
physical level.
It is collection of data that contains
physical schema information relevant to an enterprise.
It is an association among several entities. Database
relationship It is the collection of basic objects.
This is formed by one or more than one Entities
attributes.
This is a characteristic of database that
identifier includes also the protection of the
database from unauthorized access
Are applied to the table and form the
confidentiality and unauthorized changes.
logical schema.
Data Integrity
Constraints
It is an interpreted data – data supplied
It is design to manage large bodies of
with semantics.
information.
Information
Database systems
This is also known as facts that can be
recorded and that have implicit meaning.
Data
,He proposed the relational model
An alter statement that is used to add new
for database systems in 1970.
column to the table.
Dr. E.F Codd
ADD
It is a collection of relations or two-
An alter statement that is used to delete an
dimensional tables controlled by the
existing column in the table.
Oracle server.
DROP
Relational database
A statement that is use to rename the
Which of the following is not table or change the existing name of the
part of transaction control? table.
CREATE Rename
Basic unit of storage composed of rows and
Which of the following is not part of columns
data manipulation language?
Table
Alter
Which of the following is not true about
Which of the following is not part of ALTER statement?
data control language?
Define a default value for the new column
Insert
NUMBER
An alter statement that is used to
update an existing column datatype or
datatype size.
It logically represents subsets of data from
MODIFY
one or more table.
View
Which of the following datatype is not
being used in oracle?
, Suppose that a user wanted to add a
new column name as CITY datatype set
to char size 10. Which of the following is
the correct sql statement?
ALTER TABLE STUDENTS ADD CITY
CHAR(10);
Suppose that a user wanted to change
the datatype of column ADDRESS from
Varchar to Char which of the following is
the correct example.
ALTER STUDENTS
MODIFY ADDRESS VARCHAR(20);
Are said to exhibit physical data
within a database to bring it from one
independence if they do not depend on the
consistent state to a new consistent state.
physical schema.
Transaction
Application programs
It is a unit of data – is a symbol or a set of
It is the term generally used to describe
symbols which is used to represent
what was done by large mainframe
something.
computers from the late 1940's until the
datum early 1980's.
The overall design of the database is Data Processing
called the
It is a collection of interrelated data and a
database schema set of programs to access those data.
Is the underlying the structure of a database-management system (DBMS)
database.
It is the collection of information stored in
data models the database at a particular moment is
called
The overall logical structure schema of a
database can be expressed graphically by instance of the database
an
This describes the database design at the
E-R diagram logical level.
This describes the database design at the logical schema
physical level.
It is collection of data that contains
physical schema information relevant to an enterprise.
It is an association among several entities. Database
relationship It is the collection of basic objects.
This is formed by one or more than one Entities
attributes.
This is a characteristic of database that
identifier includes also the protection of the
database from unauthorized access
Are applied to the table and form the
confidentiality and unauthorized changes.
logical schema.
Data Integrity
Constraints
It is an interpreted data – data supplied
It is design to manage large bodies of
with semantics.
information.
Information
Database systems
This is also known as facts that can be
recorded and that have implicit meaning.
Data
,He proposed the relational model
An alter statement that is used to add new
for database systems in 1970.
column to the table.
Dr. E.F Codd
ADD
It is a collection of relations or two-
An alter statement that is used to delete an
dimensional tables controlled by the
existing column in the table.
Oracle server.
DROP
Relational database
A statement that is use to rename the
Which of the following is not table or change the existing name of the
part of transaction control? table.
CREATE Rename
Basic unit of storage composed of rows and
Which of the following is not part of columns
data manipulation language?
Table
Alter
Which of the following is not true about
Which of the following is not part of ALTER statement?
data control language?
Define a default value for the new column
Insert
NUMBER
An alter statement that is used to
update an existing column datatype or
datatype size.
It logically represents subsets of data from
MODIFY
one or more table.
View
Which of the following datatype is not
being used in oracle?
, Suppose that a user wanted to add a
new column name as CITY datatype set
to char size 10. Which of the following is
the correct sql statement?
ALTER TABLE STUDENTS ADD CITY
CHAR(10);
Suppose that a user wanted to change
the datatype of column ADDRESS from
Varchar to Char which of the following is
the correct example.
ALTER STUDENTS
MODIFY ADDRESS VARCHAR(20);
