database management system

Insert

Which of the following is not part of data control language?

CREATE

Which of the following is not part of transaction control?

Alter

Which of the following is not part of data manipulation language?

relationship

It is an association among several entities.

Dr. E.F Codd

He proposed the relational model for database systems in 1970.

explicit

A type of insert statement that specify the NULL keyword in the VALUES clause

ALTER TABLE EMPLOYEES

MODIFY JOB_ID CHAR(10);

Which of the following is the correct example of modifying the column JOB_ID? Change the datatype size to 10

table

Basic unit of storage composed of rows and columns

ADD

An alter statement that is used to add new column to the table

INSERT

A type of DML statement that is use to add new rows in a table

Transaction

Consists of a collection of DML statements that form a logical unit of work

TRUNCATE TABLE EMPLOYEES;

Which of the following is the correct example of truncating the table EMPLOYEES?

ALTER TABLE EMPLOYEES

MODIFY LASTNAME VARCHAR(20);

Which of the following is the correct example of modifying the column lastname? Change the datatype size to 20.

rename

A statement that is use to rename the table or change the existing name of the table

INSERT

A type of DML statement that is use to add new rows in a table

All rows are deleted but the table is still intact

Suppose that a user uses the DELETE statement as shown below: what is/are the possible output

MODIFY

An alter statement that is used to update an existing column datatype or datatype size

View

It logically represents subsets of data from one or more table

ALTER TABLE STUDENTS
ADD CITY CHAR(10);

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?

UPDATE STUDENTS
SET LASTNAME = ‘SANTOS’, YR_LVL = ‘IRREG’
WHERE USN_ID = 50;

Suppose that a user wanted to update the lastname of student to ‘Santos’ and YR_LVL to ‘Irreg’ whose USN_ID is equal to 50, in one select statement which of the following is the correct sql statement to use

Insert new row in a table

Which of the following is not true about ALTER statement?

Implicit

A type of insert statement that omit the column from the column list

ADD

An alter statement that is used to add new column to the table

ALTER TABLE STUDENTS
MODIFY ADDRESS VARCHAR(20);

Suppose that a user wanted to change the datatype of column ADDRESS from Varchar to Char which of the following is the correct example

Table

Basic unit of storage composed of rows and columns

DROP

An alter statement that is used to delete an existing column in the table

DELETE

A type of DML statement that is use to remove existing rows in a table

INT

Which of the following datatype is not being used in oracle?

Explicit

A type of insert statement that specify the NULL keyword in the VALUES clause

Transaction

Consists of a collection of DML statements that form a logical unit of work

UPDATE

A type of DML statement that is use to update existing rows in a table