Searching for "Dataset"

Q:

What does it mean to calculate frequencies within a dataset? 

A) to calculate the product of two variables to make a third variable B) to count the number of cases that fall into different subgroups within a dataset
C) to count the number of times a dataset is used by a student D) to calculate the sum of a column of variables in a dataset
 
Answer & Explanation Answer: B) to count the number of cases that fall into different subgroups within a dataset

Explanation:

Frequency is what means how many times the event occurs in the same period.

Report Error

View Answer Report Error Discuss

Filed Under: Arithmetical Reasoning
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO

Q:

Why is free space left in KSDS Dataset?

Answer

While allocating KSDS Datasets, free space is declared at regular intervals at the time of initial loading. This is done because this free space is utilized for keeping the data arranged in sequence physically, even though inserted randomly.

Report Error

View answer Workspace Report Error Discuss

Q:

What are datasets?

Answer

The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

Q:

What is the role of the DataSet object in ADO.NET?

Answer

One of the major component of ADO.NET is the DataSet object, which always remains disconnected from the database and reduces the load on the database.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

Q:

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. The application connects to a Microsoft SQL Server database. The application has two DataTable objects that reference the Customers and Orders tables in the database. The application contains the following code segment. (Line numbers are included for reference only.)


01DataSet customerOrders = new DataSet();
02customerOrders.EnforceConstraints = true;
03ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04customerOrders.Tables["Customers"].Columns["CustomerID"],
05customerOrders.Tables["Orders"].Columns["CustomerID"]);
06
07customerOrders.Tables["Orders"].Constraints.Add(ordersFK);


You need to ensure that an exception is thrown when you attempt to delete Customer records that have related Order records. Which code segment should you insert at line 06?

A) ordersFK.DeleteRule = Rule.SetNull; B) ordersFK.DeleteRule = Rule.None;
C) ordersFK.DeleteRule = Rule.SetDefault; D) ordersFK.DeleteRule = Rule.Cascade;
 
Answer & Explanation Answer: B) ordersFK.DeleteRule = Rule.None;

Explanation:
Report Error

View Answer Report Error Discuss

Q:

You ASP.NET application manages order entry data by using a DataSet object named EXorderEntry. The EXorderEntry object includes two DataTable objects named orderNames and OrderDetails. A ForeignKeyConstraint object named orderDetailsKey is defined between the two DataTable objects.


You attempt to delete a row in orderNames while there are related rows in OrderDetails, and an exception is generated.What is the most likely cause of the problem?

A) The current value of OrderDetails.KeyDeleteRule is Rule.Cascade. B) The current value of OrderDetails.KeyDeleteRule is Rule.SetNull.
C) The current value of OrderDetails.KeyDeleteRule is Rule.SetDefault. D) The current value of OrderDetails.KeyDeleteRule is Rule.None.
 
Answer & Explanation Answer: D) The current value of OrderDetails.KeyDeleteRule is Rule.None.

Explanation:

The rule enumeration indicates the action that occurs when a ForeignKeyConstraint is enforced.None specifies that no action will occur, but exceptions are generated. This is what has occurred in this scenario.

 

Incorrect Answers:

 

A: Cascade specifies that all rows containing that value are also deleted.

B: SetNull specifies that values in all child columns are set to null values.

C: SetDefault specifies that all child columns be set to the default value for the column.

Report Error

View Answer Report Error Discuss

Q:

You use Visual Studio .NET to develop a Windows-based application that interacts with a Microsoft SQL Server database. Your application contains a form named CustomerForm.

 You add the following design-time components to the form:

• SqlConnection object named XYZConnection.
• SqlDataAdapter object named XYZDataAdapter.
• DataSet object named XYZDataSet.
• Five TextBox controls to hold the values exposed by XYZDataSet.


At design time, you set the DataBindings properties of each TextBox control to the appropriate column in the DataTable object of XYZDataSet. When you test the application, you can successfully connect to the database. However, no data is displayed in any text boxes.

You need to modify your application code to ensure that data is displayed appropriately. Which behavior should occur while the CustomerForm.Load event handler is running?

A) Execute the BeginInit method of XYZDataSet. B) Execute the Open method of XYZConnection.
C) Execute the FillSchema method of XYZDataAdapter and pass in XYZDataSet. D) Execute the Fill method of XYZDataAdapter and pass in XYZDataSet.
 
Answer & Explanation Answer: D) Execute the Fill method of XYZDataAdapter and pass in XYZDataSet.

Explanation:

Dataset is a container; therefore, you need to fill it with data. You can populate a dataset by calling the Fill method of a data adapter.

Report Error

View Answer Report Error Discuss