单选题Which object privileges can be granted on a view?（）A noneB DELETE, INSERT,SELECTC ALTER, DELETE, INSERT, SELECTD DELETE, INSERT, SELECT, UPDATE

题目
单选题
Which object privileges can be granted on a view?（）
A

none

B

DELETE, INSERT,SELECT

C

ALTER, DELETE, INSERT, SELECT

D

DELETE, INSERT, SELECT, UPDATE

相似考题

1.Which two statements accurately describe a role? ()A. A role can be given to a maximum of 1000 users.B. A user can have access to a maximum of 10 roles.C. A role can have a maximum of 100 privileges contained in it.D. Privileges are given to a role by using the CREATE ROLE statement.E. A role is a named group of related privileges that can be granted to the user.F. A user can have access to several roles, and several users can be assigned the same role.

2.Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?()A. System privileges apply only to the PDB in which they are used.B. Local users cannot use local system privileges on the schema of a common user.C. The granter of system privileges must possess the set container privilege.D. Common users connected to a PDB can exercise privileges across other PDBs.E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

3.An Alias can be an alternate name for which DB2 object?()A.SequenceB.TriggerC.SchemaD.View

4.Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()A. USER_TAB_PRIVS_MADEB. USER_TAB_PRIVSC. USER_COL_PRIVS_MADED. USER_COL_PRIVS

