Searching for "0"

Q:

The status bar of Word 2010 provides useful information about the current document you are working on. You can customize the status bar to add or remove options to suit your needs. By default, which of these options is NOT present on the status bar?

A) Line Number B) Page Number
C) Word Count D) Language
 
Answer & Explanation Answer: A) Line Number

Explanation:
Report Error

View Answer Report Error Discuss

Q:

You are creating a new Word 2010 document which contains scientific information including formulas. One particular algebra formula contains the notation n squared plus 10. Which formatting style would help you represent the n squared part of the formula?

A) Superscript B) Subscript
C) Javascript D) VB script
 
Answer & Explanation Answer: A) Superscript

Explanation:
Report Error

View Answer Report Error Discuss

Q:

A large CRM project took place last year included hundreds of meetings between the various key users. All of the conversations were save in a single Word 2010 document. You need to find all instances of the following words 'bleed' and 'bled'. Which of the following wildcard searches would be best?

A) ble{2}d B) ble{1,}d
C) ble{e2}d D) ble[e2]d
 
Answer & Explanation Answer: B) ble{1,}d

Explanation:
Report Error

View Answer Report Error Discuss

Q:

The Backstage View in Word 2010 presents an easy way to access all the tools you need to manage your documents. It helps prevent clutter on the main Word 2010 Ribbon and provides core file management functions. There are 6 tabs across the top of the Backstage View window, one of these is called Info. Which of these functions does Info contain?

A) Set user permissions for documents B) Know when a document was last printed
C) Run accessibility tests D) All of these
 
Answer & Explanation Answer: D) All of these

Explanation:
Report Error

View Answer Report Error Discuss

Q:

The navigation pane in Word 2010 has several tabs that let you move through the information in your document in different ways. Which of the following tabs is part of the Navigation pane?

A) Browse by heading B) Browse by search results
C) Browse by page D) All of these
 
Answer & Explanation Answer: D) All of these

Explanation:
Report Error

View Answer Report Error Discuss

Q:

You have a portable computer named Computer1 that runs Windows 7.
You have a file server named Server1 that runs Windows Server 2008. Server1 contains a shared folder named Share1.


You need to configure Computer1 to meet the following requirements:
Ensure that cached files from Share1 are encrypted.
Ensure that files located in Share1 are available when Server1 is disconnected from the network.


What should you do?

A) On Server1, encrypt the files in Share1. On Computer1, make Share1 available offline. B) On Server1, configure BitLocker Drive Encryption. On Computer1, make Share1 available offline.
C) On Computer1, make Share1 available offline and enable encryption of offline files. D) On Computer1, copy the files from Share1 to the Documents library and configure BitLocker Drive Encryption.
 
Answer & Explanation Answer: C) On Computer1, make Share1 available offline and enable encryption of offline files.

Explanation:
Report Error

View Answer Report Error Discuss

Q:

You are the administrator of a SQL Server 2000 computer named CorpSQL. The server is a member of a Microsoft Windows NT domain named CORPORATE. Franz maintains a local user account on CorpSQL and is a member of the local Power Users group. He requests access to the SQL Server databases that are stored on CorpSQL.You need to allow Franz to access CorpSQL. Which Transact-SQL statement should you execute?

A) EXEC sp_grantlogin CorpSQL\Franz B) EXEC sp_grantlogin Franz
C) EXEC sp_grantlogin [Power Users\Franz] D) EXEC sp_grantlogin CORPORATE\Franz
 
Answer & Explanation Answer: A) EXEC sp_grantlogin CorpSQL\Franz

Explanation:
Report Error

View Answer Report Error Discuss

Q:

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?

A) Set up SQL Server replication to replicate the data from the Oracle server to the SQL Server computer. B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C) Set up a Microsoft ActiveX script that connects to the Oracle server and imports the financial information into a SQL Server temporary table. Create a view that joins the service contract information and the temporary table. D) Set up a Data Transformation Services (DTS) package that imports and transforms the data from the Oracle server to the SQL Server computer. Use SQL Server Agent to execute the DTS package throughout the day as needed.
 
Answer & Explanation Answer: B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.

Explanation:

SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements. Each distributed query can reference multiple linked servers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Report Error

View Answer Report Error Discuss