Question
1. 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
1.
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. Incorrect SELECT statement
b. It retrieves the record of ANNA and MOJICA
c. 0 rows selected / no rows selected
d. It retrieves the record of AGAPITO
2.
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. 0 row/s is updated
b. 1 row/s is updated
c. 2 rows/ is updated
d. Incorrect WHERE condition must be=NULlL
3.
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. 0 rows selected
c. It will retrieve the record of ANNA with new ID of 1030
d. It will retrieve the record of ANNA with new ID of 1003
4.
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. Cannot insert the record because of missing values for ORG and POSITION.
c. The ORG and POSITION of YAMBAO will automatically sets to N/A.
d. The ORG and POSITION of YAMBAO will automatically sets to None.
5.
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 ANNA and MOJICA
b. Incorrect SELECT statement
c. rows selected / no rows selected
d. It retrieves the record of AGAPITO
TABLE 1.0 ORGCHART ORG POSITION ID NAME 10 REYES, ANNA AMATHS PRES 15 AGAPITO, JUN SCSEC CRUZ, JOAN PCS MEMBER 12 DUQUE,ROAN JPCS 21 LASON,MOJICA MEMBERStep by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started