更多“Which object privileges can be granted on a view?（）”相关问题

  • 第1题：

    Because objects（ ） data and implementation, the user of an object can view the object as a black box that provides services.

    A.encapsulate
    B.inherit
    C.connect
    D.refer

    答案：A
    解析：

  • 第2题：

    Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）

    • A、USER_TAB_PRIVS_MADE
    • B、USER_TAB_PRIVS
    • C、USER_COL_PRIVS_MADE
    • D、USER_COL_PRIVS

    正确答案:D

  • 第3题：

    Which two statements about views are true? （）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第4题：

    Your web application uses a simple architecture in which servlets handle requests and then forward to aJSP using a request dispatcher. You need to pass information calculated in the servlet to the JSP for view generation.This information must NOT be accessible to any other servlet，JSP or session in the webapp. Which two techniques can you use to accomplish this goal？（）

    • A、Add attributes to the session object.
    • B、Add attributes on the request object.
    • C、Add parameters to the request object.
    • D、Use the pageContext object to add request attributes.
    • E、Add parameters to the JSP’s URL when generating the request dispatcher.

    正确答案:B,E

  • 第5题：

    Which two statements are true about the roles in the Oracle database？（）

    • A、A role can be granted to itself.
    • B、Roles are owned by the SYS user.
    • C、Roles can be granted to other roles.
    • D、A role cannot be assigned external authentication.
    • E、A role can contain both system and object privileges.

    正确答案:C,E

  • 第6题：

    单选题
    What is true about the WITH GRANT OPTION clause?（）
    A

    It allows a grantee DBA privileges.

    B

    It is required syntax for object privileges.

    C

    It allows privileges on specified columns of tables.

    D

    It is used to grant an object privilege on a foreign key column.

    E

    It allows the grantee to grant object privileges to other users and roles.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    多选题
    Which of the following approval member groups can an organization administrator grant privileges to？（）
    A

    ApprovalGroup

    B

    Order Process

    C

    User Group

    D

    User Registration

    E

    AccessGroup


    正确答案： E,A
    解析： 暂无解析

  • 第8题：

    单选题
    Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）
    A

    USER_TAB_PRIVS_MADE

    B

    USER_TAB_PRIVS

    C

    USER_COL_PRIVS_MADE

    D

    USER_COL_PRIVS


    正确答案： C
    解析： 暂无解析

  • 第9题：

    多选题
    An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）
    A

    You can conned as a common user by using the connect statement.

    B

    You can connect as a local user by using the connect statement.

    C

    You can connect by using easy connect.

    D

    You can connect by using OS authentication.

    E

    You can connect by using a Net Service name.

    F

    You can connect as a local user by using the SET CONTAINER statement.


    正确答案： C,D
    解析： 暂无解析

  • 第10题：

    单选题
    View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command： SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION；  Which statement is true about the user SKD afterhe/she is granted this role（）
    A

    The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.

    B

    The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.

    C

    The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.

    D

    The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privilegesfrom them


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You have created a password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）
    A

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    B

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    C

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is

    D

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    多选题
    Your web application uses a simple architecture in which servlets handle requests and then forward to aJSP using a request dispatcher. You need to pass information calculated in the servlet to the JSP for view generation.This information must NOT be accessible to any other servlet，JSP or session in the webapp. Which two techniques can you use to accomplish this goal？（）
    A

    Add attributes to the session object.

    B

    Add attributes on the request object.

    C

    Add parameters to the request object.

    D

    Use the pageContext object to add request attributes.

    E

    Add parameters to the JSP’s URL when generating the request dispatcher.


    正确答案： C,B
    解析： 暂无解析

  • 第13题：

    An Alias can be an alternate name for which DB2 object?（）

    • A、Sequence
    • B、Trigger
    • C、Schema
    • D、View

    正确答案:D

  • 第14题：

    What is true about the WITH GRANT OPTION clause?（）

    • A、It allows a grantee DBA privileges.
    • B、It is required syntax for object privileges.
    • C、It allows privileges on specified columns of tables.
    • D、It is used to grant an object privilege on a foreign key column.
    • E、It allows the grantee to grant object privileges to other users and roles.

    正确答案:E

  • 第15题：

    Which of the following approval member groups can an organization administrator grant privileges to？（）

    • A、ApprovalGroup
    • B、Order Process
    • C、User Group
    • D、User Registration
    • E、AccessGroup

    正确答案:B,D

  • 第16题：

    You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）

    • A、An object type is a user-defined composite data type. 
    • B、The attributes of an object type can be those of other object types. 
    • C、A PL/SQL table of records is an example of a nested object type. 
    • D、An object type must be declared as a type before the actual object itself can be declared.

    正确答案:A,B,D

  • 第17题：

    多选题
    Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）
    A

    You can find information about only active transactions from the view

    B

    You can find information about read only transactions from the view

    C

    You require the SELECT ANY TRANSACTION system privilege to access the view

    D

    You can find information about both active and committed transactions from the view

    E

    You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view


    正确答案： A,D
    解析： 暂无解析

  • 第18题：

    单选题
    An Alias can be an alternate name for which DB2 object?（）
    A

    Sequence

    B

    Trigger

    C

    Schema

    D

    View


    正确答案： D
    解析： 暂无解析

  • 第19题：

    单选题
    Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES,DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced? （）
    A

    Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.

    B

    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.

    C

    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.

    D

    Scott cannot create a synonym because synonyms can be created only for tables.

    E

    Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.


    正确答案： E
    解析： 暂无解析

  • 第20题：

    多选题
    Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）
    A

    System privileges apply only to the PDB in which they are used.

    B

    Local users cannot use local system privileges on the schema of a common user.

    C

    The granter of system privileges must possess the set container privilege.

    D

    Common users connected to a PDB can exercise privileges across other PDBs.

    E

    System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.


    正确答案： C,A
    解析： 暂无解析

  • 第21题：

    单选题
    Which object privileges can be granted on a view? （）
    A

    none

    B

    DELETE, INSERT,SELECT

    C

    ALTER, DELETE, INSERT, SELECT

    D

    DELETE, INSERT, SELECT, UPDATE


    正确答案： C
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements are true about the roles in the Oracle database？（）
    A

    A role can be granted to itself.

    B

    Roles are owned by the SYS user.

    C

    Roles can be granted to other roles.

    D

    A role cannot be assigned external authentication.

    E

    A role can contain both system and object privileges.


    正确答案： A,C
    解析： 暂无解析

  • 第23题：

    多选题
    Which four types of object can be thrown using the throw statement？（）
    A

    Error

    B

    Event

    C

    Object

    D

    Exception

    E

    Throwable

    F

    Runtime Exception


    正确答案： E,A
    解析： 暂无解析

  • 第24题：

    多选题
    Which two statements accurately describe a role?（）
    A

    A role can be given to a maximum of 1000 users.

    B

    A user can have access to a maximum of 10 roles.

    C

    A role can have a maximum of 100 privileges contained in it.

    D

    Privileges are given to a role by using the CREATE ROLE statement.

    E

    A role is a named group of related privileges that can be granted to the user.

    F

    A user can have access to several roles, and several users can be assigned the same role.


    正确答案： F,D
    解析： 暂无解析

相关内容