Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
The ‘IS’ keyword is used instead of the ‘AS’ keyword when creating a standalone function in PL/SQL.
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
You are a Web developer for XYZ. You create an ASP.NET application that accesses sales and marketing data. The data is stored in a Microsoft SQL Server 2000 database on a server named XYZ01.
The company purchases a factory automation software application. The application is installed on XYZ01, where it creates a second instance of SQL Server 2000 named Factory and a database named FactoryDB. You connect to FactoryDB by using Windows Integrated authentication.
You want to add a page to your ASP.NET application to display inventory data from FactoryDB. You use a SqlConnection object to connect to the database. You need to create a connection string to FactoryDB in the instance of SQL Server named Factory on XYZ01. Which string should you use?
You are the administrator of a SQL Server 2000 computer named CorpSQL. The server is a member of a Microsoft Windows NT domain named CORPORATE. Franz maintains a local user account on CorpSQL and is a member of the local Power Users group. He requests access to the SQL Server databases that are stored on CorpSQL.You need to allow Franz to access CorpSQL. Which Transact-SQL statement should you execute?
SQL Server supports a language called Transact-SQL (also called T-SQL).
To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?
Mohan traveled five cities (A, B, C, D and E) starting from home by a car which has a mileage such that the car can travel 10 km in 1 liter petrol. Distance between city A and B is twice the distance between home to city A. Distance between city B and C is thrice the distance between home to city A. Distance between city C and D is 100. Distance between city D and E is 1.5 times than the distance between B and C. Average distance traveled by Mohan was 41 km between five cities. Find how much petrol was needed by Mohan to travel from city B to D.
Which keyword is used in conjunction with DISTINCT keyword?