12
Q:

Which operator performs pattern matching ?

A) LIKE operator B) EXISTS operator
C) BETWEEN operator D) None of these

Answer:   A) LIKE operator



Explanation:

LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).

 

The syntax is as follows:
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN}

 

{PATTERN} often consists of wildcards.

 

In SQL, there are two wildcards:


% (percent sign) represents zero, one, or more characters.

_ (underscore) represents exactly one character.

 

More :: Certification Questions on SQL

Q:

Oracle SQL developer is an

Answer

Oracle SQL developer is an Oracle Database IDE.

Report Error

View answer Workspace Report Error Discuss

0 53
Q:

AND, OR and NOT are examples of

A) Clauses B) Boolean operators
C) Conjuctive operators D) Exclusive operators
 
Answer & Explanation Answer: B) Boolean operators

Explanation:
Report Error

View Answer Workspace Report Error Discuss

0 86
Q:

Which of the following is a comparison operator in SQL?

A) = B) <>
C) ` D) /
 
Answer & Explanation Answer: A) =

Explanation:

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Report Error

View Answer Workspace Report Error Discuss

0 102
Q:

A database is used to

A) store data B) modify data
C) extract data D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

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

Report Error

View Answer Workspace Report Error Discuss

1 151
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
 
Answer & Explanation Answer: D) All of the above

Explanation:
Report Error

View Answer Workspace Report Error Discuss

0 115
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.

Report Error

View Answer Workspace Report Error Discuss

2 332
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:
Report Error

View Answer Workspace Report Error Discuss

0 214
Q:

Which one of the following sorts rows in SQL?

A) ORDER BY B) GROUP BY
C) SORT BY D) ALIGN BY
 
Answer & Explanation Answer: A) ORDER BY

Explanation:
Report Error

View Answer Workspace Report Error Discuss

0 285