Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 4, Problem 14MC

Which of the following keywords allows the user to delete a record from a table, even if rows in another table reference the record through a FOREIGN KEY constraint?

  1. a. CASCADE
  2. b. CASCADE ON DELETE
  3. c. DELETE ON CASCADE
  4. d. DROP
  5. e. ON DELETE CASCADE
Blurred answer
Students have asked these similar questions
Which of the following keywords allows the user to delete a record from a table, even if rows in another table reference the record through a FOREIGN KEY constraint? ( refer to the tables in the JustLee Books database).                 a. CASCADE                                                                                                        b. CASCADE ON DELETE                                                                                     c. DELETE ON CASCADE                                                                                      d. DROP                                                                                                              e. ON DELETE CASCADE
CREATE TABLE keyvalue (  id SERIAL,  key VARCHAR(128) UNIQUE,  value VARCHAR(128) UNIQUE,  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),  PRIMARY KEY(id) ); Add a stored procedure so that every time a record is updated, the updated_at variable is automatically set to the current time
Q7:- Choose the correct statement:- Prints the database_information connection = getDbConnection()             test1 =connection.get_server_info()             cursor = connection.cursor()             cursor.execute("select database();")             test2 = cursor.fetchone()             print(test2)             closeDbConnection(connection) Prints the records for the selected database connection = getDbConnection()             test1 = connection.get_server_info()             cursor = connection.cursor()             cursor.execute("select database();")             test2 = cursor.fetchone()             print(test1)             closeDbConnection(connection)   Both None of these

Chapter 4 Solutions

Oracle 12c: SQL

Knowledge Booster
Background pattern image
Computer Science
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
SEE MORE QUESTIONS
Recommended textbooks for you
  • Text book image
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY