You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （） You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）

A、A. You get an error because of a primary key violation.

B、B. The data and structure of the EMPLOYEES table are deleted.

C、C. The data in the EMPLOYEES table is deleted but not the structure.

D、D. You get an error because the statement is not syntactically correct.

查看正确答案

更多“You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （） You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）”相关的问题

第1题

[单选题] 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.

点击查看答案

第2题

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

点击查看答案

第3题

[单选题] You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）

A、You get an error because of a primary key violation. B、The data and structure of the EMPLOYEES table are deleted. C、The data in the EMPLOYEES table is deleted but not the structure. D、You get an error because the statement is not syntactically correct.

点击查看答案

第4题

[多选题] What are two reasons to create synonyms? （）

A、You have too many tables. B、Your tables are too long. C、Your tables have difficult names. D、You want to work on your own tables. E、You want to use another schema's tables. F、You have too many columns in your tables.

点击查看答案

第5题

[多选题] What are two reasons to create synonyms? （）

点击查看答案

第6题

[多选题] What are two reasons to create synonyms?（）

点击查看答案

第7题

[] What are two reasons to create synonyms? （）

A、A. You have too many tables. B、B. Your tables are too long. C、C. Your tables have difficult names. D、D. You want to work on your own tables. E、E. You want to use another schema's tables. F、F. You have too many columns in your tables.

点击查看答案

第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;（） 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.

点击查看答案

第9题

[单选题] 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?（）

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.

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

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