Deck 3: Architecture and Configuration

ملء الشاشة (f)
exit full mode
سؤال
Linked servers can be created, modified, or dropped by using a SQL query.
استخدم زر المسافة أو
up arrow
down arrow
لقلب البطاقة.
سؤال
Which system database stores information related to jobs, schedules, and database backups?

A)tempdb
B)msdb
C)model
D)master
سؤال
Which of the following is a file extension used in the physical structure of a SQL database?

A).ldf
B).mdb
C).txt
D).dbf
سؤال
Which of the following enable frequently perform tasks to be stored as objects in the database?

A)procedures
B)views
C)indexes
D)constraints
سؤال
Which data format represents data as a series of ones and zeros?

A)binary
B)octal
C)decimal
D)hex
سؤال
Which service enables a client to connect to the SQL Server instance over a network?

A)loopback
B)listener
C)SQLCMD
D)shared memory
سؤال
Which of the following is a way of organizing data, with defined rules for storing, manipulating, and retrieving data?

A)modeling format
B)virtual instance
C)physical architecture
D)logical structure
سؤال
The primary purpose of a database is to organize and store data in a secure manner.
سؤال
Which of the following is a basic building block of a database that is used to improve the speed and efficiency of data access?

A)table
B)index
C)constraint
D)time stamp
سؤال
What can be used to satisfy compliance aspects of business requirements by creating time stamps and audits?

A)logical instance
B)index
C)constraint
D)trigger
سؤال
The master system database stores a database template that is used as a blueprint when creating a new user database.
سؤال
Which of the following is commonly referred to as a record?

A)constraint
B)column
C)row
D)attribute
سؤال
What are int, date, and bit examples of in a SQL database?

A)data type
B)condition
C)column name
D)record
سؤال
A linked server uses shared software components from the dynamic-link library on the server.
سؤال
Which of the following is NOT a reason for a database administrator to understand the main file types used in a SQL Server system?

A)physical resources
B)transparency to the user
C)backup and recovery operations
D)security
سؤال
Which tool allows you to create SQL queries to be executed against a database?

A)Object Explorer
B)Query Editor
C)Analysis Services
D)View Compiler
سؤال
Which of the following may require the database engine to perform a full scan on every record of the database?

A)invalid constraints
B)too many triggers
C)no index is defined
D)no secondary key
سؤال
Which system database stores information on the structure of other databases and their components?

A)model
B)master
C)msdb
D)tempdb
سؤال
Which of the following is NOT a system database on a SQL Server system?

A)model
B)master
C)directory
D)resource
سؤال
Client applications can only connect to the SQL Server instance on the local computer.
سؤال
Describe the physical structure of a database.
سؤال
What happens if there is no index defined for a query? What is its impact?
سؤال
When defining a ____________ server, it is possible to override the integrated authentication with a stored username and password.
سؤال
List and describe three of the five system databases found in an SQL Server 2012 system.
سؤال
What is a data type and how are they used in tables?
سؤال
A ______________ is a physical unit of storage into which data files are subdivided.
سؤال
What are the roles of listeners and loopback addresses in SQL Server remote connections?
سؤال
What is the primary purpose of a database?
سؤال
Which of the following is used by SQLCMD to test network connections used to remotely connect to a SQL server instance?

A)named pipes
B)SSRP
C)TDS packets
D)loopback address
سؤال
LastName and FirstName are examples of ____________ in a database table.
سؤال
Which of the following is NOT a network protocol supported by SQL Server 2012?

A)shared memory
B)named pipes
C)NWLink
D)TCP/IP
سؤال
What are the two basic building blocks of a database? Describe them.
سؤال
What is used to configure a connection to an external data source from within SQL Server?

A)linked server object
B)TDS packets
C)listener
D)named pipe
سؤال
Which of the following is a data provider that enables a connection to be established to almost any database or file irrespective of the operating system?

