1
Q:

# A database is used to

 A) store data B) modify data C) extract data D) All of the above

Answer:   D) All of the above

Explanation:

A database is used to store, modify, extract and to search for the data within it.

Q:

A DBMS query language is designed to

 A) Specify the structure of a database B) Support in the development of complex applications software C) Support end users who use English-like commands D) All of the above

Explanation:

0 53
Q:

A UNION query is which of the following?

 A) Combines the output from multiple queries and does not include the same number of columns. B) Combines the output from multiple queries and must include the same number of columns. C) Combines the output from no more than two queries and does not include the same number of columns. D) Combines the output from no more than two queries and must include the same number of columns.

Answer & Explanation Answer: B) Combines the output from multiple queries and must include the same number of columns.

Explanation:

A UNION query combines the output from multiple queries and must include the same number of columns.

2 235
Q:

Which of the following statements is true concerning subqueries?

 A) Does not start with the word SELECT. B) Involves the use of an inner and outer query. C) Cannot return the same result as a query that is not a subquery. D) All of the above

Answer & Explanation Answer: B) Involves the use of an inner and outer query.

Explanation:

0 161
Q:

Which one of the following sorts rows in SQL?

 A) ORDER BY B) GROUP BY C) SORT BY D) ALIGN BY

Explanation:

0 190
Q:

What operator tests column for the absence of data?

 A) NOT operator B) IS NULL operator C) EXISTS operator D) All of the above

Explanation:

SELECT "column_name"

FROM "table_name"

WHERE "column_name" IS NULL.

0 440
Q:

We can modify an existing Company from

 A) Company Info > Alter B) Gateway of Tally > Modify Company C) Company Info > Alter Company D) All of the above

Explanation:

1 300
Q:

The multi part identifier could not be bound is

One of the most common errors that you might face in join statements is

Server: Msg 4104, Level 16, State 1, Line 1The multi-part identifier could not be bound.

A multipart identifier is any description of a field or table that contains multiple parts - for instance MyTable.SomeRow - if it can't be bound that means there's something wrong with it - either you've got a simple typo, or a confusion between table and column. It can also be caused by using reserved words in your table or field names and not surrounding them with [].

The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, and then if you get error above, this means that Table1 cannot be found in the query. Sometimes you can see that source table exists in the query, but T-SQL cannot understand it, especially when you write join statements.

In SQL, UNION  merges the contents of two structurally-compatible tables into a single combined table.