This preview shows page 1. Sign up to view the full content.
Unformatted text preview: problem to related areas. Rather than an absolute value for a specific table, let's look at the relative sizes. Find the top 3 table biggest tables. 2. Write an SQL statement to retrieve a list of PostgreSQL non-default settings. 3. Write an SQL query that identifies the duplicate in the tbllecturehall table on the numberofseats column. 4. Generate a list of dates, from today, incrementing by 1 day for the next two weeks. 5. PostgreSQL keeps track of each access against an index. Write an SQL statement to view the unused indexes....
View Full Document
This note was uploaded on 02/27/2012 for the course IT 101 taught by Professor Unsure during the Spring '11 term at University of South Africa.
- Spring '11
- Computer Science