The candidate key is that you choose to identify each row uniquely is called …………….. A) Alternet Key
B) Primary Key
C) Foreign Key
D) None of the above

1 Answer

Answer :

B) Primary Key

Related questions

Description : An attribute that uniquely identifies the rows of a table is known as the ....... key. (1) primary (2) candidate (3) composite (4) foreign 

Last Answer : primary

Description : ............. is a combination of two of more attributes used as a primary key A) Composite Key B) Alternate Key C) Candidate Key D) Foreign Key

Last Answer : A) Composite Key

Description : Which one is correct w.r.t. RDBMS? (1) primary key ⊆ super key ⊆ candidate key (2) primary key ⊆ candidate key ⊆ super key (3) super key ⊆ candidate key ⊆ primary key (4) super key ⊆ primary key ⊆ candidate key

Last Answer : Answer: 2

Description : Which of the following statement is true? (1) A Primary key is also a candidate key (2) Each relation has at least one foreign key (3) Foreign keys can’t have null values (4) A Primary key is also an alternate key

Last Answer : Foreign keys can’t have null values

Description : ey to represent relationship between tables is called (A) Primary key (B) Secondary Key (C) Foreign Key (D) None of these

Last Answer : (C) Foreign Key

Description : Drop Table cannot be used to drop a table referenced by a …………… constraint. A) Local Key B) Primary Key C) Composite Key D) Foreign Key

Last Answer : D) Foreign Key

Description : Drop Table cannot be used to drop a Table referenced by .................. constraint. (a) Primary key (b) Sub key (c) Super key (d) Foreign key (A) (a) (B) (a), (b) and (c) (C) (d) (D) (a) and (d)

Last Answer : (C) (d)

Description : Based on the cardinality ratio and participation ............... associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual Referencing Design. (A) Entity (B) Constraints (C) Rules (D) Keys

Last Answer : (B) Constraints

Description : State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key. A) i-true, ii-false B) i-false, ii-true C) i-true, ii-true D) i-false, ii-false

Last Answer : C) i-true, ii-true

Description : A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G} Which of the following is a candidate key? (A) A (B) AB (C) ABC (D) ABD

Last Answer : Answer: D

Description : Consider the following database table having A, B, C and D as its four attributes and four possible candidate keys (I, II, III and IV) for this table: I: {B} II: {B, C} III: {A, D} IV: {C, D} If ... the database table? (A) I and III only (B) III and IV only (C) II only (D) I only

Last Answer : (C) II only

Description : Which of the following statements is false? (A) Optimal binary search tree construction can be performed efficiently using dynamic programming. (B) Breadth-first search cannot be used to find connected components of a graph. (C) ... used to find the components of a graph. (1) A (2) B (3) C (4) D 

Last Answer : Answer: 2

Description : A digital signature is a. a bit string giving identity of a correspondent b. a unique identification of a sender c. an authentication of an electronic record by tying it uniquely to a key only a sender knows d. an encrypted signature of a sender 

Last Answer : c. an authentication of an electronic record by tying it uniquely to a key only a sender knows

Description : The candidate key, which is not used as primary key is called ………….. key. -Technology

Last Answer : The candidate key, which is not used as primary key is calledalternate key.

Description : What is the difference between candidate key, unique key and primary key

Last Answer : Candidate keys are the columns in the table that could be the primary keys and the primary key is the key that has been selected to identify the rows. Unique key is also useful for identifying the distinct rows in the table.)

Description : Define primary key and candidate key.

Last Answer : Primary Key: A primary key is an attribute in Relation that uniquely identifies the rows in relation. A Primary key does not hold NULL values and duplicate values.  OR A key which is selected by the ... , Name) can be a candidate key if and only if Name and Rollno individually are not unique. 

Description : Anybody have a clue about why the Alternet news website is unresponsive?

Last Answer : sahID It works for me… they just want to get a donation.

Description : Which of the following statements is FALSE about weak entity set ? (A) Weak entities can be deleted automatically when their strong entity is deleted. (B) Weak entity set avoids the data ... weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Last Answer : (D) Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Description : Consider the following database table : Create table test( one integer, two integer, primary key(one), unique(two), check(one≥1 and ≤10), check(two≥1 and ≤5) ); How many data records/tuples atmost can this table contain ?  (A) 5 (B) 10 (C) 15 (D) 50

Last Answer : (A) 5 

Description : In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To ... D) To fill a column in a tuple when that column does not really exist for that particular tuple.

Last Answer : (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL.

Description : Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two relations R1 and R2 can be expressed as follows: (1) pk(R2)→pk(R1) (2) pk(R1)→pk(R2) (3) pk(R2)→R1∩R2 (4) pk(R1)→R1∩R2

Last Answer : Answer: 2

Description : MySQL order by primary key, put one row on top.

Last Answer : answer:If you can guarantee that there is only one or zero active records select * from presets order by active asc, id asc

Description : Let R be the rectangular window against which the lines are to be clipped using 2D Sutherland-Cohen line clipping algorithm. The rectangular window has lower left-hand corner at (-5,1) and upper righthand corner at (3,7). ... s) is/are candidate for clipping? (A) AB (B) CD (C) EF (D) AB and CD

