Databases
General 2 questions
- #1What type of databases are you familiar with?
- #2Database Table for Message Board System
Instructions
Design a database table for a message board system. It should include the following information:
- Personal details
- Who saw the message and when
- Replies
- Tagged people in the message
- Message categories
Notes:
- No SQL is needed
- You should include: table names, field names, data types and mention the foreign keys used.
SQL 19 questions
- #3What is a relational database?
- #4What does it mean when a database is ACID compliant?
- #5What is sharding?
- #6You find out your database became a bottleneck and users experience issues accessing data. How can you deal with such situation?
- #7What is a connection pool?
- #8What is a connection leak?
- #9What is Table Lock?
- #10Your database performs slowly than usual. More specifically, your queries are taking a lot of time. What would you do?
- #11What is a Data Warehouse?
- #12Explain what is a time-series database
- #13What is OLTP (Online transaction processing)?
- #14What is OLAP (Online Analytical Processing)?
- #15What is an index in a database?
- #16What data types are there in relational databases?
- #17Explain Normalization
- #18Explain Primary Key and Foreign Key
- #19What types of data tables have you used?
- #20What is ORM? What benefits it provides in regards to relational databases usage?
- #21What is DDL?
Time Series 1 question
- #22What is Time Series database?