Databases questions and answers
SQL and NoSQL modelling, indexing and query performance. Page 1 of 20.
System Design practice on Codemia
Work through 120+ system design problems with detailed solutions, from rate limiters to multi-region storage.
Answers 1-60
- ''0000-00-00 000000'' can not be represented as java.sql.Timestamp error
- 1030 Got error 28 from storage engine
- 1052 Column 'id' in field list is ambiguous
- 1071 - Specified key was too long; max key length is 1000 bytes
- 1114 HY000 The table is full
- 1273 - Unknown collation 'utf8mb4_unicode_ci' cPanel
- 1273 – Unknown collation ‘utf8mb4_unicode_520_ci’
- 2 Helm Charts with shared Redis dependency
- 2PC distributed transactions across many microservices?
- 3 fields composite primary key unique item in Dynamodb
- 3Phase commit protocol - Distributed System
- Difference between Redis and Kafka
- How to add a column with a default value to an existing table in SQL Server?
- Improve INSERT-per-second performance of SQLite
- A connection was successfully established with the server, but then an error occurred during the pre-login handshake
- A GUI tool for MongoDB
- A remote access exception in DolphinDB,Can''t find the object with name loadTable(''dfs//zctestDB'',''trainInfoTable'')
- Abnormally high MySQL writes and larger than normal Binary Log files. How can I determine what caused this?
- About Java Cassandra Client, which one is better? How about CQL?
- access denied for load data infile in MySQL
- Access Denied for User 'root''localhost' using password YES - No Privileges?
- Access denied for user 'root''localhost' using password YES after new installation on Ubuntu
- Access denied for user 'rootlocalhost' using passwordNO
- Access denied for user 'root''localhost' while attempting to grant privileges. How do I grant privileges?
- Access denied; you need at least one of the SUPER privileges for this DEFINER operation
- Access denied; you need at least one of the SUPER privileges for this DEFINER operation
- Access host database from a docker container
- Access multiple elements of list knowing their index
- Access mysql remote database from command line
- access postgres in kubernetes from an application outside the cluster
- Accessing a Dictionary.Keys Key through a numeric index
- Accessing an SQLite Database in Swift
- Accessing data on distributed database on OrientDB
- Accessing dict_keys element by index in Python3
- Accessing H2 Console While Running SpringBootTest
- accessing indexes of tf.data.Dataset for deleting and appending data elements
- Accidentally import the MySQL user table into TiDB, or forget the password
- Acessing Values only at certain indexes using iterators
- Add 2 hours to current time in MySQL?
- Add Foreign Key to existing table
- Add non existing element to array in DynamoDB
- Add on-premise CockroachDB node to a cluster hosted in Kubernetes
- Adding a leading zero to some values in column in MySQL
- Adding a new SQL column with a default value
- Adding multiple columns AFTER a specific column in MySQL
- Adjusting CommandTimeout in Dapper.NET?
- ADO Async all the way down the tubes?
- ADO.NET Entity Framework Update Wizard will not add tables
- Advantages of using cql over thrift
- Aerospike How Primary & Secondary Index works internally
- Aerospike Read records from a particular node using secondary index
- After Spring Boot 2.0 migration jdbcUrl is required with driverClassName
- Algorithm for finding similar images using an index
- Algorithm identify pairwise conflicts in a set of objects, given only there is a conflict in this list oracle
- Algorithm or SQL to find where conditions for a set of columns which ensures result set has value in a particular column always 0
- Algorithm Printing the correct index for the character sequence
- Algorithm Question on File Search Indexing
- Algorithm to efficiently determine the nn element in a matrix
- Algorithm to find if there is any i so that arrayi equals i
- Algorithms for building a peer to peer search engine with distributed database
Course
Beginner
27 lessons
10 hours
System Design Fundamentals
Build a strong foundation in designing scalable, reliable distributed systems.
View the course