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

Regístrate gratis

Test

Oracle Database 12c SQL Fundamentals

Jose Daniel SAAVEDRA TORO 7 preguntas

Hacer el test

Preguntas del test (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.jpgImagen de la pregunta 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?    Imagen de la pregunta 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?Imagen de la pregunta 4
    1. AALTER
    2. BEXECUTE
    3. CREFERENCES
    4. DBACKUP ANY TABLE
  5. 5Which privilege is an object privilege? Imagen de la pregunta 5
    1. ACREATE INDEX
    2. BDROP USER
    3. CCREATE SESSION
    4. DSELECT ANY TABLE
  6. 66Imagen de la pregunta 6
    1. Aa
    2. Bb
  7. 7abc
    1. Aa
    2. Bb
    3. Cc

Información

Descripción
Ingeniería Test sobre Oracle Database 12c SQL Fundamentals, creado por Jose Daniel SAAVEDRA TORO el 16/10/2018.
Idioma
Español
Visitas
1
Etiquetas
ingeniería
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?