网友您好，请在下方输入框内输入要搜索的题目：

搜题

题目

[主观题]

Examine the data in the EMPLOYEES table.EMPLOYEESEMP_NAME DEPT_ID MGR_ID JOB_ID SALARYEMPL

OYEE_ID101 Smith 20 120 SA_REP 4000102 Martin 10 105 CLERK 2500103 Chris 20 120 IT_ADMIN 4200104 John 30 108 HR_CLERK 2500105 Diana 30 108 IT_ADMIN 5000106 Smith 40 110 AD.ASST 3000108 Jennifer 30 110 HR_DIR 6500110 Bob 40 EK_DIR 8000120 Revi 20 110 SA_DIR 6500On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.Evaluate this DELETE statement:DELETE employee_id, salary, job_idFROM employeesWHERE dept_id = 90;Why does the DELETE statement fail when you execute it？（）

A. There is no row with dept_id 90 in the EMPLOYEES table.

B. You cannot delete the JOB_ID column because it is a NOT NULL column.

C. You cannot specify column names in the DELETE clause of the DELETE statement.

D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

查看参考答案

更多“Examine the data in the EMPLOYEES table.EMPLOYEESEMP_NAME DEPT_ID MGR_ID JOB_ID SALARYEMPL”相关的问题

第1题

Examine the data in the EMPLOYEES table:Which three subqueries work？（）

Examine the data in the EMPLOYEES table:Which thre

A. Examine the data in the EMPLOYEES table:Which thre

B. Examine the data in the EMPLOYEES table:Which thre

C. Examine the data in the EMPLOYEES table:Which thre

D. Examine the data in the EMPLOYEES table:Which thre

E. Examine the data in the EMPLOYEES table:Which thre

F. Examine the data in the EMPLOYEES table:Which thre

点击查看答案

第2题

Examine the data of the EMPLOYEES table.EMPLOYEES （EMPLOYEE_ID is the primary key. MGR_ID

Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000？（）

Examine the data of the EMPLOYEES table.EMPLOYEES

A. Examine the data of the EMPLOYEES table.EMPLOYEES

B. Examine the data of the EMPLOYEES table.EMPLOYEES

C. Examine the data of the EMPLOYEES table.EMPLOYEES

D. Examine the data of the EMPLOYEES table.EMPLOYEES

E. Examine the data of the EMPLOYEES table.EMPLOYEES

点击查看答案

第3题

Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the ord

er ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders？（）

Examine the data from the ORDERS and CUSTOMERS tab

A. Examine the data from the ORDERS and CUSTOMERS tab

B. Examine the data from the ORDERS and CUSTOMERS tab

C. Examine the data from the ORDERS and CUSTOMERS tab

D. Examine the data from the ORDERS and CUSTOMERS tab

点击查看答案

第4题

186Methods and techniques used to examine cost and technical data are called feasibility s

186 Methods and techniques used to examine cost and technical data are called feasibility studies. The economic aspects of a feasibility study include interest rates, present worth factors, operating costs, depreciation and _____.

A. Capitalization costs.

B. Technical skill requirements.

C. Technology forecasting.

D. Strategic marketing intelligence.

E. All of the above

点击查看答案

第5题

104Methods and techniques used to examine cost and technical data are called feasibility s

104 Methods and techniques used to examine cost and technical data are called feasibility studies. The economic aspects of a feasibility study include interest rates, present worth factors, operating costs, depreciation and _____.

A. Capitalization costs.

B. Technical skill requirements.

C. Technology forecasting.

D. Strategic marketing intelligence.

E. All of the above.

点击查看答案

第6题

You are the administrator of a SQL Server 2000 computer. The server contains database name

d Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.

You are the administrator of a SQL Server 2000 com

You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.

You are the administrator of a SQL Server 2000 com

You want the users to be able to add data, and you want to minimize administrative overhead. What should you do？

A．Increase the maximum file size of Sales_Data to 1,500MB.

B．Use the DBCC SHRINKDATABASE statement.

C．Set automatic file growth to 10 percent.

D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.

点击查看答案

第7题

Examine the following RMAN script:Which statement describes the purpose of the script？（）

Examine the following RMAN script:Which statement

A. The data file is checked for physical corruption and backed up if found clean.

B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

点击查看答案

第8题

View the Exhibit and examine the Data Pump architecture. Identify the numbered components.（）

View the Exhibit and examine the Data Pump archite

A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API

B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader

C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump

D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump

点击查看答案

第9题

Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command？（）

Examine the following command that is executed for

A. It collects statistics into the pending area in the data dictionary

B. It creates a virtual hidden column in the CUSTOMERS_OBE table

C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT

D. It creates a histogram to hold skewed information about the data in the columns

点击查看答案

第10题

Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed？（）

Examine the data from the ORDERS and CUSTOMERS tab

A. Examine the data from the ORDERS and CUSTOMERS tab

B. Examine the data from the ORDERS and CUSTOMERS tab

C. Examine the data from the ORDERS and CUSTOMERS tab

D. The query fails because the subquery returns more than one row.

E. The query fails because the outer query and the inner query are using different tables.

点击查看答案

账号：尚未登录

登录没有账号？去注册

搜题记录

联系客服

购买搜题卡

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次