DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Delimited File
|
|
|
Front-End File
|
|
|
Decrypting
|
|
|
Back-End File
|
Detailed explanation-1: -When you split a database, you reorganize it into two files-a back-end database that contains the data tables, and a front-end database that contains all the other database objects such as queries, forms, and reports. Each user interacts with the data by using a local copy of the front-end database.
Detailed explanation-2: -The back-end database contains tables, while all the other objects like forms, queries, reports, etc., are stored in a front-end database. Thus, each user gets a separate front-end copy of the database and sends or receives data from the linked back-end database.
Detailed explanation-3: -To perform a SQL table split, select the table in the SQL Server Management Studio’s Object Explorer, and from the ApexSQL Refactor main menu under the Other refactors sub-menu, click the Split table command: This will open the Split table window.
Detailed explanation-4: -On the “Get External Data-Access Database” dialog, click the option titled: “Link to the data source by creating a linked table.” Click [OK]. In the next dialog, select the tables you want to link, then click [OK].