What is DESCRIBE command in SQL Server 2005? What is its purpose?...
What is DESCRIBE command in SQL Server 2005? What is its purpose? How to use i...
view full question with answer
Posted in: SQL Server 2005 (15) | SQL (15) | SQL Server Basics (15) | SQL Server security (15) | ADO.NET Basics (15) | DataBase(35) | ADO.NET(23) | SQL Server(15) |
Resource: SQL Server 2005 | SQL | SQL Server Basics | SQL Server security | ADO.NET Basics |
You are building a scientific application that will store data in...
You are building a scientific application that will store data in a SQL Server 2005 database. The application does not store data until a final process is complete. One of the procedures you...
view full question with answer
Posted in: DataBase(35) |
You are creating a procedure that will update two tables within a...
You are creating a procedure that will update two tables within a transaction. The code looks similar to the followin...
view full question with answer
Posted in: DataBase(35) |
You need to add a column to a table that will hold a unique value...
You need to add a column to a table that will hold a unique value. Which of the following would accommodate the situatio...
view full question with answer
Posted in: DataBase(35) |
You would like to add an additional column to a table. The new co...
You would like to add an additional column to a table. The new column will be used to hold a seven-character serial number for assets and will be a mandatory element of data in the future. H...
view full question with answer
Posted in: DataBase(35) |
For producing a report from a random selection of records within...
For producing a report from a random selection of records within a SQL Server database. There are 20,000 records in the table, and you would like to include 4,000 of them in the process. How...
view full question with answer
Posted in: DataBase(35) |
While producing a grouped report of sales, by city, you only want...
While producing a grouped report of sales, by city, you only want to include report groups that have sales within the year 2007. Which of the following query elements would you use to solve ...
view full question with answer
Posted in: DataBase(35) |
During the major system upgrade, multiple data changes are going...
During the major system upgrade, multiple data changes are going to be made. You would like to implement various changes without disturbing any of the existing data. Which of the following o...
view full question with answer
Posted in: DataBase(35) |
In your development environment number of individuals creates dat...
In your development environment number of individuals creates databases regularly. You would like to log the database creation activity so that the username, time, date, and details of the c...
view full question with answer
Posted in: DataBase(35) |
Your accounting application using SQL Server database that is acc...
Your accounting application using SQL Server database that is accessed by 100 users on your organization. When a user inserts or updates a record, you want to make sure that all the required...
view full question with answer
Posted in: DataBase(35) |
Your database contains several FOREIGN KEY and CHECK constraints....
Your database contains several FOREIGN KEY and CHECK constraints. Users are facing problems while data entry on the database because the data they are adding is constantly in violation of th...
view full question with answer
Posted in: DataBase(35) |
You are creating a new index on a table that has 1,700 rows. 20 r...
You are creating a new index on a table that has 1,700 rows. 20 rows are added to this table almost every day. The table already has a primary key, and the new index does not represent the o...
view full question with answer
Posted in: DataBase(35) |
You want the data to be physically stored in SSNo sequence. Which...
You want the data to be physically stored in SSNo sequence. Which constraint should you add to the SSNo column on the Lease tabl...
view full question with answer
Posted in: DataBase(35) |
While designing an application that will provide data entry clerk...
While designing an application that will provide data entry clerks the capability of updating the data in several tables. How would like to ease entry and provide common input so the clerks ...
view full question with answer
Posted in: DataBase(35) |
An existing company-sales database exists in your company. The c...
An existing company-sales database exists in your company. The company’s sells inventory from a single warehouse location that is across town from where the computer systems are located. Th...
view full question with answer
Posted in: DataBase(35) |