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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started