sql – programming-sql – কুইজ মডেল টেস্ট অনুশীলন – 21

sql – programming-sql – কুইজ মডেল টেস্ট অনুশীলন – 21

8826. Which type of DML Trigger, executes one or more methods written in managed code that are members of an assembly created in the .NET Framework and uploaded in SQL Server

1. POST
2. AFTER
3. None of the above
4. DELAYED

8827. Where does the SQL trigger is stored in

1. None of the above
2. index
3. database catalog
4. stored procedure

8828. What is referred with the term ‘Markup Language’ in XML

1. that text is mixed with extra information about the text
2. that the text is not readable with a standard text editor
3. that tags are saved in Unicode
4. that tags may contain other tags or nesting

8829. Which attribute for the root element xs:schema is necessary if you want to place the elements in a namespace

1. attributeFormDefault
2. targetNamespace
3. elementFormDefault
4. defaultNamespace

8830. Which statement is true about Xpath

1. With XPath we specify the standard path of an XML file.
2. XPath shows the relations between several XML documents.
3. Xpath is a standard for transformation of XML documents.
4. XPath is intensively used in XQuery and XSLT.

8831. Which catalog view confirms that an XML schema is not used before dropping it

1. sys.column_xml_schema_collection_usages
2. sys.xml_schema_collections
3. sys.xml_schema_components
4. sys.xml_schema_namespaces

8832. What is the need for an XML parser

1. to translate XML
2. to compile XML
3. to validate an XML-document
4. to check the XML content for spelling errors

8833. What is needed for a well-formed document

1. The document must be created with an XML-editor.
2. The document must be saved in UTF-8 or UTF-16
3. The document must be saved in UTF-8
4. The document must be hierarchically structured.

8834. Which code will validate XML data in database by an given "CustomerSchema" XML schema

1. CREATE DEFAULT CustomerSchema AS ‘XML’
2. CREATE XML SCHEMA COLLECTION CustomerSchema
3. CREATE SCHEMA CustomerSchema
4. CREATE PRIMARY XML INDEX CustomerSchema

8835. Which system stored procedure will flush the XML from memory which has a large number of XML handles that are currently active

1. sp_xml_preparedocument
2. sp_reserve_http_namespace
3. sp_delete_http_namespace_reservation
4. sp_xml_removedocument

আমাদের কাছে থাকা লক্ষ লক্ষ মডেল টেস্ট থেকে প্রাকটিজের জন্য কিছু এখানে তুলে ধরা হল। প্রতিটি অধ্যায়ের উপরে ইশিখন.কম কুইজ চ্যালেঞ্জ এ আছে শত শত মডেল টেস্ট বার বার মডেল টেস্ট দিয়ে নিজেকে যাচাই কর এবং পুরো বাংলাদেশের সকল শিক্ষার্থীর সাথে আপনার মেধা তালিকা দেখুন। প্রশ্নে কোন প্রকার ভুল থাকলে সঠিক উত্তরসহ নিচে কমেন্ট করে জানাবেন, আমরা ঠিক করে দেবো।