GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

Oracle Database 12c SQL Fundamentals

Jose Daniel SAAVEDRA TORO 7 Fragen

Quiz starten

Fragen in diesem 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.jpgBild zu Frage 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?    Bild zu Frage 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?Bild zu Frage 4
    1. AALTER
    2. BEXECUTE
    3. CREFERENCES
    4. DBACKUP ANY TABLE
  5. 5Which privilege is an object privilege? Bild zu Frage 5
    1. ACREATE INDEX
    2. BDROP USER
    3. CCREATE SESSION
    4. DSELECT ANY TABLE
  6. 66Bild zu Frage 6
    1. Aa
    2. Bb
  7. 7abc
    1. Aa
    2. Bb
    3. Cc

Informationen

Beschreibung
Ingeniería Quiz am Oracle Database 12c SQL Fundamentals, erstellt von Jose Daniel SAAVEDRA TORO am 16/10/2018.
Sprache
Español
Aufrufe
1
Schlagwörter
ingeniería
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck