Evaluate the SQL statement: TRUNCATE TABLE BOOKS; Which of the following combination of the statements are true about the SQL statement. a. It releases the storage space used by the table b. It does not release the storage space used by the table c. You can roll back the deletion of rows after the statement executes d. You cannot roll back the deletion of rows after the statement executes e. An attempt to use DESCRIBE on the BOOKS table after the TRUNCATE statement executes will display an error f. You must be the owner of the table or have DELETE ANY TABLE system privilege to truncate the BOOKS table

Evaluate the SQL statement: TRUNCATE TABLE BOOKS; Which of the following combination of the statements are true about the SQL statement. a. It releases the storage space used by the table b. It does not release the storage space used by the table c. You can roll back the deletion of rows after the statement executes d. You cannot roll back the deletion of rows after the statement executes e. An attempt to use DESCRIBE on the BOOKS table after the TRUNCATE statement executes will display an error f. You must be the owner of the table or have DELETE ANY TABLE system privilege to truncate the BOOKS table

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

The SQL SELECT statement performs case-sensitive comparisons. a. True b. False
Instructions Write SQL queries to solve the following problems. We will be using the “university” database. All queries should involve only the instructor table. After you are done, save your work as .sql file and turn in the .sql file into Moodle for grading. Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character. Write a SQL statement to display ID and name of the instructors (ID appears first). Write a SQL statement to display department names. Write a SQL statement to display unique department names. (expect 7 rows returned) Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned) Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned) Write a SQL statement to display name, department name, and salary for instructors that have a…
You have the following tables: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) ACCOUNTS (ACCOUNT_NUMBER, MANAGER_ID, CUST_ID, BALANCE) CUSTOMERS (CUST_ID, LAST_NAME, FIRST_NAME) Write a SQL statement that lists account number, balance, MANAGER’s last name, CUSTOMER ID, and CUSTOMER’s last name for every account in the ACCOUNTS table.
Database: CUSTOMER (CustomerID, LastName, FIrstName, Phone, EmailAddress) PURCHASE (InvoiceNumber, InvoiceDate, PreTaxAmount, CustomerID) PURCHASE_ITEM (InvoiceNumber, InvoiceLineNumber, Item Number, RetailPrice) ITEM (ItemNumber, ItemDesciption, Cost, ArtistLastName, ArtistFirstName) Write an SQL statement to show which cutomers bought which items, and include any items that have not been sold. Include CUSTOMER.LastName, CUSTOMER.FirstName, IvoiceNumber, InvoiceDate, ItemNumber, ItemDescription, ArtistLastName, and ArtistFirstName,. Use a join using JOIN ON syntax, and sort the results by ArtistLastName and ArtistFirstName in ascending order. Note that in Microsoft Access this require multiple queries. From Database Concepts 9th Ed. (Kroenke)
What method of Statement is used if you want to execute DELETE SQL statement?
THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS (a) From which two fields in which table can you calculate the enrollment of a section?(b) From which table can you get both course and section numbers?(c) Which field in table SECTION uniquely identifies a section, section id or section no?(d) Write a SQL statement to show sections and their enrollment.(e) Write a SQL statement to show sections with enrollment greater than five. Display both course andsection numbers
Student (sid, name, zip) Takes (sid, cid, year) Course(cid, title, dept) We run the following SQL command: CREATE INDEX newl on Student(zip,name); For each of the following SQL queries indicate whether the index newl will speed it up, or will not affect its performance, or will slow it down. Answer "faster" if the index speeds up the query, "slower" if the index slows down the query, and "the same" if the index does not affect the runtime of the query. Assume that the optimizer is super-smart, and will always chose the absolute best possible plan.
Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
(TCO 4) What will be displayed when the following SQL statement is executed?SELECT * FROM Employee: Group of answer choices All columns in only the first row of the Employee table Only the first column in all rows of the Employee table All rows and columns of the Employee table The number of rows in the Employee table
Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
Sales Database: Customers(custId, lastName, firstName, address, phone, creditLimit) Orders(ordNumber, itemNumber, qtyOrdered.) Items(itemNumber, itemName, price) For the Sales Database referenced above, write the SQL command to create the LineItem table, assuming the Orders table and items table already exist.
Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. (display as -----------) Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. DECLARE CURSOR cursor1 IS SELECT * FROM Students; line cursor1 %type; --------------- BEGIN OPEN cursor1; LOOP SELECT cursor1 inside line; --------------- DBMS_OUTPUT.PUT_LINE('first name= '|| line.fname || 'last name= '||line.lname); EXIT WHEN Cursor %FOUND; ------------------------ END LOOP; CLOSE cursor1; END;