About Rdbms

Following are some of the multiple choice questions on the Rdbms with answers that will help the students in developing their knowledge.

Rdbms MCQ

1. A RDBMS consists a collection of ?

  • Tables
  • Fields
  • Records
  • Keys

2. The restrictions or conditions applied on data are known as ______________

  • Constraints
  • data models
  • relations
  • none of the above

3. Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

  • DML(Data Manipulation Langauge)
  • DDL(Data Definition Langauge)
  • Query
  • Relational Schema

4. Address field of a person should not be part of primary key, since it is likely to ?

  • Dependent
  • Too long
  • Changed
  • Not changed

5. A set of objects that share a common structure and a common behavior is called:

  • Object
  • Class
  • Entity
  • None of these

6. Which of the following is not a valid operator for the WHERE Clause

  • IN BETWEEN
  • <>
  • >=
  • All of above

7. Which of the following is not a definition of NULL Value?

  • NULL is not the same as zero or a blank space
  • Arithmetic operations on a NULL value does not always return a NULL Value
  • NULL Value is the absence of any character,zero,blank space
  • none of the above

8. A table is a collection of relationships, there is a close correspondence between concept of

  • Tables and instances
  • Table and variables
  • Tables and relations
  • Tables and Entries

9. Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

  • DML(Data Manipulation Language)
  • Query
  • Relational Schema
  • DDL(Data Definition Language)

10. The Oracle environment of database is called as ___________

  • Database Schema
  • Database Instances
  • Data Structure
  • All of the Mentioned

11. The union of primary keys of the related entity sets becomes a -------------------------- of the relation ?

  • Super Key
  • Candidate key
  • Foreign key
  • Primary key

12. The term attribute refers to a ___________ of a table.

  • Record
  • Tuple
  • Column
  • Key

13. The set of all possible values that an attribute may contain is called theĀ ___________ of an attribute. 1

  • Domain
  • Relation
  • Set
  • Schema

14. Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

  • DML(Data Manipulation Language)
  • DDL(Data Definition Language)
  • Query
  • Relational Schema

15. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

  • Primary
  • Referencing
  • Specific
  • Referential

16. The HAVING clause does which of the following?

  • Acts like a WHERE clause but is used for groups rather than columns.
  • Acts like a WHERE clause but is used for rows rather than columns.
  • Acts like a WHERE clause but is used for columns rather than groups.
  • Acts like a WHERE clause but is used for groups rather than rows.

17. Logical design of database, is known to be

  • Database relation
  • Database instance
  • Database entity
  • Database Schema

18. In the relational model, cardinality is termed as

  • A number of tuples.
  • A number of attributes.
  • A number of tables.
  • number of constraints.

19. A table joined with itself is called

  • Join
  • Self Join
  • Outer Join
  • Equi Join

20. In Hierarchical model records are organised as

  • Graph
  • Stack
  • Queue
  • Tree

21. .......... is an attribute or collection of attributes that uniquely identifies an entity among entity set.

  • Relations
  • Attribute
  • Weak entity
  • Key

22. Which of the following SQL clauses is used to DELETE tuples from a database table?

  • DELETE
  • REMOVE
  • DROP
  • CLEAR

23. An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

  • Candidate
  • Primary
  • Super
  • Sub

24. The level of data abstraction which describes how the data is actually stored is

  • Conceptual level
  • Physical level
  • File level
  • None of these

25. Which statement is used to extract data from a database?

  • Extract
  • Get
  • Open
  • Select

26. In a relational Database a referential integrity constraint cab be specified with the help of

  • Primary Key
  • Secondary key
  • Foreign key
  • None of these

27. In relational model, the row of table is known to be ?

  • Relation
  • Entity field
  • Tuple
  • Attribute

28. What will be the degree and cardinality of the cartesian product of two tables if the degree of first table is 3 and second table is 5. The cardinality of first table is 10 and cardinality of second table is 6.

  • Degree 15, Cardinality 16
  • Degree 8 Cardinality 16
  • Degree 15 cardinality 60
  • Degree 8 Cardinality 60

29. In the architecture of the Database System, external level is the

  • Physical level
  • Logical level
  • Conceptual level
  • View level

30. A schema describes

  • Record relationship
  • Data elements
  • Record and files
  • All of the above

31. Which of the following is not a type of data?

  • Raw Data
  • Discrete Data
  • Meta Data
  • All of above

32. What is data integrity

  • It is the data contained in database that is not redundant
  • It is the data contained in database that is accurate and consistant
  • It is the data contained in database that is secured
  • It is the data contained in database that is shared

33. A logical schema

  • is the entire database
  • is a standard way of organizing information into accessible parts
  • Describes how data is actually stored
  • None of these

34. Collection of information stored at a particular moment is

  • View
  • Schema
  • Instance
  • None of the above

35. A collection of entity sets

  • Database
  • Relationship
  • Entities
  • Data

36. _______ is a collection of database objects that are owned by a database user

  • Object
  • Schema
  • Data
  • None of these

37. An advantage of the database management approach is

  • Data is dependent on programs.
  • Data redundancy increases.
  • Data is integrated and can be accessed by multiple programs.
  • None of the above

38. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

  • Rows
  • Key
  • Attribute
  • Fields

39. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

  • Candidate key
  • Sub key
  • Super key
  • Foreign key

40. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

  • DML(Data Manipulation Langauge)
  • DDL(Data Definition Langauge)
  • Query
  • Relational Schema

41. What is the purpose of *?

  • Selects the last field in the table
  • Selects only the first field in the table
  • Selects ALL fields from the table
  • Shows only the first row in the table

42. What database level is closest to the user

  • External
  • Internal
  • Physical
  • Conceptual

43. In ER diagram relationship type is represented by

  • Ellipse
  • Dashed Ellipse
  • Rectangle
  • Diamond

44. In an ER diagram, Entity types are represented by

  • rectangle
  • ellipse
  • diamond box
  • circle

45. In an ER diagram, attributes are represented by?

  • Rectangle
  • Square
  • Ellipse
  • Triangle

46. In Hierarchical Model records are organized as

  • Graph
  • List
  • Links
  • Tree

47. ............ are the properties of entities.

  • Domain
  • Attributes
  • Relations
  • Field

48. A .............. is a very small unit of a program and it may contain several low-level tasks.

  • Attribute
  • Table
  • Normalization
  • Transaction

49. ........... is the process of minimizing redundancy from a relation or set of relations.

  • Normalization
  • Data redundancy
  • Data consistency
  • Schema

50. .......... is the process of organizing the data in the database.

  • Schema
  • Normalization
  • Instance
  • Transaction

Enjoyed the Quiz. Share this with friends

Comments

Add Your Review

Your email address will not be published.

Subscribe to Newsletter!

Subscribe to get latest updates and information.