True or False
Database Management System is a collection of interrelated data and a set of programs to access those data.
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?
Feedback
Feedback
Which of the following is not part of common Comparison operator?
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);
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.
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;
Feedback
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’;
Feedback
True or False:
Database Architecture is the overall design of the database
Feedback
Feedback
Feedback
Feedback
Feedback
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’;
Feedback
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.
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’
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’;
Feedback
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’);
Feedback
True or False
Table is known as the collection of data that contains information relevant to an enterprise.
Feedback
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’;
Given the output below. Which of the following is the correct PL/SQL to be used?
Feedback
Question 2
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Feedback
Question 3
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Feedback
Question 4
Question text
Given the output below. Which of the following is the correct PL/SQL to be used
Feedback
Question 5
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Feedback
Question 6
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Feedback
Question 7
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Feedback
Question 8
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Feedback
Question 9
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Feedback
Question 10
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
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’.
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?
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’.
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)
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’.
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
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.
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.
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.
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Which of the following is not true about writing SQL statements?
Feedback
Supposed that the user uses the ff SELECT statement: what will be the possible output.
SELECT GRADE AS STUDENT MARK FROM GRADE_REPORT;
Feedback
Feedback
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.
Feedback
Feedback
Feedback
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 correct PL/SQL that will display all rows and columns?
Which of the following SELECT statement is the correct PL/SQL that will displayeliminate the duplicate rows for column class and warehouse.
Which of the following SELECT statement is the correct PL/SQL that willcreate a report specifying only the column PRICE, ONHAND and DESCRIPTION?
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.
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.
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?
Which of the following SELECT statement is the correctreport the will merge the column CLASS and PRICE rename the COLUMN as “CLASS PRICE”.
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.
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”.
Which of the following is the correct report that will display the CLASS from table 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’
Feedback
Which of the following is the correct example of deleting a student record from STUDENTS table whose COURSE is equal to NULL;
Feedback
Which of the following is the correct example of inserting new values to STUDENTS table where the course is set to 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?
Feedback
Which of the following is the correct example of deleting all records in STUDENTS table;
Feedback
Which of the following is the correct example of inserting new values to STUDENTS table?
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;
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?
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.
Feedback
Which of the following is the correct example updating all student COURSE to ‘BSIT’ from STUDENTS table?
Feedbac
SATURDAY, JANUARY 23, 2021
Short Quiz 004 - IT6202 - Database Management System 1
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.
Feedback
Feedback
Suppose that a user uses the DELETE statement as shown below: what is/are the possible output.
DELETE from STUDENT;
Feedback
Feedback
Feedback
Feedback
Feedback
A type of DML statement that is use to remove existing rows in a table.
Feedback
Feedback
Which of the following is the correct example of removing a column SALARY from EMPLOYEES table?
Feedback
Feedback
Which of the following is the correct example of modifying the column JOB_ID? Change the datatype size to 10.
Feedback
Feedback
Which of the following is the correct example of removing a column FIRSTNAME from EMPLOYEES table?
Feedback
Feedback
Which of the following is the correct example of modifying the column lastname? Change the datatype size to 20.
Feedback
Which of the following is the correct example of adding a new column ADDRESS datatypevarchar size 20 to EMPLOYEES table?
Feedback
Which of the following is the correct example of adding a new column CONTACT_NOdatatypeNUMBER size 11 to EMPLOYEES table?
Feedbac
Short Quiz 003 - IT6202 - Database Management System 1
Feedback
Feedback
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?
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
The overall logical structure schema of a database can be expressed graphically by an.
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
Feedback
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.