Schema Questions And Answers

1⟩ What is an abstract schema?

Abstract schema is part of an entity bean’s deployment descriptor which defines the bean’s persistent fields and their relationship. Abstract schema is specifed for entity beans with container managed persistence. We specify the name of the Abstract schema name in the deployment descriptor. The queries written in EJB QL for the finder methods references this name. The information provided in this Abstract Schema is used by the container for persistence management and relationship management.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

195 views

2⟩ What is inline schema, how does it works?

Schemas can be included inside of XML file is called Inline Schemas.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

193 views

3⟩ What is meant by a schema?

Schema is collection of functions which are executed in a specified squence and the results of the function are passed on to the next function

Is this answer helpful? 0 Yes | 0 No

Answer This Question

178 views

4⟩ Define XML schema permission "Database_user"?

Specifies a database user.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

193 views

5⟩ Define XML schema permission "[ WITH GRANT OPTION ]"?

Indicates that the principal will also be given the ability to grant the specified permission to other principals.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

202 views

6⟩ Why use an XML Schema?

Schemas allow all applications to understand the rules and content of the page.

A schema is the blueprint of an XML document. Since XML works to move data, it is essential that the sender and the receiver of this data both understand the content.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

200 views

7⟩ Define XML schema permission "TO <database_principal> [ ,...n ]"?

Specifies the principal to which the permission is being granted.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

186 views

8⟩ Define XML schema permission "XML SCHEMA COLLECTION [ schema_name . ]"?

Specifies the XML schema collection on which the permission is being granted.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

186 views

9⟩ Define XML schema permission "GRANT permission [ ,...n ] ON"?

Specifies a permission that can be granted on an XML schema collection.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

190 views

10⟩ Give syntax and examples for creating and dropping XML schema collection?

Syntax and example for creating and dropping XML schema collection:

★ CREATE XML SCHEMA COLLECTION [ <relational_schema>. ]sql_identifier AS Expression

★ relational_schema: identifies the relational schema name. Default is relational schema.

★ sql_identifier: is the SQL identifier for the XML schema collection.

★ Expression is a string constant or scalar variable. It can be a varchar, varbinary, nvarchar, or xml type.

★ DROP XML SCHEMA COLLECTION [ relational_schema. ]sql_identifier

relational_schema identifies the relational schema name.

sql_identifier is the name of the XML schema collection to drop.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

190 views

11⟩ What is meant by the Waterfall Model?

The waterfall model is a popular version of the systems development life cycle model for software engineering. Often considered the classic approach to the systems development life cycle, the waterfall model describes a development method that is linear and sequential. Waterfall development has distinct goals for each phase of development. Imagine a waterfall on the cliff of a steep mountain. Once the water has flowed over the edge of the cliff and has begun its journey down the side of the mountain, it cannot turn back. It is the same with waterfall development. Once a phase of development is completed, the development proceeds to the next phase and there is no turning back

Is this answer helpful? 0 Yes | 0 No

Answer This Question

208 views

12⟩ Describe Database Connection pooling relative to the MTS?

This enables MTS to reuse database connections.Â Database connections are sent to "sleep" mode as against normal constructions and destructions.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

206 views

13⟩ Which method do you invoke on the DataAdapter control to load your generated dataset with data?

The Fill() method.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

211 views

14⟩ Which 3 major elements SQL Server (server-side) supports?

1) Creation of XML fragments: This is done from the relational data using FOR XML to the select query.

2) Ability to shred xml data to be stored in the database.

3) Finally, storing the xml data.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

207 views

15⟩ Define XML support SQL server extends?

SQL server can return XML document using FOR XML clause. XML documents can be added to SQL Server database and you can use the OPENXML clause to display the data from the document as a relational result set. SQL Server 2000 supports XPath queries.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

194 views

16⟩ Limitations of the XML Schema collection?

★ SQL Server limits identifiers of schema components to a maximum length of 1000 Unicode characters. Also, surrogate character pairs within identifiers are not supported.

★ SQL Server does not support restrictions from union types.

★ The values for minOccurs and maxOccurs attributes must fit into 4-byte integers. Schemas that do not conform are rejected by the server.

★ xsi:schemaLocation and xsi:noNamespaceSchemaLocation

★ SQL Server ignores these attributes if they are present in the XML instance data inserted into a column or variable of xml data type.

★ SQL Server rejects schemas that have an particle without children, unless the particle is defined with a minOccurs attribute value of zero.

★ Currently, SQL Server does not support . XML schemas that include this element are rejected by the server.

★ Currently, SQL Server does not support <xsd:key>, <xsd:keyref>, and <xsd:unique> constraints for enforcing uniqueness or establishing keys and key references. XML schemas that contain these elements cannot be registered.