A)DLL
B)ODBC
C)Oracle
D)Jet
سؤال
Describe the logical organization of a database.
سؤال
Describe how TCP/IP is used in SQL Server 2012 remote connectivity.
سؤال
The ______________ system database stores the system objects in a read-only database.
سؤال
What should you do to prevent blockage of the port used to communicate with a SQL Server instance?

A)disable the firewall on the client
B)configure a fixed port
C)disable the firewall on the server
D)use named pipes
سؤال
In a _________________ database, tables are designed to model real-world objects and the relationships that exist between them.
سؤال
Describe some of the components found in SQL Server Management Studio.
سؤال
Match between columns
provides a tree view of the different database schema objects organized as a series of folders
linked server
provides a tree view of the different database schema objects organized as a series of folders
primary key
provides a tree view of the different database schema objects organized as a series of folders
named pipe
provides a tree view of the different database schema objects organized as a series of folders
extent
provides a tree view of the different database schema objects organized as a series of folders
trace
provides a tree view of the different database schema objects organized as a series of folders
constraint
provides a tree view of the different database schema objects organized as a series of folders
table
provides a tree view of the different database schema objects organized as a series of folders
Object Explorer
provides a tree view of the different database schema objects organized as a series of folders
database index
provides a tree view of the different database schema objects organized as a series of folders
procedure
a physical storage unit that is a collection of eight pages
linked server
a physical storage unit that is a collection of eight pages
primary key
a physical storage unit that is a collection of eight pages
named pipe
a physical storage unit that is a collection of eight pages
extent
a physical storage unit that is a collection of eight pages
trace
a physical storage unit that is a collection of eight pages
constraint
a physical storage unit that is a collection of eight pages
table
a physical storage unit that is a collection of eight pages
Object Explorer
a physical storage unit that is a collection of eight pages
database index
a physical storage unit that is a collection of eight pages
procedure
organized as a two-dimensional structure consisting of rows and columns
linked server
organized as a two-dimensional structure consisting of rows and columns
primary key
organized as a two-dimensional structure consisting of rows and columns
named pipe
organized as a two-dimensional structure consisting of rows and columns
extent
organized as a two-dimensional structure consisting of rows and columns
trace
organized as a two-dimensional structure consisting of rows and columns
constraint
organized as a two-dimensional structure consisting of rows and columns
table
organized as a two-dimensional structure consisting of rows and columns
Object Explorer
organized as a two-dimensional structure consisting of rows and columns
database index
organized as a two-dimensional structure consisting of rows and columns
procedure
constructed based on a unique key, and it contains pointers to the underlying rows within the table
linked server
constructed based on a unique key, and it contains pointers to the underlying rows within the table
primary key
constructed based on a unique key, and it contains pointers to the underlying rows within the table
named pipe
constructed based on a unique key, and it contains pointers to the underlying rows within the table
extent
constructed based on a unique key, and it contains pointers to the underlying rows within the table
trace
constructed based on a unique key, and it contains pointers to the underlying rows within the table
constraint
constructed based on a unique key, and it contains pointers to the underlying rows within the table
table
constructed based on a unique key, and it contains pointers to the underlying rows within the table
Object Explorer
constructed based on a unique key, and it contains pointers to the underlying rows within the table
database index
constructed based on a unique key, and it contains pointers to the underlying rows within the table
procedure
a log of events on the database management system
linked server
a log of events on the database management system
primary key
a log of events on the database management system
named pipe
a log of events on the database management system
extent
a log of events on the database management system
trace
a log of events on the database management system
constraint
a log of events on the database management system
table
a log of events on the database management system
Object Explorer
a log of events on the database management system
database index
a log of events on the database management system
procedure
the column or combination of columns that uniquely identify each record within a table
linked server
the column or combination of columns that uniquely identify each record within a table
primary key
the column or combination of columns that uniquely identify each record within a table
named pipe
the column or combination of columns that uniquely identify each record within a table
extent
the column or combination of columns that uniquely identify each record within a table
trace
the column or combination of columns that uniquely identify each record within a table
constraint
the column or combination of columns that uniquely identify each record within a table
table
the column or combination of columns that uniquely identify each record within a table
Object Explorer
the column or combination of columns that uniquely identify each record within a table
database index
the column or combination of columns that uniquely identify each record within a table
procedure
a condition that imposes a limitation on a value or action
linked server
a condition that imposes a limitation on a value or action
primary key
a condition that imposes a limitation on a value or action
named pipe
a condition that imposes a limitation on a value or action
extent
a condition that imposes a limitation on a value or action
trace
a condition that imposes a limitation on a value or action
constraint
a condition that imposes a limitation on a value or action
table
a condition that imposes a limitation on a value or action
Object Explorer
a condition that imposes a limitation on a value or action
database index
a condition that imposes a limitation on a value or action
procedure
provides the capability to execute queries against a remote data source for running distributed queries.
linked server
provides the capability to execute queries against a remote data source for running distributed queries.
primary key
provides the capability to execute queries against a remote data source for running distributed queries.
named pipe
provides the capability to execute queries against a remote data source for running distributed queries.
extent
provides the capability to execute queries against a remote data source for running distributed queries.
trace
provides the capability to execute queries against a remote data source for running distributed queries.
constraint
provides the capability to execute queries against a remote data source for running distributed queries.
table
provides the capability to execute queries against a remote data source for running distributed queries.
Object Explorer
provides the capability to execute queries against a remote data source for running distributed queries.
database index
provides the capability to execute queries against a remote data source for running distributed queries.
procedure
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
linked server
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
primary key
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
named pipe
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
extent
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
trace
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
constraint
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
table
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
Object Explorer
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
database index
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
procedure
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
linked server
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
primary key
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
named pipe
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
extent
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
trace
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
constraint
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
table
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
Object Explorer
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
database index
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
procedure
فتح الحزمة
قم بالتسجيل لفتح البطاقات في هذه المجموعة!
Unlock Deck
Unlock Deck
1/41
auto play flashcards
العب
simple tutorial
ملء الشاشة (f)
exit full mode
Deck 3: Architecture and Configuration
1
Linked servers can be created, modified, or dropped by using a SQL query.
True
2
Which system database stores information related to jobs, schedules, and database backups?

