Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 4, Problem 12MC
Which type of constraint should you use on a column to allow entering only values above 100?
- a. PRIMARY KEY
- b. UNIQUE
- c. CHECK
- d. NOT NULL
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You have been instructed to add a new student information to the students table. Because the student is new, he has no
marks before, you should not add an amount to the CGPA.
The Students table contains these columns:
Student_id NUMBER(10)
Student_name VARCHAR2(30)
Student phone NUMBER(10)
CGPA NUMBER(2,2)
Which INSERT statements will accomplish your objective?
O a. INSERT INTO students VALUES (365, 'Khalil',99554721, 0 )
O b. INSERT INTO students VALUES (365, 'Khalil',99554721, 'NO CGPA' )
O c. INSERT INTO students VALUES (365, 'Khalil',99554721, NULL )
O d. INSERT INTO students VALUES (365, 'Khalil',99554721)
Which line of code has an error?
1. CREATE TABLE FRUITS VEGETABLES
2. FRUIT TYPE VARCHAR2,
3. FRUIT NAME CHAR (20),
4. QUANTITY NUMBER (4));
O a. 1
O b. 2
O c. 3
Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100. The results should be sorted bythe Num_Shares column in ascending order.
Which operator should you employ in order to locate NULL values?
Chapter 4 Solutions
Oracle 12c: SQL
Ch. 4 - What is the difference between a PRIMARY KEY...Ch. 4 - How can you verify the constraints that exist for...Ch. 4 - A table can have a maximum of how many PRIMARY KEY...Ch. 4 - Which type of constraint can be used to make...Ch. 4 - Which type of constraint should you use to ensure...Ch. 4 - How is adding a NOT NULL constraint to an existing...Ch. 4 - When must you define constraints at the table...Ch. 4 - Prob. 8RQCh. 4 - What is the difference between disabling a...Ch. 4 - Prob. 10RQ
Ch. 4 - Prob. 1MCCh. 4 - Which of the following is not a valid constraint...Ch. 4 - Which of the following SQL statements is invalid...Ch. 4 - What is the maximum number of PRIMARY KEY...Ch. 4 - Prob. 5MCCh. 4 - How many NOT NULL constraints can be created at...Ch. 4 - The FOREIGN KEY constraint should be added to...Ch. 4 - What is the maximum number of columns you can...Ch. 4 - Which of the following commands can you use to...Ch. 4 - Prob. 10MCCh. 4 - In the initial creation of a table, if a UNIQUE...Ch. 4 - Which type of constraint should you use on a...Ch. 4 - Which of the following commands can be used to...Ch. 4 - Which of the following keywords allows the user to...Ch. 4 - Which of the following data dictionary objects...Ch. 4 - Which of the following types of constraints cant...Ch. 4 - Suppose you created a PRIMARY KEY constraint at...Ch. 4 - You’re creating a new table consisting of three...Ch. 4 - Which of the following types of restrictions can...Ch. 4 - Which of the following is the valid syntax for...Ch. 4 - Prob. 1HOACh. 4 - Prob. 2HOACh. 4 - Prob. 3HOACh. 4 - Add a column named Base_salary with a datatype of...Ch. 4 - Create a table named BOOK_STORES to include the...Ch. 4 - Add a constraint to make sure the Rep_ID value...Ch. 4 - Change the constraint created in Assignment #6 so...Ch. 4 - Create a table named REP_CONTRACTS containing the...Ch. 4 - Produce a list of information about all existing...Ch. 4 - Issue the commands to disable and then enable the...
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
- 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.arrow_forwardWhich of the following is not a valid constraint type? a. PRIMARY KEYS b. UNIQUE c. CHECK d. FOREIGN KEYarrow_forwardWhich object in the data dictionary enables you to verify DEFAULT column settings? DEFAULT_COLUMNS DEF_TAB_COLUMNS USER_TAB_COLUMNS None of the abovearrow_forward
- How many NOT NULL constraints can be created at the table level by using the CREATE TABLE command? 0 1 12 30 255arrow_forwardWhich type of constraint should you use on a column to allow entering only values above 100? ( refer to the tables in the JustLee Books database). a. PRIMARY KEY b. UNIQUE c. CHECK d. NOT NULLarrow_forwardWhich of the following is a type of constraint? Creating a table Naming the columns Declaring a data type Naming the tablearrow_forward
- The INSERT statement needs to specify column names unless _____. -multiple rows are being inserted into the table with a single statement -only one row is being inserted into the table -the values are inserted in the same order as the table's columns -the values that are being inserted are for columns that are primary keysarrow_forwardQUESTION 2 Exercise: Create a statement that will show the sum of all the payments received on or after 2018-08-01. The new column should be titled recent payments_received Hint: If you did this correctly, you will have one column (and one row) showing the following amount 59755.88arrow_forwardWhich symbol in the SELECT clause indicates that all attributes of the selected row are to be retrieved? O You must select at least 1 choice O4 O % O & %23arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License