Oracle 12c: SQL 3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Joan Casteel
1 Overview Of Database Concepts 2 Basic Sql Select Statements 3 Table Creation And Management 4 Constraints 5 Data Manipulation And Transaction Control 6 Additional Database Objects 7 User Creation And Management 8 Restricting Rows And Sorting Data 9 Joining Data From Multiple Tables 10 Selected Single-row Functions 11 Group Functions 12 Subqueries And Merge Statements 13 Views Chapter3: Table Creation And Management
Chapter Questions Section: Chapter Questions
Problem 1RQ: Which command is used to create a table based on data already contained in an existing table?
Problem 2RQ Problem 3RQ: What guidelines should you follow when naming tables and columns in Oracle 12c? Problem 4RQ: What is the difference between dropping a column and setting a column as unused?
Problem 5RQ Problem 6RQ: What happens to the existing rows of a table if the DEFAULT value of a column is changed?
Problem 7RQ: Explain the difference between truncating a table and deleting a table.
Problem 8RQ Problem 9RQ: What happens if you try to decrease the scale or precision of a NUMBER column to a value less than... Problem 10RQ: Are a table and the data contained in the table erased from the system permanently if a DROP TABLE... Problem 1MC: Which of the following is a correct statement?
You can restore the data deleted with the DROP COLUMN... Problem 2MC Problem 3MC: Which of the following is not a correct statement?
A table can be modified only if it doesn’t... Problem 4MC: Which of the following is not a valid SQL statement?
CREATE TABLE anothernewtable (newtableid... Problem 5MC: Which of the following is true? a. If you truncate a table, you cant add new data to the table. b.... Problem 6MC: Which of the following commands creates a new table containing a virtual column? a. CREATE TABLE... Problem 7MC: Which of the following commands drops any columns marked as unused from the SECUSTOMERORDERS... Problem 8MC: Which of the following statements is correct?
A table can contain a maximum of only one column... Problem 9MC: Which of the following commands removes all data from a table but leaves the tables structure... Problem 10MC: Which of the following commands changes a table’s name from OLDNAME to NEWNAME?
RENAME oldname TO... Problem 11MC Problem 12MC: Which of the following is not a valid statement?
You can change the name of a table only if it... Problem 13MC: Which of the following characters can be used in a table name? a. b. ( c. % d. ! Problem 14MC: Which of the following is true?
All data in a table can be recovered if the table is dropped with... Problem 15MC Problem 16MC: Which of the following commands creates a new table containing two columns?
CREATE TABLE newname... Problem 17MC: Which of the following is a valid table name? a. 9NEWTABLE b. DATE9 c. NEWTABLE d. None of the above... Problem 18MC Problem 19MC: Which object in the data dictionary enables you to verify DEFAULT column... Problem 20MC Problem 1HOA: Create a new table containing the category code and description for the categories of books sold by... Problem 2HOA: Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The... Problem 3HOA: Add two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment... Problem 4HOA: Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two... Problem 5HOA Problem 6HOA: Rename the EMPLOYEES table as JL_EMPS.
Problem 7HOA: Create a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail,... Problem 8HOA Problem 9HOA: Truncate the BOOK_PRICING table, and then verify that the table still exists but no longer contains... Problem 10HOA: Delete the BOOK_PRICING table permanently so that it isnt moved to the recycle bin. Delete the... Problem 6RQ: What happens to the existing rows of a table if the DEFAULT value of a column is changed?
Related questions
i) In each iteration, the DBSCAN algorithm starts a new cluster from an unlabeled border point. T OR F
Answer:
Process or set of rules that allow for the solving of specific, well-defined computational problems through a specific series of commands. This topic is fundamental in computer science, especially with regard to artificial intelligence, databases, graphics, networking, operating systems, and security.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