A)tempdb
B)msdb
C)model
D)master
B
3
Which of the following is a file extension used in the physical structure of a SQL database?

A).ldf
B).mdb
C).txt
D).dbf
A
4
Which of the following enable frequently perform tasks to be stored as objects in the database?

A)procedures
B)views
C)indexes
D)constraints
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
5
Which data format represents data as a series of ones and zeros?

A)binary
B)octal
C)decimal
D)hex
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
6
Which service enables a client to connect to the SQL Server instance over a network?

A)loopback
B)listener
C)SQLCMD
D)shared memory
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
7
Which of the following is a way of organizing data, with defined rules for storing, manipulating, and retrieving data?

A)modeling format
B)virtual instance
C)physical architecture
D)logical structure
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
8
The primary purpose of a database is to organize and store data in a secure manner.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
9
Which of the following is a basic building block of a database that is used to improve the speed and efficiency of data access?

A)table
B)index
C)constraint
D)time stamp
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
10
What can be used to satisfy compliance aspects of business requirements by creating time stamps and audits?

A)logical instance
B)index
C)constraint
D)trigger
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
11
The master system database stores a database template that is used as a blueprint when creating a new user database.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
12
Which of the following is commonly referred to as a record?

A)constraint
B)column
C)row
D)attribute
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
13
What are int, date, and bit examples of in a SQL database?

A)data type
B)condition
C)column name
D)record
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
14
A linked server uses shared software components from the dynamic-link library on the server.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
15
Which of the following is NOT a reason for a database administrator to understand the main file types used in a SQL Server system?

