|
Question |
Rating |
View Answer |
|
If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice? |
|
View Answer |
|
How do you optimize stored procedures ? |
|
View Answer |
|
You have a SQL Server 2005 sales database experiencing performance problems because of heavy I/O activity. You decide to create a snapshot of this database every hour, stored on a separate physical disk array and use that for reporting queries. However the queries still seem slow immediately after snapshot creation. Why? |
|
View Answer |
|
How does a differential backup know which extents have changed so that it can be very quickly run? |
|
View Answer |
|
I was asked in an interview... "Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why..... |
|
View Answer |
|
What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL? |
|
View Answer |
|
What are data objects? |
|
View Answer |
|
Difference between a "where" clause and a "having" clause? |
|
View Answer |
|
Explain about reporting services of MYSQL? |
|
View Answer |
|
Which of the following choices show the three report formats supported by Report Builder ? |
|
View Answer |
|
How we can make sure that the SQL query does not return NULL values? |
|
View Answer |
|
After you've completed a backup for your Sales server to disk, you want to be sure that this backup is intact and able to be used for restores before writing it to tape. What command will help you here? |
|
View Answer |
|
How many rows are returned by these two select statements? |
|
View Answer |
|
Explain about SQLOS? |
|
View Answer |
|
Which types of replication work with Oracle publishers? |
|
View Answer |
|
What does the Log Reader agent in SQL Server 2005 replication do? |
|
View Answer |
|
In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean? |
|
View Answer |
|
What does the max full-text crawl range option do? |
|
View Answer |
|
What is different between int and bint? |
|
View Answer |
|
How a sql server is been used in our programs? |
|
View Answer |