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?
Look at the following keywords: Categorises, combines, compiles, composes, creates, devises, designs. These keywords belong to which of the following categories?
How many wildcards can be used with LIKE operator in SQL?
Which of the following wildcards can be used in MS Access and SQL server? , b) , c) , d) ,
The SQL -92 wildcards are ____ and ____ .
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
Which of the following shell's wildcards are used to match any number of characters including none?
Which of the following wildcards are used in conjunction with the LIKE operator?
Wildcards cannot be used as a substitute for special characters i.e. characters other than alphabets.
Wildcards are special characters which are used to replace or represent one or more characters.