The previous administrator created a table named CONTACTS, which contains outdated data. You want to remove the table and its data from the database. Which statement should you issue? which one will it be a. DELETE b. ALTER TABLE c. TRUNCATE TABLE d. DROP TABLE

The previous administrator created a table named CONTACTS, which contains outdated data. You want to remove the table and its data from the database. Which statement should you issue? which one will it be a. DELETE b. ALTER TABLE c. TRUNCATE TABLE d. DROP TABLE

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter7: User Creation And Management

Section: Chapter Questions

Problem 6MC

See similar textbooks

Related questions

Q: You have a table that contains the following fields: MemberLastName, MemberFirstName, Street, City,…

A: Here, we have given a table with a set of records. This table contains 75000 records. The records…

Q: Which of the following can be used to determine whether an index exists?a. DESCRIBE indexname;b. the…

A: An index’s information can be obtained from the views called “USER_INDEXES” and “USER_IND_COLUMNS”.…

Q: Which of the following is an in-memory copy of data pulled from one or more database tables?a. Table…

A: Answer: a. Table adapter

Q: Which statement is true regarding external tables? a. The default REJECT LIMIT for external tables…

A: Explanation:- true stаtement regаrding externаl tаbles is: The СREАTE TАBLE АS SELEСT…

Q: Open MS Access, create a database named “orderManagement” and perform the following tasks: 1. Create…

A: Microsoft Access is a tool to create database within a single file which saves all tables, forms,…

Q: Which of the following is an inmemory copy of data pulled from one or more database tables? 1. Table…

A: Which of the following is an inmemory copy of data pulled from one or more database tables?1. Table…

Q: Which SQL Command is used to delete a table from the database: a) Update b) Alter c) Drop d) Şelect

A: Update Command is used to update the value in a table. Alter command is used to change the value in…

Q: in sql If you have not yet used the COMMIT command to store the changes permanently in the…

A: Answer: a. True

Q: Update you’re the database created in week5: lab5. Write some MYSQL code to select three different…

A: According to the given query:Below is the MySQL query to SELECT the records of the tables…

Q: Which of the following is true? (refer to the tables in the JustLee Books database)a. If you…

A: True statement Here while truncating a table, new data can be added to the table. While changing…

Q: Which of the following is used to join data contained in two or more tables?a. primary keyb. unique…

A: Joining data in two or more tables A common field is a field existing in two or more tables. It…

Q: Which of the following privileges allows a user to truncate tables in a database? (refer to the…

A: There are no such privileges like "TRUNCATE ANY TABLE", and "TRUNC TABLE" in Oracle. The privilege…

Q: Which of the following commands can you use to modify an index?a. ALTER SESSIONb. ALTER TABLEc.…

Q: A table can be deleted from the database by using the _____ TABLE command. Select one: a. MODIFY b.…

A: Drop function is used to delete the table from a database. Delete is used to delete a row from a…

Q: Which of the following SQL command can be used to modify existing data in a database table? a.…

A: UPDATE sql command is used to modify existing data in a database table

Q: Which of the following is false? a. You can use a query to retrieve specific information from a…

A: Explanation: One can use a query when a database has more than one table. It also possible to get…

Q: Which of the following statements places a shared lock on at least a portion of a table named…

A: Explanation: A shared lock on a resource means that resource is open for write operation only by…

Q: What can be referenced to determine whether an index is used to perform a query?a. USER_INDEXES…

A: The EXPLAIN PLAN statement shows execution plans for SELECT, Edit, INSERT, and DELETE statements…

Q: 2. Which of the following will allow you to remove your table in the database? (SQL) A. DELETE FROM…

A: - we need to choose correct for the SQL statements.

Q: Which command should you use to copy data from one table and have it added to an existing table?

A: INSERT command: INSERT INTO command is used to copy data from one table and to add it to the…

Q: Which of the below items are the application areas of the database?

A: Answer;

Q: Which of the following commands can be used to eliminate the RECEPTIONIST role? (refer to the…

A: Option: D None of the above

Q: Create two different forms of the INSERT command to add a student with a student ID of 65798 and…

A: note, we can only solve three subparts in one question. There are two types of INSERT INTO…

Q: Which command instructs Oracle to create a new table CREATE NEW TABLE .a O ALTER TABLE b o CREATE…

A: In Oracle, CREATE TABLE statement is used to create a new table in the database. To create a…

Q: Try these commands and comment the role for each command. 1) SQL> conn sys as sysdba Password :…

A: Given 10 SQL commands and these have their own role and perform different action. 1) conn sys as…

