Freshers India

Programming - PHP

You Are Here :: Home > Programming > PHP- General Questions

79.

Which SQL statement is used to delete data from a database??

A.	DELETE	B.	COLLAPSE
C.	REMOVE	D.	None of these

80.

which SQL statement is used to insert new data in a database??

A.	INSERT NEW	B.	ADD RECORD
C.	ADD NEW	D.	INSERT INTO

81.

With SQL, how do you select a column named "FirstName" from a table named "Persons"??

A.	EXTRACT FirstName FROM Persons	B.	SELECT Persons.FirstName
C.	SELECT FirstName FROM Persons	D.	None of these

82.

With SQL, how do you select all the columns from a table named "Persons"??

A.	SELECT Persons	B.	SELECT *.Persons
C.	SELECT [all] FROM Persons	D.	SELECT * FROM Persons

83.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"??

A.	SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'	B.	SELECT * FROM Persons WHERE FirstName='Peter'
C.	SELECT [all] FROM Persons WHERE FirstName='Peter'	D.	SELECT * FROM Persons WHERE FirstName<>'Peter'

84.

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a?

A.	False	B.	True
C.	----	D.	----

« prev

Catch Us on