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.<br /> Some of the employees may not have a phone number available.<br /> Which data manipulation operation do you perform?（）..

第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、MERGE B、INSERT C、UPDATE D、ADD E、ENTER F、You cannot enter the phone numbers for the existing employee records.

点击查看答案

第2题

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

点击查看答案

第3题

[单选题] I‘m sorry. Bob‘s not in his office（）

A、Can you take a message for me. B、Are you sure for that. C、Would you like to leave a message. D、Can you phone me.

点击查看答案

第4题

[单选题] --Do you know who telephoned me? --（）

A、No，I didn’t phone you. B、Yes，I know you well. C、I heard it was Sally. D、Yes，I remember it now.

点击查看答案

第5题

[单选题] You are a desktop administrator for your company. A company user reports that he is unable to use his Bluetooth-enabled mobile phone with his Bluetooth-enabled Windows XP Professional computer. He is trying to play audio from the phone through the speakers on his computer. You verify that other Bluetooth devices work properly with the user’s computer. You test the speakers to make sure they are in working order. You also verify that the mobile phone can send output to a computer. You then discover that the phone cannot detect the computer.You

A、Place the phone in Bluetooth discovery mode. B、Place the user’s computer in Bluetooth discovery mode. C、Add the phone and the computer to the same Bluetooth Personal Area Network （PAN）. D、Install mobile phone synchronization software on the user’s computer.

点击查看答案

第6题

[] Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone_no, ' – ') AS 'office_no' 'coalesce (ph2 .phone_no, ' – ') AS 'cell_no' FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = 'office' LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = 'mobile' The tables employees and employee_phone are InnoDB tables; all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value to '555-8888' for John Doe?（） Review the definition of the phone_list view. CHEATE OR REPL

A、A.INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile') B、B.UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe' C、C.DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888) D、D.UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1

点击查看答案

第7题

[多选题] Your company has an Actrve Directory forest that runs at the functional level of Windows Server 2008 You implement Actrve Directory Rights Management Services （AD RMS） You install Microsoft SOL Server 2005 When you attempt to open the AD RMS administration Web site， you recerve the following error message： "SOL Server does not exist or access denied" You need to open the AD RMS administration Web site Which two actions should you perform（）

A、Restart liS B、Install Message Oueuing C、Start the MSSOLSVC service D、Manualy delete the Service Connection Point in AD OS and restart AD RMS

点击查看答案

第8题

[多选题] our company has an Active Directory forest that runs at the functional level of Windows Server 2008. You implement Active Directory Rights Management Services （AD RMS）. You install Microsoft SQL Server 2005. When you attempt to open the AD RMS administration Web site， you receive the following error message： "SQL Server does not exist or access denied." You need to open the AD RMS administration Web site. Which two actions should you perform（）

A、Restart IIS. B、Install Message Queuing. C、Start the MSSQLSVC service. D、Manually delete the Service Connection Point in AD DS and restart AD RMS.

点击查看答案

第9题

[] You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You add a DataGrid named gridContacts that is data-bound to a collection of Contacts. Each item has the ContactName and Phone properties. The DataGrid contains a column named ContactNameColumn that is bound to ContactName. You write the following code fragment. You need to ensure that the application meets the following requirements: Phone number is shown as a row detail when the row is selected. Only ContactName can be edited. What should you do?（） You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You add a DataGrid named gridContacts that is data-bound to a collection of Contacts. Each item has the ContactName and Phone properties. The DataGrid con

A、A.
B.
C.
D.

点击查看答案

请使用微信扫码支付