Question: 1.how many records does the following query produce: SELECT * FROM customers CROSS JOIN orders; a.7 b.15 c.0 d.12 2.Which of the following statements will

1.how many records does the following query produce:

SELECT * FROM customers CROSS JOIN orders;

a.7

b.15

c.0

d.12

2.Which of the following statements will display all workers who has a salary in the WORKERS table?

a.SELECT * FROM workers WHERE salary != NULL;

b.SELECT * FROM workers WHERE salary = NULL;

c.SELECT * FROM workers WHERE salary IS NOT NULL;

d.SELECT * FROM workers WHERE salary IS NULL;

3.Which of the following will be the output after executing this statement:

SELECT ROUND(728.166, 2) FROM dual;

a.728.16

b.728

c.728.20

d.728.17

4.Which of the following will be the output after executing this statement:

SELECT SUBSTR(Educational, 4, 4) FROM dual;

a.educ

b.onal

c.cati

d.atio

5.In SQL, which command is used to change a tables storage characteristics like changing column data type or size?

a.MODIFY TABLE

b.CREATE TABLE

c.ALTER TABLE

d.CHANGE TABLE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!