Question is ⇒ What type of join is needed when you wish to include rows that do not have matching values?, Options are ⇒ (A) Equi-join, (B) Natural join, (C) Outer join, (D) All of the above., (E) , Leave your comments or Download question paper.

Question is ⇒ What type of join is needed when you wish to include rows that do not have matching values?, Options are ⇒ (A) Equi-join, (B) Natural join, (C) Outer join, (D) All of the above., (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	What type of join is needed when you wish to include rows that do not have matching values?
A.	Equi-join [Wrong Answer]
B.	Natural join [Wrong Answer]
C.	Outer join [Correct Answer]
D.	All of the above. [Wrong Answer]
View Answer 2 -1 Explanation:- Answer : C 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 :

⇒ ________ was adopted as a national standard by ANSI in 1992.
Oracle
SQL
Microsoft Access
DBase

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

⇒ Which of the following is true concerning systems information in an RDBMS?
RDBMS store database definition information in system-created tables.
This information can be accessed using SQL.
This information often cannot be updated by a user.
All of the above.

⇒ 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.

⇒ To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
ONLY
UNIQUE
DISTINCT
SINGLE

⇒ What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
VBScript only
Jscript only
Java only
All of the above are supported

⇒ ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS

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

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

⇒ Who invented Java?
Netscape
Microsoft
Sun
None of the above is correct.

⇒ What is an advantage of placing computations in SQL views?
To save users from having to write an expression.
To ensure that the results are consistent.
To accomplish both of the above.
None of the above is correct - computations cannot be placed in a view.

⇒ Which is NOT one of the most common types of SQL CHECK constraints?
System date
Range checks
Lists of values
Comparing one column value to another within the same table

⇒ The DROP TABLE statement:
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.

⇒ 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

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

⇒ To define what columns should be displayed in an SQL SELECT statement:
use FROM to name the source table(s) and list the columns to be shown after SELECT.
use USING to name the source table(s) and list the columns to be shown after SELECT.
use SELECT to name the source table(s) and list the columns to be shown after USING.
use USING to name the source table(s) and list the columns to be shown after WHERE.

⇒ Which of the following do you need to consider when you make a table in SQL?
Data types
Primary keys
Default values
All of the above.

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

⇒ 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

⇒ The benefits of a standard relational language include which of the following?
Reduced training costs
Increased dependence on a single vendor
Applications are not needed.
All of the above.

⇒ 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.

⇒ Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
Type 1 only
Type 2 only
Both Type 3 and Type 4
All of Type 1, Type 2, Type 3 and Type 4

⇒ What is not true of a Java bean?
There are no public instance variables.
All persistent values are accessed using get and set methods.
It may have many constructors as necessary.
All of the above are true of a Java bean.

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

⇒ When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.

⇒ The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.

⇒ The HAVING clause does which of the following?
Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.

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

⇒ The strictest transaction isolation level provided by SQL Server is called:
REPEATABLE READ.
SERIALIZABLE.
READ COMMITTED.
READ UNCOMMITTED.

⇒ What servlet processor was developed by Apache Foundation and Sun?
Apache Tomcat
Apache Web server
Sun servlet processor
None of the above is correct.