70-461 Table Practice Questions

Which SQL statement is used to delete existing records in a table?

• AA. DROP
• BB. TRUNCATE
• CC. REMOVE
• DD. DELETE

What function can be used to count the number of rows in a SQL Server table?

• AA. SUM()
• BB. NUMROWS()
• CC. COUNT()
• DD. TOTAL()

Which of the following is a valid way to create a table in SQL Server?

• AA. NEW TABLE xyz
• BB. TABLE xyz CREATE
• CC. ADD TABLE xyz
• DD. CREATE TABLE xyz

What command is used to modify an existing record in a SQL Server table?

• AA. MODIFY
• BB. UPDATE
• CC. CHANGE
• DD. ALTER