sql-online-test-1

Time : 450 sec

1.  What is SQL Full form?

1. Structured Question Language

2. Structured Query Language

3. Structured Quoted Language

4. none

2.  Which one we use to get rows data from table?

1. EXTRACT

2. SELECT

3. OPEN

4. GET

3. Which one we use to update the data from table?

1. SAVE

2. UPDATE

3. MODIFY

4. EDIT

4.  Which one we use to delete the data from table?

1. DELETE

2. REMOVE

3. MOVE

4. NONE

5. Which one we use to add the data to the table?

1. ADD INTO

2. INSERT INTO

3. ADD TO

4. NONE

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

1.  SELECT ALL employee

2.  SELECT employee

3.  SELECT [all] FROM employee

4.  SELECT * FROM employee

7. how to select all the records from a table named "employee" where the value of the column "FirstName" is "ken"?

1.  SELECT * FROM employee WHERE FirstName='ken'

2.  SELECT ALL FROM employee WHERE FirstName LIKE 'ken'

3.  SELECT * FROM employee WHERE FirstName is 'ken'

4.  SELECT [all] FROM employee WHERE FirstName='ken'

8. how to select all the records from a table named "employee" where the "FirstName" is "ken" and the "LastName" is "adams"?

1.  SELECT FirstName='ken', LastName='adams' FROM employee

2.  SELECT * FROM employee WHERE FirstName='ken' AND LastName='adams'

3.  SELECT * FROM employee WHERE FirstName is 'ken' AND LastName is 'adams'

4.  NONE

9. Which SQL statement is used to return only different values?

1. SELECT UNIQUE

2. SELECT DISTINCT

3. SELECT DIFFERENT

4. NONE

10. Which one  is used to sort the rows?

1.  SORT

2.  ORDER BY

3.  ORDER

4.  SORT BY

11.How to update "BOB" with "VIKRAM" in the "LastName" column in the employee table?

1.  UPDATE employee SET LastName='VIKRAM' WHERE LastName='BOB'

2.   MODIFY employee SET LastName='BOB' WHERE LastName='VIKRAM'

3.   UPDATE employee SET LastName='BOB' INTO LastName='VIKRAM'

4.  MODIFY employee SET LastName='BOB' INTO LastName='VIKRAM'

12. how to delete the rows where the "FirstName" is "ken" in the "employee" Table?

1.   DELETE ROW FirstName='ken' FROM employee

2.  DELETE FirstName='ken' FROM employee

3.  DELETE FROM employee WHERE FirstName = 'ken'

4.  NONE

13. how to return the number of records in the "employee" table?

1.  SELECT COLUMNS() FROM employee

2.  SELECT COUNT() FROM employee

3.  SELECT COLUMNS(*) FROM employee

4.  SELECT COUNT(*) FROM employee

14.Which operator is used to select values within a range?

1. RANGE

2. BETWEEN

3. WITHIN

4. NONE

15.Which one is used to search perticular pattern from a table?

1. LIKE

2. FROM

3. GET

4. NONE