Certification Questions

Q:

Given the following network range 192.168.0.0/24. We want minimum 50 hosts on each of the available subnets. What will be the subnet mask?

A) /24 B) /25
C) /26 D) /27
 
Answer & Explanation Answer: C) /26

Explanation:

Explanation: 50 hosts require 6 bits of the last octet giving us 64 -2 = 62 possible hosts this satisfies our requirement and leaves us 2 bits over for the subnets. The default mask is /24 or 255.255.255.0 adding the 2 bits for the subnets it becomes 255.255.255.192 or /26

Report Error

View Answer Report Error Discuss

Filed Under: CCENT

1 3679
Q:

What command is the Windows version of the Cisco command that displays the networks traversed on a path to a network destination?

A) ping B) traceroute
C) arp D) tracert
 
Answer & Explanation Answer: D) tracert

Explanation:

tracert is the Windows version of the Cisco command that displays the networks traversed on a path to a network destination.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 3669
Q:

When a ping to the loopback address fails , what can you assume?

A) The IP address of the local host is incorrect B) The IP address of the remote host is incorrect
C) The NIC is not functional D) The IP stack has failed to initialize
 
Answer & Explanation Answer: D) The IP stack has failed to initialize

Explanation:

When a ping to the loopback address fails , you can assume the IP stack has failed to initialize.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 3654
Q:

The system does a forward scheduling if...

A. Material availability date falls ater today's date

B. If backward scheduling is configured

C. Material availability date falls beyond today's date

D. If backward scheduling is not configured

Answer

Answer : C , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP SD

0 3646
Q:

You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?

A) EXEC sp_defaultdb 'Andrew','FinanceData' B) GRANT ALL ON FinanceData TO Andrew
C) EXEC sp_addlogin 'Andrew' D) EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew'
 
Answer & Explanation Answer: A) EXEC sp_defaultdb 'Andrew','FinanceData'

Explanation:

Error 208 produces the message 'Invalid object name' and occurs when an object that does not exist in the current database is referenced. If the object exists in another database, we must use the USE statement to explicitly switch the context to the correct database or we must qualify the object name with the database name. A third option is to use the sp_defaultdb stored procedure. This stored procedure is used to change the default database for a login. When a client connects with SQL Server, the default database defined for its login becomes the current database without an explicit USE statement. The default database can be defined when the login is added with
sp_addlogin. When executing sp_addlogin the master database is the default database if a database is not specified. In this scenario a SQL Server 2000 login and a user account has been created for Andrew and he has been given database access and the required permissions.

Report Error

View Answer Report Error Discuss

0 3631
Q:

What command displays the ARP table on a Cisco router?

A) show ip arp B) traceroute
C) arp -a D) tracert
 
Answer & Explanation Answer: A) show ip arp

Explanation:

The command that displays the ARP table on a Cisco router is show ip arp.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 3607
Q:

Where are EIGRP successor routes stored?

A) In the routing table only B) In the neighbor table only
C) In the routing table and neighbor table D) In the routing table and the topology table
 
Answer & Explanation Answer: D) In the routing table and the topology table

Explanation:

Successor routes are going to be in the routing table since they are the best path to a remote network. However, the topology table has a link to each and every network, so the best answer is topology table and routing table. Any secondary route to a remote network is considered a feasible successor, and those routes are found only in the topology table and used as backup routes in case of primary route failure.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 3594
Q:

What does a link-local address always start with?

Answer

FE80::/10

Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

0 3581