GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

oracle

Zhansaya Adyrbek 94 questions

Take the quiz

Questions in this 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.Image for question 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, 4Image for option A
    2. BImage for option B
    3. CImage for option C
    4. DImage for option 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.Image for question 2
    1. AImage for option A
    2. BImage for option B
    3. CImage for option C
    4. DImage for option 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. AImage for option A
    2. BImage for option B
    3. CImage for option C
    4. DImage for option 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. BImage for option B
    3. CImage for option C
    4. DImage for option D
    5. EImage for option E
  5. 5How to get this result?Image for question 5
    1. AImage for option A
    2. BImage for option B
    3. CImage for option C
    4. DImage for option 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 returnsImage for question 6
    1. AImage for option A
    2. BImage for option B
    3. CImage for option C
    4. DImage for option 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 ofImage for question 8
    1. AImage for option A
    2. BImage for option B
    3. CImage for option 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;Image for option D
  9. 9which rank?Image for question 9
    1. AImage for option A
    2. BImage for option B
    3. CImage for option C
    4. DImage for option 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

Information

Description
Quiz on oracle, created by Zhansaya Adyrbek on 30/05/2018.
Language
English
Views
7
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?