1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
iren [92.7K]
4 years ago
6

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?
1. outer join
2. join ... using
3. cross join
4. none of the above
Computers and Technology
1 answer:
slava [35]4 years ago
6 0

Join ... using keywords should be used to specify how the tables should be linked.

2. join ... using

<u>Explanation:</u>

If table is has to be linked it can be connected normally as outer join with same column name.

Purpose of outer join is to fetch the matched records among the table and get the relevant records from table.

People can also use select statement with “IN” sub query, if we use “IN” query execute very slow during the fetching the matched records.

As good practice join using is used in same column name is available across the table.

By using join using in query end user can set some query conditions also.

You might be interested in
A ________ database state is one in which all data integrity constraints are satisfied
beks73 [17]
A consistent database base is one in which all data integrity constraints are satisfied.
8 0
3 years ago
Read 2 more answers
Mad Libs are activities that have a person provide various words, which are then used to complete a short story in unexpected (a
oksano4ka [1.4K]

Answer:

The program to this question can be defined as follows:

Program:

import java.util.*; //import package

public class Main //defining class

{

   public static void main(String[] as) //defining main method

   {

       Scanner ax= new Scanner(System.in);//create Scanner class object for user-input

       String val; //defining String variable

       int x;//defining an integer variable

       System.out.print("Enter string value first then numeric, and for exit 'quit & 0': \n");

       val = ax.next(); //input value

       x = ax.nextInt();//input value

       while(!(val.equals("quit") && x==0)) //Check value

       {

           System.out.println("Eating "+x+" "+val+" a day keeps the doctor away."); //print value

           val = ax.next(); //input value

           x= ax.nextInt(); //input value

       }

   }

}

Output:

Enter string value first then numeric, and for exit 'quit & 0':  

apple 5

Eating 5 apple a day keeps the doctor away.

shoes 2

Eating 2 shoes a day keeps the doctor away.

quit 0

Explanation:

In the above program, two variable "val" and "x" is declared, in which "val" is string variable and "x" is integer variable, in the next line, a while loop is declared, which can be described as follows:

In the loop, a condition is checked, that "val" is equal to "quit" and x is equal to "0", inside the loop, it will input value from the user-end.  

8 0
4 years ago
Read 2 more answers
What is the hexadecimal equivalent for 11000101?
Makovka662 [10]

Answer: C5₁₆ ⇔ 11000101₂ ⇔ 197⏨

Explanation: 11000101 is a binary number

it's equivalent decimal number is

1x2⁷+ 1x2⁶+0x2⁵ + 0x2⁴+0x2³+1x2²+0x2¹+1x2⁰ = 128+64+4+1 = 197

Hexadecimal system has equivalents in decimal system

0 ⇔0

1 ⇔ 1

2 ⇔ 2

3 ⇔ 3

4 ⇔ 4

5 ⇔ 5

6 ⇔ 6

7 ⇔ 7

8 ⇔ 8

9 ⇔ 9

10 ⇔A

11 ⇔B

12 ⇔C

13 ⇔D

14 ⇔E

15 ⇔F

197 ⇔??

To convert this decimal number in a hexadecimal number we have to divide it by 16

197/16

12,...

the quotient without the decimal part is multiplied by 16 and subtracted from the number

12x16 = 192

197-192 = 5

Then this number can be expressed as 12x16¹ + 5x16⁰ = 192 + 5 = 197

But in the hexadecimal system there are not digits > 9 , so 12 ⇔ C

197⏨ = Cx16¹ + 5x16⁰ = C5₁₆

Answer: C5₁₆ ⇔ 11000101₂ ⇔ 197⏨

\textit{\textbf{Spymore}}

8 0
3 years ago
The key to providing controlled variability in algorithms is to employ one or more placeholders, called Select one a. methods b.
lisabon 2012 [21]

Answer:

c. parameters

Explanation:

Parameters are simply placeholders (sometimes called dummy variables) used mainly by methods to perform their given tasks so as to provide controlled variability in  the program(or algorithm). Sometimes they are called arguments. But then it is much more specific to simply use parameters rather than arguments because arguments are the variable values that the parameters are serving as placeholders for.

Parameters identify and describe values that are passed into a function or subroutine.

Parameters are also used for simulation and testing purposes where the input s to the program are or can be varied.

PS: Methods are just functions performed by a class in a program.

4 0
3 years ago
What does the headgear of a mine do
deff fn [24]
Hard to answer to short but I will try the head gear let's you talk to people on the internet
5 0
4 years ago
Read 2 more answers
Other questions:
  • What is heat sink?what is its use?If it is not in the system what will happen?
    12·1 answer
  • How do you mark somebody the brainliest?
    14·2 answers
  • T-shaped, square-bottomed, dovetailed, and V-shaped are all types of _______ in a machined part. A. gears B. bolts C. lines D. s
    8·2 answers
  • 3 thing I learned in ICT
    7·1 answer
  • Which of the following is the most common tool that Windows administrators use on the domain controller?
    9·1 answer
  • What are 5 ways we can reduce our energy?
    5·1 answer
  • Do most web queries have fully meets results
    11·1 answer
  • What are the file sharing copyright laws in your area? Are they more strict or less strict than those in other areas of the worl
    9·1 answer
  • What is an accessor in Java?
    12·1 answer
  • True or false we can used virus not use pirated software and programs ​
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!