Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 MEMBER

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

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

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hands-On Database

Authors: Steve Conger

2nd Edition

0133024415, 978-0133024418

More Books

Students also viewed these Databases questions

Question

=+ Should the MNE belong (why, why not)?

Answered: 1 week ago

Question

Provide examples of KPIs in Human Capital Management.

Answered: 1 week ago

Question

What are OLAP Cubes?

Answered: 1 week ago