单选题Which of the following is a characteristic of a schema?（）AForeign key references cannot cross schema boundaries.BA DB2 user must be created before a schema with the same name can be created.CIf no schema is specified when an object is created, the default schema PUBLIC is used.DA schema enables the creation of multiple objects in a database without encountering namespace collisions.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
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.
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.
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.
Which of the following describes the objects of a DB2 database and their relationships?() A.InstanceB.Table spaceC.System catalogD.Schema repository
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.
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.
Which of the following describes the objects of a DB2 database and their relationships?（）A、InstanceB、Table spaceC、System catalogD、Schema repository
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.
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.
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、 LGWRB、 DBWRC、 MMOND、 RVWR
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.
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.
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 agoB、 when the table EMP of the SCOTT schema was dropped by mistake 15 minutes agoC、 when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes agoD、 when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutesE、 never， because FLASHBACK TABLE is not a valid command in Oracle 10g.
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 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.
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.
单选题Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）AAn error is generated.BYou will have two identical tables in the HR schema with different names.CYou create a table called employees in the HR schema based on you EMP table.DYou create an alternative name for the employees table in the HR schema in your own schema.
单选题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;（）AYou obtain the results retrieved from the public synonym HR created by the database administrator.BYou obtain the results retrieved from the HR table that belongs to your schema.CYou get an error message because you cannot retrieve from a table that has the same name as a public synonym.DYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.EYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
单选题Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）AEXECUTE_CATALOG_ROLEBCONNECTCRESOURCEDRECOVERY_CATALOG_OWNERERECOVERY_CATALOG_USER
多选题In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；Awhen the schema of the user， SCOTT， was deleted by mistake 15 minutes agoBwhen the table EMP of the SCOTT schema was dropped by mistake 15 minutes agoCwhen some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes agoDwhen some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutesEnever， because FLASHBACK TABLE is not a valid command in Oracle 10g.
单选题Which describes the default behavior when you create a table? （）AThe table is accessible to all users.BTables are created in the public schema.CTables are created in your schema.DTables are created in the DBA schema.EYou must specify the schema when the table is created.
单选题Which of the following is a characteristic of a schema?（）AForeign key references cannot cross schema boundaries.BA DB2 user must be created before a schema with the same name can be created.CIf no schema is specified when an object is created, the default schema PUBLIC is used.DA schema enables the creation of multiple objects in a database without encountering namespace collisions.
单选题What is true about sequences? （）AOnce created, a sequence belongs to a specific schema.BOnce created, a sequence is linked to a specific table.COnce created, a sequence is automatically available to all users.DOnly the DBA can control which sequence is used by a certain table.EOnce created, a sequence is automatically used in all INSERT and UPDATE statements.
单选题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？（）AYou can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.BYou can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.CYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.DYou 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.
单选题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.
单选题You are granted the CREATE VIEW privilege. What does this allow you to do?（）ACreate a table view.BCreate a view in any schema.CCreate a view in your schema.DCreate a sequence view in any schema.ECreate a view that is accessible by everyone.FCreate a view only of it is based on tables that you created.
单选题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 LGWRB DBWRC MMOND RVWR