Certification Questions

Q:

Which proprietary Cisco STP extensions would put a switch port into err-disabled if a BPDU is received on this port?

Answer

BPDUGuard

Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

0 2204
Q:

You are the administrator of a SQL Server 2000 computer named CorpSQL. The server is a member of a Microsoft Windows NT domain named CORPORATE. Franz maintains a local user account on CorpSQL and is a member of the local Power Users group. He requests access to the SQL Server databases that are stored on CorpSQL.You need to allow Franz to access CorpSQL. Which Transact-SQL statement should you execute?

A) EXEC sp_grantlogin CorpSQL\Franz B) EXEC sp_grantlogin Franz
C) EXEC sp_grantlogin [Power Users\Franz] D) EXEC sp_grantlogin CORPORATE\Franz
 
Answer & Explanation Answer: A) EXEC sp_grantlogin CorpSQL\Franz

Explanation:
Report Error

View Answer Report Error Discuss

0 2202
Q:

Project Risk Management - Processes

Describe the Inputs, Tools and Techniques , Outputs included in the Risk Management Planning?

Answer

I. Inputs



  • Enterprise environmental factors

  • Organizational process assets

  • Project Scope statement

  • Project Management plan


II. Tools and Techniques



  • Planning meetings and analysis


III. Outputs



  • Risk Management Plan

Report Error

View answer Workspace Report Error Discuss

0 2200
Q:

You are setting up a computer for students to use to practice exercises for their certification exams. You want to configure the computer so that users can boot into both Windows 98 and Windows 2000 Professional. You want to ensure that students can access all drive resources from either operating system. What should you do?

A) Create a single FAT32 partition. B) Create a single NTFS volume.
C) Configure one NTFS volume, and one extended FAT32 partition. D) Configure a dynamic volume.
 
Answer & Explanation Answer: A) Create a single FAT32 partition.

Explanation:
Report Error

View Answer Report Error Discuss

0 2196
Q:

Project Procurement Management - Processes

Describe the Inputs, Tools and Techniques , Outputs included in the Plan Purchase and Acquisitions?

Answer

I. Inputs



  • Enterprise environmental factors

  • Organizational process assets

  • Project scope statement

  • Work breakdown structure

  • WBS dictionary

  • Project management plan


                 - Risk register


                 - Risk - related contractual agreements


                 - Resource requirements


                 - Project schedule


                 - Activity cost estimates


                 - Cost baseline


II. Tools and Techniques



  • Make-or-buy analysis

  • Expert judgement

  • Contract types


III. Outputs



  • Procurement management plan

  • contract statement of work

  • make-or-buy decisions

  • Requested changes       

Report Error

View answer Workspace Report Error Discuss

0 2195
Q:

What is the purpose of SQL Profiler in SQL server?

Answer

SQL profiler is a tool to monitor performance of various stored procedures. It is used to debug the queries and procedures. Based on performance, it identifies the slow executing queries. Capture any problems by capturing the events on production environment so that they can be solved.

Report Error

View answer Workspace Report Error Discuss

1 2195
Q:

A subquery in an sql select statement.

Answer

A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause.


Subqueries are most frequently used with the SELECT statement. The basic syntax is as follows::


SELECT column_name [, column_name ]
FROM table1 [, table2 ]
WHERE column_name OPERATOR
(SELECT column_name [, column_name ]
FROM table1 [, table2 ]
[WHERE])



A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.


Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN, etc.


 


There are a few rules that subqueries must follow −


 


1. Subqueries must be enclosed within parentheses.


2. A subquery can have only one column in the SELECT clause, unless multiple columns are in the main query for the subquery to compare its selected columns.


3. An ORDER BY command cannot be used in a subquery, although the main query can use an ORDER BY. The GROUP BY command can be used to perform the same function as the ORDER BY in a subquery.


4. Subqueries that return more than one row can only be used with multiple value operators such as the IN operator.


5. The SELECT list cannot include any references to values that evaluate to a BLOB, ARRAY, CLOB, or NCLOB.


6. A subquery cannot be immediately enclosed in a set function.


7. The BETWEEN operator cannot be used with a subquery. However, the BETWEEN operator can be used within the subquery.

Report Error

View answer Workspace Report Error Discuss

0 2193
Q:

How can you redirect print jobs to a different print device?

A) Copy the print jobs from one printer to another printer B) Assign the printer to a port that is connected to a different type of print device.
C) Cancel all of the print jobs, then delete the printer. Create a new printer with the same name, and assign it to a different port. D) Assign the printer to a port that is connected to another identical print device.
 
Answer & Explanation Answer: D) Assign the printer to a port that is connected to another identical print device.

Explanation:

You need to assign the printer to a different port that is connected to the same type of print device.

Report Error

View Answer Report Error Discuss

0 2192