The space use of XML indexes can be found in the table-valued function named?(a) sys.dm_db_index_physical_stats(b) sys.dm_db_index_phy_stats(c) sys.dm_db_index_plan_stats(d) sys.dm_db_index_table_statsThis question was addressed to me in exam.The origin of the question is Working With XML Data topic in chapter Beyond Relational of SQL Server

The space use of XML indexes can be found in the table-valued function

1.	The space use of XML indexes can be found in the table-valued function named?(a) sys.dm_db_index_physical_stats(b) sys.dm_db_index_phy_stats(c) sys.dm_db_index_plan_stats(d) sys.dm_db_index_table_statsThis question was addressed to me in exam.The origin of the question is Working With XML Data topic in chapter Beyond Relational of SQL Server
Answer» Right option is (a) sys.dm_db_index_physical_stats The explanation is: sys.dm_db_index_physical_stats provides information, such as the NUMBER of DISK pages OCCUPIED, average row SIZE in bytes, and number of records, for all index TYPES.

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