Sql server objective questions pdf

True B. False Ans: A 8. False Ans: A 9. A row in a database can also be called a domain. False Ans: B A first step in database creation should be needs analysis. False Ans: A ADD B. MAKE Ans: c Both A and B are correct. Neither A nor B are correct. Ans: B To specify the syntax and semantics of SQL data definition language B.

To specify the syntax and semantics of SQL manipulation language C. To define the data structures D. All of the above. Ans: D A virtual table that can be accessed via SQL commands B. A virtual table that cannot be accessed via SQL commands C. A base table that can be accessed via SQL commands D.

DDL B. DML C. HTML D. XML Ans: A Yes B. No Ans: A One user at a time is allowed to connect to the database C. Only some members are allowed to access the database D. Only the system admin and some members are allowed to access the database Ans: A What is the difference between adhoc queries from stored procedures? Adhoc queries are placed embedded in the business logic code B.

Stored procedures are placed embedded in the business logic code C. There is no difference as both are fired on the databases D. West Bengal Current Affairs. November October September August July June May April Agriculture Current Affairs.

Bank Current Affairs. Committees and Commissions Current Affairs. Memorandum of Understanding Current Affairs. Economic Survey Currrent Affairs. Environment Current Affairs. Festivals Current Affairs.

Finance Current Affairs. Health Current Affairs. History Current Affairs. Indian Polity Current Affairs. International Relationship Current Affairs. Sports Current Affairs. Union Budget Current Affairs. Ad-hoc queries are placed embedded in the business logic code B. Stored procedures are placed embedded in the business logic code C. There is no difference as both are fired on the databases D. None of the above Ans: A. A candidate key cannot be regarded as a possible primary key A.

Save my name, email, and website in this browser for the next time I comment. All of the above Ans: C 3. None Ans: A 4. Which operation, when performed on a database can throw an error A. False Ans: B 8. Root Ans: C