Tafuta maswali…
⌘
K
English
Tiếng Việt
日本語
한국어
Español
العربية
বাংলা
čeština
Dansk
Deutsch
Ελληνικά
Suomi
Français
Gaeilge
ગુજરાતી
Hausa
हिन्दी
Hrvatski
Magyar
Bahasa Indonesia
Italiano
Basa Jawa
ქართული
Lietuvių
मराठी
Melayu
Malti
नेपाली
Nederlands
Norsk
ਪੰਜਾਬੀ
Polski
Português
Română
Русский
Slovenščina
Shqip
Svenska
Kiswahili
தமிழ்
తెలుగు
ภาษาไทย
Türkçe
اردو
简体中文
flow
Nyumbani
Mada
Kategoria
Njia za kujifunza
Tafuta
Maswali na majibu ya usaili wa SQL · Mazoezi ya Mahojiano ya IT
Nyumbani
/
Database
/
SQL
Database
SQL
Kuuliza maswali kwenye hifadhidata za uhusiano: joins, indexes na transactions.
30
maswali
yanasasishwa kila wiki
Junior
10
Middle
12
Senior
8
SQL maswali
30 / 30 yameonyeshwa
Chaguo-msingi
Maarufu
Mpya zaidi
›
Eleza INNER, LEFT, RIGHT na FULL JOIN.
Junior
#Join
#Query
Maelezo →
›
Index ni nini katika SQL? Lini unapaswa na lini hupaswi kuitumia?
Middle
#Index
#Utendaji
Maelezo →
›
SQL ni nini na inatumika kwa nini?
Junior
#Hifadhidata
Maelezo →
›
Kauli ya SELECT inafanyaje kazi?
Junior
#Query
Maelezo →
›
Unachujaje safu kwa kutumia WHERE?
Junior
#Query
Maelezo →
›
Aggregate functions ni nini (COUNT, SUM, AVG, n.k.)?
Junior
#Query
Maelezo →
›
GROUP BY na HAVING zinafanyaje kazi?
Junior
#Query
Maelezo →
›
ORDER BY na LIMIT zinafanyaje kazi, na unawekaje pagination?
Junior
#Query
Maelezo →
›
INSERT, UPDATE na DELETE zinafanyaje kazi?
Junior
#Query
Maelezo →
›
Unashughulikiaje nakala-zinazojirudia kwa kutumia DISTINCT?
Junior
#Query
Maelezo →
›
NULL inafanyaje kazi katika SQL?
Junior
#Hifadhidata
Maelezo →
›
Subqueries ni nini na unazitumiaje?
Middle
#Query
Maelezo →
›
UNION, INTERSECT na EXCEPT ni nini?
Middle
#Query
Maelezo →
›
Primary keys na foreign keys ni nini?
Middle
#Hifadhidata
Maelezo →
›
Constraints za hifadhidata ni zipi?
Middle
#Hifadhidata
Maelezo →
›
Ni nini urekebishaji (normalization) wa hifadhidata?
Middle
#Hifadhidata
Maelezo →
›
Ni nini transactions na sifa za ACID?
Middle
#Hifadhidata
Maelezo →
›
Ni nini views na materialized views?
Middle
#Hifadhidata
Maelezo →
›
Inafanyaje kazi expression ya CASE?
Middle
#Query
Maelezo →
›
Ni zipi functions za kawaida za string na tarehe?
Middle
#Query
Maelezo →
›
Ni nini self-join?
Middle
#Query
Maelezo →
›
Ni nini window functions?
Senior
#Query
Maelezo →
›
Ni nini Common Table Expressions (CTEs)?
Senior
#Query
Maelezo →
›
Unaboreshaje hoja za SQL za polepole?
Senior
#Utendaji
Maelezo →
›
Ni nini transaction isolation levels?
Senior
#Hifadhidata
Maelezo →
›
Ni nini husababisha deadlocks na unazizuiaje?
Senior
#Hifadhidata
Maelezo →
›
Ni nini stored procedures na lini unapaswa kuzitumia?
Senior
#Hifadhidata
Maelezo →
›
Ni nini DDL, DML, DCL na TCL?
Senior
#Hifadhidata
Maelezo →
›
Ni zipi data types za kawaida za SQL na unazichaguaje?
Middle
#Hifadhidata
Maelezo →
›
Ni nini table partitioning?
Senior
#Utendaji
Maelezo →
