#Hifadhidata

85 maswali

Faida na hasara za TypeORM ni zipi?Node.js#databaseMiddle
Faida na hasara za Sequelize ni zipi?Node.js#ormMiddle
TypeORM na Sequelize hulinganaje, na ungechagua kila kimoja lini?Node.js#ormSenior
SQL ni nini na inatumika kwa nini?SQL#databaseJunior
NULL inafanyaje kazi katika SQL?SQL#databaseJunior
Primary keys na foreign keys ni nini?SQL#databaseMiddle
Constraints za hifadhidata ni zipi?SQL#databaseMiddle
Ni nini urekebishaji (normalization) wa hifadhidata?SQL#databaseMiddle
Ni nini transactions na sifa za ACID?SQL#databaseMiddle
Ni nini views na materialized views?SQL#databaseMiddle
Ni nini transaction isolation levels?SQL#databaseSenior
Ni nini husababisha deadlocks na unazizuiaje?SQL#databaseSenior
Ni nini stored procedures na lini unapaswa kuzitumia?SQL#databaseSenior
Ni nini DDL, DML, DCL na TCL?SQL#databaseSenior
Ni zipi data types za kawaida za SQL na unazichaguaje?SQL#databaseMiddle
Unaquery vipi records bilioni 10 chini ya 100ms?System Design#databaseSenior
Ungeshard vipi database kwa watumiaji bilioni 1?System Design#databaseSenior
Unascale vipi MySQL wakati traffic inakua mara 100?System Design#databaseSenior
Unahifadhi vipi log events milioni 100 kwa siku?System Design#databaseSenior
Unajengaje full-text search juu ya records 100M+?System Design#searchingSenior
Real-time revenue analytics juu ya mamilioni ya transactions/siku: vipi?System Design#databaseSenior
Hifadhi na query transaction history kwa mamia ya mamilioni ya accountsSystem Design#scalingSenior
Hamisha database ya 10TB bila downtime: mpango ni upi?System Design#data-migrationSenior
Backup na disaster recovery kwa database ya makumi ya TBSystem Design#databaseSenior
Unaimport vipi records milioni 100 za CSV kwenye DB kwa haraka?System Design#performanceSenior
Unaundaje audit log kwa miaka ya traceability?System Design#loggingSenior
CDC husync vipi data kuvuka systems?System Design#databaseMiddle
Unapartition vipi jedwali moja lenye rows bilioni?System Design#sqlMiddle
Unaexport vipi dataset kubwa bila kuathiri live system?System Design#performanceMiddle
Unashughulikiaje hot key au hot row chini ya contention kubwa?System Design#performanceMiddle
Unazuiaje deadlocks na maelfu ya concurrent transactions?System Design#concurrencyMiddle
PostgreSQL ni nini na kwa nini uichague?PostgreSQL#databaseJunior
PostgreSQL inatoa aina gani za data zaidi ya SQL ya kawaida?PostgreSQL#databaseJunior
psql ni nini na amri zake muhimu ni zipi?PostgreSQL#databaseJunior
Vitambulisho vinavyojiongeza vinafanyaje kazi (SERIAL, sequences, IDENTITY)?PostgreSQL#databaseJunior
Schemas ni nini katika PostgreSQL?PostgreSQL#databaseJunior
Safu wima za array zinafanyaje kazi katika PostgreSQL?PostgreSQL#databaseJunior
Generated columns ni nini?PostgreSQL#databaseJunior
JSONB inafanyaje kazi na ni lini unapaswa kuitumia?PostgreSQL#databaseMiddle
Full-text search inafanyaje kazi katika PostgreSQL?PostgreSQL#databaseMiddle
MVCC ni nini katika PostgreSQL?PostgreSQL#databaseMiddle
Extensions za PostgreSQL ni nini?PostgreSQL#databaseMiddle
LISTEN na NOTIFY ni nini?PostgreSQL#databaseMiddle
PostgreSQL inaunga mkono constraints zipi?PostgreSQL#databaseMiddle
Locking inafanyaje kazi katika PostgreSQL?PostgreSQL#databaseSenior
MongoDB ni nini na inatofautianaje na hifadhidata za SQL?MongoDB#databaseJunior
Nyaraka na makusanyo ni nini katika MongoDB?MongoDB#databaseJunior
BSON ni nini na MongoDB inasaidia aina gani za data?MongoDB#databaseJunior
MongoDB shell (mongosh) ni nini na amri zake muhimu?MongoDB#databaseJunior
Utafutaji wa maandishi hufanya kazi vipi katika MongoDB?MongoDB#databaseMiddle
Transactions hufanya kazi vipi katika MongoDB?MongoDB#databaseMiddle
Mongoose ni nini na kwa nini kutumia ODM?MongoDB#databaseMiddle
Schema validation hufanya kazi vipi katika MongoDB?MongoDB#databaseMiddle
Change streams ni nini?MongoDB#databaseSenior
Write concern na read concern huathiri vipi uthabiti?MongoDB#databaseSenior
Redis ni nini na hutumika kwa nini?Redis#databaseJunior
Redis inaunga mkono aina gani za data?Redis#databaseJunior
Strings na keys hufanya kazi vipi katika Redis?Redis#databaseJunior
Key expiration (TTL) hufanya kazi vipi katika Redis?Redis#databaseJunior
Redis lists hufanya kazi vipi na hutumikaje kwa queues?Redis#databaseJunior
Redis hashes na sets hufanya kazi vipi?Redis#databaseJunior
Sorted sets ni nini na hutumikaje?Redis#databaseJunior
redis-cli ni nini na amri zake muhimu?Redis#databaseJunior
Redis inatofautiana vipi na database ya kawaida?Redis#databaseJunior
Persistence ya Redis hufanya kazi vipi (RDB dhidi ya AOF)?Redis#databaseMiddle
Redis transactions hufanya kazi vipi?Redis#databaseMiddle
Kwa nini operesheni za Redis ni za kiatomiki na kwa nini ni muhimu?Redis#databaseMiddle
Lua scripting inafanya kazi vipi katika Redis?Redis#databaseSenior
Miundo ya data ya Redis iliyoongezwa na moduli gani zinajulikana?Redis#databaseSenior
Amazon DynamoDB ni nini?Cloud & AWS#databaseMiddle
Unajinasaje query ya utendaji wa haraka katika hifadhidata?Site Reliability & Operations#databaseMiddle
Spring Data JPA hufanyaje kazi na derived queries ni nini?Spring Boot#springMiddle
@Transactional hufanyaje kazi, pamoja na propagation na rollback?Spring Boot#databaseMiddle
MySQL ni nini, na InnoDB na MyISAM zinatofautianaje?MySQL#databaseJunior
Unachaguaje data types katika MySQL, na ni makosa gani ya kawaida?MySQL#databaseJunior
Index ni nini, na primary key inatofautianaje na secondary index?MySQL#databaseJunior
Eleza INNER, LEFT, na RIGHT JOIN katika MySQL kwa mifano.MySQL#databaseJunior
B-tree, composite, na covering indexes zinafanyaje kazi, na kanuni ya leftmost-prefix ni nini?MySQL#databaseMiddle
Unasomaje EXPLAIN na kuitumia kuboresha (optimize) query ya polepole?MySQL#performanceMiddle
Eleza transactions na isolation levels katika InnoDB, na anomalies wanazozizuia.MySQL#databaseMiddle
Ni uwiano gani (trade-offs) kati ya normalization na denormalization?MySQL#databaseMiddle
Replication ya master–replica ya MySQL inafanyaje kazi, na inasaidiaje kuongeza (scale) reads?MySQL#databaseMiddle
Row locks na MVCC zinafanyaje kazi katika InnoDB, na unaepukaje deadlocks?MySQL#databaseSenior
Ni lini unatumia partitioning dhidi ya sharding kuongeza (scale) MySQL?MySQL#databaseSenior
Unaupangaje (tune) server ya MySQL: buffer pool, slow query log, na connections?MySQL#performanceSenior