Skip to main content

Important MCQ of RDBMS( Relational database management system)-FCST

Important MCQ of RDBMS 


 1. A RDBMS consists a collection of ?
a. Tables b. Fields c. Records d. Keys 
ANS/- a. table

2. The term attribute refers to a ___________ of a table
a. Record b. Tuple c. Column d. Key
 ans/- c. Column

3. In relational model, the row of table is known to be ?
 a. Relation b. Entity field c. Tuple d. Attribute 
ans/- C. Tuple

4. . Address field of a person should not be part of primary key, since it is likely to ?
a. Dependent b. Too long c. Changed d. Not changed 
ans/- c. Changed

5. The relational model is concerned with ?
a. Data structure and Data integrity b. Data Manipulation c. Both a and b d. None of these 
ans/- c. Both a and b

6. Which is the false statement from the following ?
a. A veiw is a named derived table b. A name relation is variable c. A veiw is a named reation and is virtual d. None of these 
ans/- d. None of these

7. The union of primary keys of the related entity sets becomes a -------------------------- of the relation ?
a. Super Key b. Candidate key c. Foreign key d. Primary key 
ans/- a. super key

8. What is the full form of RDBMS ?
a. Right Database Management System  
b. Relational Database Management system
 c. Rapid Database Management System
d. Route Database Management System
ans/- b. Relational database management system

9. . In a relational Database a referential integrity constraint cab be specified with the help of;
a. Primary Key b. Secondry key c. Foreign key d. None of these
ans/- c. Foreign key

10. Primary key should be chosen such that its attribute values are never
a. Updated b. Changed c. Dependent d. None of these 
ans/- b. Changed

11. Query language is a language in which a user?
a. Requests b. Stores c. Response d. Represents 
ans/- a.requests

12. Minimal superkeys are called ?
a. Unique key b. Superset key c. Candidate key d. Primary key 
ans/- c. Candidate key

13. A table is a collection of relationships, there is a close correspondence between concept of :
a. Tables and instances b. Table and variables c. Tables and relations d. Tables and Entries 
ans/- c. Tables and relations

14. Contents of a relation instance may change with time as relation :
a. Domain b. Retrieved c. Updated d. Time 
ans/- c. updated

15. Query languages used in practice includes
a. Elements b. Instances c. Tuples d. Fields
 ans/- a. Elements

16. Logical design of database, is known to be
a. Database relation b. Database instance c. Database entity d. Database Schema 
ans/- d. Database Schema

17. A domain is atomic if elements of the domain are considered to be ____________ units.
a. Different b. Indivisible c. Constant d. Divisible 
Ans/- b. Indivisible

18. Which one of the following is a procedural language ?
a. Domain relational calculus b. Tuple relational calculus c. Query language d. Relational algebra 
Ans/- d. Relational algebra

19. The _______operation performs a set union of two “similarly structured” tables :
a. Intersect b. Product c. Union d. Join 
Ans/- c. Union


20. Which is the operator, takes the results of two queries and returns only rows that appear in both result sets ?
a. Union b. Projection c. Difference d. Intersect 
Ans/- d. Intersect















Location: India

Comments

Post a Comment

please subscribe my blog and let me suggest how I improve this site

Popular posts from this blog

type casting in C. - computer science fundamentals tutorial

Typecasting in C Typecasting is also known as "forced conversion". It refers to changing variable one data type to another data type.          Typecasting in can be certified into following two types: - 1) Implicit type casting. 2) Explicit type casting. Implicit type casting : - It is also known as "Automatic type conversion". It is done by compiler on its own without any external trigger from user. Generally takes place when in an expression more than one data type is present in such condition. Type conversion take places to avoid data lose. Example : - #include<stdio.h> main() {   char y = 'a';   int b = y; printf("%c",y); printf("%d",b); } Explicit Type casting : - This process also called 'Type casting' and it is user defined . Here the user can type cast the result to make it of particular data type. Example : - #include<stdio.h> main() { int m
Post a Comment
Read more

Solve-write C program to find grade of student by using nested else-if statement

C program to find grade of student by using nested else-if statement Problem Description This program take input as your number then show your grade. Problem Solution 1. enter your marks as input. 2. then check your marks with 'If' block's condition. if it satisfied then show your grade as output. 3. if it not satisfied then it checks with all else-if block's condition repeatedly. 4. print the grade according to your given marks as input and exit. Program codes:-   #include<stdio.h> main() { int n; printf("\n enter the marks:"); scanf("%d",&n); if(n>89) printf("O"); else if(n>79) printf("E"); else if(n>69) printf("A"); else if(n>59) printf("B"); else if(n>49) printf("C"); else if(n>39) printf("D"); else printf("F"); } Program explanation:- 1. enter your marks. for example we take 70 .
Post a Comment
Read more