Simple SQL

Which SQL statement is used to create a table?

• FORM TABLE
• GENERATE TABLE
• CREATE TABLE
• PRODUCE TABLE

With SQL, how do you select all the columns from a table named "Persons"?

• SELECT Persons
• SELECT * FROM Persons
• SELECT ALL FROM Persons
• None of the above

Which SQL statement is used to insert new data in a database?

• ADD NEW.....INTO

• ADD INTO.....VALUES

• INSERT VALUES ....INTO

• INSERT INTO ....VALUES

Which SQL keyword is used to sort the result-set?

• ORDER BY
• SORT BY
• DESC BY
• ACS BY

With SQL, how do you select column Name from table "Persons" where the name starts with an "a"?

• SELECT Name FROM Persons WHERE Name = 'a'
• SELECT * FROM Persons WHERE Name LIKE '%a'
• SELECT Name FROM Persons WHERE Name LIKE 'a%'
• SELECT * FROM Persons WHERE Name LIKE '%a%'

When I want to delete a table, I should use:

• DELETE TABLE

• REMOVE TABLE

• DROP TABLE

• IGNORE TABLE

Suppose you want to multiply two columns, i.e. quantity purchase with unit price to get the new column value from table Order. Select the correct command.

• SELECT (Qty MULTIPLY UnitPrice) FROM Order;

• SELECT (Qty * UnitPrice) FROM Table Order;

• SELECT (Qty * UnitPrice) AS 'Total Value' FROM Order;

• SELECT (Qty * UnitPrice) = 'Total Value' FROM Table Order;

Choose the correct command to add primary key in table Product.

• ALTER TABLE PRODUCT ADD PRIMARY KEY (P_CODE)

• ALTER TABLE PRODUCT

  ADD CONSTRAINT PK_Product PRIMARY KEY (P_CODE)

• ALTER PRODUCT ADD PRIMARY KEY (P_CODE)

• ALTER PRODUCT MODIFY ADD PRIMARY KEY (P_CODE)

When modification of table content is involved, the following commands must be included:

• UPDATE

• SET

• WHERE

• ALTER

To store characters, when the number of characters are fixed, _(1)_____ is used; otherwise, _(2)________ is used.

• (1) CHAR; (2) VARCHAR

• (1) VARCHAR, (2) CHAR

• (1) VARCHAR (2) VARCHAR

• (1) CHAR; (2) STRING