In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.

Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: Given the table R (a, b, c) where a and b together form the primary key, the following is a valid table definition. CREATE TABLE S ( a INTEGER, d INTEGER, e INTEGER, PRIMARY KEY (d) FOREIGN KEY (a) references R) Which one of the following statements is CORRECT?

A

S1 is TRUE and S2 is FALSE

B

BOTH S1 and S2 are TRUE

C

S1 is FALSE and S2 is TRUE

D

BOTH S1 and S2 are FALSE

The following sentences have been given in a jumbled manner. Un-jumble the sentences and answer the option which describes the order of sentences in a correct manner. A. India's government is in talks with foreign lenders to provide as much as $14.5 billion in credit to millions of its small firms, two officials said, in a sign, the country's banking system may not be robust enough to do the job on its own B. India's micro, small and medium enterprise(MSME) ministry is discussing the proposal to pull in foreign banks with the country's ministry of finance, which will make a final call. C. The push for foreign loans comes on the heels of the Indian government's announcement earlier this month that it plans to borrow about 700 billion rupees by issuing overseas sovereign bonds. D. The government is in discussions with multiple foreign lenders, including Germany's state-owned development bank KfW Group, the World Bank and some Canadian institutions to extend lines of credit to small enterprises E. One official said that the government plans to source up to 1 trillion Indian rupees of loans from foreign institutions because Indian banks were not in a position to provide enough capital for the small business sector, which is seen as critical to job creation.

A

ABCED

B

ACDEB

C

BCDEA

D

CBADE

E

EDCBA

User level threads are threads that are visible to the programmer and are unknown to the kernel. The operating system kernel supports and manages kernel level threads. Three different types of models relate user and kernel level threads. Which of the following statements is/are true ? (a) (i) The Many - to - one model maps many user threads to one kernel thread (ii) The one - to - one model maps one user thread to one kernel thread (iii) The many - to - many model maps many user threads to smaller or equal kernel threads (b) (i) Many - to - one model maps many kernel threads to one user thread (ii) One - to - one model maps one kernel thread to one user thread (iii) Many - to- many model maps many kernel threads to smaller or equal user threads

A

(a) is true; (b) is false

B

(a) is false; (b) is true

C

Both (a) and (b) are true

D

Both (a) and (b) are false

Public key encryption uses multiple keys.ne key is used to encrypt data, while another is used to decrypt data.he key used to encrypt data is called the _______ key, while the key used to decrypt data is called the ________ key.

A

encryption, decryption

B

private, public

C

encryption, public

D

public, private

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

A

True

B

False

Who among the following dignitaries were in Delhi in February/March 2012? Select the correct answer from the codes given below : 1. Foreign Minister of Norway 2. Foreign Minister of China 3. Foreign Minister of Italy 4. Foreign Minister of Egypt

A

1 and 2 only

B

2 and 3 only

C

3 and 4 only

D

1, 2 and 3 only

Which of the following would include Foreign Direct Investment in India? 1. Subsidiaries of foreign companies in India 2. Majority of foreign equity holding in Indian companies 3. Companies exclusively financed by foreign companies 4. Portfolio investment Select the correct answer using the codes given below:

A

1, 2, 3 and 4

B

2 and4 only

C

1 and 3 only

D

1, 2 and 3 only

Foreign investment can be made through which of the following routes ? (i) Foreign Direct Investment (FDI) (ii) Foreign Portfolio Investment (FPI) (iii) Private Equity Investment (PEI) (iv) Foreign Venture Capital Investors (FVCI) Choose the correct answer from the code given below :

A

(i), (ii), (iii) and (iv)

B

(i) and (iv)

C

(i), (ii) and (iv)

D

(i), (iii) and (iv)

Foreign investment can be made through which of the following routes?
1. Foreign Direct Investment (FDI)
2. Foreign Portfolio Investment (FPI)
3. Private Equity Investment (PEI)
4. Foreign Venture Capital Investors (FVCI)
Choose the correct answer

A

1, 3 and 4

B

Both 1 and 4

C

1, 2 and 4

D

All of the above

Which of the following statement is/are correct?
1. The Government of India has power to cede Indian territory in favour of a foreign country.
2. Any territory of India can be ceded in favour of the foreign country only if there is an agreement between the heads of the two States.
3. Indian territory can be ceded to a foreign country only in accordance with Article 368 of the Constitution of India.
4. The Indian territory can not be ceded to any foreign country.
Select the correct answer:

A

1, 2 and 3

B

4

C

2 and 3 only

D

1 and 3 only

In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.

Related Questions