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
- Spring '11
- Computer Science, two weeks, Information Technology department, 1 Day, Two week, School of Information Technology Department of Computer Science