Guide-yakabatana mibvunzo · Pakati Nhanho

Maitiro ekunzwisisa SQL Inobatana neAI Quiz

Dzidzira yemukati nekunze yekujoinha mhinduro, yakawanda-kune-yakawanda mitsara kuwanda uye kuisa mafirita uchishandisa mutengi mudiki uye odha mienzaniso.

Nzira dzekutungamira dzinoenderanaNzwisisa Sql Inobatana neAI
Mubvunzo 1 ye 8

Ada ane maoda maviri uye Ben haana. Mitsara mingani inobuda kubva kugwaro remutengi-ku-kuhodha kuruboshwe kujoina usati wawedzera kusefa?

Tarisa mubvunzo wese8 mibvunzo

Mhinduro uye tsananguro zvinoonekwa paunenge uchitora bvunzo.

  1. Ada ane maoda maviri uye Ben haana. Mitsara mingani inobuda kubva kugwaro remutengi-ku-kuhodha kuruboshwe kujoina usati wawedzera kusefa?
    • Vaviri, nekuti mirairo chete inoverengwa
    • Imwe, nekuti mazita evatengi akasiyana
    • Matatu, kusanganisira mutsara waBen usingaenzaniswi
    • Zvina, nekuti mutengi wese anowana mitsara miviri
  2. Mitsetse mitatu yekurongeka uye marekodhi maviri ekusimudzira anogovera kiyi yechigadzirwa. Mangani masanganiswa anoenderana ayo kuenzana kunojoinha pane iyo kiyi inogadzirwa?
    • Vatanhatu
    • Vashanu
    • Vatatu
    • Vaviri
  3. Chirevo chinofanirwa kunge chine mutsara mumwechete pamutengi, asi kujoinwa parizvino kunodzosera mutsara mumwe paodha. Chii chinofanira kujekeswa usati wagamuchira mubvunzo?
    • Kunyangwe kurongedza zvawanikwa nemutengi kunobvisa mamwe mitsara yekuodha
    • Kunyangwe kusarudza makoramu mashoma eodha chete anoshandura goho rezviyo
    • Kunyangwe kutumidzazve kiyi yemutengi kunoita kuti ive yakasarudzika mumhedzisiro yakabatanidzwa
    • Izvo zvakatarisirwa kubuda zviyo uye kuti data reodha rinofanira kuunganidzwa sei
  4. Kubatana kwekuruboshwe kunofanirwa kuchengetedza vatengi pasina maodha akatumirwa. Ndepapi mamiriro ekurambidza machisi kumaodha anotumirwa?
    • In a WHERE mamiriro anoramba ese asina maturo-kurudyi kukosha
    • Mune iyo ON mamiriro ayo anodzora maodha anowirirana
    • Chete mukupedzisira ORDER BY clause
    • Mukuita DISTINCT mushure mekunge maodha ese abatanidzwa
  5. Sei kuwedzera DISTINCT isiri gadziriso yakavimbika yehuwandu hwakakwira mushure mekujoinha kwevazhinji-kune-vazhinji?
    • DISTINCT inogadza mutsara mumwe pamutengi zvisinei kuti ndeapi makoramu akasarudzwa
    • DISTINCT inoita kuti imwe neimwe yejoin-kiyi kukosha ive yakasiyana kusati kwaitika
    • Inogona kuvanza zvakapetwa-inotaridzika pasina kugadzirisa kuenzanirana kana kuunganidza pfungwa
    • DISTINCT inovimbisa kuti aggregate yakaverengerwa mushure mekujoinha yakashandisa yega yega mari kamwechete
  6. Ndechipi chinongedzo chinochengetedza mitsetse isingaenzaniswi kubva kumatafura ese ekuisa?
    • Kubatana kwakazara kwekunze
    • Kubatana kwemukati
    • Kubatanidzwa kuruboshwe mune yega yega tafura yehurongwa
    • A self join zvisinei kuti ijoin type ipi
  7. Mushure mekubatana kwekuruboshwe, sei COUNT(*) ichigona kusiyana neCOUNT yeisiri-null-yerudyi identifier?
    • COUNT(*) inongoverengera vatengi vakasiyana
    • COUNT yeidentifier inosanganisira yese isina-yakawedzerwa mutsara
    • COUNT(*) inobvisa otomatiki makiyi ekubatanidza
    • COUNT(*) inosanganisira mitsara yekubuda isingaenzaniswi ukuwo nhamba yezviziviso isingasanganisire nulls
  8. Tsananguro yeAI inotora yakajairika kuenzana ichaenderana maviri asina kubatanidzwa-kiyi kukosha. Kudai ikoko kunofanira kubatwa sei?
    • Zvigamuchire nekuti mativi ese ane imwechete inoshaikwa-value marker
    • Igadzirise uchishandisa database's null semantics
    • Zvigamuchire nekuti kujoinwa kwekunze kunoshandura kuenzana kwekuenzanisa kunosanganisira null
    • Fungidzira makiyi maviri asina null anoenderana pese apo ese ari maviri masosi makoramu ane yakafanana data mhando