Question is ⇒ The command to remove rows from a table 'CUSTOMER' is:, Options are ⇒ (A) REMOVE FROM CUSTOMER ..., (B) DROP FROM CUSTOMER ..., (C) DELETE FROM CUSTOMER WHERE ..., (D) UPDATE FROM CUSTOMER ..., (E) , Leave your comments or Download question paper.

Question is ⇒ The command to remove rows from a table 'CUSTOMER' is:, Options are ⇒ (A) REMOVE FROM CUSTOMER ..., (B) DROP FROM CUSTOMER ..., (C) DELETE FROM CUSTOMER WHERE ..., (D) UPDATE FROM CUSTOMER ..., (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	The command to remove rows from a table 'CUSTOMER' is:
A.	REMOVE FROM CUSTOMER ... [Wrong Answer]
B.	DROP FROM CUSTOMER ... [Wrong Answer]
C.	DELETE FROM CUSTOMER WHERE ... [Correct Answer]
D.	UPDATE FROM CUSTOMER ... [Wrong Answer]
View Answer 1 -1 Explanation:- Answer : C Discuss it below : !! OOPS Login [Click here] is required to post your answer/result Help other students, write article, leave your comments

Previous question Next question

Also Read Similar Questions Below :

⇒ The command to eliminate a table from a database is:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;

⇒ Which JDBC driver Types are for use over communications networks?
Type 3 only
Type 4 only
Both Type 3 and Type 4
Neither Type 3 nor Type 4

⇒ Embedded SQL is which of the following?
Hard-coded SQL statements in a program language such as Java.
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a procedure.
Hard-coded SQL statements in a trigger.

⇒ What type of join is needed when you wish to include rows that do not have matching values?
Equi-join
Natural join
Outer join
All of the above.

⇒ SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.

⇒ How many tables may be included with a join?
One
Two
Three
All of the above.

⇒ A subquery in an SQL SELECT statement is enclosed in:
braces -- {...}.
CAPITAL LETTERS.
parenthesis -- (...) .
brackets -- [...].

⇒ A reason for using an SQL view to hide columns is:
to simplify a result only.
to prevent the display of sensitive data only.
to accomplish both of the above.
None of the above are reasons for using an SQL view.

⇒ The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Equi-join
Natural join
Outer join
Cartesian join

⇒ When using the SQL INSERT statement:
rows can be modified according to criteria only.
rows cannot be copied in mass from one table to another only.
rows can be inserted into a table only one at a time only.
rows can either be inserted into a table one at a time or in groups.

⇒ Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Lock level
Transaction isolation level
Cursor concurrency setting
Locking hints

⇒ What MySQL property is used to create a surrogate key in MySQL?
UNIQUE
SEQUENCE
AUTO_INCREMENT
None of the above -- Surrogate keys are not implemented in MySQL.

⇒ Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
Type 1 only
Type 2 only
Both Type 3 and Type 4
All of Type 1, Type 2, Type 3 and Type 4

⇒ The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.

⇒ With which type of SQL Server recovery model are all database changes logged?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery

⇒ A CASE SQL statement is which of the following?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.

⇒ What is bytecode?
Machine-specific code
Java code
Machine-independent code
None of the above is correct.

⇒ The result of a SQL SELECT statement is a(n) ________ .
report
form
file
table

⇒ SQL Server 2000 stored procedures can:
never be kept within the database.
be kept within the database and invoked by application programs.
be stored on the users' computer.
support BEFORE, INSTEAD OF and AFTER types.

⇒ Which of the following is an SQL trigger supported by Oracle?
BEFORE
INSTEAD OF
AFTER
All of the above.

⇒ The command to remove rows from a table 'CUSTOMER' is:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...

⇒ With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Nonclustered
Clustered
Primary
Secondary

⇒ The DROP TABLE statement:
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.

⇒ Which of the following is the correct order of keywords for SQL SELECT statements?
SELECT, FROM, WHERE
FROM, WHERE, SELECT
WHERE, FROM,SELECT
SELECT,WHERE,FROM

⇒ Which of the three possible types of triggers does SQL Server support?
INSTEAD OF only
AFTER only
BEFORE only
INSTEAD OF and AFTER only

⇒ Which of the following is true concerning systems information in an RDBMS?
RDBMS store database definition information in system-created tables.
This information can be accessed using SQL.
This information often cannot be updated by a user.
All of the above.

⇒ Which of the following statements is true concerning subqueries?
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
Does not start with the word SELECT.
All of the above.

⇒ What is not true of a Java bean?
There are no public instance variables.
All persistent values are accessed using get and set methods.
It may have many constructors as necessary.
All of the above are true of a Java bean.

⇒ An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
COBOL.
VB.NET.
TRANSACT SQL.
Visual Basic.

⇒ What is the full form of SQL?
Simple Query Language
Structured Query Language
Structured Query List
None of these