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

Related MCQs

• 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 different 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;