Guide-yakabatana mibvunzo · Pakati Nhanho

Maitiro ekunyora SQL CTEs uye Subqueries neAI Quiz

Tarisa CTE chiyero, EXISTS uye scalar subqueries, uye inodzokorodza-mubvunzo chengetedzo kuburikidza nemishumo yevatengi uye madiki emhando mienzaniso.

Nzira dzekutungamira dzinoenderanaSql Ctes uye Subqueries neAI
Mubvunzo 1 ye 8

A SELECT CTE inonzi customer_totals inotsanangurwa na WITH. Mubairo iwoyo wakajairika uripo kwenguva yakareba sei?

Tarisa mubvunzo wese8 mibvunzo

Mhinduro uye tsananguro zvinoonekwa paunenge uchitora bvunzo.

  1. A SELECT CTE inonzi customer_totals inotsanangurwa na WITH. Mubairo iwoyo wakajairika uripo kwenguva yakareba sei?
    • Kusvikira iyo database server inotevera inotangazve
    • Mukati mechirevo chikuru chinochitsanangura
    • Kusvikira murairo weDROP TABLE wakasiyana waubvisa
    • Mumubvunzo wese weramangwana mune imwechete application
  2. Mutengi ane maodha matatu anokodzera. Ko chimiro che EXISTS chinokanganisa sei mutsara wekunze wemutengi uyo?
    • Iyo inongogadzira makopi matatu ekubuda
    • Inowedzera zvitatu kune yese yevatengi vese
    • Inokundikana nekuti inopfuura mutsara mumwe wemukati uripo
    • Inoedza chokwadi pasina kuwanza mutsara nekuda kwemachisi iwayo
  3. A PostgreSQL scalar subquery isingatarisirwe inodzosa mitsara miviri. Ndeipi mhinduro inochengetedza mutemo wekusarudza une musoro?
    • Tsanangurai uye shandisai kukosha kumwe chete kunofanira kudzoka mubvunzo
    • Wedzera isina kurongeka LIMIT kungodzvinyirira kukanganisa
    • Fungidzira PostgreSQL inogara ichisarudza yazvino mutsara
    • Chinja chinobuda alias uye siya subquery isina kuchinjika
  4. Sei mutengi_totals CTE ichifanira kuongororwa isati yajoinha kune ruzivo rwevatengi?
    • Iro zita reCTE rinosimbisa kuti kiyi yega yega yevatengi yakasarudzika
    • Aggregate mukati meCTE haigone kuburitsa akadzokororwa makiyi evatengi
    • Makiyi emutengi asingatarisirwe akadzokororwa anogona kuwanza mhedzisiro inotevera
    • Kutarisa chete yekupedzisira mutsara kuverenga kunosimbisa yega yega yepakati mhedzisiro tsanga
  5. Iyo AI inoti kutsiva yega subquery neCTE inogara ichivandudza mashandiro. Izvi zvinofanira kuongororwa sei?
    • Gamuchira nekuti nhanho dzakapihwa dzinogara dzichiita kamwe chete
    • Tarisa maitiro ejini inonangwa uye hurongwa hwekuita
    • Zvigamuchire nekuti mubvunzo mupfupi unogara uchida basa shoma
    • Ramba CTE yega yega nekuti inofanirwa kugara ichigadzirwa
  6. Nei UNION ingatadza kumisa kutenderera kutenderera kana yakadzika mbiru ichichinja pakushanya kwega kwega?
    • UNION inochengetedza zvese zvakapetwa netsanangudzo
    • Makolamu akadzama anodzivirira chero mubvunzo unodzokororwa kushanda
    • Kutenderera kunogona kuitika chete mumibvunzo uchishandisa UNION ALL
    • Kushanya kwakadzokororwa kunogona kuramba kwakasiyana mitsara yemhedzisiro nekuti kudzika kwayo kunosiyana
  7. A correlated subquery inoreva kukosha kwekunze. Ndechipi chikumbiro chekuita chingave chisati chasvika pasina humbowo hwehurongwa?
    • Inofanirwa kudzokorodza muvhunzo uzere wakazvimiririra wemutsetse wega wega wekunze
    • Mhedzisiro yaro zvine musoro zvinoenderana nehukoshi hwekunze
    • An optimizer inogona kushandura kutaura kwakakodzera
    • Hunhu hwayo hunofanira kuongororwa pane data remumiriri
  8. Sei zvigadziriso zvisina-isina zvigadziriso zvichishandiswa kana uchinyorazve ZVINO ZVAKAWANDA?
    • Nulls inogara ichiita seyakajairwa yakaenzana tsika
    • NOT IN inofuratira chimwe chinhu chisina maturo mukuenzanisa kwayo
    • Nulls inogona kushandura mhedzisiro yechokwadi chemamiriro uye maitiro ekunyorazve
    • Kuwedzera CTE kunobvisa otomatiki misiyano ine hukama