搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition:<br /> Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）

A、The valid time columns employee_time_start and employee_time_end are automatically created.

B、The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C、The valid time columns are not populated by the Oracle Server automatically.

D、The valid time columns are visible by default when the table is described.

E、Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio

查看正确答案
更多“ You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition:<br /> Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）”相关的问题
第1题
[单选题] 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.  

点击查看答案
第2题
[单选题] 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.  

点击查看答案
第3题
[单选题] 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.  

点击查看答案
第4题
[单选题] 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.  

点击查看答案
第5题
[单选题] 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.  

点击查看答案
第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.  

点击查看答案
第7题
[] You want to create a temporary table while executing a procedure in a form. Which statement is true?（）

A、A.You cannot create a table form within Forms.   B、B.You must use the FORMS_DDL built-in to create the table.   C、C.You must use the DBMS_DYNAMIC_DDL package to create the table.   D、D.You can write the CREATE TABLE statement directly into the trigger.  

点击查看答案
第8题
[] You are granted the CREATE VIEW privilege. What does this allow you to do?（）

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

点击查看答案
第9题
[] You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（） You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）

A、A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;  B、B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;  C、C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***  

点击查看答案
第10题
[] 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;（） 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、A. You obtain the results retrieved from the public synonym HR created by the database administrator.  B、B. You obtain the results retrieved from the HR table that belongs to your schema.  C、C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.  D、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、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.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服