Searching for "By"

Q:

 In the relational model, relationships between relations or tables are created by using:

A) composite keys. B) determinants.
C) candidate keys. D) foreign keys.
 
Answer & Explanation Answer: D) foreign keys.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The different classes of relations created by the technique for preventing modification anomalies are called:

A) normal forms. B) functional dependencies.
C) referential integrity constraints. D) None of the above is correct.
 
Answer & Explanation Answer: A) normal forms.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Your network consists of a single Active Directory domain named contoso.com. The functional level of the domain is Windows Server 2003. You have a file server named Server1 that is used to store users' home folders and profiles. On Server1, you create a folder named D:data and share the folder as UserData. You create a new user account named TemplateUser in Active Directory. You need to ensure that each user account you create by copying TemplateUser is configured to have a unique home folder stored in the UserData share. Which home folder path should you specify?

A) D:\data\%homedrive% B) D:\data\%username%
C) \\server1\userdata\%homedrive% D) \\server1\userdata\%username%
 
Answer & Explanation Answer: D) \\server1\userdata\%username%

Explanation:
Report Error

View Answer Report Error Discuss

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 plan to install Windows 7 by using a Windows 7 DVD.
You need to perform an automated installation of Windows 7.
What should you do?

A) Create an answer file named oobe.xml. Copy the file to a network share. B) Create an answer file named winnt.sif. Place the file on a removable drive.
C) Create an answer file named sysprep.inf. Copy the file to a network share. D) Create an answer file named autounattend.xml. Place the file on a removable drive.
 
Answer & Explanation Answer: D) Create an answer file named autounattend.xml. Place the file on a removable drive.

Explanation:
Report Error

View Answer Report Error Discuss

Q:

You have a computer that runs Windows 7. The computer connects to the corporate network by using a VPN connection.

 

You need to ensure that you can access the Internet when the VPN connection is active. The solution must prevent Internet traffic from being routed through the VPN connection.


What should you do?

A) Configure a static DNS server address. B) Configure a static IP address and default gateway.
C) Configure the security settings of the VPN connection. D) Configure the advanced TCP/IP settings of the VPN connection.
 
Answer & Explanation Answer: D) Configure the advanced TCP/IP settings of the VPN connection.

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

Q:

You are the administrator of eight SQL Server 2000 computers. You configure alerts on each server so that various problem conditions will be reported if they occur.You create 20 operators on one of the servers. You configure these operators by using the e-mail and pager contact information for the employees in your department. You configure the alerts on the server to send e-mail messages and pager messages to the appropriate operators.You need to configure the same 20 operators on the other seven servers. You want to do this with a minimum amount of administrative time.What should you do?

A) Use SQL Server Enterprise Manager to script all of the operators. Use SQL Query Analyzer to run the script on the other seven servers. B) Detach the msdb database from the first server. Copy the database to the other seven servers. Attach the database on all eight servers.
C) Use snapshot replication to replicate the msdb database from the first server to the other seven servers. D) Use SQL ServerEnterprise Manager on a single client computer to create the operators on each server.
 
Answer & Explanation Answer: A) Use SQL Server Enterprise Manager to script all of the operators. Use SQL Query Analyzer to run the script on the other seven servers.

Explanation:

Transact-SQL scripts can be used to create defined operators or alerts. Scripting all the
predefined operators and alerts and copying them to the servers if the same group of operators is responsible for responding to the same alerts on other servers can save time.

Report Error

View Answer Report Error Discuss