GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

oracle

Zhansaya Adyrbek 94 Fragen

Quiz starten

Fragen in diesem Quiz (94)

  1. 1For each combination of sex–town–year of birth, get the number of players; for each sex, get the number of players; and, finally, get the total number of players.Bild zu Frage 1
    1. ASELECT ROW_NUMBER() OVER () AS SEQNO, SEX, TOWN, YEAR(BIRTH_DATE), COUNT(*) FROM PLAYERS GROUP BY ROLLUP (SEX, (TOWN, YEAR(BIRTH_DATE))) ORDER BY 2, 3, 4Bild zu Antwort A
    2. BBild zu Antwort B
    3. CBild zu Antwort C
    4. DBild zu Antwort D
  2. 2Get the number of players for each combination of sex–town, for each sex and for each town, and also get the total number of players in the entire table.Bild zu Frage 2
    1. ABild zu Antwort A
    2. BBild zu Antwort B
    3. CBild zu Antwort C
    4. DBild zu Antwort D
    5. ESELECT ROW_NUMBER() OVER () AS SEQNO, SEX, TOWN, COUNT(*) FROM PLAYERS GROUP BY CUBE (SEX, TOWN) ORDER BY 2, 3
  3. 3What is the result of this code?

    SELECT ROW_NUMBER() OVER () AS SEQNO, SEX, TOWN, YEAR(BIRTH_DATE), COUNT(*) FROM PLAYERS GROUP BY ROLLUP (SEX, (TOWN, YEAR(BIRTH_DATE))) ORDER BY 2, 3, 4
    1. ABild zu Antwort A
    2. BBild zu Antwort B
    3. CBild zu Antwort C
    4. DBild zu Antwort D
  4. 4Which query executes a CUBE on column town, sex and team number after the two tables PLAYERS and TEAMS have been joined?
    1. ASELECT P.TOWN, P.SEX, M.TEAMNO, COUNT(*) FROM MATCHES AS M INNER JOIN PLAYERS AS P ON M.PLAYERNO = P.PLAYERNO GROUP BY CUBE (P.TOWN, P.SEX, M.TEAMNO) ORDER BY 1, 2, 3
    2. BBild zu Antwort B
    3. CBild zu Antwort C
    4. DBild zu Antwort D
    5. EBild zu Antwort E
  5. 5How to get this result?Bild zu Frage 5
    1. ABild zu Antwort A
    2. BBild zu Antwort B
    3. CBild zu Antwort C
    4. DBild zu Antwort D
    5. Eselect product_id, order_date,
      LEAD (order_date,1) over (ORDER BY order_date) AS next_order_date
      from orders;
  6. 6The query which returnsBild zu Frage 6
    1. ABild zu Antwort A
    2. BBild zu Antwort B
    3. CBild zu Antwort C
    4. DBild zu Antwort D
    5. ESELECT product_id, order_date,
      LEAD (order_date,1) OVER (PARTITION BY product_id ORDER BY order_date) AS next_order_date
      FROM orders;
  7. 7Difference between RANK and DENSE_RANK function?
    1. AThe rank function can cause non-consecutive rankings regradles to the values. Whereaes, the DENSE_RANK will always result in consecutive rankings
    2. BThe rank function can cause non-consecutive rankings if the tested values are the same. Whereaes, the DENSE_RANK will always result in consecutive rankings
    3. CThe dense_rank function can cause non-consecutive rankings if the tested values are the same. Whereaes, the RANK will always result in consecutive rankings
    4. DThe rank function can cause non-consecutive rankings if the tested values are different. Whereaes, the DENSE_RANK will always result in consecutive rankings
  8. 8The query which separates sets of running serial to emplyees ofBild zu Frage 8
    1. ABild zu Antwort A
    2. BBild zu Antwort B
    3. CBild zu Antwort C
    4. DSELECT empno, deptno, hiredate,
      ROW_NUMBER( ) OVER (PARTITION BY
      deptno ORDER BY hiredate
      NULLS LAST) SRLNO
      FROM emp
      WHERE deptno IN (10, 20)
      ORDER BY deptno, SRLNO;Bild zu Antwort D
  9. 9which rank?Bild zu Frage 9
    1. ABild zu Antwort A
    2. BBild zu Antwort B
    3. CBild zu Antwort C
    4. DBild zu Antwort D
  10. 10Use ________ to create an application, composed of a set of HTML pages, based on database objects in APEX
    1. AApplication Builder
    2. BTeam development
    3. CPackadged apps
    4. Dsql workshop

Informationen

Beschreibung
Quiz am oracle, erstellt von Zhansaya Adyrbek am 30/05/2018.
Sprache
English
Aufrufe
7
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck