Explain the behaviour of sql

Assignment Help Database Management System

Reference no: EM133055169

Question: Using the mi602_employee database that you previously installed in Module 2.2:

Open a new query window, copy and paste the following commands.

Start copy

DROP TABLE IF EXISTS demo_NULL;

CREATE TABLE demo_NULL (

INT_A int DEFAULT NULL,

CHR_B varchar(100) DEFAULT NULL,

CHR_C varchar(100) DEFAULT NULL

) ;

INSERT INTO demo_NULL VALUES

(NULL,'That','Over there'),

(1,'Box of 64 Pixels','64 RGB pixels in a decorative box'),

(2,'Sense of Humor','Especially dry. Imported from England.'),

(NULL,'No','Stay Put'),

(10,'Beauty','Inner beauty. No cosmetic surgery required!'),

(4,'Bar Code','Unused. In original packaging.'),

(0,'This','Right here!');

End Copy

Run the following commands one at a time.

Can you explain the results?

select * from demo_NULL;

select * from demo_NULL ORDER BY INT_A;

select count(*) from demo_NULL;

select count (INT_A) from demo_NULL;

Please save a copy of your answers. Your learning facilitator will review the answers with you in class and explain the behaviour of SQL when null values are encountered.

Reference no: EM133055169

Questions Cloud

Benefits of national identification system : Will the benefits of a national identification system countermand violations of individual privacy invasive surveillance?

Effect on the average queue length : The Petroco Service Station has one pump for regular unleaded gas, which (with an attendant) can service 10 customers per hour.

Prepare a journal entry to correct the prior period error : A $51,000 payment of a note payable had been recorded as interest expense. Prepare a journal entry to correct the prior period error

Future privacy problem concern : Radio frequency identification tags (RFID) are inserted in people, clothing, and many objects humans use. Future versions will engage in two-way communications.

Explain the behaviour of sql : Explain the behaviour of SQL when null values are encountered - Can you explain the results

Estimate the total number of sick days : In the last 12 months, a company of 50 staff has experienced unplanned sick leave rate of 8.5days per employer and has returned 3 replacement staff due to resig

Common network architecture devices : Research the common network architecture devices and create a list of the devices your friend should expect to see in the "parts list" from the company

Real-life examples of team cohesiveness : Teams are essential in any job, and sometimes it may not go the way people in the group want to. According to the textbook, "team cohesiveness is defined as the

Create two versions of query : Create two versions of query one using BETWEEN and the other using comparison operators

User Account

All Pages