SQL (76-103)

Retrieve all data from the table office {id, locations, name}

• Select *from office;

• Select from office;

• Select name from office;

• Select *form office;

_{sName,sAddress}(Student) is equal to?

• SELECT Sname FROM Students

• SELECT Sname, SAddress FORM Students

• SELECT Sname and SAddress FROM Students

• SELECT Sname, SAddress FROM Student

Define an union

• combines the result set of two or more select statements

• returns all rows from the left table (1. ) and from the right table (2)

• returns all rows from the right table (2), with the matching rows in the right table (1. )

• returns all rows from the left table (1. ), with the matching rows in the right table (2)

Find the SQL statement that is equal to: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

• SELECT NAME IN CUSTOMER WHERE STATE IN 'VA';

• SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

• SELECT NAME FROM CUSTOMER WHERE STATE IN 'VA';

• SELECT NAME IN CUSTOMER WHERE STATE = 'V';

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Students table?

• Update persons set lastname = 'hansen' into lastname = 'nilsen'

• Update students set lastname = 'hansen' into lastname = 'nilsen'

• Update persons set lastname = 'hansen' where lastname = 'nilsen'

• Update students set lastname = 'nilsen' where lastname = 'hansen'

how to Add a new column into existing table?

• ALTER TABLE Student MODIFY COLUMN sDegree CHAR(64) NOT NULL

• ALTER TABLE Student ADD COLUMN sDegree VARCHAR(64) NOT NULL

• ALTER TABLE S ADD COLUMN s VACHAR(64) NOT NULL

• ALTER TABLE Student DROP COLUMN sDegree VARCHAR(64) NOT NULL

how to change the row(s) in a table

• insert

• update

• change

• delete

how to remove the row(s) from a table

• insert

• update

• change

• delete

how to rename a column in existing table?

• ALTER TABLE Student MODIFY COLUMN sDegree CHAR(64) NOT NULL

• ALTER TABLE Student CHANGE COLUMN sDegree Degree VARCHAR(64) NOT NULL

• ALTER TABLE Student RENAME COLUMN s to SS VACHAR(64) NOT NULL

• ALTER TABLE Student DROP COLUMN sDegree VARCHAR(64) NOT NULL

In E\R diagrams, we will represent Attributes as

• Boxes with rounded corners

• Links between two entities

• Ovals

• Diamond box