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

Sign up free

Quiz

Oracle Database 12c SQL Fundamentals

Jose Daniel SAAVEDRA TORO 7 questions

Take the quiz

Questions in this quiz (7)

  1. 1Which privilege can only be granted to a user and NOT to a role?https://cdn.goconqr.com/uploads/media/image/17626243/desktop_7e7fb99c-6a0c-404a-9977-da0e192a48ca.jpgImage for question 1
    1. AALTER
    2. BDELETE
    3. CINSERT
    4. DEXECUTE
    5. EREFERENCES
  2. 2Caroline, the database administrator, has created a role named (HumanResourcesInterns). The role has been granted the (UPDATE) privilege on the salary and Phone columns of the Employee table.

    After reviewing the new security procedures, Caroline must not allow the (HumanResourcesInterns) role to update the (Salary) column, but must still allow the role to update the (Phone) column of the (Employee) table.

    What should you run?    Image for question 2
    1. AREVOKE UPDATE (Salary) ON Employee TO HumanResourcesInterns;
    2. BREVOKE UPDATE ON Employee.Salary FROM HumanResourcesInterns;
    3. CREVOKE UPDATE (Salary) ON Employee TO HumanResourcesInterns CASCADE CONSTRAINTS;
    4. DREVOKE UPDATE ON Employee FROM HumanResourcesInterns;
      GRANT UPDATE (Phone) ON Employee TO HumanResourcesInterns;
    5. EREVOKE ALL ON Employee FROM HumanResourcesInterns;
      GRANT UPDATE ON Employee TO HumanResourcesInterns;
  3. 3Which of the following conditions would allow a use to grant (SELECT) privileges on the (customer) table to everyone using the (PUBLIC) keyword?
    1. AThe user owns the customer table.
    2. BThe user has been granted the PUBLIC privilege.
    3. CThe user has SELECT privileges on the customer table.
    4. DThe user has been granted the SELECT privilege with the PUBLIC OPTION.
  4. 4Which system privilege may be granted to a role?Image for question 4
    1. AALTER
    2. BEXECUTE
    3. CREFERENCES
    4. DBACKUP ANY TABLE
  5. 5Which privilege is an object privilege? Image for question 5
    1. ACREATE INDEX
    2. BDROP USER
    3. CCREATE SESSION
    4. DSELECT ANY TABLE
  6. 66Image for question 6
    1. Aa
    2. Bb
  7. 7abc
    1. Aa
    2. Bb
    3. Cc

Information

Description
Ingeniería Quiz on Oracle Database 12c SQL Fundamentals, created by Jose Daniel SAAVEDRA TORO on 16/10/2018.
Language
Español
Views
1
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?