Guide-yakabatana mibvunzo · Pakati Nhanho

Maitiro ekunyora SQL Window Mabasa neAI Quiz

Tarisa SQL windows partitions, zvisungo zvekuisa uye anomhanya-akazara mafuremu ane mienzaniso yekutenga, misi isipo uye ichangoburwa-chiitiko kusarudzwa.

Nzira dzekutungamira dzinoenderanaSql Window Inoshanda neAI
Mubvunzo 1 ye 8

Pakutenga kwakaodha kwe5, 7 uye 4, ndedzipi mutsara-ne-mutsara dzinomhanya dzinoenderana nefuremu yegwaro?

Tarisa mubvunzo wese8 mibvunzo

Mhinduro uye tsananguro zvinoonekwa paunenge uchitora bvunzo.

  1. Pakutenga kwakaodha kwe5, 7 uye 4, ndedzipi mutsara-ne-mutsara dzinomhanya dzinoenderana nefuremu yegwaro?
    • 5, 7uye 4
    • 5, 12 uye 16
    • 16, 16 uye 16
    • 5, 14 uye 12
  2. Pakudzika zvibodzwa 100, 100 ne90, ndeipi inotevedzana inoburitswa neRANK?
    • 1, 2 uye 3
    • 1, 1 uye 2
    • 2, 2 uye 3
    • 1, 1 uye 3
  3. Nderipi basa rinopa zvibodzwa zvakasungwa 100, 100 uye 90 nhanho 1, 1 uye 2?
    • DENSE_RANK
    • ROW_NUMBER
    • RANK
    • LAG
  4. Muvhunzo wechiitiko uchangoburwa unoshandisa ROW_NUMBER yakarongedzwa chete nechitambi chenguva chakagovaniswa nezviitiko zviviri. Chii chinodiwa pasarudzo inofanotaurwa pakati pavo?
    • Bvisa chikamu cheakaundi
    • Tsiva chigumisiro chekupedzisira neisina kukodzera DISTINCT
    • Wedzera yakakodzera tie-breaker kurodha yehwindo
    • Fungidzira odha yekuisa inogadzirisa tie yese
  5. Sei LAG yekutengesa kwemazuva ese ichitadza kumiririra kutengesa nezuro?
    • LAG inogara ichireva mutsara wekutanga wetafura yese
    • Mutsara wakare wakarekodhwa unogona kuparadzaniswa nemazuva asipo
    • LAG inozvibatanidza mazuva ese mumwedzi mumwe
    • Basa racho rinotsiva mazuva asipo ne zero
  6. An ORDER BY inowanikwa mukati OVER. Chii chichiri kudikanwa kana yekupedzisira yakaratidzwa mhedzisiro ichifanira kuve neyakatarwa?
    • Chete CHIKAMU BY chine koramu imwechete
    • Chete ROWS furemu inoshandisa iyo imwechete yekurongeka koramu
    • Hapana imwe clause nekuti kuodha kwehwindo kunovimbisa kuratidza kurongeka
    • Yekupedzisira ORDER BY yemhinduro yemubvunzo
  7. Sei munhu anotyora tie asingawedzerwe zvisina tsarukano kuRANK kana zvibodzwa zvakaenzana zvichifanira kugovera chinzvimbo?
    • Inogona kushandura mitsara iri vezera uye saka shandura yakasungwa mitsara
    • Inosiya nhengo yevezera isina kuchinjika nekuti iyo yekutanga yekuodha koramu ndiyo inonyanya kukosha
    • Inoshandura chete yekupedzisira kuratidza kurongeka uye kwete iyo hwindo kuverenga
    • Iyo inochengetedza yakaenzana-nhamba-yepakati apo ichiita otomatiki nhamba dzemitsara yavo kufungidzira
  8. MuPostgreSQL, ungaite sei mitsara yekusefa uchishandisa kukosha kwehwindo kuverengerwa mukati SELECT?
    • Shandisa kukosha ikoko mune imwechete SELECT's WHERE pasina imwe nhanho yemubvunzo
    • Tsiva OVER neGROUP BY mune zvese
    • Sefa mumubvunzo wekunze kana mataurirwo etafura
    • Fungidzira kuti dhatabhesi yega yega inotsigira yakafanana QUALIFY clause