Databases questions and answers
SQL and NoSQL modelling, indexing and query performance. Page 15 of 20.
System Design practice on Codemia
Work through 120+ system design problems with detailed solutions, from rate limiters to multi-region storage.
Answers 841-900
- Error in MySQL when setting default value for DATE or DATETIME
- Error in Oracle Coherence - no storage-enabled nodes exist for service partitionedcache while using Cohql in production
- Error in TiDB `java.sql.BatchUpdateExecptionstatement count 5001 exceeds the transaction limitation`
- Error installing mysql2 Failed to build gem native extension
- Error related to only_full_group_by when executing a query in MySql
- Error renaming a column in MySQL
- Error starting yugabyte as per shown in docs
- Error Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
- ERROR update or delete on table tablename violates foreign key constraint
- Error while trying to configure ArangoDB replication
- Escaping single quote in PHP when inserting into MySQL
- Event Sourcing With an Event Store and an ORM
- Exception authenticating MongoCredential and Uncategorized Mongo Db Exception
- Exception when AddWithValue parameter is NULL
- Exception when creating datasource with PostgreSQL driver in Spring Boot
- Exchanging data between Android SQL-Lite and SQL Sever without using webserive
- Exclude a column using SELECT * [except columnA] FROM tableA?
- Executing an update/delete query in the JQPL query
- Existing tools to find unused tables in cassandra cluster
- Explicitly select items from a list or tuple
- Export and Import all MySQL databases at once
- Export data from DynamoDB
- Export MySQL dump from command line
- Export schema without data
- Exporting a table from Amazon RDS into a CSV file
- Expose MongoDB on Kubernetes with StatefulSets outside cluster
- Extension exists but uuid_generate_v4 fails
- Failed to auto-configure a DataSource 'spring.datasource.url' is not specified
- Failed to configure a DataSource 'url' attribute is not specified and no embedded datasource could be configured
- Failed to connect mongo-express to mongoDb in k8s
- Failed to load driver class com.mysql.jdbc.Driver
- Farmer needs algorithm for looping through self-referencing animal table
- Fastest Way of Inserting in Entity Framework
- Fastest way to remove duplicate documents in mongodb
- Fastest way to sort a list of number and their index
- Fault tolerance through replication of SQL databases
- Fault Tolerant Write-only Highly Distributed Database
- Fetch all rows in cassandra
- Field does not exist on transformations to extract key with Debezium
- Field required a bean of type that could not be found. error spring restful API using mongodb
- Filtering DynamoDB Streams events for a specific field change
- Find and Replace text in the entire table using a MySQL query
- Find duplicate records in MySQL
- FIND_IN_SET vs IN
- Find largest document size in MongoDB
- Find most frequent value in SQL column
- Find nearest latitude/longitude with an SQL query
- Find nearest points with MySQL from points Table
- Find Oracle JDBC driver in Maven repository
- Find records from one table which don't exist in another
- Find rows that have the same value on a column in MySQL
- Find Similar Rows in Database
- Find the number of columns in a table
- Find the number of elements greater than x in a given range
- Finding duplicate values in MySQL
- Finding duplicate values in MySQL
- Finding the index of elements based on a condition using python list comprehension
- Finding the reason for DBUpdateException
- firestore PERMISSION_DENIED Missing or insufficient permissions
- First-time database design am I overengineering?
Course
Beginner
27 lessons
10 hours
System Design Fundamentals
Build a strong foundation in designing scalable, reliable distributed systems.
View the course