单选题Which one is a system privilege? （）A SELECTB DELETEC EXECUTED ALTER TABLEE CREATE TABLE

题目
单选题
Which one is a system privilege? （）
A

SELECT

B

DELETE

C

EXECUTE

D

ALTER TABLE

E

CREATE TABLE

相似考题

1.Which one is a system privilege? ()A. SELECTB. DELETEC. EXECUTED. ALTER TABLEE. CREATE TABLE

2._______control system is one in which the control action is independent of the output.A.Feed backB.Negative feed backC.Close loopD.Open loop

3.Which statement about using McAfee and Webroot together is true？（） A、it is not recommended： the system will not detect more malwareB、it is notpossible ： the WSA will accept only one anti-malware licenseC、the system will stop all web-based threatsD、it is recommended： the system will detect more malware

4.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.

更多“Which one is a system privilege? （）”相关问题

  • 第1题：

    When configuring more than one archival site, which statement is true?（）

    • A、The system will first attempt the transfer using the URL configured last
    • B、The system will transfer the configuration to each archival site
    • C、The system will not transfer to a secondary site unless the previous site fails
    • D、The system will transfer using secure copy protocl (SCP) before attempting FTP

    正确答案:C

  • 第2题：

    For the following attempts， which one is to ensure that no one employee becomes a pervasive securitythreat， that data can be recovered from backups， and that information system changes do not compromisea system’s security？（）

    • A、Strategic security planning
    • B、Disaster recovery
    • C、Implementation security
    • D、Operations security

    正确答案:D

  • 第3题：

    On which of the following database objects may the SELECT privilege be controlled?（）

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

    正确答案:D

  • 第4题：

    Which one is a system privilege?（）

    • A、SELECT
    • B、DELETE
    • C、EXECUTE
    • D、ALTER TABLE
    • E、CREATE TABLE

    正确答案:E

  • 第5题：

    多选题
    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
    解析： 暂无解析

  • 第6题：

    单选题
    Which of the following hydraulic systems is not one of the three sub-division of the Hydraulic drive system?（）
    A

    Constant pressure system

    B

    Variable pressure system

    C

    Variable displacement system

    D

    Constant volume system


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

  • 第7题：

    单选题
    Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）
    A

    The table created by SKD isnot accessibleand SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

  • 第8题：

    单选题
    Which one is a system privilege?（）
    A

    SELECT

    B

    DELETE

    C

    EXECUTE

    D

    ALTER TABLE

    E

    CREATE TABLE


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

  • 第9题：

    单选题
    Which option is best practice for creating a recovery catalog owner in the catalog database?（）
    A

    Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

    B

    Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

    C

    Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user

    D

    Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user


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

  • 第10题：

    单选题
    When configuring more than one archival site, which statement is true?（）
    A

    The system will first attempt the transfer using the URL configured last

    B

    The system will transfer the configuration to each archival site

    C

    The system will not transfer to a secondary site unless the previous site fails

    D

    The system will transfer using secure copy protocl (SCP) before attempting FTP


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

  • 第11题：

    单选题
    Which statement about using McAfee and Webroot together is true？（）
    A

    it is not recommended： the system will not detect more malware

    B

    it is notpossible ： the WSA will accept only one anti-malware license

    C

    the system will stop all web-based threats

    D

    it is recommended： the system will detect more malware


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

  • 第12题：

    单选题
    （） control system is one in which the control action is independent of the output.
    A

    Feed back

    B

    Negative feed back

    C

    Close loop

    D

    Open loop


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

  • 第13题：

    The database users are connecting to the PROD database from different  applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one.  Which action would you take to achieve this objective？（）

    • A、set the SESSIONS to 1 in the parameter file
    • B、grant SINGLE SESSION privilege to all of the users
    • C、set the SESSIONS_PER_USER to 1 in the users’ profile
    • D、grant RESTRICTED SESSION privilege to all of the database users
    • E、create a role with SINGLE SESSION privilege and assign the role to the users

    正确答案:C

  • 第14题：

    Which of the following MOST likely causes problems with SCSI communication?（）

    • A、Low communication latency
    • B、Maximum drive capacity is exceeded
    • C、Improper termination
    • D、Too many SCSI devices on one system

    正确答案:C

  • 第15题：

    A System p distribution customer is very concerned about Reliability， Availability and  Serviceability （RAS）. They are planning to install several p6 servers in their facilities and want to be able to move an LPAR from one System p to another.  Which of the following would accomplish this（）

    • A、System p servers using similar SAN storage
    • B、System p servers must share an HMC
    • C、System p servers must have the same level HMC
    • D、System p servers with VIOS

    正确答案:B

  • 第16题：

    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.

    正确答案:A,C,E

  • 第17题：

    单选题
    The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）
    A

    set the SESSIONS to 1 in the parameter file

    B

    grant SINGLE SESSION privilege to all of the users

    C

    set the SESSIONS_PER_USER to 1 in the users’ profile

    D

    grant RESTRICTED SESSION privilege to all of the database users

    E

    create a role with SINGLE SESSION privilege and assign the role to the users


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

  • 第18题：

    单选题
    Which of the following MOST likely causes problems with SCSI communication？（）
    A

     Low communication latency

    B

     Maximum drive capacity is exceeded

    C

     Improper termination

    D

     Too many SCSI devices on one system


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

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    Which option is best practice for creating a recovery catalog owner in the catalog database？（）
    A

     Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

    B

     Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

    C

     Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user

    D

     Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user


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

  • 第21题：

    单选题
    Which space(s) on your cargo vessel must have a fire detection system?（）
    A

    Any compartment containing explosives

    B

    Any compartment adjacent to one containing explosives

    C

    Enclosed spaces which are specially suitable for vehicles

    D

    All of the above


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

  • 第22题：

    单选题
    Which one of the following commands can be used to enable AAA authentication to determine if a user canaccess the privilege command level？（）
    A

    aaa authentication enable method default

    B

    aaa authentication enable default

    C

    aaa authentication enable level

    D

    aaa authentication enable default local


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

  • 第23题：

    单选题
    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）
    A

    The table created by SKD is not accessible and SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

相关内容