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.

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:

Feedback

Which of the following is not part of handling data?
Select one:

Feedback

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

Select one:

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:

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;

Select one:

Feedback

Which of the following is not part of characteristics of database?
Select one:

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:

Feedback

True or False:

Database Architecture is the overall design of the database

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:

Feedback

Which of the following is not the correct example of entity?
Select one:

Feedback

Which of the following is not part of DDL statement?
Select one:

Feedback

Which of the following is not part of DML statement?
Select one:

Feedback

Which of the following is not part of disadvantage of database?
Select one:

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:

Feedback

Which of the following is not part of basic SELECT statement
Select one:

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’

Select one:

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:

Feedback

Which of the following is not part of other Comparison Operator?
Select one:

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:

Feedback

True or False

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

Feedback

Which of the following is not part of advantage of database?
Select one:

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:

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

Select one:

Feedback

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:

Feedback

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:

Feedback

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:

Feedback

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:

Feedback

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:

Feedback

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:

Feedback

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:

Feedback

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:

Feedback

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:

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.

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

Feedback

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

Feedback

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

Feedback

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

Feedback

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

Feedback

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

Feedback

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

Feedback

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

Feedback

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

Feedback

This is used to in conditions that compare one expression with another value or expression.
Select one:
This haracter is used to override the default precedence or to clarify the statement.
Select one:

Feedback

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

Select one:

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:

Feedback

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

Feedback

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

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:

Feedback

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

Feedback

A system used to concatenate one column to another column.
Select one:

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:

Feedback

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

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’

Select one:

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:

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:

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:

Feedback

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

Select one:

Feedback

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

Select one:

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:

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:

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:

Feedback

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

Select one:

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:

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:

Feedback

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

Feedback

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

 

DELETE from STUDENT;
Select one:

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:

Feedback

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

Feedback

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

Feedback

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

Feedback

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

Select one:

Feedback

A type of DML statement that is use to add new rows in a table.
Select one:
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:

Feedback

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

Select one:

Feedback

Which of the following is the correct example of truncating the table EMPLOYEES?
Select one:

Feedback

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

Select one:

Feedback

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

Feedback

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

Select one:

Feedback

Which of the following is the correct example of dropping the table EMPLOYEES?
Select one:

Feedback

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

Select one:

Feedback

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

Select one:

Feedback

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

Select one:

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:

Feedback

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

Feedback

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

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:

Feedback

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

Feedback

Basic unit of storage composed of rows and columns
Select one:

Feedback

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

Feedback

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

Feedback

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

Feedback

Which of the following is not true about ALTER statement?
Select one:
Which of the following is not part of transaction control?
Select one:

Feedback

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

Feedback

Which of the following is not part of data manipulation language?
Select one:

Feedback

Which of the following is not part of data control language?
Select one:

Feedback

He proposed the relational model for database systems in 1970.
Select one:
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.
This describes the database design at the logical level.

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

Feedback

The overall design of the database is called the

Feedback

Are applied to the table and form the logical schema.

Feedback

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

Feedback

It is an association among several entities.

Feedback

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

Feedback

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

Feedback

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

Feedback

It is design to manage large bodies of information.

Feedback

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

Feedback

This describes the database design at the physical level.

Feedback

It is an interpreted data – data supplied with semantics.

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.

Feedba

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

Feedback

It is the collection of basic objects.