Databases questions and answers
SQL and NoSQL modelling, indexing and query performance. Page 10 of 20.
System Design practice on Codemia
Work through 120+ system design problems with detailed solutions, from rate limiters to multi-region storage.
Answers 541-600
- Database topology design confusion
- DatabaseError current transaction is aborted, commands ignored until end of transaction block?
- Datastax Cassandra Driver throwing CodecNotFoundException
- DateTime2 vs DateTime in SQL Server
- Datetime equal or greater than today in MySQL
- DAX Intermittent No Endpoints Available
- DB Query profiling in Node.js
- DbContext discard changes without disposing
- Dealing with schema changes in Mongoose
- Debezium-contains no connector type
- Debezium connector for MySQL. The db history topic is missing
- debezium could not access file decoderbufs using postgres 11 with default plugin pgoutput
- Debezium flush timeout and OutOfMemoryError errors with MySQL
- Debezium No maximum LSN recorded in the database; please ensure that the SQL Server Agent is running
- Debezium's ExtractNewRecordState transform cannot work
- Decimal / Float in mongoose for node.js
- Decimal precision and scale in EF Code First
- Declare a variable in RedShift
- Deduplication , Grouping for events table at scale
- Default maximumPoolSize for HikariCP
- Delayed Queue implementation in Storm – Kafka, Cassandra, Redis or Beanstalk?
- Delete all Duplicate Rows except for One in MySQL?
- Delete all items in a DynamoDB table using bash with both partition and sort keys
- Delete many rows from a table using id in Mysql
- Delete sql rows where IDs do not have a match from another table
- Delete with Join in MySQL
- Deleting a key/value from existing MongoDB entry
- Deleting rows with MySQL LEFT JOIN
- Delimiters in MySQL
- deployment/auth-mongo-depl container auth-mongo is waiting to start mongo can't be pulled
- Detect if value is number in MySQL
- Determine which MySQL configuration file is being used
- DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
- Development Environment for Testing MySQL Replication
- Difference between a distributed lock manager and distributed database
- Difference between AWS DynamoDB vs. AWS DocumentDBNewly launched service?
- Difference between AWS SDK DynamoDB client and DocumentClient?
- Difference between DynamoDb PutItem vs UpdateItem?
- Difference between FetchType LAZY and EAGER in Java Persistence API?
- Difference between filter and filter_by in SQLAlchemy
- Difference between findBy and findOneBy in Spring data JPA
- Difference between Key, Primary Key, Unique Key and Index in MySQL
- Difference Between One-to-Many, Many-to-One and Many-to-Many?
- Difference between OneToMany and ElementCollection?
- Difference between Partial Replication and Sharding?
- Difference between primary key and unique key
- Difference between save and saveAndFlush in Spring data jpa
- Difference Between Schema / Database in MySQL
- Difference between Select and Where in Entity Framework
- Difference between Statement and PreparedStatement
- Difference between storing an ObjectId and its string form, in MongoDB
- Difference between text and varchar (character varying)
- Difference between Transaction Co-ordinator and Transaction Manager
- Difference between two dates in MySQL
- Difference between unlogged and logged Cassandra batches in negative cases
- Difference between VARCHAR and TEXT in MySQL
- Difference between Zookeeper and a managed replicated database service
- Differences between GSI and table
- Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
- Differences between MySQL and SQL Server
Course
Beginner
27 lessons
10 hours
System Design Fundamentals
Build a strong foundation in designing scalable, reliable distributed systems.
View the course