SQL LANGUAGEPLEASE JUST ANSWER WITHOUT EXPLANATION DDL, DML and SELECT Statements7. Create the BOOKS table:Column NameData TypeSizeConstraintsBookIDNumber5PRIMARY KEYCategoryVarchar230NOT NULLTitleVarchar230NOT NULLPriceNumber5, 2Add the new column Author in BOOKS table, string value up to 30 characters.Add constraint for PRICE column, it must be more than 10 only.

7. Create the BOOKS table: Column Name Data Type Size Constraints BookID Number 5 PRIMARY KEY NOT NULL NOT NULL Varchar2 Category Title 30 Varchar2 30 Price Number 5, 2 Add the new column Author in BOOKS table, string value up to 30 characters. Add constraint for PRICE column, it must be more than 10 only.

7. Create the BOOKS table: Column Name Data Type Size Constraints BookID Number 5 PRIMARY KEY NOT NULL NOT NULL Varchar2 Category Title 30 Varchar2 30 Price Number 5, 2 Add the new column Author in BOOKS table, string value up to 30 characters. Add constraint for PRICE column, it must be more than 10 only.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 1MC: Which of the following is a correct statement? You can restore the data deleted with the DROP COLUMN...

See similar textbooks

Similar questions

A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.
Create a view named CONDO_FEES. It consists of two columns: the first is the square footage, and the second is the average fee for all condos in the CONDO_UNIT table thathave that square footage. Use AVERAGE_FEE as the column name for the average fee.Group and order the rows by square footage. a. Write and execute the CREATE VIEW command to create the CONDO_FEES view. b. Write and execute the command to retrieve the square footage and average fee foreach square footage for which the average fee is greater than 500. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what arethey? If not, why not?
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.
Perform the following tasks: a. Create an index named ITEM_INDEX1 on the ITEM_NUM column in the ORDER_LINEtable. b. Create an index named ITEM_INDEX2 on the CATEGORY column in the ITEMtable. c. Create an index named ITEM_INDEX3 on the CATEGORY and STOREHOUSE columnsin the ITEM table. d. Create an index named ITEM_INDEX4 on the CATEGORY and STOREHOUSEcolumns in the ITEM table. List categories in descending order.
How many NOT NULL constraints can be created at the table level by using the CREATE TABLE command? 0 1 12 30 255
Which of the following types of constraints cant be created at the table level? a. NOT NULL b. PRIMARY KEY c. CHECK d. FOREIGN KEY e. None of the above constraints can be created at the table level.
In the initial creation of a table, if a UNIQUE constraint is included for a composite column that requires the combination of entries in the specified columns to be unique, which of the following statements is correct? a. The constraint can be created only with the ALTER TABLE command. b. The constraint can be created only with the table-level approach. c. The constraint can be created only with the column-level approach. d. The constraint can be created only with the ALTER TABLE MODIFY command.