Certification Questions

Q:

Explain Given the following SQL statement: GRANT REFERENCES ON TABLE tab1 TO USER usera.Which of the following describes what USERA is allowed to do?

A) Create a read?only view using TAB1. B) Alter TAB1 to add a check constraint.
C) Define a primary key or unique constraint on TAB1. D) Define a dependent table where TAB1 is the parent.
 
Answer & Explanation Answer: D) Define a dependent table where TAB1 is the parent.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2471
Q:

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application uses the ADO.NET Entity Framework to manage customer and related order records. You add a new order for an existing customer. You need to associate the Order entity with the Customer entity. What should you do?

A) Set the Value property of the EntityReference of the Order entity. B) Call the Add method on the EntityCollection of the Order entity.
C) Use the AddObject method of the ObjectContext to add both Order and Customer entities. D) Use the Attach method of the ObjectContext to add both Order and Customer entities.
 
Answer & Explanation Answer: A) Set the Value property of the EntityReference of the Order entity.

Explanation:
Report Error

View Answer Report Error Discuss

0 2469
Q:

 The plant maintenance component is used for the technical management of asset and the treasury component is used ot manage finincial assets.

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

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: SAP FI

0 2468
Q:

You want to use a single group to organise users from multiple domains that perform similar job tasks. Which kind of group should you use?

A) Universal group B) Global group
C) Domain Local group D) Built-in special group
 
Answer & Explanation Answer: A) Universal group

Explanation:

Universal groups are used to organize users from multiple domains  that perform similar job tasks or have similar network access requirements, and / or to control access to shared resources in multiple domains.

Report Error

View Answer Report Error Discuss

0 2464
Q:

What is keyword contextual targeting?

Answer

It is when themes of keywords are matched by AdWords to relevant content on various websites that run Google ads.

Report Error

View answer Workspace Report Error Discuss

0 2462
Q:

Organizational Systems

What are Project-based and Non project-based organizations?

Answer



      • Project-based Organizations are those whose operations consist primarily of projects.

      • Non Project-based organizations often may lack management systems designed to support project needs efficiently and effectively.



Report Error

View answer Workspace Report Error Discuss

0 2456
Q:

You are preparing to upgrade a Windows NT Server 4.0 computer to Windows 2000 Server. You recently obtained upgrade packs for several software applications installed on this computer.When should you apply the upgrade packs?

A) Before the upgrade B) During the upgrade
C) After the upgrade D) You can install the upgrade pack at any time
 
Answer & Explanation Answer: B) During the upgrade

Explanation:

During the upgrade process, the Windows 2000 Setup program will prompt you to provide any upgrade packs you have for installed software applications.

Report Error

View Answer Report Error Discuss

0 2449
Q:

You develop an inventory management application called XYZManagement that will call a Microsoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter. This total will be displayed to users in a message box.


Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write the
following code to call sp_GetDailyXYZSales:
SqlConnection cnn = new SqlConnection(myConnString);
SqlCommand cmd = new SqlCommand(“sp_GetDaily XYZ Sales”, cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter prm = cmd.Parameters.Add(“@ItemTotal”,SqlDbType.Int);
prm.Direction = ParameterDirection.Output;
cnn.Open();
cmd.ExecuteNonQuery();


Now you must write additional code to access the output parameter. Which code segment should you use?

A) MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].Value.ToString()); B) MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].ToString());
C) MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal? D) MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
 
Answer & Explanation Answer: C) MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?

Explanation:

The @ItemTotal parameter is declared as an output parameter with SQL Server data type INT.We use the Value property of the SQLParameter class to retrieve the value of this parameter. We must also convert the INT value to a string value with the ToString method. We then supply this string to the MessageBox.Show method. 

 

Incorrect Answers


Option A, B:
The @ItemTotal parameter is the output parameter. Using @Output this way is incorrect. Output is a keyword and no variable named @Output has been declared.


Option D:
We must use the Value method to retrieve the value of the parameter..

Report Error

View Answer Report Error Discuss

1 2447