Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using sql server over ms access
or why should one use sql instead of ms access
- 2 Answers
- 13609 Views
- CMS, Impetus, I also Faced
- E-Mail Answers
Answer Posted / rajeshwari
it is an query language with an structure so we esily
access the data from data base
| Is This Answer Correct ? | 5 Yes | 14 No |
Post New Answer View All Answers
Tell me what is the difference between locking and multi-versioning?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Can you please explain the difference between primary keys and foreign keys?
What is bcnf normalization form?
what are isolation levels? : Sql server database administration
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is named calculation? : sql server analysis services, ssas
How many triggers are possible per table?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
Explain what is the function of sql server agent windows service?
How do I view a stored procedure in sql server query?
What protocol does sql server use?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Tell me in brief how sql server enhances scalability of the database system?
