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

  1. AkanshyaOctober 14, 2020 at 12:19 PM

    What a really awesome post this is. Truly, one of the best posts I've ever witnessed to see in my whole life. Wow, just keep it up.
    Data Science Training in Hyderabad
    Data Science course in Hyderabad
    Data Science coaching in Hyderabad
    Data Science Training institute in Hyderabad
    Data Science institute in Hyderabad

    ReplyDelete
  2. Ramesh SampangiDecember 24, 2021 at 12:05 AM

    Really an awesome blog. Informative and knowledgeable content. I enjoyed while reading your article. Keep sharing more stuff like this. Thank you.
    Data Science Training and Placements in Hyderabad
    Data Science Training Institute in Hyderabad

    ReplyDelete
  3. prathyushaDecember 6, 2022 at 9:51 AM

    The new wave of innovation that is changing the way people do business is called data science. Gain expertise in organizing, sorting, and transforming data to uncover hidden patterns Learn the essential skills of probability, statistics, and machine learning along with the techniques to break your data into a simpler format to derive meaningful information. Enroll in Data science in hyderabad and give yourself a chance to power your career to greater heights.data science training in hyderabad

    ReplyDelete
  4. prathyushaDecember 6, 2022 at 9:51 AM

    The new wave of innovation that is changing the way people do business is called data science. Gain expertise in organizing, sorting, and transforming data to uncover hidden patterns Learn the essential skills of probability, statistics, and machine learning along with the techniques to break your data into a simpler format to derive meaningful information. Enroll in Data science in hyderabad and give yourself a chance to power your career to greater heights.data science training in hyderabad

    ReplyDelete
  5. sivakumarDecember 24, 2022 at 10:33 AM

    You re in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!data science training in roorkee

    ReplyDelete

Post a Comment

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

Popular posts from this blog

Short notes on database schema & database independence- computer science fundamentals tutorial

            Database Schema &  Data Independence PDF version of this post also available. to download the click the link given at the end of this post.           Database Schema : -  A database schema   is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how relat ion among them are associated.  Database schema  formulates all the constrains that are to be applied on the data. A database schema defines its entities and the relationship among them. It contains descriptive details of the database which can be described by means of schema diagram. A database schema can be divided into two categories.   I.     Physical database schema : - this schema contain to the actual storage of data and its form of storage like files, indices etc. It defines how the data will be stored in a secondary storage. ...
2 comments
Read more

C program to find factorial of number using function - FCST

C program to find factorial of number using function Problem description In this program take number as input & then it show the factorial of given number as output. Problem solution 1.take a number as input. 2.declare the void Fact(int) function globally if you want or declare the function prototype  into the main() function. 3.after taking input call the function into main() . 4.then define the function definition. 5.after taking function definition for loop started in this function definition. 6. In for loop i=1 & fact=1 then fact=1. after this loop is continue and incremented by1 until the n is grater than equal to i. continuity of loop is depend on what number take as input .  Program code: #include<stdio.h> void Fact(int);//function prototype declearation int i,fact=1;//global variable declearation int main()  { int n; printf("\n enter the  number:"); scanf("%d",&n); Fact(n);//function call } //func...
Post a Comment
Read more