Last Answer : (D) AB and CD

Description : Now that Rick Santorum has won 3 states in a row, and more states than any other candidate (4) is it time for Gingrich and Romney to drop out?

Last Answer : Don’t think it matters, Obama is a stone cold shoe-in whichever misfit….Republican shows up. Speaking as an impartial observer of course.

Description : a tester, what is your main objective in reviewing a requirement document? A. To ascertain that each requirement is traceable to a business need B. To ascertain that each ... business need, testable, and uniquely identifiable D. To ascertain that each requirement is uniquely identifiable

Last Answer : C. To ascertain that each requirement is traceable to a business need, testable, and uniquely identifiable

Description : As a tester, what is your main objective in reviewing a requirement document? A. To ascertain that each requirement is traceable to a business need B. To ascertain that each ... business need, testable, and uniquely identifiable D. To ascertain that each requirement is uniquely identifiable

Last Answer : B. Test objective

Description : ................ allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement. A) Procedure B) Trigger C) Curser D) None of above

Last Answer : C) Curser

Description : The RDBMS terminology for a row is (A) tuple. (B) relation. (C) attribute. (D) degree.

Last Answer : (A) tuple

Description : Consider an array A[20, 10], assume 4 words per memory cell and the base address of array A is 100. What is the address of A[11, 5] ? Assume row major storage. (A) 560 (B) 565 (C) 570 (D) 575

Last Answer : (A) 560

Description : The row rangefor a table is dynamically partitioned and each row range is called a) Tablet b) Row key c) Time stamp d) Pairs

Last Answer : Tablet

Description : The row rangefor a table is dynamically partitioned and each row range is called a) Tablet b) Row key c) Time stamp d) Pairs

Last Answer : Tablet

Description : A foreign key is a primary key in another table. -Technology

Last Answer : True When a table’s primary key field is added to a related table in order to create the common field which relates two tables, it is called a foreign key in the related table.

Description : Primary key is used to …………….. identify the record. -Technology

Last Answer : Primary key is used to uniquelyidentify the record.

Description : Identify the primary key column of Train and Reservation. -Technology

Last Answer : (i) Train-TrainIdReservation-RefNo(ii) (d) By default, the UNION operator selects all the values.

Description : In a Examination a candidate has to score minimum of 24 marks inorder to clear the exam. The maximum that he can score is 40 marks. Identify the Valid Equivalance values if the student clears the exam. A. 22,23,26 B. 21,39,40 C. 29,30,31 D. 0,15,22

Last Answer : C. 29,30,31

Description : How does randomized hill-climbing choose the next move each time? (A) It generates a random move from the moveset, and accepts this move. (B) It generates a random move from the whole state ... move from the whole state space, and accepts this move only if this move improves the evaluation function.

Last Answer : (C) It generates a random move from the moveset, and accepts this move only if this move improves the evaluation function. 

Description : What do you think poetry uniquely allow us to investigate, to learn, to understand?

Last Answer : I wish this question didn’t sound quite so much like an essay prompt. It’s an interesting topic. Why don’t you tell us your thoughts first—on both the what and the how—and let us respond to them?

Description : What specific behaviors make you uniquely lovable? How did you learn to be that way?

Last Answer : Well, as I have already said, I took Milo to vet's for an enema today. That was both y out of love, and out of fear of my daughter. It turned out to be very much like a changing a baby' ... during my pregnancies. There was no analysis, no thinking, no work involved. The love just was, and still is.

Description : What uniquely odd roadside attraction would you recommend visiting?

Last Answer : The Grandfather Tree in Humboldt County, California is pretty cool. It really is quite large. I know I've visited that on road trips before. Also, the Trees of Mystery in Del Norte County ... and signs and that we've stopped before. Most of those types of things are usually pretty good.

Description : What type of blood capillary located in this sublayer is uniquely suited for absorption of nutrient material?

Last Answer : Feel Free to Answer

Description : PRPP glutamyl amidotransferase, the first enzyme uniquely committed to purine synthesis is feed back inhibited by (A) AMP (B) IMP (C) XMP (D) CMP

Last Answer : Answer : A

Description : An IP address is a: a) binary number that uniquely identifies computers. b) also identifies other devices on TCP/IP network c) Both of Above d) None of These

Last Answer : c) Both of Above

Description : An IP address is a: a) binary number that uniquely identifies computers. b) also identifies other devices on TCP/IP network c) Both of Above d) None of These

Last Answer : c) Both of Above

Description : Which of the following area of cloud computing is uniquely troublesome? a) Auditing b) Data integrity c) e-Discovery for legal compliance d) All of the mentioned

Last Answer : All of the mentioned

Description : A variable is A. DIM B. Console.Writeline("") C. A uniquely named storage location D. a way of holding a WHOLE number

Last Answer : C. A uniquely named storage location

Description : Assertion (A): The coin when flipped next time will come up tails. Reason (R): Because the coin was flipped five times in a row, and each time it came up heads. Choose the correct answer from below: (A) Both (A ... A). (D) (A) is doubtful, (R) is false, and (R) is the correct explanation of (A).

Last Answer : (C) (A) is doubtful, (R) is true, and (R) is not the correct explanation of (A).