单选题Which of the following is a characteristic of a schema?（）A Foreign key references cannot cross schema boundaries.B A DB2 user must be created before a schema with the same name can be created.C If no schema is specified when an object is created, the d

题目
单选题
Which of the following is a characteristic of a schema?（）
A

Foreign key references cannot cross schema boundaries.

B

A DB2 user must be created before a schema with the same name can be created.

C

If no schema is specified when an object is created, the default schema PUBLIC is used.

D

A schema enables the creation of multiple objects in a database without encountering namespace collisions.

相似考题

1.Which of the following is not responsibility of DBA(Data Base Administrator)?A．Database management system designB．Database schema definitionC．Database schema modificationD．Integrity constraint specification

2.View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）A. The second user‘s session immediately produces the resource busy error.B. The second user‘s command executes successfully.C. The second user‘s session waits for a time period before producing the resource busy error.D. A deadlock is created.

3.Which of the following is a characteristic of a schema?()A.Foreign key references cannot cross schema boundaries.B.A DB2 user must be created before a schema with the same name can be created.C.If no schema is specified when an object is created, the default schema PUBLIC is used.D.A schema enables the creation of multiple objects in a database without encountering namespace collisions.

4.You are granted the CREATE VIEW privilege. What does this allow you to do? ()A. Create a table view.B. Create a view in any schema.C. Create a view in your schema.D. Create a sequence view in any schema.E. Create a view that is accessible by everyone.F. Create a view only of it is based on tables that you created.

更多“单选题Which of the following is a characteristic of a schema?（）A Foreign key references cannot cross schema boundaries.B A DB2 user must be created before a schema with the same name can be created.C If no schema is specified when an object is created, the d”相关问题

  • 第1题：

    Which of the following describes the objects of a DB2 database and their relationships?()

    A.Instance

    B.Table space

    C.System catalog

    D.Schema repository


    参考答案：C

  • 第2题：

    Which of the following is a characteristic of a schema?（）

    • A、Foreign key references cannot cross schema boundaries.
    • B、A DB2 user must be created before a schema with the same name can be created.
    • C、If no schema is specified when an object is created, the default schema PUBLIC is used.
    • D、A schema enables the creation of multiple objects in a database without encountering namespace collisions.

    正确答案:D

  • 第3题：

    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

    • A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
    • B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
    • C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
    • D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

    正确答案:B

  • 第4题：

    You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）

    • A、 LGWR
    • B、 DBWR
    • C、 MMON
    • D、 RVWR

    正确答案:D

  • 第5题：

    Which describes the default behavior when you create a table?（）

    • A、The table is accessible to all users.
    • B、Tables are created in the public schema.
    • C、Tables are created in your schema.
    • D、Tables are created in the DBA schema.
    • E、You must specify the schema when the table is created.

    正确答案:C

  • 第6题：

    You are granted the CREATE VIEW privilege. What does this allow you to do?（）

    • A、Create a table view.
    • B、Create a view in any schema.
    • C、Create a view in your schema.
    • D、Create a sequence view in any schema.
    • E、Create a view that is accessible by everyone.
    • F、Create a view only of it is based on tables that you created.

    正确答案:C

  • 第7题：

    Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）

    • A、An error is generated.
    • B、You will have two identical tables in the HR schema with different names.
    • C、You create a table called employees in the HR schema based on you EMP table.
    • D、You create an alternative name for the employees table in the HR schema in your own schema.

    正确答案:D

  • 第8题：

    单选题
    The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）
    A

    You obtain the results retrieved from the public synonym HR created by the database administrator.

    B

    You obtain the results retrieved from the HR table that belongs to your schema.

    C

    You get an error message because you cannot retrieve from a table that has the same name as a public synonym.

    D

    You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.

    E

    You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.


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

  • 第9题：

    多选题
    In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；
    A

    when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago

    B

    when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago

    C

    when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago

    D

    when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes

    E

    never， because FLASHBACK TABLE is not a valid command in Oracle 10g.


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

  • 第10题：

    单选题
    Which of the following is a characteristic of a schema?（）
    A

    Foreign key references cannot cross schema boundaries.

    B

    A DB2 user must be created before a schema with the same name can be created.

    C

    If no schema is specified when an object is created, the default schema PUBLIC is used.

    D

    A schema enables the creation of multiple objects in a database without encountering namespace collisions.


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

  • 第11题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin.  Which statement is correct？（）
    A

    You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    B

    You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

    C

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.

    D

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of  the recycle bin are purged every 12 hours by default.


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

  • 第12题：

    单选题
    You are granted the CREATE VIEW privilege. What does this allow you to do?（）
    A

    Create a table view.

    B

    Create a view in any schema.

    C

    Create a view in your schema.

    D

    Create a sequence view in any schema.

    E

    Create a view that is accessible by everyone.

    F

    Create a view only of it is based on tables that you created.


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

  • 第13题：

    Which of the following is TRUE when creating a file system that resides on the center of a disk?（）

    • A、The logical volume is created first.
    • B、The physical volume will be automatically created.
    • C、The physical partition must be specified as an option.
    • D、The file system will be mounted during the time of creation.

    正确答案:A

  • 第14题：

    Which of the following describes the objects of a DB2 database and their relationships?（）

    • A、Instance
    • B、Table space
    • C、System catalog
    • D、Schema repository

    正确答案:C

  • 第15题：

    What is true about sequences? （）

    • A、Once created, a sequence belongs to a specific schema.
    • B、Once created, a sequence is linked to a specific table.
    • C、Once created, a sequence is automatically available to all users.
    • D、Only the DBA can control which sequence is used by a certain table.
    • E、Once created, a sequence is automatically used in all INSERT and UPDATE statements.

    正确答案:A

  • 第16题：

    The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）

    • A、You obtain the results retrieved from the public synonym HR created by the database administrator.
    • B、You obtain the results retrieved from the HR table that belongs to your schema.
    • C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
    • D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
    • E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

    正确答案:B

  • 第17题：

    In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；

    • A、 when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago
    • B、 when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
    • C、 when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
    • D、 when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
    • E、 never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

    正确答案:C,D

  • 第18题：

    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

  • 第19题：

    单选题
    Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）
    A

    An error is generated.

    B

    You will have two identical tables in the HR schema with different names.

    C

    You create a table called employees in the HR schema based on you EMP table.

    D

    You create an alternative name for the employees table in the HR schema in your own schema.


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

  • 第20题：

    单选题
    Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）
    A

    EXECUTE_CATALOG_ROLE

    B

    CONNECT

    C

    RESOURCE

    D

    RECOVERY_CATALOG_OWNER

    E

    RECOVERY_CATALOG_USER


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

  • 第21题：

    单选题
    Which describes the default behavior when you create a table? （）
    A

    The table is accessible to all users.

    B

    Tables are created in the public schema.

    C

    Tables are created in your schema.

    D

    Tables are created in the DBA schema.

    E

    You must specify the schema when the table is created.


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

  • 第22题：

    单选题
    What is true about sequences? （）
    A

    Once created, a sequence belongs to a specific schema.

    B

    Once created, a sequence is linked to a specific table.

    C

    Once created, a sequence is automatically available to all users.

    D

    Only the DBA can control which sequence is used by a certain table.

    E

    Once created, a sequence is automatically used in all INSERT and UPDATE statements.


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

  • 第23题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）
    A

     You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.

    B

     You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    C

     You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.

    D

     You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.


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

  • 第24题：

    单选题
    You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）
    A

     LGWR

    B

     DBWR

    C

     MMON

    D

     RVWR


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

相关内容