InterviewSolution
| 1. |
What Are The Options Available, While Building A Table? |
|
Answer» The Build process uses Data Definition Language (DDL) to construct a physical DATABASE component that is based on the associated record and field definitions that you created. With the Build feature, you can create the following. Create Tables: Creates structure in database. Create INDEX: When you build a table, it ALSO creates index for that table Create VIEW: It will create a sql view. Alter Tables: When you don’t want to lose the existing data we build that record with this Create Trigger after the Build process begins, there are no runtime prompts until the process is COMPLETE. All events are written to the Build log. The Build process uses Data Definition Language (DDL) to construct a physical database component that is based on the associated record and field definitions that you created. With the Build feature, you can create the following. Create Tables: Creates structure in database. Create Index: When you build a table, it also creates index for that table Create View: It will create a sql view. Alter Tables: When you don’t want to lose the existing data we build that record with this Create Trigger after the Build process begins, there are no runtime prompts until the process is complete. All events are written to the Build log. |
|