The result set retrieved by the following SELECT statement contains records that have SELECT Balance, Number FROM Accounts WHERE Balance < 0

two of the columns from the Accounts table where Balance is less than 0

two of the columns and all of the rows from the Account table

all of the columns and rows from the Accounts table

all of the columns from the Accounts table where Balance is less than 0

Which EF development technique uses the Scaffold-DbContext command?

Entity Relationship development

In which EF development technique do you start by writing entity and database context classes before generating a new database?

Entity Relationship development

Given an entity named Products that has a Description property, and given a combo box named cboProducts, which of the following statements performs the same task as the statement below? cboProducts.DisplayMember = "Description";

cboProducts.DisplayMember = nameof(Products.Description);

cboProducts.DisplayMember = nameof(Products);

cboProducts.DisplayMember = nameof("Products.Description");

cboProducts.DisplayMember = nameof(Products["Description"]);

Given a DB context object named context that contains an entity collection named Customers with a return type of DbSet, which of the following statements retrieves data from all rows of the table that the Customers entity is mapped to?

var customers = context.Customers.ToList();

var customers = context.Customers;

var customers = context.DbSet<Customers>();

var customers = context.Customers.Where(c => c.CustomerId > 0);

Which of the following properties checks all columns of its entity for concurrency?

[Timestamp] public byte[] RowVersion { get; set; }

[ConcurrencyCheck] public string Address { get; set; }

[ConcurrencyCheck] public byte[] Columns { get; set; }

[RowVersion] public DateTime TimeStamp { get; set; }

Given a class named MMABooksContext that inherits the DbContext class, which of the following statements creates the database context object?

MMABooksContext context = new MMABooksContext();

MMABooksContext context = new DbContext();

MMABooksContext context = MMABooksContext.Create();

MMABooksContext context = MMABooksContext.DbContext();

Given a DB context object named context, which of the following statements saves all pending changes in the context object to the underlying database?

int rowsUpdated = context.SaveChanges();

int rowsUpdated = context.SaveAll();

int rowsUpdated = context.Update();

int rowsUpdated = context.UpdateDB();

Which of the following identifies a placeholder for a SQL Server parameter?

a named variable that begins with an at sign (@)

a named variable that begins with a colon (:)

Given a valid connection string named conString, which of the following statements creates a connection for a SQL Server database?

SqlConnection con = new SqlConnection(conString);

Connection con = new Connection(conString);

SqlConnection con = new SqlConnection(); con.SqlConnectionString = conString;

Which of the following statements creates a SQL Server parameter named ProductCode with the value in a variable named productCode and adds it to the collection of parameters in a command named selectCommand?

selectCommand.Parameters.AddWithValue("@ProductCode", productCode);

selectCommand.Parameters.Add("@ProductCode", productCode);

selectCommand.Add(new Parameter("@ProductCode", productCode));

selectCommand.Parameter.Add(new Parameter("@ProductCode", productCode));

Which of the following identifies a placeholder for an OLE DB or ODBC parameter?

a named variable that begins with an at sign (@)

a named variable that begins with a colon (:)

Which of the following declarations could be used for a method in a database class named EmployeeDB that deletes an employee row in a database table and returns a true/false value if the operation was successful? Assume that this method enforces optimistic concurrency.

public static bool Delete(Employee employee)

public static bool Delete(int employeeID)

public static int Delete(int employeeID)

public static int Delete(Employee employee)

Which of the following statements adds a parameter named userIDParm to an SQL statement that’s stored in a command object named updateCommand?

updateCommand.Parameters.Add(userIDParm);

updateCommand.Parameter[userIDParm];

updateCommand.Parameter.Add(userIDParm);

Given a valid SqlDataReader object named employeeReader, which of the following statements retrieves the first column of the current row and stores it in a string variable named s?

string s = employeeReader[0].ToString();

string s = employeeReader.GetFirstColumn();

