Simple SQL Quiz

1) SQL stands for..

2) The command for adding records is..

3) The command for removing records is..

4) The command for updating records is..

5) The number of primary keys allowed in a table..

6) The instruction to get all column values in SELECT statement..

7) To complete SELECT animal from Mammals WHERE modeofMovement=

8) The best way to add a record is...

9) DELETE animal from mammals .... animalID=5. The missing command is..

10) To get data in alphabetical order, the command is...

11) One of the following is not a constrain

12)SELECT age from members where fn='Tim' and mn='Berners' and ln='Lee' will extract,

13) ALTER TABLE command can be used to...

14) Integer data type needs...

15) SELECT COUNT(*) from members will return...

Programmed by Vivax Solutions

1. Relational Databases....
The data is stored in a set of tables, connected to each other by special relationships. The relational database model was a huge step forward, as it allowed files to be related by a common entity. In order to relate any two files, they simply need to have a common entity, which makes the model highly flexible and easy to use.
2. It can have one, two or many tables. However, Please click this....
3. How the effect you see is produced...