Question types

Start with

Question limit

of 50 available terms

Print test

50 Multiple choice questions

  1. • The number and order of the columns must be the same in all queries.
    • The data types must be compatible.
  2. asterisk (*) in the place where the column name(s) would otherwise be given.
  3. ...all of the related tables are deleted using a cascading delete.
  4. - You can identify and delete individual rows from the database using the DELETE syntax,
    - delete all the rows using a truncate table statement, or
    - remove the entire table using the drop table statement.
  6. WHERE NOT department = 'shipping'
  7. The SQL command for retrieving any data from a database
  8. removes the actual data (delete all the rows) from within the table, but it leaves the table structure in place for future use.
  9. Referential integrity
  10. retrieve user-requested information from a database through the use of queries.
  11. SELECT ProductID
    FROM Production.Product
    SELECT ProductID
    FROM Production.WorkOrder;
  12. final result set where data exists in the first query and not in the second dataset (returns any distinct values from the left query that are not also found on the right query)
  13. TRUNCATE TABLE <table_name>
  14. values you would like to insert.
  15. allow you to match related records taken from different source tables.
  16. BEGIN TRAN and a COMMIT or ROLLBACK while performing maintenance tasks, you will catch most accidents before they happen.
  17. SELECT ProductID
    FROM Production.Product
    SELECT ProductID
    FROM Production.WorkOrder;
  18. can include records from one or both tables you are querying that do not have any corresponding record(s) in the other table.
  19. FROM clause.
  20. you may wish to have a table join with itself, say if you want to compare records from within the same table.
  21. SSMS or the INSERT statement.
  22. return all rows from one table along with all rows from the other table. WHERE conditions should always be included.
  23. DELETE FROM <table_name>
    WHERE <conditions>
  24. remove one or more rows in a table or view.
  25. Add a record in the department table with our new supervisor's name and department ID information.
  26. you want a list of all employees who don't work in the shipping department.
  27. • Columns to retrieve
    • Tables to retrieve the columns from
    • Conditions, if any, that the data must satisfy
  28. • Inner joins
    • Outer joins
    • Cross joins
  29. comma.
  30. comma-separated list of the column names in the table you wish to include
  31. DELETE FROM employee
    WHERE department = 'accounting'
  32. SELECT first_name, last_name, salary
    FROM employees
    WHERE salary >= 50,000
  33. change data in a table or view.
  34. SELECT * FROM employees
  35. allows you to combine related data from multiple table sources.
  36. INSERT INTO employee (first_name, last_name, employee_id, department) VALUES ('David', 'Clark', 610008, 'shipping'),
    ('Arnold', 'Davis', 610009, 'accounting')
  37. transactions when updating data.
  38. square brackets or double quotes—for example, [first name] or "first name"
  39. search data in terms of what you don't want in your output.
    DELETE FROM <table_name>
  41. allows you to combine the results of two or more queries into a resulting single set that includes all the rows belonging to the query in that union.
  42. SELECT first_name, last_name
    FROM employees
    WHERE department = 'shipping'
  43. ...this query uses the AND conjunction to yield the names of all employees who are in the shipping department and who are female.
  44. UPDATE employee
    SET department = 4
    WHERE department IS NULL
  45. DROP TABLE <table_name>
    Remove an entire table.
  46. final result set where values in both of the queries match by the query on both the left and right sides of the operand (returns any distinct values found on both the left and right sides of this operand)
  47. allows you to specify the range to be used in a "between x and y" query format.
  48. • Open the SSMS interface.
    • Open the table in which you wish to update data.
    • Locate the row in which you wish to update the records within the Open Table view.
  49. Launch the SSMS application -> connected to the database -> Databases folder -> Tables folder -> Right-click the table name and chose Edit Top 200 Rows -> Enter your data into the last row of the table
  50. you want to give your boss a list of employees whose salary is above $50,000 per year.