Given a DataGridView control named dgCustomers, what does the following event handler do? You can assume that this event handler is wired correctly. private void dgCustomers_CellClick(object sender, DataGridViewCellEventArgs e) { MessageBox.Show (dgCustomers.Rows[e.RowIndex].Cells[0].Value.ToString()); }

It displays the value of the first column for the row that was clicked.

It displays the value of the first column for the first row.

It displays the value of the row index for the row that was clicked.

It throws a MethodNotFoundException.

When implementing paging, which other controls are also typically on the form that displays the DataGridView control?

A combo box that lets you select the previous or next page

Another DataGridView control that displays rows that are related to the selected row

A text box that displays the total number of pages

Four buttons that move to the first, previous, next, and last pages

Given a DataGridView control named dgCustomers, what does the following event handler do? You can assume this event handler is wired correctly. private void dgCustomers_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 1) { MessageBox.Show (e.RowIndex.ToString()); } }

It displays the row index for the row that was clicked but only if the user clicks in the second column.

It displays the row index for the row that was clicked.

It displays the row index for the row that was clicked but only if the user clicks in the first column.

It displays the column index for the row that was clicked.

Given DataGridView controls named dgvCustomers and dgvInvoices, what does the following event handler do? You can assume that the event handler is wired correctly. private void dgvCustomers_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { DataGridViewRow row = dgvCustomers.Rows[e.RowIndex]; int customerID = Convert.ToInt32(row.Cells[0].Value); var invoices = context.Invoicess .Where(i => i.CustomerId == customerID) .OrderBy(i => i.InvoiceId) .Select(i => new { i.InvoiceId, i.InvoiceDate, i.ProductTotal, i.SalesTax, i.Shipping, i.InvoiceTotal }) .ToList(); dgvInvoices.DataSource = invoices; }

It displays data for zero or more invoices for a customer when the user clicks the header row for the customer.

It displays data for the first invoice for a customer when the user clicks anywhere in the row for the customer.

It displays data for zero or more invoices for a customer when the user clicks anywhere in the row for the customer.

It causes an IllegalColumnException to be thrown.

Given a DataGridView control named dgvProducts, which of the following statements right aligns the values in the third column?

dgvProducts.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;

dgvProducts.Columns[3].Alignment = MiddleRight;

dgvProducts.Columns[2].DefaultCellStyle.Alignment = MiddleRight;

dgvProducts.Columns[2].Alignment = DataGridViewContentAlignment.MiddleRight;

CPT 231 Midterm Part 1

Authored by Reza Naqvi

Computers

University

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

40 questions

Show all answers

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What does a relational database use to uniquely identify each row in a table?

indexes

foreign keys

non-primary keys

primary keys

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Assuming the third row in the OrderOptions table has an OrderOptionsID of 3, what does the following SQL statement do?
DELETE FROM OrderOptions
WHERE OrderOptionsID = 3

It deletes the OrderOptionsID column from the OrderOptions table

It deletes the first three rows from the OrderOptions table

It deletes the row in the OrderOptions table that has an ID of 3

It deletes all rows except the first three rows from the OrderOptions table

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Code example 19-1
SELECT VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal
FROM Vendors INNER JOIN Invoices
ON Vendors.VendorID = Invoices.VendorID
WHERE InvoiceTotal >= 500
ORDER BY VendorName DESC
(Refer to code example 19-1.) How many columns will the result set have?

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

To communicate with a DBMS, the application software sends

command objects

SQL Queries

dataset requests

primary keys

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What does the following SQL statement add to the Terms table?
INSERT INTO Terms (TermsDueDays) VALUES (90)

A row with a value of 90 for the TermsDueDays column

90 rows with a column of TermsDueDays

All rows where the TermsDueDays column has a value of 90

A TermsDueDays column with a default value of 90

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following can a SELECT statement not do?

Retrieve data

Create calculated fields

Combine data from two tables

Modify selected data

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

The data that’s retrieved by a SELECT statement is called a

check constraint

SQL query

data reader

result set

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

SIMULASI DIGITAL - X

