[Solved] The command to remove rows from a table ‘CUSTOMER’ is __________________

Q.	The command to remove rows from a table ‘CUSTOMER’ is __________________
A.	DROP FROM CUSTOMER
B.	UPDATE FROM CUSTOMER
C.	REMOVE FROM CUSTOMER
D.	DELETE FROM CUSTOMER WHERE
Answer» D. DELETE FROM CUSTOMER WHERE

View all MCQs in: DataBase Management System (DBMS)

Discussion

Related Multiple Choice Questions

Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
A lock that allows concurrent transactions to access different rows of the same table is known as a
A lock that allows concurrent transactions to access different rows of the same table is known as a
A is a query that retrieves rows from more than one table or view:
A lock that allows concurrent transactions to access diﬀerent rows of the same table is known as a
…………….. is used to determine whether of a table contains duplicate rows.
___________removes all rows from a table without logging the individual row deletions.
Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;

Help us improve!

We want to make our service better for you. Please take a moment to fill out our survey.