Matching
Matching :
Premises:
provides a tree view of the different database schema objects organized as a series of folders
a physical storage unit that is a collection of eight pages
organized as a two-dimensional structure consisting of rows and columns
constructed based on a unique key, and it contains pointers to the underlying rows within the table
a log of events on the database management system
the column or combination of columns that uniquely identify each record within a table
a condition that imposes a limitation on a value or action
provides the capability to execute queries against a remote data source for running distributed queries.
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
Responses:
procedure
named pipe
extent
Object Explorer
primary key
table
constraint
database index
trace
linked server
Correct Answer:
Premises:
Responses:
provides a tree view of the different database schema objects organized as a series of folders
a physical storage unit that is a collection of eight pages
organized as a two-dimensional structure consisting of rows and columns
constructed based on a unique key, and it contains pointers to the underlying rows within the table
a log of events on the database management system
the column or combination of columns that uniquely identify each record within a table
a condition that imposes a limitation on a value or action
provides the capability to execute queries against a remote data source for running distributed queries.
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
Premises:
provides a tree view of the different database schema objects organized as a series of folders
a physical storage unit that is a collection of eight pages
organized as a two-dimensional structure consisting of rows and columns
constructed based on a unique key, and it contains pointers to the underlying rows within the table
a log of events on the database management system
the column or combination of columns that uniquely identify each record within a table
a condition that imposes a limitation on a value or action
provides the capability to execute queries against a remote data source for running distributed queries.
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
Responses:
Related Questions
Q12: In a _ database, tables are designed
Q13: Which system database stores information related to
Q14: Which of the following is a file
Q15: What is a data type and how
Q16: What is used to configure a connection
Q18: The _ system database stores the system
Q19: Which of the following may require the
Q20: Linked servers can be created, modified, or
Q21: Which system database stores information on the
Q22: Which of the following is NOT a