Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Databases Illuminated

Authors: Catherine M. Ricardo, Susan D. Urban, Karen C. Davis

4th Edition

1284231585, 978-1284231588

Students also viewed these Databases questions