click below
click below
Normal Size Small Size show me how
Database
Interview questions
Question | Answer |
---|---|
What is a Primary Key: | primary keys must contain unique values/A field that uniquely identifies a record in a table |
Foreign keys | foreign keys may have duplicates |
What is an index | summary table which lets you quickly look up the contents of any record in a table. Think of how you use an index to a book: as a quick jumping off point to finding full information about a subject. |
normalisation | The process of structuring data to minimise duplication and inconsistencies. |
Count duplicates | select distinct city, count(city) from A2Account group by city |
what is a group by statement | "Group By X" means "put all those with the same value for X in the one group. "Group By X, Y" means "put all those with the same values for both X and Y in the one group." |
group by having? | The Having is simply equivalent to a WHERE clause after the group by has executed and before the select part of the query is computed. |
how much space in sybase | • sp_hds • sp_helpdb • sp_spaceused |