Certification Questions

Q:

Data integrity constraints are used to

A) Ensure that duplicate records are not entered into the table B) Prevent users from changing the values stored in the table
C) Control who is allowed access to the data D) Improve the quality of data entered for a specific property like table column
 
Answer & Explanation Answer: D) Improve the quality of data entered for a specific property like table column

Explanation:

Integrity constraints are used to ensure accuracy and consistency of data in a relational database. Data integrity is handled in a relational database through the concept of referential integrity. Many types of integrity constraints play a role in referential integrity (RI).

 

Hence, Data integrity constraints are used to Improve the quality of data entered for a specific property i.e, table column.

Report Error

View Answer Report Error Discuss

27 5869
Q:

If one of the host connected to Sw-AC3 wants to send message to ip 190.0.2.5 (or any ip on a different subnet) what will be the destination MAC address ?

Answer

Answer and Explanation:


Because the destination address is on a different subnet from the switch, the packet will be forwarded to its default gateway. To verify the default gateway of this switch, use the show running-config command



From the output above, we can see that its default-gateway is 192.168.1.254. Which can be said to be a layer 3 device (router); in this case, the VLAN-R1 router. You can use the show cdp neighbor detail command verify further.



From the output above, you can confirm that the switch's default gateway is VLAN-R1 router (with the IP address of 192.168.1.254).The interface FastEthernet0/3 shows that the switch is directly connected to VLAN-R1 router through the switchport Fa0/3. To verify the MAC address associated this interface is interface, you use the show mac-address-table command:



Looking closely at the table above, you will discorver that the corresponding MAC address is 000a.b7e9.8360. Although there are some entries on port Fa0/3 with different Vlans ,but they have the same MAC address.


From the output above, you can confirm that the switch's default gateway is VLAN-R1 router (with the IP address of 192.168.1.254).The interface FastEthernet0/3 shows that the switch is directly connected to VLAN-R1 router through the switchport Fa0/3. To verify the MAC address associated this interface is interface, you use the show mac-address-table command
Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

1 5864
Q:

On a systems development project, Richard needs two programmers. He knows John and Smith were able to create a program in 40 days similar to the one he wants to create on his project. He decides to use 40 days as his estimate. This is an example of what type of estimating?

A) Parametric modeling B) Analogous
C) Rule of thumb D) Fixed Rate
 
Answer & Explanation Answer: B) Analogous

Explanation:

Richard is using an estimate based on a project very similar to to his own with staff he will be using.  Answer A is incorrect because perametric modeling involves using a mathematical model to predict costs, such as dollars per line of code. Answer C is incorrect, although close; if the development project is a common item, such as putting down new flooring, a rule -of-thumb measurement can be used, although it is less accurate. Answer D is incorrect because it is not a form of estimating, but a type of pricing.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

0 5835
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 5825
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 5824
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 5781
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 5762
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 5756