[Solved] Which of the following statement is true?

McqMate

Q.	Which of the following statement is true?
A.	DELETE does not free the space containing the table and TRUNCATE free the space containing the table
B.	Both DELETE and TRUNCATE free the space containing the table
C.	Both DELETE and TRUNCATE does not free the space containing the table
D.	DELETE free the space containing the table and TRUNCATE does not free the space containing the table
Answer» A. DELETE does not free the space containing the table and TRUNCATE free the space containing the table

1k

0

Do you find this helpful?

1

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Which of the following statement is true?
View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
Which statement is true regarding external tables?
Which statement is true regarding synonyms?
Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible
Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible
Which of the following is true regarding Null Value?
Which of the following in true regarding Referential Integrity?
Which of the following is true of a network structure?
Which of the following is not true of the traditional approach to information processing