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
Gala2k [10]
4 years ago
6

Write a SELECT statement that selects all of the columns for the catalog view that returns information about foreign keys. How m

any foreign keys are defined in the AP database?
Computers and Technology
1 answer:
Nutka1998 [239]4 years ago
6 0

Answer:

SELECT COUNT (DISTICT constraint_name)

FROM apd_schema.constraint_column_usage

RUN

Explanation:

General syntax to return a catalog view of information about foreign keys.

SELECT DISTINCT PARENT_TABLE =

           RIGHT(Replace(DC.constraint_name, 'fkeys_', ''),

           Len(Replace(DC.constraint_name, 'fkeys_', '')) - Charindex('_', Replace(DC.constraint_name, 'fkeys_', ''))),

           CHILD_TABLE = DC.table_name,

           CCU.column_name,

           DC.constraint_name,

           DC.constraint_type

FROM apd_schema.table_constraints DC

INNER JOIN apd_schema.constraint_column_usage CCU

           ON DC.constraint_name = CCU.constraint_name

WHERE  DC.constraint_type LIKE '%foreign'

           OR DC.constraint_type LIKE '%foreign%'

           OR DC.constraint_type LIKE 'foreign%'

RUN

You might be interested in
Write a program that accepts inputs, outputs them and exits correctly when - 1<br> is pressed
dolphi86 [110]

Answer:

Explanation:

The following program is written in Python. It simply creates an endless loop that continously asks the user for an input. If the input is not -1 then it outputs the same input, otherwise it exists the program correctly. A test output can be seen in the attached image below.

while True:

   answer = input("Enter a value: ")  

   if answer != "-1":

       print(answer)

   else:

       break

7 0
3 years ago
Which statement is true about a metamorphic rock that was exposed to stress equally from all directions?
Zolol [24]
I think the correct answer from the choices listed above is option B. A  metamorphic rock that was exposed to stress equally from all directions <span>will have all of its mineral crystals aligned in layers. Hope this answers the question. Have a nice day.
</span>
7 0
3 years ago
Which of these is most often the cause of the Blue Screen of Death?
Masja [62]

D.

a device driver problem

5 0
3 years ago
Hadoop is : open source software framework designed for distributing data-processing over inexpensive computers. data mining pla
kirill115 [55]

Answer: open-source software framework designed for distributing data-processing over inexpensive computers.

Explanation:

Hadoop refers to the collection of open-source software utilities which are important in facilitating the use of a network of several computers to solve big data.

It provides huge storage for different kinds of data, and the ability to handle concurrent tasks virtually. Therefore, the correct option is "open-source software framework designed for distributing data-processing over inexpensive computers".

7 0
3 years ago
. Write a program name Eggs that declares four variables to hold the number of eggs produced in a month by each of four chickens
DaniilM [7]

Answer:

// code in C++.

#include <bits/stdc++.h>

using namespace std;

// main function

int main()

{

   // variables

   int e1,e2,e3,e4;

   int tot,doz,rem_egg;

   cout<<"Enter the eggs given by first chicken:";

   // read the eggs given by first chicken

   cin>>e1;

   cout<<"Enter the eggs given by second chicken:";

   // read the eggs given by second chicken

   cin>>e2;

   cout<<"Enter the eggs given by third chicken:";

   // read the eggs given by third chicken

   cin>>e3;

   cout<<"Enter the eggs given by fourth chicken:";

   // read the eggs given by fourth chicken

   cin>>e4;

   // find total eggs

   tot=e1+e2+e3+e4;

   // find the dozens

   doz=tot/12;

   // remaining eggs

   rem_egg=tot%12;

   // print total eggs, dozen and remaining eggs

   cout<<"A total of "<<tot<<" eggs is "<<doz<<" dozen and "<<rem_egg<<" eggs.";

return 0;

}

Explanation:

Read the eggs given by four chickens and assign them to variables e1,e2,e3,e4 respectively.Then calculate the total eggs of all four chickens.After this find the dozen by dividing the total eggs with 12.To find the remaining eggs after the dozen and assign it to variable "rem_egg".Print the total eggs, dozen and remaining eggs.

Output:

Enter the eggs given by first chicken:40

Enter the eggs given by second chicken:23                                                                                  

Enter the eggs given by third chicken:55

Enter the eggs given by fourth chicken:60

A total of 178 eggs is 14 dozen and 10 eggs.

5 0
4 years ago
Other questions:
  • An expression that has correctly paired delimiters is called a(n)
    6·1 answer
  • What is the service provided by a third party (such as an ISP) that enables you to connect another cloud directly to your Google
    15·1 answer
  • Which of the following does NOT describe a node?
    10·2 answers
  • A telephone repair technician uses a meter to measure voltage on a phone line. This meter is an example of _____.
    10·2 answers
  • What are the benefits of transferable skills check all the boxes that apply
    6·2 answers
  • Somebody supplied me with a file that was edited on a Windows machine. The file contains carriage returns in addition to the new
    9·1 answer
  • Hello can you please help with this if you want to thank you!
    15·2 answers
  • Display all the lines in unixPasswd that contain at least 10 consecutive lowercase letters. How many names are there in total th
    12·1 answer
  • An analogue sensor has a bandwidth which extends from very low frequencies up to a maximum of 14.5 kHz. Using the Sampling Theor
    9·2 answers
  • What are web site and web page?​
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!