A)physical resources
B)transparency to the user
C)backup and recovery operations
D)security
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
16
Which tool allows you to create SQL queries to be executed against a database?

A)Object Explorer
B)Query Editor
C)Analysis Services
D)View Compiler
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
17
Which of the following may require the database engine to perform a full scan on every record of the database?

A)invalid constraints
B)too many triggers
C)no index is defined
D)no secondary key
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
18
Which system database stores information on the structure of other databases and their components?

A)model
B)master
C)msdb
D)tempdb
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
19
Which of the following is NOT a system database on a SQL Server system?

A)model
B)master
C)directory
D)resource
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
20
Client applications can only connect to the SQL Server instance on the local computer.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
21
Describe the physical structure of a database.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
22
What happens if there is no index defined for a query? What is its impact?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
23
When defining a ____________ server, it is possible to override the integrated authentication with a stored username and password.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
24
List and describe three of the five system databases found in an SQL Server 2012 system.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
25
What is a data type and how are they used in tables?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
26
A ______________ is a physical unit of storage into which data files are subdivided.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
27
What are the roles of listeners and loopback addresses in SQL Server remote connections?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
28
What is the primary purpose of a database?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
29
Which of the following is used by SQLCMD to test network connections used to remotely connect to a SQL server instance?

A)named pipes
B)SSRP
C)TDS packets
D)loopback address
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
30
LastName and FirstName are examples of ____________ in a database table.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
31
Which of the following is NOT a network protocol supported by SQL Server 2012?

A)shared memory
B)named pipes
C)NWLink
D)TCP/IP
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
32
What are the two basic building blocks of a database? Describe them.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
33
What is used to configure a connection to an external data source from within SQL Server?

A)linked server object
B)TDS packets
C)listener
D)named pipe
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
34
Which of the following is a data provider that enables a connection to be established to almost any database or file irrespective of the operating system?

A)DLL
B)ODBC
C)Oracle
D)Jet
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
35
Describe the logical organization of a database.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
36
Describe how TCP/IP is used in SQL Server 2012 remote connectivity.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
37
The ______________ system database stores the system objects in a read-only database.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
38
What should you do to prevent blockage of the port used to communicate with a SQL Server instance?

