Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
thumb_up100%
Chapter 3, Problem 2RQ
Explanation of Solution
Datatypes supported by Oracle 12c:
- While creating a table in the
database , each and every column of the table will be having its own data type and the user can select the data type according to his or her requirements. - The datatypes supported by Oracle 12c include:
- CHAR
- DATE
- VARCHAR2
- NUMBER
CHAR:
- This data type is used to store the character strings of fixed length.
- The size will be specified in brackets.
- The maximum length of the character will be 255.
- Even blank space is counted as a character.
- For example, create a table named p, which includes a char column (x). The length of each column in 10 bytes.
Create Table p{x Char(10)};
VARCHAR2(n):
- This data type is used to store alphabetical and numeric data length variables.
- It is more flexible than Char data type, with its maximum capacity of 4000 characters.
- Here, n represents the maximum length of the column.
- For example, create a table named p, which includes a char column (x)...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
"Mpho is very excited about the new information system to be built for his spaza shop. In this section, you need to make Mpho understand database concepts and how they will benefit his spaza shop."
Draw sample tables that would be used in Mpho's information system. Provide the following for the sample database:
Table names (Three tables required).
Table fields (at least four fields per table).
Specify the primary keys for each table.
Specify foreign keys wherever applicable.
Populate the tables with at least two records.
Explain the difference between MySQL and Oracle ?
9. Delete the CUSTOMERREP role from the Oracle 12c database.
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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- What transformations of data need to be performed before HSD-DW is loaded with data? List all the transformations, showing the original format of the HSD data and how they appear in the HSD-DW database Write the SQL statements needed to load HSD-DW.arrow_forwardWhat are the differences between Personal, Standard, and Enterprise editions of Oracle 11g? Please be as detailed as possible. Thank you in advance!arrow_forwardGiven the following database table data: Customer Table CustomerID (text datatype and key field) CustomerName Order Table OrderlD (text datatype and key field) OrderDate (date datatype) TotalOrderValue (currency datatype - $ value for this order) CustomerlD (text datatype and foreign key from the Customer table - customer assigned to this order) Which of the following would be required in order to create a single query that counts the number of orders for each customer and lists the CustomerName in the results. Select all that are correct: O A query that includes only the Customer table O A query that includes the Customer and Order tables O A query that includes only the Order table O A query that includes the Customer name attribute from the Customer tablearrow_forward
- Part One: What are the significant differences between using the NoSQL and the traditional SQL databases? What are the theoretical differences? What are the technical differences? What are the differences in database usage restrictions? How are the database architectures different? How does NoSQL operate related to the following? Part Two: What are NoSQL system requirements, running queries, and insertion time speed? What are the benefits of using NoSQL? Are there any drawbacks to consider?arrow_forwardWrite Oracle SQL code to implement role-based access control for Jdoe: "Jdoe is a manager. His role as a manager requires him to be able to view, update, insert, and delete records in Customer and Account_Payable tables."arrow_forwardWhat exactly is metadata? What is metadata for a result set? When is metadata from a result set useful?arrow_forward
- State the difference between MySQL and Oracle ?arrow_forward2. Implement your database schema named “college” on Microsoft SQL Server Management Studio.Include the SQL statements you used in your submission.arrow_forwardScenario: The owner of Al Musana Hotel would like to have a database tables that will help him manage the clients and rooms in his building. He wants to record the information about his clients and its occupancy. The hotel has three different room types which are available for daily rent only. As the Database Designer, perform the following tasks to help the owner of the hotel: Create the CLIENTS table using the specification below: Table Name: CLIENTS Field Name/ Data Type column name Size Constraints CID Number 8 PRIMARY KEY CName Varchar2 25 NOT NULL Validate to accept Male or Female only Gender Varchar2 10 Address Varchar2 25 Contact Number 15 Стуре Varchar2 15arrow_forward
- a) Create the proper database using sql queries that stores students information (ID,Name) with thier marks (Testl, Test2, Assignment1, Assignment2) then calculate and store the total mark and the final grade (A, B, C, D or F) within the same database. b) Add to the created database in (a), 10 records and then delete the record with the lowest total mark after viewing all the record (only ID and final grade).arrow_forwardI'm putting the finishing touches on a Transaction Processing System in Android Studio (TPS). When I use the DB browser for SQLite, I am able to examine my data; however, I am unable to observe the activity associated with my list views.arrow_forwardWhat is the difference between SQL performance tuning and database performance tuning?What are the three phases the DBMS processes a query in? What do you do in each phase?Why is an index on every column of a table inappropriate?Where do database statistics come from?Explain what RAID stands for, and describe the levels.What is the difference between a rule-based optimizer and a cost-based optimizer?What are optimizer hints? Give an example of their use.What factors should you take into consideration when creating and using an index?What does the database do differently between optimizing DDL vs DML statements?List and describe 5 things that could cause a delay in query processing.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr