Which of the following is the correct order of keywords for SQL SELECT statements?

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?

A

EXEC sp_defaultdb 'Andrew','FinanceData'

B

GRANT ALL ON FinanceData TO Andrew

C

EXEC sp_addlogin 'Andrew'

D

EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew'

Which of the following instances can be held to be final orders?
1. An order of a High Court dismissing an appeal for the appellant's failure to furnish order
2. An order that an appeal had abated
3. An order in a revision reversing the dismissal of a suit and restoring it to the file of the lower court when such an order had the effect of reinstating a primary decree
4. An order refusing an application under section 45 of the Specific Relief Act 1 of 1877
5. An order passed by a High Court in insolvency proceedings

A

2, 3

B

1, 4

C

1, 5, 6

D

All of these

SQL keywords are case sensitive.

A

True

B

False

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?

A

?Server=XYZ01;Data Source=Factory; Initial Catalog=FactoryDB;Integrated Security=SSPI?

B

?Server=XYZ01;Data Source=Factory; Database=FactoryDB;Integrated Security=SSP1?

C

?Data Source=XYZ01\\Factory; Initial Category=Factory; Integrated Security=SSP1?

D

?Data Source=XYZ01\\Factory; Database=FactoryDB; Integrated Security=SSP1?

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?

A

EXEC sp_grantlogin CorpSQL\\Franz

B

EXEC sp_grantlogin Franz

C

EXEC sp_grantlogin Power Users\\Franz

SQL Server supports a language called Transact-SQL (also called T-SQL).

A

True

B

False

Which of the following represents the correct order for keywords?

A

IF, THEN, ELSIF, THEN, ELSE

B

IF, ELSE, THEN, ELSIF, THEN

C

IF, ELSIF, THEN, ELSE, THEN

D

IF, THEN, ELSE, THEN, ELSIF

________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.

A

Archival

B

Fuzzy

C

SQL

D

All of the mentioned

Which of the following instances of order are decrees?
1. An order rejecting an application for leave to sue in forma pauperis for no suit has till then been filed
2. An order refusing leave to institute for accounts of religious endowment
3. An order under the Indian Trusts Act, 1882 dismissing an application for the removal of trustee
4. An order on a settlement case under section 104 (2) of the Bengal Tenancy Act 3 of 1898 as the proceeding is instituted not by a plaint but by an application
5. An order made on an application to the District Court under section 84 (2) of the Madras Religious Endowments Act 2 of 1927

A

1, 3

B

2, 5

C

2, 4, 5

D

All of these

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

A

GROUP BY

B

WHERE

C

ORDER BY

D

FROM

Which of the following is the correct order of keywords for SQL SELECT statements?

Related Questions