A)disable the firewall on the client
B)configure a fixed port
C)disable the firewall on the server
D)use named pipes
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
39
In a _________________ database, tables are designed to model real-world objects and the relationships that exist between them.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
40
Describe some of the components found in SQL Server Management Studio.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
41
Match between columns
provides a tree view of the different database schema objects organized as a series of folders
linked server
provides a tree view of the different database schema objects organized as a series of folders
primary key
provides a tree view of the different database schema objects organized as a series of folders
named pipe
provides a tree view of the different database schema objects organized as a series of folders
extent
provides a tree view of the different database schema objects organized as a series of folders
trace
provides a tree view of the different database schema objects organized as a series of folders
constraint
provides a tree view of the different database schema objects organized as a series of folders
table
provides a tree view of the different database schema objects organized as a series of folders
Object Explorer
provides a tree view of the different database schema objects organized as a series of folders
database index
provides a tree view of the different database schema objects organized as a series of folders
procedure
a physical storage unit that is a collection of eight pages
linked server
a physical storage unit that is a collection of eight pages
primary key
a physical storage unit that is a collection of eight pages
named pipe
a physical storage unit that is a collection of eight pages
extent
a physical storage unit that is a collection of eight pages
trace
a physical storage unit that is a collection of eight pages
constraint
a physical storage unit that is a collection of eight pages
table
a physical storage unit that is a collection of eight pages
Object Explorer
a physical storage unit that is a collection of eight pages
database index
a physical storage unit that is a collection of eight pages
procedure
organized as a two-dimensional structure consisting of rows and columns
linked server
organized as a two-dimensional structure consisting of rows and columns
primary key
organized as a two-dimensional structure consisting of rows and columns
named pipe
organized as a two-dimensional structure consisting of rows and columns
extent
organized as a two-dimensional structure consisting of rows and columns
trace
organized as a two-dimensional structure consisting of rows and columns
constraint
organized as a two-dimensional structure consisting of rows and columns
table
organized as a two-dimensional structure consisting of rows and columns
Object Explorer
organized as a two-dimensional structure consisting of rows and columns
database index
organized as a two-dimensional structure consisting of rows and columns
procedure
constructed based on a unique key, and it contains pointers to the underlying rows within the table
linked server
constructed based on a unique key, and it contains pointers to the underlying rows within the table
primary key
constructed based on a unique key, and it contains pointers to the underlying rows within the table
named pipe
constructed based on a unique key, and it contains pointers to the underlying rows within the table
extent
constructed based on a unique key, and it contains pointers to the underlying rows within the table
trace
constructed based on a unique key, and it contains pointers to the underlying rows within the table
constraint
constructed based on a unique key, and it contains pointers to the underlying rows within the table
table
constructed based on a unique key, and it contains pointers to the underlying rows within the table
Object Explorer
constructed based on a unique key, and it contains pointers to the underlying rows within the table
database index
constructed based on a unique key, and it contains pointers to the underlying rows within the table
procedure
a log of events on the database management system
linked server
a log of events on the database management system
primary key
a log of events on the database management system
named pipe
a log of events on the database management system
extent
a log of events on the database management system
trace
a log of events on the database management system
constraint
a log of events on the database management system
table
a log of events on the database management system
Object Explorer
a log of events on the database management system
database index
a log of events on the database management system
procedure
the column or combination of columns that uniquely identify each record within a table
linked server
the column or combination of columns that uniquely identify each record within a table
primary key
the column or combination of columns that uniquely identify each record within a table
named pipe
the column or combination of columns that uniquely identify each record within a table
extent
the column or combination of columns that uniquely identify each record within a table
trace
the column or combination of columns that uniquely identify each record within a table
constraint
the column or combination of columns that uniquely identify each record within a table
table
the column or combination of columns that uniquely identify each record within a table
Object Explorer
the column or combination of columns that uniquely identify each record within a table
database index
the column or combination of columns that uniquely identify each record within a table
procedure
a condition that imposes a limitation on a value or action
linked server
a condition that imposes a limitation on a value or action
primary key
a condition that imposes a limitation on a value or action
named pipe
a condition that imposes a limitation on a value or action
extent
a condition that imposes a limitation on a value or action
trace
a condition that imposes a limitation on a value or action
constraint
a condition that imposes a limitation on a value or action
table
a condition that imposes a limitation on a value or action
Object Explorer
a condition that imposes a limitation on a value or action
database index
a condition that imposes a limitation on a value or action
procedure
provides the capability to execute queries against a remote data source for running distributed queries.
linked server
provides the capability to execute queries against a remote data source for running distributed queries.
primary key
provides the capability to execute queries against a remote data source for running distributed queries.
named pipe
provides the capability to execute queries against a remote data source for running distributed queries.
extent
provides the capability to execute queries against a remote data source for running distributed queries.
trace
provides the capability to execute queries against a remote data source for running distributed queries.
constraint
provides the capability to execute queries against a remote data source for running distributed queries.
table
provides the capability to execute queries against a remote data source for running distributed queries.
Object Explorer
provides the capability to execute queries against a remote data source for running distributed queries.
database index
provides the capability to execute queries against a remote data source for running distributed queries.
procedure
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
linked server
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
primary key
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
named pipe
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
extent
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
trace
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
constraint
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
table
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
Object Explorer
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
database index
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
procedure
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
linked server
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
primary key
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
named pipe
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
extent
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
trace
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
constraint
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
table
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
Object Explorer
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
database index
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data
procedure
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.
فتح الحزمة
k this deck
locked card icon
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 41 في هذه المجموعة.