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.
相似考题

1.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. MERGEB. INSERTC. UPDATED. ADDE. ENTERF. You cannot enter the phone numbers for the existing employee records.

2.Click the Exhibit button and examine the data in the EMPLOYEES table.On 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.

3.Which two are true about aggregate functions?（）A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.E、You can use aggregate functions on a table, only by grouping the whole table as one single group.F、You cannot group the rows of a table by more than one column while using aggregate functions.

4.Examine the data in the EMPLOYEES table.On 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: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.

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

  • 第1题：

    You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）

    • A、It is created as a nondisplay item. 
    • B、The Lock Record property is set to Yes. 
    • C、It cannot be referenced in item level triggers. 
    • D、It is placed on the canvas with the highest sequence number.

    正确答案:A

  • 第2题：

    Which two statements about sequences are true? （）

    • A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
    • B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
    • C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
    • D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
    • E、If a sequence starting from a value 100 and incremented by 1 is used by more than one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
    • F、You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

    正确答案:B,C

  • 第3题：

    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

    正确答案:B,C,D

  • 第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.

    正确答案:A

  • 第5题：

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


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?（）
    A

    Use the report wizard to change the column label. 

    B

    Click and high light the column label and replace it with desired text. 

    C

    Click the column label and alter its property palette. 

    D

    Click the dept column and alter its property palette. 


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    You work in a company which 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 named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal？（）
    A

    You should drop the XML index on the table. Modify the primary key. Recreate the XML index 

    B

    You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. 

    C

    You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. 

    D

    You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）
    A

    Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.

    B

    Define the new column as NOT NULL with a default value of ’Undefined.’

    C

    Define the new column as NULL. Use application logic to enforce the data constraint.

    D

    Define the new column as NULL with a default value of ’Undefined.’


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）
    A

    CLOB

    B

    BLOB

    C

    BFILE

    D

    LONG RAW


    正确答案： B
    解析： 暂无解析

  • 第10题：

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


    正确答案： D
    解析： 暂无解析

  • 第11题：

    You work in a company which 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 named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal？（）  

    • A、You should drop the XML index on the table. Modify the primary key. Recreate the XML index 
    • B、You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. 
    • C、You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. 
    • D、You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.

    正确答案:A

  • 第12题：

    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、Sequence
    • B、Table Function
    • C、Identity Column
    • D、INSTEAD OF Trigger

    正确答案:A

  • 第13题：

    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.

    正确答案:B

  • 第14题：

    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

    正确答案:C

  • 第15题：

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


    正确答案： B
    解析： 暂无解析

  • 第16题：

    多选题
    You need to create a column that allows you to createa unique constraint. Which two column definitions should you choose?（）
    A

    nvarchar（100） NULL

    B

    nvarchar（max） NOT NULL

    C

    nvarchar（100） NOT NULL

    D

    nvarchar（100） SPARSE NULL


    正确答案： B,D
    解析： 暂无解析

  • 第17题：

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


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）
    A

     the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view

    B

     the column of the V$INSTANCE_RECOVERY view

    C

     the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view

    D

     the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）
    A

    Rows 

    B

    Totals 

    C

    Columns 

    D

    Cells 

    E

    Data


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）
    A

    Double click the dept column in the group to alter the property palette and change the break out order value. 

    B

    Double click the dept column in the group to open the property palette and change the set break order value. 

    C

    Double click the g_dept group object to change the break order. 

    D

    Click the dept column in the group to change the break order.


    正确答案： B
    解析： 暂无解析

相关内容