Discussion Today : 26/09/2017 : Topic : DBMS
Q. max no of super keys for relation schema R(E,FG,H) with E as the key is?
A) 10
B) 6
C) 4
D) 8
Answer: D
The maximum number of super keys for the relation schema R ( E,F,G, H ) with E as the key is 2^3= 8, because any subset of non key attributes along with key attribute will form the super key of R. As, we have 3 non-keys (F, G and H), so answer will be 2^3i.e. 8.
Q.The operation which is not considered a basic operation of relational algebra is
(A) Join. (B) Selection.
(C) Union. (D) Cross product.
Answer: A
An SQL join clause combines columns from one or more tables in a relational database. It creates a set that can be saved as a table or used as it is. AJOIN is a means for combining columns from one (self-table) or more tables by using values common to each.
Q1. ER modelling technique is
a.tree structure
b.top down
c.bottom up
d. right left approach
Answer : b.top down
A graphical technique for understanding and organizing the data independent of the actual database implementation
Q2. The descriptive property possessed by each entity set is _________ .
a) Entity
b) Attribute
c) Relation
d) Model
Answer: b) Attribute
Q3. Which of the following is used to define the integrity constraints.?
1)DML
2)DCL
3)DDL
4)All the above
Answer: 3)DDL
Q4.SQL command to delete a column from an existing table?
a)drop b)alter c)update d)truncate
Answer: B
Q5. Check points are a part of____?
A) recovery measures B) security measures
C) concurrency measures. D) authorization measures
Answer:A
Q6. What is the function of the not null constraint?
a) It prevents illegal data from being entered into the database
b) It ensures that data is entered into the database
c) It ensures that the data entered is unique
d) None of the mentioned
Answer: B
Q7. Which of the following is not an integrity constraint?
a) not null
b) unique
c) identical
d) check
Answer:C
Q8. Which of the following is used to store movie and image files?
1. clob
2. blob
3, DECIMAL
4. NONE OF THESE
Answer: B
Q9. Which of the following is not a property of transactions?
A) atomicity B) concurrency
C) isolation D) durability
Answer:B
More Questions and Discussion...
GK Questions
1. The movement caused the dismissal of the first Communist Government (31 July 1959)
Answer : Vimochana Samaram(Liberation Struggle)
12. Who translated the conversation between Tagore and Sree Narayana Guru
Answer : Kumaranasan
13. The first President of Travancore Devasaom Board
Answer : Mannath padmanabhan
14. The first temple consecrated by Sree Narayana Guru in
Answer : Aruvippuram (1888)
15. Who is known as Madhan Mohan Malavya of Kerala
Answer : Mannath Padmanabhan
16. The leader of Villuvandi Samaram(1893)
Answer : Ayyankali
17. The founder of All Travancore Muslim Mahajanasabha
Answer : Vakkom Muhammed Abdul Khadar Moulavi
18. Who is known as "saint without saffron"
Answer : Chattambi Swamikal
19. Advaitha Ashramam at Aluva was established on
Answer : 1913
20. The song "Akhilandamandalam" is written by
Answer : Panthallam K.P.RamanPillai
A) 10
B) 6
C) 4
D) 8
Answer: D
The maximum number of super keys for the relation schema R ( E,F,G, H ) with E as the key is 2^3= 8, because any subset of non key attributes along with key attribute will form the super key of R. As, we have 3 non-keys (F, G and H), so answer will be 2^3i.e. 8.
Q.The operation which is not considered a basic operation of relational algebra is
(A) Join. (B) Selection.
(C) Union. (D) Cross product.
Answer: A
An SQL join clause combines columns from one or more tables in a relational database. It creates a set that can be saved as a table or used as it is. AJOIN is a means for combining columns from one (self-table) or more tables by using values common to each.
Q1. ER modelling technique is
a.tree structure
b.top down
c.bottom up
d. right left approach
Answer : b.top down
A graphical technique for understanding and organizing the data independent of the actual database implementation
Q2. The descriptive property possessed by each entity set is _________ .
a) Entity
b) Attribute
c) Relation
d) Model
Answer: b) Attribute
Q3. Which of the following is used to define the integrity constraints.?
1)DML
2)DCL
3)DDL
4)All the above
Answer: 3)DDL
Q4.SQL command to delete a column from an existing table?
a)drop b)alter c)update d)truncate
Answer: B
Q5. Check points are a part of____?
A) recovery measures B) security measures
C) concurrency measures. D) authorization measures
Answer:A
Q6. What is the function of the not null constraint?
a) It prevents illegal data from being entered into the database
b) It ensures that data is entered into the database
c) It ensures that the data entered is unique
d) None of the mentioned
Answer: B
Q7. Which of the following is not an integrity constraint?
a) not null
b) unique
c) identical
d) check
Answer:C
Q8. Which of the following is used to store movie and image files?
1. clob
2. blob
3, DECIMAL
4. NONE OF THESE
Answer: B
Q9. Which of the following is not a property of transactions?
A) atomicity B) concurrency
C) isolation D) durability
Answer:B
More Questions and Discussion...
GK Questions
1. The movement caused the dismissal of the first Communist Government (31 July 1959)
Answer : Vimochana Samaram(Liberation Struggle)
12. Who translated the conversation between Tagore and Sree Narayana Guru
Answer : Kumaranasan
13. The first President of Travancore Devasaom Board
Answer : Mannath padmanabhan
14. The first temple consecrated by Sree Narayana Guru in
Answer : Aruvippuram (1888)
15. Who is known as Madhan Mohan Malavya of Kerala
Answer : Mannath Padmanabhan
16. The leader of Villuvandi Samaram(1893)
Answer : Ayyankali
17. The founder of All Travancore Muslim Mahajanasabha
Answer : Vakkom Muhammed Abdul Khadar Moulavi
18. Who is known as "saint without saffron"
Answer : Chattambi Swamikal
19. Advaitha Ashramam at Aluva was established on
Answer : 1913
20. The song "Akhilandamandalam" is written by
Answer : Panthallam K.P.RamanPillai
Q8: Answer: Blob
ReplyDelete