¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

oracle

Zhansaya Adyrbek 94 preguntas

Hacer el test

Preguntas del test (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.Imagen de la pregunta 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, 4Imagen de la opción A
    2. BImagen de la opción B
    3. CImagen de la opción C
    4. DImagen de la opción 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.Imagen de la pregunta 2
    1. AImagen de la opción A
    2. BImagen de la opción B
    3. CImagen de la opción C
    4. DImagen de la opción 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. AImagen de la opción A
    2. BImagen de la opción B
    3. CImagen de la opción C
    4. DImagen de la opción 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. BImagen de la opción B
    3. CImagen de la opción C
    4. DImagen de la opción D
    5. EImagen de la opción E
  5. 5How to get this result?Imagen de la pregunta 5
    1. AImagen de la opción A
    2. BImagen de la opción B
    3. CImagen de la opción C
    4. DImagen de la opción 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 returnsImagen de la pregunta 6
    1. AImagen de la opción A
    2. BImagen de la opción B
    3. CImagen de la opción C
    4. DImagen de la opción 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 ofImagen de la pregunta 8
    1. AImagen de la opción A
    2. BImagen de la opción B
    3. CImagen de la opción 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;Imagen de la opción D
  9. 9which rank?Imagen de la pregunta 9
    1. AImagen de la opción A
    2. BImagen de la opción B
    3. CImagen de la opción C
    4. DImagen de la opción 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

Información

Descripción
Test sobre oracle, creado por Zhansaya Adyrbek el 30/05/2018.
Idioma
English
Visitas
7
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?