CRUD

  1. The acronym CRUD is commonly used to describe the 4 primary actions that can be performed on a table using SQL.  Enter the term that “C” stands for:
    1. Create
  2. The acronym CRUD is commonly used to describe the 4 primary actions that can be performed on a table using SQL.  Enter the term that “R” stands for:
    1. Read
  3. The acronym CRUD is commonly used to describe the 4 primary actions that can be performed on a table using SQL.  Enter the term that “U” stands for:
    1. Update
  4. The acronym CRUD is commonly used to describe the 4 primary actions that can be performed on a table using SQL.  Enter the term that “D” stands for:
    1. Delete
  5. Enter “True” or “False” to describe this statement:  When writing a SQL statement, extra whitespace is ignored.
    1. True
  6. Enter “True” or “False” to describe this statement:  When writing a SQL statement, capitalization is ignored:
    1. True
  7. Enter “True” or “False” to describe this statement:  When writing a SQL statement, spelling is ignored.
    1. False
  8. Enter “True” or “False” to describe this statement:  When writing a SQL statement, commented-out lines affect the results.
    1. False
  9. Write a SQL query that returns all columns from a table called “Employee”:
    1. SELECT * FROM Employee
  10. Write a SQL query that returns columns called “LastName” and “FirstName” from a table called “Employee”:
    1. SELECT LastName, FirstName FROM Employee
  11. Write a SQL statement that inserts the values “Jordan”, “Michael”, and “February 17, 1963” into the columns “LastName”, “FirstName”, and “DateOfBirth” in a table called “Employee”:
    1. INSERT INTO Employee (LastName, FirstName, DateOfBirth) VALUES (‘Jordan’, ‘Michael’, ‘1963-02-17’)

Instructions: 

  1. Click the play button to watch the video lesson.
  2. Watch the lesson as many times as needed.
  3. Code along with the instructor using the integrated code editor in the center of your screen.
  4. You can use the Run button beneath the code editor to test your code.
  5. Output from the code that you have written will appear in the panel on the right side of your screen.

If you get stuck or need assistance, you can click the button below to connect with a tutor. 

For additional questions or technical support, email support@veroskills.com