You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees

题目

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

A、MERGE
B、INSERT
C、UPDATE
D、ADD
E、ENTER
F、You cannot enter the phone numbers for the existing employee records.

参考答案和解析

正确答案:C

更多“You added a PHONE_NUMBER column”相关问题

第1题

A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）A、SequenceB、Table FunctionC、Identity ColumnD、INSTEAD OF Trigger

点击查看答案
第2题

You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）A、BFILE B、REF column C、Object table D、Column object E、INSTEAD-OF trigger

点击查看答案
第3题

You are creating a DataTable. You use the following code segment to create the DataTable. (Line numbers are included for reference only.) 01 Dim dt As New DataTable("Products") 02 dt.Columns.Add(New DataColumn("Price", _ GetType(Decimal))) 03 dt.Columns.Add(New DataColumn("Quantity", _ GetType(Int32))) 04 Dim dc As DataColumn = New DataColumn("Total", _ GetType(Decimal)) 05 dt.Columns.Add(dc) You need to ensure that the Total column is set to the value of the Price column multiplied by the Quantity column when new rows are added or changed. What should you do? （）A、Add the following code segment after line 05. dc.ExtendedProperties("Total") = "Price * Quantity"B、Add the following code segment after line 05. dc.Expression = "Price * Quantity"C、Write an event handler for the DataTable's TableNewRow event that updates the row's Total.D、Write an event handler for the DataTable's ColumnChanged event that updates the row's Total.

点击查看答案
第4题

You need to ensure that the Cust_CalcData column is implemented appropriately. What should you do?（）A、Specify that the Cust_CalcData column must be implemented as a computed column of the table. B、Specify that the Cust_CalcData column must be indexed using a non-clustered index.C、Specify that the Cust_CalcData column must be implemented as a column that uses a user-defined data type.D、Specify that the Cust_CalcData column must be updated by a SQL Server Agent job that runs nightly.

点击查看答案
第5题

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?（） A、On the Products table, you should create a view. B、On the RadioSize column, you should create a clustered index C、On the RadioSize column, you should create a filtered index D、On the RadioSize column, you should create a unique clustered index

点击查看答案
第6题

单选题You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means， including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do？（）A Create a trigger that rolls back changes to the Price column that violate company policy.B Create a stored procedure that disallows changes to the Price column that violate company policy.C On the Price column， create a check constraint that requires a specified minimum value.D On the Price column， create a foreign key constraint to a table that contains valid prices.

点击查看答案
第7题

单选题You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）A After the query. B Enter the report and change the column's position in the field tab. C Alter the column's position in the object navigator. D Enter the report wizard and change the column's position in the data tab. E Alter the column's position within its group and change the layout.

点击查看答案

You added a PHONE_NUMBER column

题目

参考答案和解析

更多“You added a PHONE_NUMBER column”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容