Related InterviewSolutions

• Which of the following command is used to get child items in powershell?(a) Get-Child(b) Set-Alias(c) Get-Command(d) Get-ChildItemThe question was posed to me in an interview.My query is from Powershell in section Laying the Foundation of SQL Server
• We can test for the nonexistence of tuples in a subquery by using the __________ construct.(a) Not exist(b) Not exists(c) Exists(d) ExistThe question was asked by my school teacher while I was bunking the class.I want to ask this question from Aggregation of Data topic in section Laying the Foundation of SQL Server
• Which of the following is not an aggregate function?(a) Avg(b) Sum(c) With(d) MinI got this question during an interview.My question is based upon Aggregation of Data in chapter Laying the Foundation of SQL Server
• The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.(a) In(b) Lateral(c) Having(d) WithThe question was posed to me in a job interview.Enquiry is from Aggregation of Data topic in division Laying the Foundation of SQL Server
• SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.(a) Group by(b) With(c) Where(d) HavingI got this question in an online quiz.My doubt stems from Aggregation of Data topic in section Laying the Foundation of SQL Server
• Aggregate functions are functions that take a ___________ as input and return a single value.(a) Collection of values(b) Single value(c) Double value(d) All of the mentionedI had been asked this question by my school principal while I was bunking the class.My question is taken from Aggregation of Data topic in division Laying the Foundation of SQL Server
• ___________ isstored only in the Master database.(a) Database-scoped Dynamic Management View(b) Complex View(c) Catalog View(d) None of the mentionedThe question was posed to me in an interview.I need to ask this question from Views topic in division Laying the Foundation of SQL Server
• Which of the following is not a SQL Server INFORMATION_SCHEMA view?(a) INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE(b) INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS(c) INFORMATION_SCHEMA.KEY_COLUMN_USAGE(d) sys.dm_exec_connectionsI had been asked this question in an internship interview.I'd like to ask this question from Views topic in portion Laying the Foundation of SQL Server
• What is SCHEMABINDING a VIEW?(a) Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view(b) These are stored only in the Master database(c) These types of view are defined by users on a specified schema(d) These are used to show database self describing informationI got this question during an interview.Origin of the question is Views topic in section Laying the Foundation of SQL Server
• You can delete a view with ___________ command.(a) DROP VIEW(b) DELETE VIEW(c) REMOVE VIEW(d) TRUNCATE VIEWThis question was posed to me by my school principal while I was bunking the class.My question is based upon Views in division Laying the Foundation of SQL Server