#72. You use DTS to move orders data from DBase III to SQL server, after you created SQL table using: CREATE TABLE [Order] (Order int, CustNo int, OrderDate smalldate, Foreign bit) The Import fails every time you run DTS wizard. What to do?
#73. Your database table: CREATE TABLE SalesInformation (SalesInformation_ID int Identify (1,1) Not NULL SalesPerson_ID int not NULL, Region_ID int not NULL, Receipt_ID int not NULL, Salesamount money) You want to populate the table with data from existing application that has numeric Primary Key. In order to maintain referential integrity, you want to preserve the value of original Primary Key. What can you do to populate the table?
#74. Your users report time when they modify data in your transaction process application. Response time is excellent when users retrieving data. All transactions are short & follow standard guide. Your monitor is blocking locks & you find out what causes?
#75. A shipping company has database application. When each vessel is unloaded at its destination, the INVENTORY table is created & Arrived_Quantity column is updated in database. Each shipment is identified by Shipment_ID column, each item is identified by Item_Number column. You want to make sure the update of the Arrived_Quantity is fast as possible. What do you do?
#76. The user wants to find out all those, which had some sales. The SQL command given is: SELECT title_id FROM titles WHERE title_id = (SELECT title_id FROM sales) The above SQL is:
#77. You are designing a data model for a DSS system containing two tables (parent child relationship). The child table holds thousands more rows than the parent. The fields in the parent table will be queried the most. How do you implement the design?
#78. You are implementing a logical data model for an online processing (OLTP) application. One entity from the logical model in 3rd normal form currently has 10 attribute. - One attribute is the primary key. - Six of the attribute are foreign key referencing into six other entities. - The last three attributes representing columns that holds Numeric values. How should this entity from the logical model be implemented?
#79. You automate the backup & recovery process for your database application, after database is restored, you discover the queries that use the FREETEXT & CONTAINS keyword no longer return the expected rows. What do you do?
#80. You database includes a table named product the Product table currently has clustered index on the primary key of the product_id column. There is also a nonclusted index on the description column. You are experiencing very poor response times when querying the product table. Most of the queries against the table include search arguments on the description and product_type columns. Because there are many values in the size columns for new product. Query result set usually contain between 200 and 800 rows.
gen. 0.07
Forum
Master braindump