c# - Databases
Tables from databases are commonly shown in a GUI through a ________. DataGridView ListBoxView SpreadSheet DataBoxView
DataGridView
The SqlCommand class allows the following types of DB access: Run a stored procedure Run a sql query by specifying its text Direct table access All the above
Run a stored procedure Run a sql query by specifying its text Direct table access All the above
Indexes are created for the following reasons: Speeding up select queries Speeding up insert statements Speeding up both select queries and insert statements
Speeding up select queries
SQL is an acronym for: Smart Query Language Structured Query Language Simulated Query Language None of the above
Structured Query Language
The namespace for ADO.Net is System.Data.SqlClient System.Net System.DB
System.Data.SqlClient
Consider the code segment below. Which of the following statements is false? int[] g; g = new int[ 23 ]; The value of g[ 3 ] is -1. The first statement declares an array reference. g is a reference to an array of integers. The second statement creates the array.
The value of g[ 3 ] is -1.
A password can be part of a SQL connection string. True False
True
A primary key must be unique for each record in the relational database table. True False
True
A query is a request to the database for the data that satisfies the specified criteria. True False
True
A table can have multiple indexes. True False
True
ADO.Net allows you to read any SQL data type. True False
True
Changes won't be made in the DB until the SaveChanges() method is called. True False
True
Columns can have a default value. True False
True
Columns can have null values. True False
True
Database projects in Visual Studio allow you to execute SQL statements from within Visual Studio. True False
True
EF can be used with other .Net languages, like VB.Net. True False
True
EF is considered a higher-level DB access mechanism than ADO.Net. True False
True
Indexes can slow down the system. True False
True
It's possible to select only a subset of a relational database table's columns. True False
True
Linq-like queries are used to access entities with EF. True False
True
The recommended way to add EF support to your project is by installing the NuGet package. True False
True
There are many different formats for a connection string. True False
True
There is a ____________ relationship between a primary key and its corresponding foreign key. one-to-one structural foreign one-to-many
one-to-many
Today's most popular database systems are ________. management databases relational databases formatted databases structural databases
relational databases
A relational database model allows relationships between data to be considered without concern for the ________. meaning of the data application of the data structure of the data All of the above
structure of the data
Relational databases can be thought of as ________. tables of rows and columns columns three-dimensional arrays rows
tables of rows and columns
The maximum number of columns in a table is 99 21 Unlimited
unlimited
It's bad practice from a security standpoint to allow untrusted input to be inserted into text queries. The following are acceptable alternatives: Parameterized SQL statements Parameterized stored procedures Both A and B
Parameterized SQL statements Parameterized stored procedures Both A and B
A database's name can have any special character. True False
False
A developer is encouraged to supply index hints in a select query. True False
False
A relational database model is a way of organizing data and considering relationships based on the physical structure of the data. True False
False
An index can span more than one table. True False
False
Each foreign key can be created independently. True False
False
The same context class can't be used for both reading and writing. True False
False
When various databases are combined, this is known as data binding. True False
False
You can have more than one database on the same server with the same name. True False
False
A SQL database has the following (choose all that apply): Functions Methods Tables Views Stored Procedures Types
Functions Tables Views Stored Procedures Types
