Certification Questions

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 3698
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 3657
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 3642
Q:

In the Determine Budget processes the project schedule

A) is not one of the inputs to these processes. B) is used to allocate the project budget to the various project activities.
C) is used to assign costs to the time period when the costs will be incurred D) is used to determine the size of the contingency component of the budget after all scheduled costs are accounted for.
 
Answer & Explanation Answer: C) is used to assign costs to the time period when the costs will be incurred

Explanation:

“This [project schedule] information can be used to aggregate costs to the calendar periods when the costs are planned to be incurred.” PMBOK [7.2.1.4]

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

0 3634
Q:

User can define and use their own transaction types for Assets accounting in  a SAP R/3 system

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

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: SAP FI

0 3633
Q:

What does a link-local address always start with?

Answer

FE80::/10

Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

0 3622
Q:

What is a chunk when using raw devices?

A) a dynamic unit of disk space B) a location in shared memory
C) a contiguous unit of disk space D) a data table
 
Answer & Explanation Answer: C) a contiguous unit of disk space

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

4 3622
Q:

You type Router#sh ru and receive a % ambiguous command error. why did you receive this message?

A) The command requires additional options or parameters B) There is more than one show command that starts with the letters ru.
C) There is no show command that starts with ru D) The command is being executed from the wrong router mode
 
Answer & Explanation Answer: B) There is more than one show command that starts with the letters ru.

Explanation:

The % ambiguous command error means that there is more than one possible show command that starts with ru. Use a question mark to find the correct command.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 3605