Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 16MC
Which of the following types of constraints can’t 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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
What happens when a constraint is followed? Unique I Primary Key (ii), Default (iii), and Check (iv) Unique I Primary Key (ii), Default (iii), and Check (iv)
Which of the following is not a valid constraint type? ( refer to the tables in the JustLee Books database). a. PRIMARY KEYS b. UNIQUE c. CHECK d. FOREIGN KEY
Question 7
In PDO Prepared Statement, which of the following method allows parameters to be given as input by "reference":
A bindValue
B bindParam
C) bindReference
D) bindVariable
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 commands can you use to rename a constraint? RENAME ALTER CONSTRAINT MOVE NEW NAME None of the above commands can be used.arrow_forwardWhich of the following is not a valid constraint type? a. PRIMARY KEYS b. UNIQUE c. CHECK d. FOREIGN KEYarrow_forwardherpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraintsarrow_forward
- ( Please answer this question immediately I do not have time ) Use the following table to answer the questions below: Table name: Books Column Name Role Data Type Length Constraint bookID Stores the ID of a book Number 5 Primary key bookTitle Stores the title of a book Varchar2 50 - bookISBN Stores the ISBN of a book Number 13 Cannot be null and duplicated publicationDate Store the publication date of a book Date - Cannot be null bookPrice Stores the price of a book Number 2,2 Cannot be null a. Write in SQL a command that creates the table Books according to the above description b. Write in SQL a statement that adds a new column named publisherID of type Char(10). This column should be defined as a foreign key that relates the table Books to the table Publisher c. Write in SQL a command that deletes the books that are published before 20-Aug-2010 d. Write a SQL query that displays the number of books that are published in the year 2018 e. Write in SQL a…arrow_forwardThe command DESC DEPARTMENTS shows the following information: Name A M G V Null? MANAGER D LOCATION ID DEPARTMENT ID NOT NULL NUMBER (4) DEPARTMENT NAME NOT NULL VARCHAR2 (30) NUMBER (6) NUMBER (4) Туре A developer then runs the following command ALTER TABLE ADD CONSTRAINT KEY (DEPARTMENT ID); What is the outcome ? DEPARTMENT PK A primary key for DEPARTMENTS is created. A foreign key for DEPARTMENTS is created. PRIMARY An error occurs because column DEPARTMENT_ID already has the constraint NOT NULL The command DESC does not show information of the primary key of a table, therefore we won't know if the command will or will not fail.arrow_forwardFast answer pleasearrow_forward
- Create a procedure that takes instructor_ID as a parameter. Name it INSTR_SECTIONS. The procedure displays instructor first and last names, and also a list of sections that the instructor is scheduled to teach. Only one instructor per procedure call. You give/pass a procedure instructor_ID as a parameter, the procedure prints INFO related only to that instructor. Hint: You will need a cursor processed inside the procedure.arrow_forwardWhich of the following commands can you use to rename a constraint? ( refer to the tables in the JustLee Books database). a. RENAME b. ALTER CONSTRAINT c. MOVE d. NEW NAME e. None of the above commands can be used.arrow_forwardcalculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100arrow_forward
- Create a stored procedure that will return the number of customers in a given state. The parameter for your stored procedure should accept the state abbreviation ('UT') and return the results of a query that returns the number of customers in that state.arrow_forwardWhich one of the following constraint is used along with the DROP COLUMN clause? O a. DISABLE CONSTRAINTS O b. ENABLE CONSTRAINTS O. CASACDE CONSTRAINTS O d. DROP CONSTRAINTS 1 40 DMarrow_forwardTask 3: The Marketing team wants to collect emails of the users on InstantStay. However, the team needs a SQL statement to execute inside their programming environment. You need to create a statement that they can easily run the EXECUTE command to return a single column table containing the USER_EMAIL addresses. Task: Create a prepared statement for use with the EXECUTE command.arrow_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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY