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
Please create a constraint file using the images below. The code that is in one of the images is a Verilog code for the M1 chart. Use the M1 chart and the Verilog code to create a constraint file.
Which of the following types of constraints can’t be created at the table level? ( refer to the tables in the JustLee Books database). a. NOT NULL
b. PRIMARY KEY
c. CHECK
d. FOREIGN KEY
e. None of the above constraints can be created at the table level
Specify the various types of constraints.
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
- 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)arrow_forwardSuppose you have a table with a primary key composed of two columns. When another column in this table is dependent on only one of the two columns in the primary key, this poses a risk for _____. a. update anomalies b. functional dependency c. qualification errors d. function splittingarrow_forward11. Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values? a. A domain constraint b. A range constraint c. An intrarelation constraint d. An interrelation constraintarrow_forward
- 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 KEYarrow_forwardWhich of the following is not a valid constraint type? a. PRIMARY KEYS b. UNIQUE c. CHECK d. FOREIGN KEYarrow_forwardWhich 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_forward
- 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) bindVariablearrow_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_forwardWhat is the Candidate key defined as?arrow_forward
- Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.arrow_forwardCreate 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_forwardAn index is automatically created for a FOREIGN KEY constraint. Select one: a. True b. Falsearrow_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