O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

Oracle Database 12c SQL Fundamentals

Jose Daniel SAAVEDRA TORO 7 perguntas

Fazer o quiz

Perguntas do 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.jpgImagem da pergunta 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?    Imagem da pergunta 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?Imagem da pergunta 4
    1. AALTER
    2. BEXECUTE
    3. CREFERENCES
    4. DBACKUP ANY TABLE
  5. 5Which privilege is an object privilege? Imagem da pergunta 5
    1. ACREATE INDEX
    2. BDROP USER
    3. CCREATE SESSION
    4. DSELECT ANY TABLE
  6. 66Imagem da pergunta 6
    1. Aa
    2. Bb
  7. 7abc
    1. Aa
    2. Bb
    3. Cc

Informações

Descrição
Ingeniería Quiz sobre Oracle Database 12c SQL Fundamentals, criado por Jose Daniel SAAVEDRA TORO em 16-10-2018.
Idioma
Español
Visualizações
1
Etiquetas
ingeniería
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?