Correct Answer: TRUNCATE TABLE Students;
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Transact-SQL (T-SQL) Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Transact-SQL (T-SQL) MCQ Questions
You would like to have a record added to a TableB every time a record is modified in TableA. What technique should you look at implementing?
What is the result of this query? SELECT 123+'123' AS Result;
To combine the results of two or more SELECT statements, removing duplicates, which keyword can you use?
Your database currently has a table called Inventory in the Warehouse schema. You need to move the table to the Products schema. Which query accomplishes this goal?
You need to create a simple database backup in the server's Z:\Backups directory. Which query should you use?
Which of these data types is an approximate numeric?
Which is the best approach to update the last name of the student Donette Figgins to Smith
What is the result of this statement?
Which query shows the first name, department, and team of all students with the two lowest points?
You need to write a query that returns all Employees that have a LastName starting with the letter A. Which WHERE clause should you use to fill in the blank in this query?