UGRD-IT6202 Database Management System 1 (Oracle)

It logically represents subsets of data from one or more table.	View
Which of the following is the correct example updating all student COURSE to ‘BSIT’ from STUDENTS table?	UPDATE STUDENTS
Basic unit of storage composed of rows and columns INSERT INTO STUDENST(USN_ID, FIRSTNAME)	Table
Is the underlying the structure of a database.	VALUES(10,’ELENA’)
Suppose that a user wanted to insert a new value using the implicit method which of the following is the correct example.	Datum
It is a unit of data – is a symbol or a set of symbols which is used to represent something.	Dr. E.F Codd
He proposed the relational model for database systems in 1970.	Data Processing
It is the term generally used to describe what was done by large mainframe computers from the late 1940's until the early 1980's.	Insert
Which of the following is not part of data control language?	Database
It is collection of data that contains information relevant to an enterprise.	Constraints
Are applied to the table and form the logical schema.	Relational database
It is a collection of relations or two-dimensional tables controlled by the Oracle server.	Database Management System
It is a collection of interrelated data and a set of programs to access those data.	Data integrity
This is a characteristic of database that includes also the protection of the database from unauthorized access confidentiality and unauthorized changes.	Tuples
This is formed by one or more than one attributes.	Relationship
It is an association among several entities.	Data
This is also known as facts that can be recorded and that have implicit meaning.	Database schema
The overall design of the database is called the	Entities
It is the collection of basic objects.	Instance of the database
It is the collection of information stored in the database at a particular moment is called	Logical schema
This describes the database design at the logical level.	Transaction
It is a bundle of actions which are done within a database to bring it from one consistent state to a new consistent state.	ER Diagram
The overall logical structure schema of a database can be expressed graphically by an .	Information
It is an interpreted data – data supplied with semantics.	Physical schema
This describes the database design at the physical level.	Data Model
A type of DML statement that is use to update existing rows in a table.	UPDATE
Which of the following is the correct example of creating a new table STUDENTS? The column STUD_ID is set to primary key.	CREATE TABLE STUDENTS( STUD_ID NUMBER(3) PRIMARY KEY);
A type of DML statement that is use to remove existing rows in a table.	DELETE
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 TABLE STUDENTS MODIFY ADDRESS VARCHAR(20);
Which of the following is the correct example of modifying the column JOB_ID? Change the datatype size to 10.	ALTER TABLE EMPLOYEES
An alter statement that is used to add new column to the table.	ADD
A type of insert statement that specify the NULL keyword in the VALUES clause.	Explicit
Which of the following is the correct example inserting a new value to STUDENTS table that will only add new data to STUD_ID and LASTNAME? The stud_id is 10 and lastname is ‘CRUZ’	INSERT INTO STUDENTS(STUD_ID,LASTNAME)
Which of the following is the correct example of renaming the table EMPLOYEES to WORKERS?	RENAME EMPLOYEES TO WORKERS;