ich 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

ich 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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 14MC: Which of the following is true? All data in a table can be recovered if the table is dropped with...

See similar textbooks

Similar questions

Which of the following statements is correct? A table can contain a maximum of only one column marked as unused. You can delete a table by removing all columns in the table. Using the SET UNUSED clause allows you to free up storage space used by a column. None of the above statements are correct.
Which of the following symbols is used in a SELECT clause to display all columns from a table? / & * "
Which of the following is true? All data in a table can be recovered if the table is dropped with the PURGE option. All data in a table can be recovered from the recycle bin if the table is dropped. All data in a table is lost if the table is dropped. All of the above statements are true.
Which clause is required in a SELECT statement? WHERE ORDER BY GROUP BY FROM all of the above
Which clause is not required in a SELECT statement? SELECT FROM WHERE All of the above clauses are required.
Which of the following is not a valid SQL statement? CREATE TABLE anothernewtable (newtableid VARCHAR2 (2)); CREATE TABLE anothernewtable (date, anotherdate) AS (SELECT orderdate, shipdate FROM orders); CREATE TABLE anothernewtable (firstdate, seconddate) AS (SELECT orderdate, shipdate FROM orders); All of the above are valid statements.
Which of the following is a correct statement? You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. You can’t create empty tables—all tables must contain at least three rows of data. A table can contain a maximum of 1000 columns. The maximum length of a table name is 265 characters.
The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields contain text. Write a SQL SELECT statement that arranges the records in descending order by the Cost field. Write a SQL SELECT statement that selects only the Name and Cost fields from records having a code of PG10. Write a SQL SELECT statement that selects only the Name and Cost fields from records having a cost of $3 or more. Write a SQL SELECT statement that selects the Visual Basic record. Write a SQL SELECT statement that selects only the Name field from records whose magazine name begins with the letter C. Write a SQL SELECT statement that selects only the Name field from records whose magazine name contains two characters. Write a SQL SELECT statement that selects only the Name and Cost fields from records whose cost is from $4 to $6, inclusive. Write a SQL SELECT statement that selects only records for the Code provided by the user. Write a SQL SELECT statement that selects only…
The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields contain text. Write a SQL SELECT statement that arranges the records in descending order by the Cost field. Write a SQL SELECT statement that selects only the Name and Cost fields from records having a code of PG10. Write a SQL SELECT statement that selects only the Name and Cost fields from records having a cost of $3 or more. Write a SQL SELECT statement that selects the Visual Basic record. Write a SQL SELECT statement that selects only the Name field from records whose magazine name begins with the letter C. Write a SQL SELECT statement that selects only the Name field from records whose magazine name contains two characters. Write a SQL SELECT statement that selects only the Name and Cost fields from records whose cost is from $4 to $6, inclusive. Write a SQL SELECT statement that selects only records for the Code provided by the user. Write a SQL SELECT statement that selects only…
Which of the following characters can be used in a table name?a. –b. (c. %d. !
Which of the following is not a valid INSERT statement? a. INSERT INTO table_name VALUES (val1, val2); b. INSERT INTO table_name (column1, column2) VALUES (val1, val2); c. INSERT INTO table_name1 SELECT col1, col2 FROM table_name2; d. INSERT INTO table_name1 VALUES (SELECT col1, col2 FROM table_name2); e. All of the above f. None of the above
The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields contain text. Write a SQL SELECT statement that selects the Visual Basic record. Write a SQL SELECT statement that selects only the Name field from records whose magazine name begins with the letter C. Write a SQL SELECT statement that selects only the Name field from records whose magazine name contains two characters.