Question is ⇒ The SQL keyword(s) ________ is used with wildcards., Options are ⇒ (A) LIKE only, (B) IN only, (C) NOT IN only, (D) IN and NOT IN, (E) , Leave your comments or Download question paper.

Question is ⇒ The SQL keyword(s) ________ is used with wildcards., Options are ⇒ (A) LIKE only, (B) IN only, (C) NOT IN only, (D) IN and NOT IN, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	The SQL keyword(s) ________ is used with wildcards.
A.	LIKE only [Correct Answer]
B.	IN only [Wrong Answer]
C.	NOT IN only [Wrong Answer]
D.	IN and NOT IN [Wrong Answer]
View Answer 2 -1 Explanation:- Answer : A Discuss it below : !! OOPS Login [Click here] is required to post your answer/result Help other students, write article, leave your comments

Previous question Next question

Also Read Similar Questions Below :

⇒ How does Tomcat execute a JSP?
As a CGI script
As an independent process
By one of Tomcat's threads
None of the above is correct.

⇒ Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
READCOMMITTED

⇒ How many tables may be included with a join?
One
Two
Three
All of the above.

⇒ What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results

⇒ The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.

⇒ Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Type 1
Type 2
Type 3
Type 4

⇒ What SQL structure is used to limit column values of a table?
The LIMIT constraint
The CHECK constraint
The VALUE constraint
None of the above is correct.

⇒ When using the SQL INSERT statement:
rows can be modified according to criteria only.
rows cannot be copied in mass from one table to another only.
rows can be inserted into a table only one at a time only.
rows can either be inserted into a table one at a time or in groups.

⇒ The SQL keyword(s) ________ is used with wildcards.
LIKE only
IN only
NOT IN only
IN and NOT IN

⇒ Which of the following is one of the basic approaches for joining tables?
Subqueries
Union Join
Natural join
All of the above

⇒ SQL data definition commands make up a(n) ________ .
DDL
DML
HTML
XML

⇒ The SQL keyword BETWEEN is used:
for ranges.
to limit the columns displayed.
as a wildcard.
None of the above is correct.

⇒ Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Lock level
Transaction isolation level
Cursor concurrency setting
Locking hints

⇒ A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands

⇒ A reason for using an SQL view to hide columns is:
to simplify a result only.
to prevent the display of sensitive data only.
to accomplish both of the above.
None of the above are reasons for using an SQL view.

⇒ SQL query and modification commands make up a(n) ________ .
DDL
DML
HTML
XML

⇒ In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
Complete backup
Transaction Log
Differential backup
None of the above is correct.

⇒ Which of the following are the five built-in functions provided by SQL?
COUNT, SUM, AVG, MAX, MIN
SUM, AVG, MIN, MAX, MULT
SUM, AVG, MULT, DIV, MIN
SUM, AVG, MIN, MAX, NAME

⇒ What is the full form of SQL?
Simple Query Language
Structured Query Language
Structured Query List
None of these

⇒ You can add a row using SQL in a database with which of the following?
ADD
CREATE
INSERT
MAKE

⇒ What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
All of the above.

⇒ What is not an advantage of stored procedures?
Greater security
SQL can be optimized
Code sharing
Increased network traffic

⇒ With which type of SQL Server recovery model, is no logging done?
Differential recovery
Full recovery
Bulk-logged recovery
Simple recovery

⇒ A CASE SQL statement is which of the following?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.

⇒ What is bytecode?
Machine-specific code
Java code
Machine-independent code
None of the above is correct.

⇒ Which JDBC driver Type(s) can be used in either applet or servlet code?
Both Type 1 and Type 2
Both Type 1 and Type 3
Both Type 3 and Type 4
Type 4 only

⇒ To sort the results of a query use:
SORT BY.
GROUP BY.
ORDER BY.
None of the above is correct.

⇒ The wildcard in a WHERE clause is useful when?
An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement.
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.

⇒ SQL views can be used to hide:
columns and rows only.
complicated SQL syntax only.
both of the above can be hidden by an SQL view.
None of the above is correct.

⇒ Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
REPEATABLE READ
SERIALIZABLE
READ COMMITTED
READ UNCOMMITTED