In which of the following scenario, using XML native storage would be inappropriate?(a) Fixed schema(b) You want to query and modify your XML data(c) You want to index the XML data for faster query processing(d) Your application needs system catalog views to administer your XML data and XML schemaI had been asked this question during an interview.This key question is from Working With XML Data topic in division Beyond Relational of SQL Server

In which of the following scenario, using XML native storage would be

1.	In which of the following scenario, using XML native storage would be inappropriate?(a) Fixed schema(b) You want to query and modify your XML data(c) You want to index the XML data for faster query processing(d) Your application needs system catalog views to administer your XML data and XML schemaI had been asked this question during an interview.This key question is from Working With XML Data topic in division Beyond Relational of SQL Server
Answer» The correct choice is (a) FIXED schema For EXPLANATION I would SAY: XML is appropriate when we may or may not have a schema for your XML DATA.

Discussion

No Comment Found

Related InterviewSolutions

CONTAINS and CONTAINSTABLE look for a _______ match for the phrase.(a) exact(b) similar(c) different(d) none of the mentionedThis question was posed to me by my school teacher while I was bunking the class.The question is from Full Text Search in chapter Beyond Relational of SQL Server
The CONTAINS and FREETEXT predicates return a _________value.(a) TRUE or FALSE(b) Scalar(c) One(d) All of the mentionedThe question was posed to me by my college director while I was bunking the class.Question is taken from Full Text Search in portion Beyond Relational of SQL Server
FREETEXTTABLE is a full text _____________(a) Predicate(b) Function(c) Procedure(d) All of the mentionedI got this question during an interview.The question is from Full Text Search in chapter Beyond Relational of SQL Server
Which of the following predicates is used for full text search?(a) TEXT()(b) FREETEXT()(c) TEXT()(d) All of the mentionedI got this question in an online interview.My doubt stems from Full Text Search in portion Beyond Relational of SQL Server
Full text indexing is a great feature that solves a database problem, the searching of _________ columns for specific words and phrases in SQL Server databases.(a) Textual data(b) Character data(c) String(d) All of the mentionedI had been asked this question in semester exam.I would like to ask this question from Full Text Search in section Beyond Relational of SQL Server
Point out the wrong statement.(a) To define full-text searches, SQL Server full-text queries use the full-text predicates(b) Full-text queries perform linguistic searches against text data(c) Before you can run full-text queries on a table, the database administrator must create a full-text index on the table(d) Full-text search is applicable to a shorter range of business scenariosThis question was posed to me in final exam.Enquiry is from Full Text Search in section Beyond Relational of SQL Server
Full-Text Search in SQL Server lets users and applications run _________ queries.(a) simple queries(b) full-text(c) scalar(d) none of the mentionedThis question was posed to me during an interview.My question comes from Full Text Search topic in division Beyond Relational of SQL Server
Full-text search is an ________ component of the SQL Server Database Engine.(a) slower(b) optimal(c) faster(d) none of the mentionedThis question was posed to me during an online interview.Question is taken from Full Text Search topic in chapter Beyond Relational of SQL Server
We can create a full-text index on _____________(a) table(b) view(c) indexed view(d) all of the mentionedThe question was asked in an online quiz.I want to ask this question from Full Text Search in portion Beyond Relational of SQL Server
Point out the correct statement.(a) The full-text index includes only one character-based column in the table(b) The full-text index includes more than one character-based columns in the table(c) The full-text index includes one or more character-based columns in the table(d) None of the mentionedI got this question by my school principal while I was bunking the class.This is a very interesting question from Full Text Search in portion Beyond Relational of SQL Server

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment