Database Management System 1

 True or False

Database Management System is a collection of interrelated data and a set of programs to access those data.

Answer: 

Feedback

Suppose that the user wanted to add a new column name as CUST_NAME data type char size 6. What is the correct SQL statement to use?

Select one:

a. ALTER  PARTS
SET CUST_NAME  = CHAR(6);

b. ALTER TABLE PARTS
SET CUST_NAME  = CHAR(6);

c. ALTER TABLE PARTS
ADD CUST_NAME CHAR(6);

d. ALTER PARTS
ADD CUST_NAME CHAR(6);

Feedback

Which of the following is not part of handling data?

Select one:

a. Semi-Computerized

b. File Oriented Approach

c. Data Management Systems

d. Data Processing

Feedback

Which of the following is not part of common Comparison operator?

Select one:

a. >

b. !=

c. <

d. LIKE

Feedback

Refer to table 1.0, suppose that user insert the following values using the statement below what would be the possible output?

INSERT INTO ORGCHART VALUES (11,’YAMBAO,JUN’, NULL, NULL); 

Select one:

a. The ORG and POSITION of YAMBAO will automatically sets to N/A

b. The ORG and POSITION of YAMBAO will automatically sets to None.

c. The ORG and POSITION of YAMBAO will automatically sets to NULL.

d. Cannot insert the record because of missing values for ORG and POSITION.

Feedback

True or False:

Security is one of the characteristics of the database that includes also the protection of the database from unauthorized access confidentiality and unauthorized changes.

Answer: 

Feedback

Refer to table 1.0, suppose that user update the table using the statement below what would be the possible output?

UPDATE ORGCHART

SET ORG = ‘PCS’

WHERE ORG IS NULL;

Select one:

a. 1 row/s is updated

b. Incorrect WHERE condition must be =NULL

c. 2 rows/ is updated

d. 0 row/s is updated

Feedback

Which of the following is not part of characteristics of database?

Select one:

a. Data Persistence

b. Transactions

c. Data Integrity

d. Data Processing

Feedback

Refer to table 1.0 Using the SELECT statement below what would be the possible output:

SELECT NAME, ORG, POSITION

FROM ORGCHAR

WHERE ORG =’JPCS’

OR POSITION = ‘SEC’;

Select one:

a. Incorrect SELECT statement

b. It will retrieve the record of JOAN andROAN

c. 0 rows selected

d. It will retrieve the record of JOAN,ROAN and JUN

Feedback

True or False:

Database Architecture is the overall design of the database

Answer: 

Feedback

Suppose that the user wanted to add a new column name as CUST_NAME data type char size 6. What is the correct type of statement to use?

Select one:

a. UPDATE

b. DELETE

c. INSERT

d. ALTER

Feedback

Which of the following is not the correct example of entity?

Select one:

a. EMPLOYEES

b. ORDERS

c. STUDENT

d. Phone_no

Feedback

Which of the following is not part of DDL statement?

Select one:

a. DELETE

b. ALTER

c. CREATE

d. None of the choices

Feedback

Which of the following is not part of DML statement?

Select one:

a. UPDATE

b. INSERT

c. MERGER

d. CREATE table

Feedback

Which of the following is not part of disadvantage of database?

Select one:

a. Data integrity

b. Lower Efficiency

c. Costs

d. Qualified Personnel

Feedback

Refer to table 1.0 Using the SELECT statement below what would be the possible output:

SELECT NAME, ORG, POSITION

FROM ORGCHAR

WHERE ORG =’JPCS’

OR POSITION = ‘SEC’

AND NAME LIKE ‘%N’;

Select one:

a. Incorrect SELECT statement

b. 0 rows selected

c. It will retrieve the record of JOAN,ROAN and JUN

d. It will retrieve the record of JOAN and ROAN

Feedback

Which of the following is not part of basic SELECT statement

Select one:

a. Concat

b. Alias

c. Specific Column

d. Logical condition

Feedback

True or False: 

Database is the term generally used to describe what was done by large mainframe computers from the late 1940's until the early 1980's.

Answer: 

Feedback

Refer to table 1.0 Using the SELECT statement below what would be the possible output:

SELECT NAME, ORG, POSITION, ID * (100 + 3)

FROM ORGCHAR

WHERE ORG = ‘AMATHS’

Select one:

a. It will retrieve the record of ANNA with new ID of 10

b. It will retrieve the record of ANNA with new ID of 1003

c. It will retrieve the record of ANNA with new ID of 1030

d. 0 rows selected

Feedback

Refer to table 1.0 Using the SELECT statement below what would be the possible output:

SELECT NAME, ORG, POSITION

FROM ORGCHAR

WHERE NAME LIKE ‘A%’

AND POSITION = ‘SEC’;

Select one:

a. It retrieves the record of AGAPITO

b. Incorrect SELECT statement

c. It retrieves the record of ANNA and MOJICA

