Which of the following commands removes all orders placed before April 1, 2009?a. DELETE FROM orders WHERE orderdate < ‘01-APR-09’;b. DROP FROM orders WHERE orderdate < ‘01-APR-09’;c. REMOVE FROM orders WHERE orderdate < ‘01-APR-09’;d. DELETE FROM orders WHERE orderdate > ‘01-APR-09’;

Which of the following commands removes all orders placed before April 1, 2009?a. DELETE FROM orders WHERE orderdate < ‘01-APR-09’;b. DROP FROM orders WHERE orderdate < ‘01-APR-09’;c. REMOVE FROM orders WHERE orderdate < ‘01-APR-09’;d. DELETE FROM orders WHERE orderdate > ‘01-APR-09’;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 13MC

See similar textbooks

Similar questions

Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM homework10; b. DELETE . FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid = ; e. Both c and d delete all rows in the HOMEWORK10 table.
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.
Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this order), which of the following commands stores a NULL value in Col3 of the HOMEWORK10 table?a. INSERT INTO homework10 VALUES (‘A’, ‘B’, ‘C’);b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’, ‘B’);c. INSERT INTO homework10 VALUES (NULL, ‘A’, ‘B’);d. UPDATE homework10 SET col1 = col3;
Which of the following statements places a shared lock on at least a portion of a table named HOMEWORK10?a. SELECT * FROM homework10 WHERE col2 IS NULL FOR UPDATE;b. INSERT INTO homework10 (col1, col2, col3) VALUES (‘A’, ‘B’, ‘C’);c. UPDATE homework10 SET col3 = NULL WHERE col1 = ‘A’;d. UPDATE homework10 SET col3 = LOWER (col3) WHERE col1 = ‘A’;e. all of the above
Which of the following commands is valid?a. RENAME customer# TO customernumber FROM customers;b. ALTER TABLE customers RENAME customer# TO customernum;c. DELETE TABLE customers;d. ALTER TABLE customers DROP UNUSED COLUMNS;
Which of the following statements represents a correctly structured transaction? a.) BEGIN;COMMIT;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11; b.) BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11;COMMIT; c.) BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348)insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip')UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11COMMIT d.) BEGIN;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert…
Assume you have added eight new orders to the ORDERS table. Which of the following is true?a. Other users can view the new orders as soon as you execute the INSERT INTO command.b. Other users can view the new orders as soon as you issue a ROLLBACK command.c. Other users can view the new orders as soon as you exit the system or execute a COMMIT command.d. Other users can view the new orders only if they place an exclusive lock on the table.
Use the "uniq -c" command to sort and summarize the total occurrences of sudo access by month and user. Submit - Screen shot of your syntax and output showing total occurrences by month and user of sudo access, for example: 112 Apr msmith 101 Mar admin What command should we use??
Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? a. Me.CompanyDataSet.Fill(Me.Sales) b. Me.SalesBindingSource.Fill(Me.CompanyDataSet) c. Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) d. Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)
Which of the following LINQ statements arranges the records in ascending order by the LastName field, with records having the same last name arranged in descending order by the FirstName field?a. Dim records = From name In NamesDataSet.tblNames Order By name.LastName Ascending, name.FirstName Descending Select nameb. Dim records = From name In NamesDataSet.tblNames Order By name.LastName, name.FirstName Descending Select namec. Dim records = Select name From NamesDataSet.tblNames Order By name.FirstName Descending, name.LastNamed. both a and b
Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? Me.CompanyDataSet.Fill(Me.Sales) Me.SalesBindingSource.Fill(Me.CompanyDataSet) Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)
Which of the following is a valid SQL statement? SELECT * WHERE amid = ‘J100’ FOR UPDATE; INSERT INTO homeworkl0 VALUES (SELECT * FROM acctmanager); DELETE amid FROM acctmanager; rollback; all of the above