Q: Using prepared statement give a PHP script (prest.php) for a database “demodb” and table…

A: I am providing the entire code which I developed for the problem. There will be 2 PHP files, which…

Q: Which of the following types of restrictions can be viewed with the DESCRIBE command? ( refer to the…

A: Answer: NOT NULL constraint: 1.A column can hold NULL values by default. 2. The NOT NULL constraint…

Q: Which of the following creates a new table in a database and also copies the records into the new…

A: Required: Which of the following creates a new table in a database and also copies the records into…

Q: Which of the following privileges allows a user to truncate tables in a database? a. DROP ANY…

A: TRUNCATE TABLE statement is used to remove all rows from existing table. It is used to delete…

Q: EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in…

A: MPDET is an external table containing the columns EMPNO and ENAME. Which command would work in…

Q: Which of the following is a valid SQL command? ( refer to the tables in the JustLee Books database).…

A: ALTER TABLE books ADD CONSTRAINT UNIQUE (pubid); This is not a valid SQL command. Valid Syntax:…

Q: Which of the following privileges allows a user to truncate tables in a database?

A: The privilege provided to truncate any kind of tables was not available in oracle 12c version. So…

Q: to delete a table, that is referenced by other tables, from your database; you use use the command:…

A: The suitable option is (b).

Q: UTAS-Ibri youth club wants to have a database of blood donors on campus. The club requests you to…

A: <Html> <head> <title> BLOOD DONATION FORM </title> </head> <body…

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: SQL CODE FOR TABLE CREATION OF TABLE MAINTENANCES:- CREATE TABLE MAINTENANCES( CAR_ID CHAR(5),…

Q: 2. Click the Execute button or press F5 to see the new database in the Object Explorer. 3. Create…

A: The solution to the problem is given below Step 1: Click on New Query option then create new…

Q: Create the following tables in a database named "roster". Make sure that your database and tables…

A: I will provide the picture of solution in step 2

Q: Which of the following keywords allows the user to delete a record from a table, even if rows in…

A: Deletion in database The DROP statement allows the user to drop (or delete) the existing database…

Q: Which of the following statements assigns the role CUSTOMERREP as the default role for Maurice Cain?…

A: The correct statement to assign the role CUSTOMERREP as the default role for Maurice Cain is as…

Q: You have a list of all your contacts details that you would like to store in a database. Your goal…

A: Hi. Triggers are set of statements that runs when a certain event is triggered. A trigger can be…

Q: Which SQL command changes the structure of a TABLE? a. MODIFY b. AMEND c. ALTER d. CHANGE 2. Which…

A: 1. SQL command changes the structure of a TABLE a. MODIFYb. AMENDc. ALTERd. CHANGE 2. the following…

Q: Which SQL Command is used to delete a table from the database: a) Update b) Alter c) Drop d)…

A: Update command is used to update the values in database Alter command is used to change the value…

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: According to the Question below the Solution:

Q: To restore the values of a table, you must use the. .command. Select one: a.COMMIT b.ROLLBACK…

A: The correct option is : b.) ROLLBACK

Question

The previous administrator created a table named CONTACTS, which contains outdated data. You want to remove the table and its data from the database. Which statement should you issue?

which one will it be

a. DELETE

b. ALTER TABLE

c. TRUNCATE TABLE

d. DROP TABLE

Organized collection of structured information, or data, typically stored in a computer system.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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 CASCADE
Which of the following is a correct statement? You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. You can’t create empty tables—all tables must contain at least three rows of data. A table can contain a maximum of 1000 columns. The maximum length of a table name is 265 characters.
Which command should you use to copy data from one table and have it added to an existing table?
Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be able to retrieve data from the TRIP table. b. Users Gomez and Liston must be able to add new reservations and customers to thedatabase. c. Users Andrews and Zimmer must be able to change the price of any trip. d. All users must be able to retrieve the trip name, start location, distance, and type forevery trip. e. User Golden must be able to add and delete guides. f. User Andrews must be able to create an index for the TRIP table. g. Users Andrews and Golden must be able to change the structure of the CUSTOMERtable. h. User Golden must have all privileges on the TRIP, GUIDE, and TRIP_GUIDEStables.
Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table.
Which of the following statements is correct? A table can contain a maximum of only one column marked as unused. You can delete a table by removing all columns in the table. Using the SET UNUSED clause allows you to free up storage space used by a column. None of the above statements are correct.
Which 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.