d. 0 rows selected / no rows selected

Feedback

Which of the following is not part of other Comparison Operator?

Select one:

a. <>

b. IS NUL

c. IN

d. Between AND

Feedback

Refer to table 1.0, suppose that user insert the following values using the statement below what would be the possible output?

INSERT INTO ORGCHART (ID, NAME)

VALUES (11,’YAMBAO,JUN’); 

Select one:

a. The ORG and POSITION of YAMBAO will automatically sets to NULL.

b. The ORG and POSITION of YAMBAO will automatically sets to None.

c. Cannot insert the record because of missing values for ORG and POSITION

d. The ORG and POSITION of YAMBAO will automatically sets to N/A.

Feedback

True or False

Table is known as the collection of data that contains information relevant to an enterprise.

Answer: 

Feedback

Which of the following is not part of advantage of database?

Select one:

a. Data integrity and security

b. Data independence

c. Database instance

d. Efficient data access

Feedback

Refer to table 1.0 Using the SELECT statement below what would be the possible output:

SELECT NAME, ORG, POSITION

FROM ORGCHAR

WHERE NAME LIKE ‘%A’;

Select one:

a. 0 rows selected / no rows selected

b. Incorrect SELECT statement

c. It retrieves the record of AGAPITO

d. It retrieves the record of ANNA and MOJICA

 Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS

WHERE CLASS = ‘HW’;

b. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS

WHERE CLASS = HW;

c. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS

WHERE ONHAND >=21;

d. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS

WHERE ONHAND IN(50,21,22);

Feedback

Correct

Marks for this submission: 1.00/1.00.

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT * FROM PARTS;

b. SELECT ALL FROM PARTS;

c. SELECT ALL COLUMN FROM PARTS;

d. SELECT * FROM TABLE PARTS;

Feedback

Correct

Marks for this submission: 1.00/1.00.

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS IN (‘HW’,’SG’);

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE DESCRIPTION LIKE ‘%L’;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE ONHAND >=9;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE DESCRIPTION LIKE ‘L%’;

Feedback

Correct

Marks for this submission: 1.00/1.00.

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used

Select one:

a. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (‘AP’,’SG’,’HW’);

b. SELECT WAREHOUSE, CLASS FROM PARTS;

c. SELECT DISTINCT WAREHOUSE FROM PARTS;

d. SELECT DICTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1;

Feedback

Correct

Marks for this submission: 1.00/1.00.

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT DESCRIPTION, PRICE *.5 +PRICE-100 FROM PARTS WHERE PRICE >10000;

b. SELECT DESCRIPTION, (PRICE *.5 )+PRICE-100 FROM PARTS WHERE PRICE >10000;

c. SELECT DESCRIPTION, PRICE *.5 +PRICE-100 FROM PARTS WHERE PRICE <10000;

d. SELECT DESCRIPTION, PRICE *.5 +(PRICE-100) FROM PARTS WHERE PRICE <10000;

Feedback

Correct

Marks for this submission: 1.00/1.00.

Question 6

Correct

Mark 0.67 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ OR ONHAND BETWEEN 8 AND 12;

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ AND ONHAND BETWEEN 8 AND 12;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘%ER’;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘%ER’;

Feedback

Correct

Marks for this submission: 1.00/1.00. Accounting for previous tries, this gives 0.67/1.00.

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ OR ONHAND BETWEEEN 8 AND 12

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘__S%’;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ OR ONHAND >=8;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘__S%’;

Feedback

Correct

Marks for this submission: 1.00/1.00.

Question 8

Correct

Mark 0.67 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT WAREHOUSE, CLASS FROM PARTS;

b. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS;

c. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (‘AP’,’SG’,’HW’);

d. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1;

Feedback

Correct

Marks for this submission: 1.00/1.00. Accounting for previous tries, this gives 0.67/1.00.

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE PARTNUM IN (‘BV06,’KV29’)

b. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’;

c. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’;

d. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = SG;

Feedback

Correct

Marks for this submission: 1.00/1.00.

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE DESCRIPTION LIKE ‘%R’;

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS IN (‘HW’,’AP’);

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE DESCRIPTION LIKE ‘R%’;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = ‘AP’ OR CLASS = ‘HW’;

Choose the letter of the correct answer based on table PARTS as shown below

Which of the following is the correct report listing only the column DESCRIPTION, PARTNUM, CLASS and PRICE of all parts where the description fourth letter starting from the first is equal to ‘D’.

SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS WHERE DESCRIPTION LIKE ‘___D%’;

SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS WHERE DESCRIPTION LIKE ‘%D___’;

SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS WHERE DESCRIPTION LIKE ‘D%’;

SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS WHERE DESCRIPTION LIKE ‘%D’;

Feedback

Choose the letter of the correct answer based on table PARTS as shown below

Which of the following is the correct report that will display the distinct value for CLASS and WAREHOUSE limit the rows by getting only the parts under WAREHOUSE 3?

SELECT CLASS, WAREHOUSE FROM PARTS WHERE WAREHOUSE = 3;

SELECT CLASS, WAREHOUSE FROM PARTS WHERE WAREHOUSE = ‘3’;

SELECT CLASS, WAREHOUSE FROM PARTS WHERE WAREHOUSE = =3;

SELECT CLASS, WAREHOUSE =3 FROM PARTS WHERE WAREHOUSE = 3;

Feedback

Choose the letter of the correct answer based on table PARTS as shown below

Which of the following is the correct report listing only the column DESCRIPTION, WAREHOUSE, CLASS and PRICE of all parts where the description contains keyword ‘SHE’.

SELECT DESCRIPTION, WAREHOUSE, CLASS, PRICE FROM PARTS WHERE DESCRIPTION LIKE ‘%SHE%’;

SELECT DESCRIPTION, WAREHOUSE, CLASS, PRICE FROM PARTS WHERE DESCRIPTION LIKE ‘SHE%’;

SELECT DESCRIPTION, WAREHOUSE, CLASS, PRICE FROM PARTS WHERE DESCRIPTION LIKE ‘%SHE’;

SELECT DESCRIPTION, WAREHOUSE, CLASS, PRICE FROM PARTS WHERE DESCRIPTION LIKE ‘SHE’;

Feedback

Choose the letter of the correct answer based on table PARTS as shown below

Which of the following is the correct report listing only the column PARTNUM, CLASS and ONHAND of all parts where partnum is equal to AT94, DR93 and KV29. (Note 1 query only and do not use logical condition)

SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM IN (‘AT94’,’DR93’,’KV29’);

SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM IN (AT94,DR93,KV29);

SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM = (‘AT94’,’DR93’,’KV29’);

SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM NOT IN (‘AT94’,’DR93’,’KV29’);

Feedback

Choose the letter of the correct answer based on table PARTS as shown below

Which of the following is the correct report that will merge the column DESCRIPTION and PRICE put a literal character string of = “ with a price of ” in between the two columns. Limit the rows returned by getting only the partnum that starts with letter ‘K’.

SELECT (DESCRIPTION|| ‘WITH A PRICE OF’ || PRICE) FROM PARTS WHERE PARTNUM LIKE ‘K%’;

SELECT (DESCRIPTION|| ‘WITH A PRICE OF’ || PRICE) FROM PARTS WHERE PARTNUM LIKE ‘%K’;

SELECT (DESCRIPTION|| ‘WITH A PRICE OF’ || PRICE) FROM PARTS WHERE PARTNUM LIKE ‘%K%’;

SELECT (DESCRIPTION|| ‘WITH A PRICE OF’ || PRICE) FROM PARTS WHERE PARTNUM LIKE ‘__K%’;

Feedback

Choose the letter of the correct answer based on table PARTS as shown below

Which of the following is the correct report listing the column PARTNO, DESCRIPTION and WAREHOUSE. Get only that description that does not ends with ‘ER’. Note that you have to merge the said three columns, rename the merge column as “Parts Record”. Below is the sample output for column.
Parts Record
AT94is the part number ofIRONwhich belong to warehouse3

SELECT (PARTNUM || ‘is the part number of’|| DESCRIPTION || ‘which belongs to’ || WAREHOUSE FROM PARTS WHERE PARTNUM NOT LIKE ‘%ER’;

SELECT (PARTNUM || ‘is the part number of’ ||DESCRIPTION || ‘which belongs to’ || WAREHOUSE) FROM PARTS WHERE PARTNUM NOT LIKE ‘ER%’;

SELECT (PARTNUM ‘is the part number of’ DESCRIPTION‘which belongs to’WAREHOUSE) FROM PARTS WHERE PARTNUM NOT LIKE ‘%ER’;

SELECT (PARTNUM || ‘is the part number of’ ||DESCRIPTION || ‘which belongs to’ || WAREHOUSE) FROM PARTS WHERE PARTNUM LIKE ‘%ER’;

Feedback

Choose the letter of the correct answer based on table PARTS as shown below

Which of the following is the correct report listing only the column CLASS, DESCRIPTION and PRICE of all PARTS where price range is between 200 to 500.

SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 200 AND 500;

SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 500 AND 500;

SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN =200 AND 500;

SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 200 AND BETWEEN 500;

Feedback

Choose the letter of the correct answer based on table PARTS as shown below

 

Which of the following is the correct report listing only the column PARTNUM, DESCRIPTION and PRICE of all PARTS where price is less than 500. Sort the PRICE in ascending order.

SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE < 500;

SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE > 500;

SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE <=500;

SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE >= 500;

Feedback

Choose the letter of the correct answer based on table PARTS as shown below

Which of the following is the correct report that will display the DESCRIPTION, WAREHOUSE AND distinct value for CLASS.

SELECT DISTINCT (CLASS),DESCRIPTION, WAREHOUSE FROM PARTS;

SELECT DESCRIPTION, WAREHOUSE, CLASS FROM PARTS;

SELECT DISTINCT DESCRIPTION, WAREHOUSE, CLASS FROM PARTS;

SELECT DESCRIPTION, WAREHOUSE, DISTINCT ‘CLASS ‘ FROM PARTS;

True/False. Character strings and date values are enclosed with double quotation marks.

Answer: 

Feedback

This is used to perform wildcard searches of valid search string values.

Select one:

a. Comparison

b. Between

c. IN

d. Like

Feedback

True/False Character values are format sensitive and date values are case sensitive-sensitive.

Answer: 

Feedback

This is used to display rows based on a range of values.

Select one:

a. Comparison

b. Like

c. Between

d. IN

Feedback

This is used to test for values in a specified set of values.

Select one:

a. Between

b. IN

c. Like

d. Comparison

Feedback

True/False. A null value means that the value is unavailable, unassigned, unknown, or inapplicable.

Answer: 

Feedback

True/False. The != not equal to symbol is also equal to this symbol<>.

Answer: 

Feedback

This is used to restrict the rows that are returned by a query.

Select one:

a. Select

b. Insert

c. Delete

d. Where

Feedback

True/False. This symbol % denotes zero or many characters.

Answer: 

Feedback

This is used to in conditions that compare one expression with another value or expression.

Select one:

a. Comparison

b. Add

c. Logical Condition

d. Subtraction

This haracter is used to override the default precedence or to clarify the statement.

Select one:

a. ( )

b. *

c. AS

d. ||

Feedback

Which of the following is not true about writing SQL statements?

Select one:

a. Keywords cannot be split across lines or abbreviated.

b. SQL statements are case sensitive.

c. Clauses are usually placed on separate lines for readability and ease of editing.

d. Indents should be used to make code more readable.

Feedback

Supposed that the user uses the ff SELECT statement: what will be the possible output.

SELECT GRADE AS STUDENT MARK FROM GRADE_REPORT;

Select one:

a. Error because of missing “” mark.

b. Will display the column GRADE rename as STUDENT MARK

c. Error because of the keyword AS.

d. Will display all rows and columns.

Feedback

This is use to create expression with number and date values.

Select one:

a. Arithmetic expression

b. Logical Condition

c. MDAS operator

d. Numerical Values

Feedback

This is used to brings together data that is stored in different tables by specifying the link between them.

Select one:

a. Projection

b. Joins

c. Inclusion

d. Selection

Feedback

This is used to selects the rows in a table that are returned by a query. Various criteria can be used to restrict the rows that are retrieved.

Select one:

a. Projection

b. Joins

c. Inclusion

d. Selection

Feedback

It is a value that is unavailable, unassigned, unknown, or inapplicable.

Select one:

a. NULL

b. Blank

c. Space

d. Zero

Feedback

A system used to concatenate one column to another column.

Select one:

a. ||

b. ( )

c. AS

d. *

Feedback

This is use to Selects the columns in a table that are returned by a query. Selects a few or as many of the columns as required.

Select one:

a. Projection

b. Joins

c. Inclusion

d. Selection

Feedback

It is a character, a number, or a date that is included in the SELECT statement.

Select one:

a. String

b. Alias

c. Literal

d. Table name

Choose the letter of the correct answer based on the given table PARTS as shown below.

 

Which of the following SELECT statement is the correct PL/SQL that will display all rows and columns?

SELECT * FROM PARTS;

SELECT ALL FROM PARTS;

SELECT TABLE PARTS;

SELECT FROM TABLE PARTS;

Which of the following SELECT statement is the correct PL/SQL that will displayeliminate the duplicate rows for column class and warehouse.

SELECT DISTINCT CLASS, WAREHOUSE FROM PARTS;

SELECT DISTINCT CLASS AND WAREHOUSE FROM PARTS;

SELECT DISTINCT CLASS, DISTINCT WAREHOUSE FROM PARTS;

SELECT DISTINCT CLASS AND DISTINCT WAREHOUSE FROM PARTS;

Which of the following SELECT statement is the correct PL/SQL that willcreate a report specifying only the column PRICE, ONHAND and DESCRIPTION?

SELECT PRICE, ONHAND, DESCRIPTION FROM PARTS;

SELECTONHAND,PRICE ,DESCRIPTION FROM PARTS;

SELECT (ONHAND||PRICE ||DESCRIPTION FROM PARTS;

SELECTONHAND,PRICE DESCRIPTION FROM PARTS ORDER BY ONHAND;

Which of the following SELECT statement is the correct PL/SQL that willcreate a report that will add 10% increase in PRICE? List only the column DESCRIPTION, CLASS and PRICE.

SELECT (PRICE*0.10)+PRICE, DESCRIPTION, CLASS FROM PARTS;

SELECT PRICE*10, DESCRIPTION, CLASS FROM PARTS;

SELECT PRICE*0.10 FROM PARTS;

SELECT PRICE*10+PRICE, DESCRIPTION, CLASS FROM PARTS;

Which of the following SELECT statement is the correct report that will deduct 5 from ONHAND, multiply 5 in WAREHOUSE, after getting the value on both ONHAND and WAREHOUSE add their data: as shown below:

ONHAND - 5 + 5 * WAREHOUSE

Note that you have to force the Oracle to prioritize first the Subtraction over Multiplication. List only the column DESCRIPTION, ONHAND and WAREHOUSE.

SELECT (ONHAND-5) + 5 * WAREHOUSE, DESCRIPTION FROM PARTS;

SELECT ONHAND-5 + 5 * WAREHOUSE, DESCRIPTION FROM PARTS;

SELECT ONHAND-5 + 5 (* WAREHOUSE), DESCRIPTION FROM PARTS;

SELECT (ONHAND-5) + 5(* WAREHOUSE), DESCRIPTION FROM PARTS;

Feedback

Choose the letter of the correct answer based on the given table PARTS as shown below.

 

Which of the following SELECT statement is the correctreport that will rename the column DESCRIPTION to TITLE, PARTNUM to ID and ONHAND to STOCK?

SELECT DESCRIPTION AS TITLE, PARTNUM AS ID, ONHAND AS STOCK FROM PART;

SELECT DESCRIPTION AS ‘TITLE’, PARTNUM AS ‘ID’, ONHAND AS ‘STOCK’ FROM PARTS;

SELECT DESCRIPTION RENAME AS TITLE, PARTNUM RENAME AS ID, ONHAND RENAME AS STOCK FROM PARTS;

SELECT DESCRIPTION NEW AS TITLE, PARTNUM NEW AS ID, ONHAND NEW AS STOCK FROM PARTS;

Which of the following SELECT statement is the correctreport the will merge the column CLASS and PRICE rename the COLUMN as “CLASS PRICE”.

SELECT (CLASS||PRICE) AS “CLASS PRICE” FROM PARTS;

SELECT (CLASS||PRICE) AS CLASS PRICE FROM PARTS;

SELECT (CLASS||PRICE) CLASS PRICE FROM PARTS;

SELECT (‘CLASS’||’PRICE’) AS “CLASS PRICE” FROM PARTS;

Which of the following SELECT statement is the correctreport that will combine the column PARTNUM and DESCRIPTION put a literal character string “belongs to” in between the two columns then rename the column as “NUMBER TITLE”. Note put space before and after the character literal string to avoid no spaces in the report.

SELECT (PARTNUM||’ THAT BELONGS TO ’||DESCRIPTION) AS “NUMBER TITLE” FROM PARTS;

SELECT (PARTNUM||’ THAT BELONGS TO ’||DESCRIPTION) AS NUMBER TITLE FROM PARTS;

SELECT (PARTNUM|| THAT BELONGS TO ||DESCRIPTION) AS “NUMBER TITLE” FROM PARTS;

SELECT (;PARTNUM’||’ THAT BELONGS TO ’||’DESCRIPTION;) AS “NUMBER TITLE” FROM PARTS;

Which of the following SELECT statement is the correctreport that will display the unique value for WAREHOUSE renames the column as “No. of Available Warehouse”.

SELECT DISTINCT WAREHOUSE AS “No. of available warehouse” FROM PARTS;

SELECT DISTINCT ‘WAREHOUSE AS’ “No. of available warehouse” FROM PARTS;

SELECT DISTINCT WAREHOUSE AS No. of available warehouse FROM PARTS;

SELECT DISTINCT COLUMN WAREHOUSE AS “No. of available warehouse” FROM PARTS;

Which of the following is the correct report that will display the CLASS from table PARTS.

SELECT CLASS FROM PARTS;

SELECT * CLASS FROM PARTS;

SELECT ‘CLASS’ FROM PARTS;

SELECT CLASS AS CLASS FROM PARTS;

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’

Select one:

a. INSERT INTO STUDENTS VALUES (A0,’CRUZ’);

b. INSERT INTO STUDENTS(STUD_ID,LASTNAME)

VALUES(10,’CRUZ’);

c. INSERT INTO STUDENTS VALUES (STUD_ID,LASTNAME)

(10,’CRUZ’);

d. INSERT INTO STUDENTS (A0,’CRUZ’);

Feedback

Which of the following is the correct example of deleting a student record from STUDENTS table whose COURSE is equal to NULL;

Select one:

a. DELETE FROM STUDENTS

WHERE COURSE = ‘NULL’;

b. DELETE FROM STUDENTS

WHERE COURSE IS NULL;

c. DELETE * FROM STUDENTS

WHERE COURSE IS NULL;

d. DELETE FROM STUDENTS

WHERE COURSE IS  =NULL;

Feedback

Which of the following is the correct example of inserting new values to STUDENTS table where the course is set to NULL;

Select one:

a. INSERT INTO STUDENTS (1,'DELA CRUZ','JUANITO',NULL);

b. INSERT INTO STUDENTS VALUES(1,'DELA CRUZ','JUANITO',NULL);

c. INSERT INTO STUDENTS VALUES(1,'DELA CRUZ','JUANITO','NULL');

d. INSERT INTO STUDENTS (1,'DELA CRUZ','JUANITO','NULL');

Feedback

Which of the following is the correct example of updating the LASTNAME to ‘REYES’ of all students from STUDENTS table whose STUD_ID is equal to 01020564?

Select one:

a. UPDATE TABLE STUDENTS

SET STUD_ID = 01020564;

WHERE LASTNAME = ‘REYES’;

b. UPDATE STUDENTS

SET LASTNAME = ‘REYES’

WHERE STUD_ID = 01020564;

c. UPDATE TABLE STUDENTS

SET LASTNAME = ‘REYES’

WHERE STUD_ID = 01020564;

d. UPDATE STUDENTS

SET STUD_ID = 01020564;

WHERELASTNAME = ‘REYES’;

Feedback

Which of the following is the correct example of deleting all records in STUDENTS table;

Select one:

a. DROP TABLE STUDENTS;

b. DELETE FROM STUDENTS;

c. DELETE * FROM STUDENTS;

d. DELETE TABLE STUDENTS;

Feedback

Which of the following is the correct example of inserting new values to STUDENTS table?

Select one:

a. INSERT INTO STUDENTS VALUES(1,DELA CRUZ,JUANITO,BSIT);

b. INSERT INTO STUDENTS VALUES(1,'DELA CRUZ','JUANITO','BSIT');

c. INSERT INTO STUDENTS (1,'DELA CRUZ','JUANITO','BSIT');

d. INSERT INTO STUDENTSVALUES('1','DELA CRUZ','JUANITO','BSIT');

Feedback

Which of the following is the correct example of updating the COURSE to ‘N/A’ of all students from STUDENTS table whose course IS NULL;

Select one:

a. UPDATE TABLE STUDENTS

SET COURSE = ‘N/A’

WHERE COURSE IS NULL;

b. UPDATE STUDENTS

SET COURSE = ‘N/A’

WHERE COURSE IS NULL;

c. UPDATE STUDENTS

SET COURSE = ‘N/A’

WHERE COURSE = NULL;

d. UPDATE TABLE STUDENTS

SET COURSE = ‘N/A’

WHERE COURSE = NULL;

Feedback

Which of the following is the correct example updating the student LASTNAME TO ‘SANTOS’ and course to ‘BSCS’ whose STUD_ID is equal to 109?

Select one:

a. UPDATE EMPLOYEES

SET LASTNAME = ‘SANTOS’, SET COURSE = ‘BSCS’

WHERE STUD_ID = 109;

b. UPDATE TABLE EMPLOYEES

SET LASTNAME = ‘SANTOS’, SET COURSE = ‘BSCS’

WHERE STUD_ID = 109;

c. UPDATE TABLE EMPLOYEES

SET LASTNAME = ‘SANTOS’, COURSE = ‘BSCS’

WHERE STUD_ID = 109;

d. UPDATE EMPLOYEES

SET LASTNAME = ‘SANTOS’, COURSE = ‘BSCS’

WHERE STUD_ID = 109;

Feedback

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' and the rest of the column is set to NULL.

Select one:

a. INSERT INTO STUDENTS TABLE VALUES (10,'CRUZ','NULL','NULL');

b. INSERT INTO STUDENTS VALUES (10,'CRUZ',NULL,NULL);

c. INSERT INTO STUDENTS (10,'CRUZ',NULL,NULL);

d. INSERT INTO STUDENTS VALUES (10,'CRUZ','NULL','NULL');

Feedback

Which of the following is the correct example updating all student COURSE to ‘BSIT’ from STUDENTS table?

Select one:

a. UPDATE STUDENTS

SET COURSE = ‘BSIT’;

b. UPDATE TABLE STUDENTS

SET COURSE = ‘BSIT’

WHERE COURSE = ‘BSIT’;

c. UPDATE STUDENTS

SET COURSE = ‘BSIT’

WHERE COURSE = ‘BSIT’;

d. UPDATE TABLE STUDENTS

SET COURSE = ‘BSIT’;

Feedbac

SATURDAY, JANUARY 23, 2021

Short Quiz 004 - IT6202 - Database Management System 1

Suppose that a user wanted to insert a new value using the explicit method which of the following is the correct example.

Select one:

a. INSERT INTO STUDENTS VALUES (USN_ID, FIRSTNAME)
(10,’ELENA’)

b. INSERT INTO STUDENTS VALUES (10,’ELENA’)

c. INSERT INTO STUDENST(USN_ID, FIRSTNAME)
VALUES(10,’ELENA’)

d. INSERT INTO STUDENTS VALUES (10, NULL,’ELENA’,NULL);

Feedback

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.

Select one:

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

b. UPDATE STUDENTS
SET LASTNAME = ‘SANTOS’, SET YR_LVL = ‘IRREG’;

c. UPDATE STUDENTS
SET LASTNAME = ‘SANTOS’, YR_LVL = ‘IRREG’;

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

Feedback

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

Select one:

a. Select

b. Transaction

c. DDL

d. DML

Feedback

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

 

DELETE from STUDENT;

Select one:

a. 0 rows are deleted.

b. 0 rows are updated.

c. All rows are deleted including table structure.

d. All rows are deleted but the table is still intact.

Feedback

Suppose that a user wanted to insert a new value using the implicit method which of the following is the correct example.

Select one:

a. INSERT INTO STUDENTS VALUES (10,’ELENA’)

b. INSERT INTO STUDENTS VALUES (10, NULL,’ELENA’,NULL);

c. INSERT INTO STUDENST(USN_ID, FIRSTNAME)
VALUES(10,’ELENA’)

d. INSERT INTO STUDENTS VALUES (USN_ID, FIRSTNAME)
(10,’ELENA’)

Feedback

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

Select one:

a. Explicit

b. included

c. Excluded

d. Implicit

Feedback

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

Select one:

a. Excluded

b. included

c. Implicit

d. Explicit

Feedback

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

Select one:

a. UPDATE

b. DELETE

c. INSERT

d. TRUNCATE

Feedback

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

Select one:

a. INSERT

b. DELETE

c. UPDATE

d. TRUNCATE

Feedback

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

Select one:

a. DELETE

b. INSERT

c. TRUNCATE

d. UPDATE

Which of the following is the correct example of creating a new table STUDENTS? The column STUD_ID is set to primary key.

Select one:

a. CREATE TABLE STUDENTS( STUD_ID NUMBER(3) datatypePRIMARY KEY);

b. CREATE TABLE STUDENTS( STUD_ID NUMBER(3) PRIMARY KEY);

c. CREATE TABLE STUDENTS( STUD_ID NUMBER(3) pk);

d. CREATE STUDENTS( STUD_ID NUMBER(3) PRIMARY KEY);

Feedback

Which of the following is the correct example of removing a column SALARY from EMPLOYEES table?

Select one:

a. ALTER EMPLOYEES

DROP SALARY;

b. ALTER TABLE EMPLOYEES

DROP COLUMN SALARY;

c. ALTER EMPLOYEES

DROP COLUMN SALARY;

d. ALTER TABLE EMPLOYEES

DROP SALARY;

Feedback

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

Select one:

a. TRUNCATE EMPLOYEES;

b. ALTER TABLE TRUNCATE TABLE EMPLOYEES;

c. TRUNCATE TABLE EMPLOYEES;

d. ALTER TABLE TRUNCATE EMPLOYEES;

Feedback

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

Select one:

a. ALTER TABLE EMPLOYEES

MODIFY SET JOB_ID CHAR(10);

b. ALTER EMPLOYEES

MODIFY SET JOB_ID CHAR(10);

c. ALTER TABLE EMPLOYEES

MODIFY JOB_ID CHAR(10);

d. ALTER EMPLOYEES

MODIFY JOB_ID CHAR(10);

Feedback

Which of the following is the correct example of renaming the table EMPLOYEES to WORKERS?

Select one:

a. RENAME TABLE EMPLOYEES TO WORKERS;

b. RENAME EMPLOYEES AS WORKERS;

c. RENAME EMPLOYEES TO WORKERS;

d. ALTER TABLE RENAME EMPLOYEES TO WORKERS;

Feedback

Which of the following is the correct example of removing a column FIRSTNAME from EMPLOYEES table?

Select one:

a. ALTER EMPLOYEES

FROM COLUMN FIRSTNAME;

b. ALTER EMPLOYEES

FROM N FIRSTNAME;

c. ALTER TABLE EMPLOYEES

DROP COLUMN FIRSTNAME;

d. ALTER TABLE EMPLOYEES

DROP FIRSTNAME;

Feedback

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

Select one:

a. DROP EMPLOYEES;

b. ALTER TABLE DROP TABLE EMPLOYEES;

c. ALTER TABLE DROP EMPLOYEES;

d. DROP TABLE EMPLOYEES;

Feedback

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

Select one:

a. ALTER EMPLOYEES

MODIFY LASTNAME VARCHAR(20);

b. ALTER EMPLOYEES

SET LASTNAME  = VARCHAR(20);

c. ALTER TABLE EMPLOYEES

MODIFY LASTNAME VARCHAR(20);

d. ALTER TABLE EMPLOYEES

SETLASTNAME  =VARCHAR(20);

Feedback

Which of the following is the correct example of adding a new column ADDRESS datatypevarchar size 20 to EMPLOYEES table?

Select one:

a. ALTER TABLE EMPLOYEES

ADD COLUMN ADDRESS VARCHAR(20);

b. ALTER TABLE EMPLOYEES

ADD ADDRESS VARCHAR(20);

c. ALTER EMPLOYEES

ADD ADDRESS VARCHAR(20);

d. ALTER TABLE EMPLOYEES

SET ADDRESS VARCHAR(20);

Feedback

Which of the following is the correct example of adding a new column CONTACT_NOdatatypeNUMBER size 11 to EMPLOYEES table?

Select one:

a. ALTER TABLE EMPLOYEES

ADD CONTACT_NO NUMBER;

b. ALTER EMPLOYEES

ADD CONTACT_NO NUMBER(11);

c. ALTER TABLE EMPLOYEES

ADD COLUMN CONTACT_NO NUMBER(11);

d. ALTER TABLE EMPLOYEES

ADD CONTACT_NO NUMBER(11);

Feedbac

Short Quiz 003 - IT6202 - Database Management System 1

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

Select one:

a. ALTER TABLE STUDENTS
SET ADDRESS VARCHAR(20);

b. ALTER STUDENTS
SET ADDRESS VARCHAR(20);

c. ALTER TABLE STUDENTS
MODIFY ADDRESS VARCHAR(20);

d. ALTER STUDENTS
MODIFY ADDRESS VARCHAR(20);

Feedback

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

Select one:

a. ADD

b. MODIFY

c. DROP

d. DELETE

Feedback

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

Select one:

a. MODIFY

b. DELETE

c. DROP

d. ADD

Feedback

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?

Select one:

a. ALTER TABLE STUDENTS
ADD CITY CHAR(10);

b. ALTER TABLE STUDENTS
ADD COLUMN CITY VARCHAR(10);

c. ALTER TABLE STUDENTS
ADD COLUMN CITY CHAR(10);

d. ALTER TABLE STUDENTS
ADD CITY VARCHAR(10);

Feedback

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

Select one:

a. NUMBER

b. VARCHAR

c. CHAR

d. INT

Feedback

Basic unit of storage composed of rows and columns

Select one:

a. Synonym

b. Table

c. View

d. Index

Feedback

It logically represents subsets of data from one or more table.

Select one:

a. View

b. Synonym

c. Table

d. Index

Feedback

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

Select one:

a. Rename

b. Alias

c. Update

d. Name

Feedback

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

Select one:

a. MODIFY

b. DELETE

c. ADD

d. DROP

Feedback

Which of the following is not true about ALTER statement?

Select one:

a. Define a default value for the new column

b. Drop a column

c. Modify an existing column definition

d. Insert new row in a table

Which of the following is not part of transaction control?

Select one:

a. ROLLBACK

b. COMMIT

c. CREATE

d. SAVEPOINT

Feedback

It is a collection of relations or two-dimensional tables controlled by the Oracle server.

Select one:

a. Database management system

b. Relational database

c. Relational server

d. Relational model

Feedback

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

Select one:

a. merge

b. Insert

c. Alter

d. Update

Feedback

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

Select one:

a. Insert

b. Grant

c. Revoke

Feedback

He proposed the relational model for database systems in 1970.

Select one:

a. Dr. E.F Codd

b. DrcL.F Codd

c. Dr. Lee Codd

d. Dr. J.F Codd

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.

Answer: 

This describes the database design at the logical level.

Answer: 

The overall logical structure schema of a database can be expressed graphically by anAnswer.

Feedback

The overall design of the database is called the

Answer: 

Feedback

Are applied to the table and form the logical schema.

Answer: 

Feedback

It is collection of data that contains information relevant to an enterprise.

Answer: 

Feedback

It is an association among several entities.

Answer: 

Feedback

It is a unit of data – is a symbol or a set of symbols which is used to represent something.

Answer: 

Feedback

It is the collection of information stored in the database at a particular moment is called

Answer: 

Feedback

This is a characteristic of database that includes also the protection of the database from unauthorized access confidentiality and unauthorized changes.

Answer: 

Feedback

It is design to manage large bodies of information.

Answer: 

Feedback

Are said to exhibit physical data independence if they do not depend on the physical schema.

Answer: 

Feedback

This describes the database design at the physical level.

Answer: 

Feedback

It is an interpreted data – data supplied with semantics.

Answer: 

Feedback

It is a bundle of actions which are done within a database to bring it from one consistent state to a new consistent state.

Answer: 

Feedba

This is also known as facts that can be recorded and that have implicit meaning.

Answer: 

Feedback

It is the collection of basic objects.

Answer: