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 1, Problem 17MC
Which of the following represents a field in a table?
- a. a record
- b. a row
- c. a column
- d. an entity
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Which of the following represents a row in a table?a. an attributeb. a characteristicc. a fieldd. a record
which DML keyword is used to make change to existing records in a table?
a) Insert
b) Select
c) Update
d) Delete
Which of the following are constraints that can be used with the create table command?
Select one:
a.
references, alias, check
b.
null, primary key, view of
c.
primary key, not null, unique
d.
primary key, default, between
Chapter 1 Solutions
Oracle 12c: SQL
Ch. 1 - Prob. 1RQCh. 1 - Prob. 2RQCh. 1 - Prob. 3RQCh. 1 - Prob. 4RQCh. 1 - Discuss the problems that can be caused by data...Ch. 1 - Explain the role of a primary key.Ch. 1 - Prob. 7RQCh. 1 - Prob. 8RQCh. 1 - What type of relationship can’t be stored in a...Ch. 1 - Identify at least three reasons an organization...
Ch. 1 - Prob. 1MCCh. 1 - Prob. 2MCCh. 1 - Prob. 3MCCh. 1 - Prob. 4MCCh. 1 - Prob. 5MCCh. 1 - Prob. 6MCCh. 1 - Prob. 7MCCh. 1 - Which of the following has no partial or...Ch. 1 - Prob. 9MCCh. 1 - Which of the following has no partial dependencies...Ch. 1 - Which of the following has no repeating groups but...Ch. 1 - Prob. 12MCCh. 1 - Prob. 13MCCh. 1 - A unique identifier for a data row that consists...Ch. 1 - Which of the following symbols represents an...Ch. 1 - Prob. 16MCCh. 1 - Which of the following represents a field in a...Ch. 1 - Which of the following defines a relationship in...Ch. 1 - When part of the data in a table depends on a...Ch. 1 - Which of the following is used to join data...Ch. 1 - Which tables and fields would you access to...Ch. 1 - Prob. 2HOACh. 1 - Prob. 3HOACh. 1 - Prob. 4HOACh. 1 - Access path A database table is composed of...Ch. 1 - Prob. 6HOACh. 1 - Prob. 7HOACh. 1 - Prob. 8HOACh. 1 - Prob. 9HOACh. 1 - Prob. 10HOA
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 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? a. CASCADE b. CASCADE ON DELETE c. DELETE ON CASCADE d. DROP e. ON DELETE CASCADEarrow_forwardWhich of the following is true? All data in a table can be recovered if the table is dropped with the PURGE option. All data in a table can be recovered from the recycle bin if the table is dropped. All data in a table is lost if the table is dropped. All of the above statements are true.arrow_forwardWhich of the following is not a correct statement? A table can be modified only if it doesn’t contain any rows of data. The maximum number of characters in a table name is 30. You can add more than one column at a time to a table. You can’t recover data contained in a table that has been truncated.arrow_forward
- 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 is not a valid statement? You can change the name of a table only if it doesn’t contain any data. You can change the length of a column that doesn’t contain any data. You can delete a column that doesn’t contain any data. You can add a column to a table.arrow_forwardWhich of the following is not a correct statement?a. A table can be modified only if it doesn’t contain any rows of data.b. The maximum number of characters in a table name is 30.c. You can add more than one column at a time to a table.d. You can’t recover data contained in a table that has been truncated.arrow_forward
- . Which of the following is not a valid statement? (refer to the tables in the JustLee Books database) a. You can change the name of a table only if it doesn’t contain any data.b. You can change the length of a column that doesn’t contain any data.c. You can delete a column that doesn’t contain any data.d. You can add a column to a table.arrow_forwardWhich of the following is populated with a Stores procedures saving the results in the database to make reporting easier select one of the following A. Views B. Temp tables, C. Derived Table or materialized view.arrow_forwardWhich of the following creates a new table in a database and also copies the records into the new table? update query append query delete query make table queryarrow_forward
- Which SQL statement key word can be used to delete a record within a table?a. DELETEb. DROPc. REMOVEd. CLEARarrow_forwardWhich clause is used to change a column in a table? a. SET b. MODIFY c. ALTER d. UPDATEarrow_forwardWhich of the following is true?a. All data in a table can be recovered if the table is dropped with the PURGE option.b. All data in a table can be recovered from the recycle bin if the table is dropped.c. All data in a table is lost if the table is dropped.d. All of the above statements are true.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY