Question

Matching - Match the terms with the best possible definition. 1. DML command that returns search results from a database. 2. DDL command for deleting a table. 3. DDL command for making new tables or databases. 4. DML command for adding a new record to a table. 5. Command that allows you to save a query. 6. DML command for removing a record from a table. 7. DDL command for editing or adding fields in a table. a. SELECT b. ALTER c. CREATE d. DELETE FROM e. INSERT INTO f. DROP g. CREATE VIEW 8. Write the SQL to show only the name field of a table named students. 9. Write the SQL to show all of the fields and records of a table named students. 10. Write the SQL to show all students with a name of john from a table named students.

          Matching - Match the terms with the best possible definition.
1. ____ DML command that returns search results from a database.
2. ____ DDL command for deleting a table.
3. ____ DDL command for making new tables or databases.
4. ____ DML command for adding a new record to a table.
5. ____ Command that allows you to save a query.
6. ____ DML command for removing a record from a table.
7. ____ DDL command for editing or adding fields in a table.
a. SELECT
b. ALTER
c. CREATE
d. DELETE FROM
e. INSERT INTO
f. DROP
g. CREATE VIEW
8. Write the SQL to show only the name field of a table named students.
9. Write the SQL to show all of the fields and records of a table named students.
10. Write the SQL to show all students with a name of john from a table named students.

Matching - Match the terms with the best possible definition.
1. DML command that returns search results from a database.
2. DDL command for deleting a table.
3. DDL command for making new tables or databases.
4. DML command for adding a new record to a table.
5. Command that allows you to save a query.
6. DML command for removing a record from a table.
7. DDL command for editing or adding fields in a table.
a. SELECT
b. ALTER
c. CREATE
d. DELETE FROM
e. INSERT INTO
f. DROP
g. CREATE VIEW
8. Write the SQL to show only the name field of a table named students.
9. Write the SQL to show all of the fields and records of a table named students.
10. Write the SQL to show all students with a name of john from a table named students.

Added by John S.

Question

Please give Ace some feedback