Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

A group of 74 students of Class XI went on picnic. The number of students who went on picnic by each section is as follows: Section A = 15 Section B = 24 Section C = 15 Section D = 20 5 students from Section A spent as much as 4 students from Section B. 12 Section B students spent as much as 9 Section C students and 6 Section C students spent as much as 8 Section D student. If every student of a particular section spent the same amount and all the students spent Rs. 23,370 altogether, find the amount spent by each student of Section D?
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.
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?
Consider the following statements S1 and S2 about the relational data model: S1: A relation scheme can have at most one foreign key. S2: A foreign key in a relation scheme R cannot be used to refer to tuples of R. Which one of the following choices is correct? 
Last year, there were three sections in a competitive exam. Out of them 33 students cleared the cut-off in Section A, 34 students cleared the cut-off in Section B and 32 students cleared the cut-off in Section C. 10 students cleared the cut-off in section A and section B, 9 cleared the cut-off in section B and section C and 8 cleared the cut-off in section A and section C. The number of students who cleared only one section was equal and was 21 for each section. How many students cleared all the three sections?
State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
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.
Let relation R2 has a Foreign Key that refers to Primary Key of relation R1. Which of the following operations may cause violation of referential integrity constraints? I: insert into R1 II: insert into R2 III: delete from R1 IV: delete from R2
Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation. Employee (empId, empName, empAge) Dependent(depId, eId, depName, depAge) Consider the following relational algebra query: ΠempId(employee)-ΠempId (employee⋈(empId = eID)∧(empAge ≤ depAge)dependent) The above query evaluates to the set of empIds of employees whose age is greater than that of