Sawaal
  • Home/
  • Searching for But

 Searching for "But"

Q:

 A distributed database can use which of the following strategies?

A) Totally centralized one location and accessed by many sites B) Partially or totally replicated across sites
C) Partitioned into segments at different sites D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

A) Supertype entity B) Subtype entity
C) Archetype entity D) Instance entity
 
Answer & Explanation Answer: A) Supertype entity

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

John is a system administrator for a renowned travel agency.The agency is planning to upgrade its computer systems to Windows XP Professional.Most of the computers are networked but some computers do not have CD-ROM drives.How can John upgrade the computer systems without CD-ROM drives to Windows XP Professional?

A) can attach a portable tape backup unit to each computer and install the operating system from it. B) can use the windows installer program to push out the operating system.
C) can perfom the installation over a network share. D) can not install windows XP Professional unless he installs a CD-ROM drive in the computer systems that do not have them.
 
Answer & Explanation Answer: C) can perfom the installation over a network share.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

Q:

Sachin works for a computer training institute in North America.After discussing the steps of installing Windows XP professional in the class room, sachin divided the students in a group of two and asked them to complete the installation on their respective machines.But none of the students were able to complete the installation process.Identify the solution that is the cause to the above problem.

A) Needs to run XP Upgrade Adviser to avoid compatibility problem B) Needs to run XP Upgrade Professional to avoid compatibility problem
C) Needs to run XP Upgrade Home Edition to avoid compatibility problem D) Needs to run XP Service Pack to avoid compatibility problem
 
Answer & Explanation Answer: A) Needs to run XP Upgrade Adviser to avoid compatibility problem

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

Q:

You have installed a Windows Server 2003 DNS server, but because of security reasons, you have to install this behind a firewall. What port on the firewall must be opened so that users can access the server?

A) IP and UDP port 42 B) UDP and TCP port 53
C) TCP 53 but not UDP D) PPTP and UDP 21
 
Answer & Explanation Answer: B) UDP and TCP port 53

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

Q:

Someone has created a new document using Word 2010 and sent you a copy. The document is not protected and you have rights to view the content and even make changes. However, they have inserted a hyperlink to a company website but when you click the hyperlink nothing happens. What might be wrong?

A) Hyperlinks do not open automatically, you need to paste them into your web browser B) You need to hold the Ctrl key whilst clicking the hyperlink
C) Its impossible to add hyperlinks to a document. Maybe they formatted it to look like a link. D) You need to hold the Alt key whilst clicking the hyperlink
 
Answer & Explanation Answer: B) You need to hold the Ctrl key whilst clicking the hyperlink

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MOS-Microsoft Office Specialist

Q:

You are the administrator of a SQL Server 2000 computer. You configure SQL Server to perform C2 auditing. Audit logs are saved in the C:MSSQLAudit folder.The server functions normally for several days, but then the MSSQLServer service shuts down without warning. You cannot restart the service.You need to restart the MSSQLServer service. What should you do?

A) Start the MSSQLServer service manually by using the -m startup option. B) Start the MSSQLServer service manually by using the -s startup option.
C) Set the SQLServerAgent service's startup method to Disabled. Start the MSSQLServer service. D) Delete the audit logs from the C:\MSSQL\Audit folder. Start the MSSQLServer service.
 
Answer & Explanation Answer: D) Delete the audit logs from the C:\MSSQL\Audit folder. Start the MSSQLServer service.

Explanation:

SQL Server functioned for several days but now it is impossible to start it.
The most likely cause is the size of the auditing log files. The maximum file size for the audit log is fixed at 200 megabytes (MB). When the audit log file reaches 200 MB, a new file will be created and the old file handle will be closed. If the directory fills up, then the instance of Microsoft SQL Server is stopped. The system administrator needs to either free up disk space for the audit log before restarting the instance of SQL Server or restart the instance of SQL Server

Note 1: SQL Server Agent monitors itself and the SQL Server service.
SQL Server Agent can restart the local instance of SQL Server if it has terminated for reasons other than a typical shutdown.

Note 2: Start the MSSQLServer service manually by using the -f startup option would start the service with minimal configuration. It could be used when some configuration errors have been made and the MSSQLServer service isn't able to start.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

Q:

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock.When parts are shipped, a table named PartsShipped is updated. When parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit. (Click the Exhibit button.)

You want the database to update the InStock field automatically. What should you do?

A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table. B) Use a view that creates anInStock field as part of an aggregate query.
C) Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables. D) Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
 
Answer & Explanation Answer: A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.

Explanation:

Triggers are a special class of stored procedure defined to fire automatically when an UPDATE, INSERT, or DELETE statement is issued against a table or view. They are powerful tools that can be used to enforce business rules automatically when data is modified. Triggers can extend the integrity checking logic of SQL Server constraints, defaults, and rules, although constraints and defaults should be used instead whenever they provide all the needed functionality. In this scenario an AFTER UPDATE trigger can be used to update the tables to update the PartsShipped and the PartsReceived tables that update the InStock column in the parts table.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert