The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

The “from” programs convert sequence files from GCG format into the named format, and the “to” programs convert the alternative format into GCG format.

A

True

B

False

Which of the following statement/s about Fundamental Duties is/are not correct?
1. The Fundamental Duties are incorporated in Article 51A (part IVA) of Consitution.
2. The Fundamental Duties are inserted in the Constitution by the 42^nd Constitution Amendment Act, 1976.
3. The Fundamental Duties have to be fulfilled by every person living in India.
4. The eleventh Fundamental Duty was added by the 86^th Constitution Amendment Act, 2006.
Choose the correct answer:

A

1 and 2 are correct

B

2 and 3 are not correct

C

3 and 4 are correct

D

Only 3 is not correct

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'

You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create anapplication. The application connects to a Microsoft SQL Server 2008 database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures to return multiple result sets. You need to ensure that the result sets are returned as strongly typed values. What should you do?

A

Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult

B

Apply the FunctionAttribute and ParameterAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

C

Apply the ResultTypeAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

D

Apply the ParameterAttribute to the stored procedure function. Use the GetResult

Which of the following is true about the fundamental rights under Indian Constitution?
1. It is protected and enforced by the Constitution.
2. It can be changed by the common legislative process.
3. Supreme Court is the guardian of fundamental rights.
4. All Constitutional rights are fundamental rights.
Select the correct answer:

A

1 and 3

B

1 and 2

C

1, 2 and 4

D

1, 3 and 4

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 statement(s) is/are incorrect?
1. Chapter III on Fundamental Rights of the Constitution is based upon Bill of Rights of the U. S. A.
2. Right to die' is a Fundamental Right Under Article 21 of the Constitution
3. Indian Constitution is a Complete Federal Constitution
4. Fundamental Rights can be waived under the Indian, Constitution

A

Only 2

B

3 and 4 only

C

2 and 3

D

2, 3 and 4

The question below consists of a set of labelled sentences. These sentences, when properly sequenced form a coherent paragraph. Select the mostlogical order of sentences from among the options. P: While it is good to see SEBI taking a serious view of leaks and initiating suo motu action, bringing the perpetrators to book through such old-fashioned methods 0may be an uphill task.
Q: But recent episodes of suspected insider trading through WhatsApp groups, in which analysts shared prescient tip-offs about upcoming results for top listedcompanies, reveals that the framework remains porous.
R: The Ministry of Corporate Affairs and the Securities Exchange Board of India (SEBI) have lately redoubled their efforts to put in place a water-tight governance framework for listed firms.
S: Initiating a probe into this episode, SEBI has interrogated analysts, conducted raids on stock brokers and deployed search-and-seizure powers to confiscatelaptops and mobile phones.

A

RQSP

B

QSPR

C

SPQR

D

PRQS

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Related Questions