★ The length, minLength, and maxLength facets are stored as a long type. This type is a 32-bit type. Therefore, the range of acceptable values for these values is 2^31.

★ SQL Server does not support the NOTATION type.

★ SQL Server does not support types derived from xs:QName that use an XML Schema restriction element and the union types with xs:QName as a member element.

★ Members cannot be added to an existing substitution group in an XML schema collection.

★ The canonical representation of a value cannot violate the pattern restriction for its type.

★ SQL Server does not support XML schemas with types that have pattern facets or enumerations that violate those facets.

★ In working with large XML schema collections, an out-of-memory condition might occur.

★ SQL Server rejects schemas in which the block or final attribute has repeated values such as "restriction restriction" and "extension extension". .

Is this answer helpful? 0 Yes | 0 No

Answer This Question

223 views

17⟩ Can we write a DTD instead of Schema?

You could write a DTD for an XML page and accomplish some of the same goals. However, because a schema is written in XML, there is no new syntax or rules to understand. If you can write a page in XML, you can write an XML schema.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

198 views

18⟩ Client-side XML support in SQL Server is in the form of SQLXML. Described in terms?

XML Views:

Providing bidirectional mapping between XML schema's and relational tables.

Creation of XML Templates:

Allows creation of dynamic sections in XML.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

221 views

19⟩ Define XML schema permission "| Database_user_mapped_to_certificate"?

Specifies a database user mapped to a certificate.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

201 views

20⟩ Describe XML Schema?

A schema is a blueprint of an XML document that defines the elements, data types and nesting structure of the page.

An XML schema is a road map for the XML document similar to a Document Type Definition (DTD). Created by the World Wide Web Consortium (W3C), schemas describe the elements and map out the presentation and nesting of XML documents.

Essentially, the schema enables all applications to understand the flow of the page and validate the elements.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

210 views

Schema

Home Applications Programs Schema

27 Schema Questions And Answers

1⟩ What is an abstract schema?

2⟩ What is inline schema, how does it works?

3⟩ What is meant by a schema?

4⟩ Define XML schema permission "Database_user"?

5⟩ Define XML schema permission "[ WITH GRANT OPTION ]"?

6⟩ Why use an XML Schema?

7⟩ Define XML schema permission "TO <database_principal> [ ,...n ]"?

8⟩ Define XML schema permission "XML SCHEMA COLLECTION [ schema_name . ]"?

9⟩ Define XML schema permission "GRANT permission [ ,...n ] ON"?

10⟩ Give syntax and examples for creating and dropping XML schema collection?

11⟩ What is meant by the Waterfall Model?

12⟩ Describe Database Connection pooling relative to the MTS?

13⟩ Which method do you invoke on the DataAdapter control to load your generated dataset with data?

14⟩ Which 3 major elements SQL Server (server-side) supports?

15⟩ Define XML support SQL server extends?

16⟩ Limitations of the XML Schema collection?

17⟩ Can we write a DTD instead of Schema?

18⟩ Client-side XML support in SQL Server is in the form of SQLXML. Described in terms?

19⟩ Define XML schema permission "| Database_user_mapped_to_certificate"?

20⟩ Describe XML Schema?

Quick Links:

Schema

Home Applications Programs Schema

27 Schema Questions And Answers

1⟩ What is an abstract schema?

2⟩ What is inline schema, how does it works?

3⟩ What is meant by a schema?

4⟩ Define XML schema permission "Database_user"?

5⟩ Define XML schema permission "[ WITH GRANT OPTION ]"?

6⟩ Why use an XML Schema?

7⟩ Define XML schema permission "TO <database_principal> [ ,...n ]"?

8⟩ Define XML schema permission "XML SCHEMA COLLECTION [ schema_name . ]"?

9⟩ Define XML schema permission "GRANT permission [ ,...n ] ON"?

10⟩ Give syntax and examples for creating and dropping XML schema collection?

11⟩ What is meant by the Waterfall Model?

12⟩ Describe Database Connection pooling relative to the MTS?

13⟩ Which method do you invoke on the DataAdapter control to load your generated dataset with data?

14⟩ Which 3 major elements SQL Server (server-side) supports?

15⟩ Define XML support SQL server extends?

16⟩ Limitations of the XML Schema collection?

17⟩ Can we write a DTD instead of Schema?

18⟩ Client-side XML support in SQL Server is in the form of SQLXML. Described in terms?

19⟩ Define XML schema permission "| Database_user_mapped_to_certificate"?

20⟩ Describe XML Schema?

BE THE FIRST TO KNOW

Quick Links: