#42. You are recreating the customers database and you want to create the index, The table has 1,000,000 records and is heavily updated. The table is expected to increase by 20% over two years. Choices given:
#44. Want to export data to Pivot table in Excel spreadsheet from SQL. Data changes frequently. Want to automate the process of updating the Excel spreadsheet - use SQL Server Agent to schedule job to automate.
#46. The accounting question with staging and production files. You run a stored procedure which counts the records. You get locking problems when two users run the same procedure. What to do ?
#47. Evaluate this trigger: USE sales GO CREATE TRIGGER inventory_update ON inventory FOR UPDATE AS IF UPDATE (product_id) BEGIN ROLLBACK TRANSACTION END Which result will this trigger provide?
#48. A table design suggests a parent/child relation. Parent table will have 1 million records, Child will have 100 million. Aggregate data is contained in the child table, Detailed child reporting is occasionally used. What to do?
#49. You are implementing a logical data model for a decision support system (DSS) database. Two of the tables in the model have a parent/child relationship. The parent table is expected to have more than 1 millions rows. The child table is expected to have more than 100 million rows. Most reports present aggregate child information grouped according to each parent row. Reports containing detailed child table information are occasionally needed. How should the tables be implemented?
#50. The sales database contains a customer table and an order table. For each order there is one and only one customer, and for each customer there can be zero or many orders. How should primary and foreign key fields be placed into the design of this database?
gen. 0.06
Forum
Master braindump