Filters
Question type
Study Flashcards

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?​


A) ​NATURAL JOIN
B) ​JOIN...ON
C) ​LEFT OUTER JOIN
D) ​FULL OUTER JOIN

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

A column qualifier indicates the column containing the data being referenced._________________________​

A) True
B) False

Correct Answer

verifed

verified

Explain the difference between an inner join and an outer join.

Correct Answer

verifed

verified

An inner join only returns rows from one...

View Answer

A table alias is assigned to a table in the WHERE clause.​

A) True
B) False

Correct Answer

verifed

verified

​ Structure of the ORDERS table Structure of the CUSTOMERS table ​ -​Which of the following SQL statements will return the names of all customers who placed an order on April 12,2003? A) SELECT lastname,firstname FROM customers WHERE orderdate = '12-APR-03'; B) SELECT lastname,firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03'; C) SELECT lastname,firstname FROM customers JOIN orders ON (customer#) WHERE orderdate = '12-APR-03'; D) ​both a and b ​ Structure of the ORDERS table ​ Structure of the ORDERS table Structure of the CUSTOMERS table ​ -​Which of the following SQL statements will return the names of all customers who placed an order on April 12,2003? A) SELECT lastname,firstname FROM customers WHERE orderdate = '12-APR-03'; B) SELECT lastname,firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03'; C) SELECT lastname,firstname FROM customers JOIN orders ON (customer#) WHERE orderdate = '12-APR-03'; D) ​both a and b Structure of the CUSTOMERS table ​ -​Which of the following SQL statements will return the names of all customers who placed an order on April 12,2003?


A) SELECT lastname,firstname
FROM customers
WHERE orderdate = '12-APR-03';
B) SELECT lastname,firstname
FROM customers NATURAL JOIN orders
WHERE orderdate = '12-APR-03';
C) SELECT lastname,firstname
FROM customers JOIN orders ON (customer#)
WHERE orderdate = '12-APR-03';
D) ​both a and b

E) A) and C)
F) C) and D)

Correct Answer

verifed

verified

A(n)Cartesian Join replicates each row from the first table with every row from the second table._________________________​

A) True
B) False

Correct Answer

verifed

verified

​A table alias can consist of a maximum of ____ characters.


A) ​12
B) ​225
C) ​255
D) ​30

E) A) and B)
F) B) and D)

Correct Answer

verifed

verified

A(n)non-equality join is when a table is joined to itself._________________________​

A) True
B) False

Correct Answer

verifed

verified

The ____________________ keywords create a join automatically between two tables,based on columns with matching names.

Correct Answer

verifed

verified

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.​

A) True
B) False

Correct Answer

verifed

verified

A cross join between two tables,containing four rows each,will display eight rows in its output._________________________​

A) True
B) False

Correct Answer

verifed

verified

​A(n) ____ is used to combine the results of two queries.


A) ​concatenation operator
B) ​set operator
C) ​comparison operator
D) ​logical operator

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

A Cartesian join usually results from the user omitting the joining condition that links two or more tables together.​

A) True
B) False

Correct Answer

verifed

verified

The JOIN keyword is included in which of the following clauses?​


A) ​SELECT
B) ​FROM
C) ​WHERE
D) ​ORDER BY

E) A) and D)
F) A) and B)

Correct Answer

verifed

verified

A(n)non-equality join is also known as an equijoin,inner join,or simple join._________________________​

A) True
B) False

Correct Answer

verifed

verified

Structure of the BOOKS table Structure of the PUBLISHER table -​Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table,as well as the name of the contact person and the phone number to call to reorder the book? A) SELECT title,cost,contact,phone FROM publisher,books; B) SELECT title,cost,contact,phone FROM publisher JOIN books USING (pubid) ; C) SELECT title,cost,contact,phone FROM publisher JOIN books USING (isbn) ; D) SELECT title,cost,contact,phone FROM publisher JOIN books USING (contact) ; Structure of the BOOKS table Structure of the BOOKS table Structure of the PUBLISHER table -​Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table,as well as the name of the contact person and the phone number to call to reorder the book? A) SELECT title,cost,contact,phone FROM publisher,books; B) SELECT title,cost,contact,phone FROM publisher JOIN books USING (pubid) ; C) SELECT title,cost,contact,phone FROM publisher JOIN books USING (isbn) ; D) SELECT title,cost,contact,phone FROM publisher JOIN books USING (contact) ; Structure of the PUBLISHER table -​Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table,as well as the name of the contact person and the phone number to call to reorder the book?


A) SELECT title,cost,contact,phone
FROM publisher,books;
B) SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (pubid) ;
C) SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (isbn) ;
D) SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (contact) ;

E) A) and C)
F) A) and D)

Correct Answer

verifed

verified

​In which of the following examples is the ORDERS table used as a column qualifier?


A) ​o.order#
B) ​orders.order#
C) ​order#.o
D) ​order#.orders

E) A) and B)
F) C) and D)

Correct Answer

verifed

verified

If you are attempting to join two tables that have multiple common columns,which of the following JOIN keywords should be used to specify how the tables should be linked?​


A) ​OUTER JOIN
B) ​CROSS JOIN
C) ​JOIN...USING
D) ​none of the above

E) C) and D)
F) None of the above

Correct Answer

verifed

verified

A(n)non-equality join is used when there are no equivalent rows of data in the tables that are being joined._________________________​

A) True
B) False

Correct Answer

verifed

verified

​The outer join operator is placed on the side of the joining condition that has ____________________ rows.

Correct Answer

verifed

verified

​deficient...

View Answer

Showing 81 - 100 of 119

Related Exams

Exam 1

Overview of Database Concepts

108 Questions

Exam 2

Basic SQL Select Statements

121 Questions

Exam 3

Table Creation and Management

136 Questions

Exam 4

Constraints

132 Questions

Exam 5

Data Manipulation and Transaction Control

136 Questions

Exam 6

Additional Database Objects

138 Questions

Exam 7

User Creation and Management

130 Questions

Exam 8

Restricting Rows and Sorting Data

132 Questions

Exam 10

Selected Single-Row Functions

133 Questions

Exam 11

Group Functions

137 Questions

Exam 12

Subqueries and Merge Statements

131 Questions

Exam 13

Views

133 Questions

Show Answer