Quiz

•

KG - Professional Dev...

45 questions

UAS BSD 1

Quiz

•

University

44 questions

Round 1 Code2duo

Quiz

•

University

40 questions

Grade 6-Sistem Komputer

Quiz

•

6th Grade - University

45 questions

อจ.ฉี

Quiz

•

University

40 questions

Database Systems Quiz

Quiz

•

University

35 questions

Kuis Aplikasi Kamus Digital

Quiz

•

8th Grade - University

36 questions

MOC 20345 Test

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

10 questions

Probability Practice

Quiz

•

4th Grade

15 questions

Probability on Number LIne

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

6 questions

Appropriate Chromebook Usage

Lesson

•

7th Grade

10 questions

Greek Bases tele and phon

Quiz

•

6th - 8th Grade

Discover more resources for Computers

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

20 questions

Endocrine System

Quiz

•

University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

30 questions

W25: PSYCH 250 - Exam 2 Practice

Quiz

•

University

5 questions

Inherited and Acquired Traits of Animals

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

38 questions

Unit 8 Review - Absolutism & Revolution

Quiz

•

10th Grade - University

CPT 231 Midterm Part 1

What does a relational database use to uniquely identify each row in a table?

Assuming the third row in the OrderOptions table has an OrderOptionsID of 3, what does the following SQL statement do?
DELETE FROM OrderOptions
WHERE OrderOptionsID = 3

Code example 19-1
SELECT VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal
FROM Vendors INNER JOIN Invoices
ON Vendors.VendorID = Invoices.VendorID
WHERE InvoiceTotal >= 500
ORDER BY VendorName DESC
(Refer to code example 19-1.) How many columns will the result set have?

To communicate with a DBMS, the application software sends

What does the following SQL statement add to the Terms table?
INSERT INTO Terms (TermsDueDays) VALUES (90)

Which of the following can a SELECT statement not do?

The data that’s retrieved by a SELECT statement is called a

The result set retrieved by the following SELECT statement contains records that have
SELECT Balance, Number
FROM Accounts
WHERE Balance < 0

What does a relational database use to relate tables in the database to each other?

A system that divides the processing between the clients and the server is called

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

CPT 231 Midterm Part 1

What does a relational database use to uniquely identify each row in a table?

Assuming the third row in the OrderOptions table has an OrderOptionsID of 3, what does the following SQL statement do?DELETE FROM OrderOptions WHERE OrderOptionsID = 3

Code example 19-1SELECT VendorName, InvoiceNumber, InvoiceDate, InvoiceTotalFROM Vendors INNER JOIN Invoices ON Vendors.VendorID = Invoices.VendorIDWHERE InvoiceTotal >= 500ORDER BY VendorName DESC(Refer to code example 19-1.) How many columns will the result set have?

To communicate with a DBMS, the application software sends

What does the following SQL statement add to the Terms table?INSERT INTO Terms (TermsDueDays) VALUES (90)

Which of the following can a SELECT statement not do?

The data that’s retrieved by a SELECT statement is called a

The result set retrieved by the following SELECT statement contains records that haveSELECT Balance, NumberFROM AccountsWHERE Balance < 0

What does a relational database use to relate tables in the database to each other?

A system that divides the processing between the clients and the server is called

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Assuming the third row in the OrderOptions table has an OrderOptionsID of 3, what does the following SQL statement do?
DELETE FROM OrderOptions
WHERE OrderOptionsID = 3

Code example 19-1
SELECT VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal
FROM Vendors INNER JOIN Invoices
ON Vendors.VendorID = Invoices.VendorID
WHERE InvoiceTotal >= 500
ORDER BY VendorName DESC
(Refer to code example 19-1.) How many columns will the result set have?

What does the following SQL statement add to the Terms table?
INSERT INTO Terms (TermsDueDays) VALUES (90)

The result set retrieved by the following SELECT statement contains records that have
SELECT Balance, Number
FROM Accounts
WHERE Balance < 0