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 19MC
Which of the following types of restrictions can be viewed with the DESCRIBE command?
- a. NOT NULL
- b. FOREIGN KEY
- c. UNIQUE
- d. CHECK
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Which of the following types of restrictions can be viewed with the DESCRIBE command? ( refer to the tables in the JustLee Books database).
a. NOT NULL
b. FOREIGN KEY
c. UNIQUE
d. CHECK
Which one of the following statements is false?
The Restrict Policy: reject modifications
The Cascade Policy: automatically apply modifications to foreign key
The Set Null Policy: set null in place the modified values
None of the above
Which of the following are the features of a primary key?
a.
Unique value
b.
Not null
c.
All
d.
Not repeated
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 is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.arrow_forwardWhich of the following commands can be used to eliminate the RECEPTIONIST role? (refer to the JustLee Books database).a. DELETE ROLE receptionist;b. DROP receptionist;c. DROP ANY ROLE;d. none of the abovearrow_forwardWhich syntax is correct for removing a public synonym?a. DROP SYNONYM synonymname;b. DELETE PUBLIC SYNONYM synonymname;c. DROP PUBLIC SYNONYM synonymname;d. DELETE SYNONYM synonymname;arrow_forward
- Which of the following commands creates a private synonym?a. CREATE PRIVATE SYNONYMb. CREATE NONPUBLIC SYNONYMc. CREATE SYNONYMd. CREATE PUBLIC SYNONYMarrow_forwardWrite and execute the command to retrieve the item ID, description, invoice number, and quoted price for all invoices in the ITEM_INVOICE VIEW for items with a quoted prices that exceed $100. I have been trying this solution and it is incorrect: SELECT i.item_id, i.description, l.invoice_num, l.quoted_priceFROM item iINNER JOIN invoice_line l ON i.item_id = l.item_idWHERE i.item_id IN ( SELECT item_id FROM item_invoice WHERE quoted_price > 100);arrow_forwardWhich are the types of Triggers?arrow_forward
- what command shows the status of the previous command a @ b $ c \$? d Isarrow_forward(a) Which command makes updates permanent?(b) Which command reverses updates? (c) Which updates are reversed?arrow_forwardYou issue the following command: INSERT INTO homework10 (col1, col2, col3) VALUES (‘A’, NULL, ‘C’). The command will fail if which of the following statements is true?a. Col1 has a PRIMARY KEY constraint enabled.b. Col2 has a UNIQUE constraint enabled.c. Col3 is defined as a DATE column.d. None of the above would cause the command to fail.arrow_forward
- Which of the following commands is used to assign a privilege to a role?(refer to the JustLee Books database).a. CREATE ROLEb. CREATE PRIVILEGEc. GRANTd. ALTER PRIVILEGEarrow_forwardWhich of the following statements DOES NOT delete the last value in the list lst? a) 1st.pop( b) 1st.remove(-1) c) 1st = lst[:-1] d) 1st.pop(len(lst)-1)arrow_forward3. What is the difference between DROP and TRUNCATE commands?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY