Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 3, Problem 15MC
Program Description Answer
The following command is a valid command among the given ones:
“ALTER TABLE customers DROP UNUSED COLUMNS;”
Hence, correct answer is option “D”.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The following table has been created:
CREATE TABLE student table (
stud id NUMBER (6),
last_name VARCHAR2 (20),
first name VARCHAR2 (20),
lunch num NUMBER (4) ) ;
Which one of the following INSERT statements will fail?
O INSERT INTO student table VALUES (143354, 'Roberts', 'Cameron', 6543);
O INSERT INTO student_table (stud_id, last_name, lunch_num) VALUES (143354, Roberts, 6543, 'Cameron');
O INSERT INTO student_table (stud_id, last_name, first_name, lunch_num) VALUES (143354, 'Roberts', 'Cameron', 6543);
O INSERT INTO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352, 6543, 'Cameron', 'Roberts');
Question Workspace
Which of the following statements is valid?
a. DROP table_name;
b. DELETE TABLE table_name;
c. UPDATE TABLE table_name SET col1 = new_value;
d. ALTER TABLE table_name MODIFY col1 CHAR(10);
e. All of the above.
f. None of the above.
Icon Key
Task 4: Use the EXISTS operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021.
This is incorrect:
Chapter 3 Solutions
Oracle 12c: SQL
Ch. 3 - Which command is used to create a table based on...Ch. 3 - Prob. 2RQCh. 3 - What guidelines should you follow when naming...Ch. 3 - What is the difference between dropping a column...Ch. 3 - Prob. 5RQCh. 3 - What happens to the existing rows of a table if...Ch. 3 - Explain the difference between truncating a table...Ch. 3 - Prob. 8RQCh. 3 - What happens if you try to decrease the scale or...Ch. 3 - Are a table and the data contained in the table...
Ch. 3 - Which of the following is a correct statement?
You...Ch. 3 - Prob. 2MCCh. 3 - Which of the following is not a correct...Ch. 3 - Which of the following is not a valid SQL...Ch. 3 - Which of the following is true? a. If you truncate...Ch. 3 - Which of the following commands creates a new...Ch. 3 - Which of the following commands drops any columns...Ch. 3 - Which of the following statements is correct?
A...Ch. 3 - Which of the following commands removes all data...Ch. 3 - Which of the following commands changes a table’s...Ch. 3 - Prob. 11MCCh. 3 - Which of the following is not a valid...Ch. 3 - Which of the following characters can be used in a...Ch. 3 - Which of the following is true?
All data in a...Ch. 3 - Prob. 15MCCh. 3 - Which of the following commands creates a new...Ch. 3 - Which of the following is a valid table name? a....Ch. 3 - Prob. 18MCCh. 3 - Which object in the data dictionary enables you to...Ch. 3 - Prob. 20MCCh. 3 - Create a new table containing the category code...Ch. 3 - Create a new table containing these four columns:...Ch. 3 - Add two columns to the EMPLOYEES table. One...Ch. 3 - Modify the Job_class column of the EMPLOYEES table...Ch. 3 - Prob. 5HOACh. 3 - Rename the EMPLOYEES table as JL_EMPS.
Ch. 3 - Create a new table containing these four columns...Ch. 3 - Prob. 8HOACh. 3 - Truncate the BOOK_PRICING table, and then verify...Ch. 3 - Delete the BOOK_PRICING table permanently so that...
Knowledge Booster
Similar questions
- How do you indicate that a column alias should be used?arrow_forwardSome rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902 UX 8 Tony 203 - 3902 PX 9 Charles BD 11 Mary 877 - 3333 BD Which of the following queries retrieves the rows where there is no phone? a. SELECT * FROM User WHERE phone IS NULL b. SELECT * FROM User WHERE phone = “ ” c. SELECT * FROM User WHERE phone NOT IS NULL d. SELECT * FROM User WHERE phone > 0arrow_forwardWhich of the following is true? (refer to the tables in the JustLee Books database)a. If you truncate a table, you can’t add new data to the table.b. If you change the default value of an existing column, all existing rows containing a NULL value in the same column are set to the new DEFAULT value.c. If you delete a column from a table, you can’t add a column to the table with the same name as the previously deleted column.d. If you add a column to an existing table, it’s always added as the last column of the table.arrow_forward
- Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns. In addition, you must calculate the order total from the columns in the OrderItems table. Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return two columns: the customer�s email address and the largest order for that customer. To do this, you can group the result set by the EmailAddress column.arrow_forwardThe Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0 THIS IS IN SQL FORMAT FOR CENGAGE MINDTAP, PLEASE HELP I AM STUCKarrow_forwardQ1. Write a SELECT statement that returns these columns from the Invoices table: ⚫ The invoice_total column • A column that uses the ROUND function to return the invoice_total column with 1 decimal digit • A column that uses the ROUND function to return the invoice_total column with no decimal digits invoice_total one_digit 3813.33 zero_digits 3813.3 3813arrow_forward
- Which of the following is a valid SQL statement?a. ALTER TABLE secustomersspent ADD DATE lastorder;b. ALTER TABLE secustomerorders DROP retail;c. CREATE TABLE newtable AS (SELECT * FROM customers);d. ALTER TABLE drop column *;arrow_forwardIn The SQL Oracle Application Using the UNION operator, write a query that displays the employee_id, job_id, and salary of ALL present and past employees. If a salary is not found, then just display a 0 (zero) in its place.arrow_forwardIn SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created because you cannot add a column after the table is created b. Becomes the last column in the table c. Can be placed by adding a GROUP BY clause d. Becomes the first column in the tablearrow_forward
- You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause). (you MAY use 1 or 2 statements) Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their departmentarrow_forwardWhich of the following statements is valid? (refer to the tables in the JustLee Books database.)a. SELECT title FROM booksWHERE retail<(SELECT cost FROM booksWHERE isbn = '9959789321');b. SELECT title FROM booksWHERE retail = (SELECT cost FROM booksWHERE isbn = '9959789321' ORDER BY cost);c. SELECT title FROM booksWHERE category IN (SELECT cost FROM orderitemsWHERE isbn = '9959789321');d. none of the above statementsarrow_forwardWrite a SELECT statement that returns three columns using the explicit join syntax: CompanyName From the Customers Table ShipAddress From the Orders Table CompanyName AS Shipping Company From the Shippers Table Sort the result set by Shipping Companyarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
