Certification Questions

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

16 5836
Q:

What multicast addresses does EIGRPv6 use?

A) FF02::A B) FF02::9
C) FF02::5 D) FF02::6
 
Answer & Explanation Answer: A) FF02::A

Explanation:

EIGRPv6's multicast address stayed very near the same. In IPv4 it was 224.0.0.10; now it is FF02::A (A = 10 in decimal notation)

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 5829
Q:

Dynamic Search Ads would be most helpful for

A) Campaigns that need to reduce exposure on competitive keywords. B) Websites with hundreds or thousands of products, services, or listings that frequently change.
C) A local restaurant with a dynamically changing menu that offers fresh new entrees every few months. D) Moving an ads position dynamically in whatever direction a users eyes are looking.
 
Answer & Explanation Answer: B) Websites with hundreds or thousands of products, services, or listings that frequently change.

Explanation:

Dynamic Search Ads are the simplest way to find the customers searching on Google for indubitably what you offer. This is an ideal way for with a well-developed website or with a large inventory. Businesses with websites that contain a lot of content or well-structured URLs will see the best results from using Dynamic Search Ads. 

 

Even well managed Adwords account with many keywords can miss relevant searches, experiance delays in getting ads added for new products or it may be out of Sync with what the website originally have.

 

How to Target : 

You can target 

        • All the web pages  (or)

 

        • Specific webpages containing certain keywords.

 

Benefits of Dynamic Search Ads :

        • Save time. No more mapping keywords, bids, and ad text to each product on your website. Plus, Dynamic Search Ads may help you advertise to new markets faster than other alternatives.
        • Frequent, automatic updates to your ads. When you make changes to pages in our index, we'll crawl your website again to help ensure that your ads are as up to date as possible.
        • Show relevant, dynamically generated headlines with your ads. When a customer's search is relevant to your product or service, AdWords will dynamically generate an ad with a clear headline for the most relevant page on your site.
Report Error

View Answer Report Error Discuss

32 5792
Q:

If your routing table has a static, a RIP, and an EIGRP route to the same network, which route will be used to route packets by default?

A) Any available route B) RIP route
C) Static route D) EIGRP route
 
Answer & Explanation Answer: C) Static route

Explanation:

Static routes have an administrative distance of 1 by default. Unless you change this, a static route will always be used over any other dynamically learned route. EIGRP has an administrative distance of 90, and RIP has an administrative distance of 120, by default

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

1 5763
Q:

What is meant by same layer interaction

A) That a packet is forwarded to a different host that resides in the same layer of the Cisco three layer hierarchical model. B) That an interaction occurs within a single layer of a networking model and that no other layers or devices take any part in the interaction.
C) An interaction that progresses up or down only one level of a networking model. D) That two computers use a protocol defined at the same layer of a networking model to communicate with each other.
 
Answer & Explanation Answer: D) That two computers use a protocol defined at the same layer of a networking model to communicate with each other.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: CCENT

0 5757
Q:

Which hardware platform (or platforms) are supported by Windows 2000?

A) The Intel Pentium/ 166MHZ (and higher) platform B) The Compac Alpha platform
C) The PowerPC platform D) The MIPS R4000 platform
 
Answer & Explanation Answer: A) The Intel Pentium/ 166MHZ (and higher) platform

Explanation:

The Intel Pentium/166MHz (and higher) platform is the only hardwaer platform supported by Windows 2000.

Report Error

View Answer Report Error Discuss

20 5691
Q:

When a router is connected to a Frame Relay WAN link using a serial DTE interface, how is the clock rate determined?

A) Supplied by the CSU/DSU B) By the far end router
C) By the clock rate command D) By the Physical layer bits stream timing
 
Answer & Explanation Answer: A) Supplied by the CSU/DSU

Explanation:

Clocking on a serial interface is always provided by the CSU/DSU (DCE device). However, if you do not have a CSU/DSU in your non-production test environment, then you need to supply clocking with the clock rate command on the serial interface of the router with the DCE cable attached.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 5688
Q:

An asset under construction requires a separate asset class with their own account determination since depreciation has to be shown separately on the balances sheet.

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: SAP FI

1 5656