Database Management Objectives Set 1

15/08/2020 1 By indiafreenotes

Q1. What do you mean by one to many relationship between Teacher and Class table?

  1. One class may have many teachers
  2. One teacher can have many classes
  3. Many classes may have many teachers
  4. Many teachers may have many classes

 

Q2. What are the different view to present a Table?

  1. Datasheet View
  2. Design View
  3. Pivote Table View
  4. All Of Above

 

Q3. In one-to-many relationship the table on ‘many’ side is called _______

  1. Parent
  2. Child
  3. Sister
  4. Master

           

Q4. In which state one gathers and list all the necessary fields for the database design project.

  1. Data Definition
  2. Data Refinement
  3. Establishing Relationship
  4. None of The Above

 

Q5. Which of the following enables us to view data from a table based on a specific criterion.

  1. Form
  2. Query
  3. Macro
  4. Report

 

Q6. Which database object is ideal to view, change, and analyze detain different ways ?

  1. Table
  2. Form
  3. Query
  4. Report

 

Q7. In one-to-many relationship the table in ‘one’ side is called _______

  1. Child
  2. Owner
  3. Parent
  4. Owner

 

Q8. Which data type allows alphanumeric characters and special symbols to be entered?

  1. Text
  2. Memo
  3. Auto number
  4. Mixed

 

Q9. It is used to establish an association between related tables.

  1. Line
  2. Relationship
  3. Primary Key
  4. Records

 

Q10. This key that uniquely identifies each record is called:

  1. Primary Key
  2. Key Record
  3. Unique Key
  4. Field Name

 

Q11. Which name must be unique within a database?

  1. Table
  2. Field
  3. Record
  4. Character

 

Q12. The third stage of designing a database is when we create___________ between tables

  1. Relationship
  2. Join
  3. Query
  4. None of These

 

Q13. Two tables can be linked with relationship to _____

  1. Ensure data entry
  2. Ensure data integrity
  3. Create Primary Key
  4. Ensure Foreign Key

           

Q14. In a database Table, the each category of information is called __________

  1. Tuple
  2. Field
  3. Record
  4. All Of Above

 

Q15. Which of the following fields has width of 8 bytes?

  1. Memo
  2. Number
  3. Date/Time
  4. Hyperlink

 

Q16. Which of the following is not a database object?

  1. Tables
  2. Queries
  3. Relationships
  4. Reports

 

Q17. Which one is the guideline of Referential integrity in a relationship?

  1. Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
  2. Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table
  3. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
  4. Do not enter a value in the foreign key field of child table if that value does not exist in the foreign key of the parent table

 

Q18. Which of the following is not a database model

  1. Network Database Model
  2. Relational Database Model
  3. Object Oriented Database Model
  4. None

 

Q19. The overall description of a database is called______.

  1. Data integrity
  2. Data manipulation
  3. Database schema
  4. Data definition

 

Q20. A data dictionary is a repository that manages _____

  1. Memory
  2. Metadata
  3. Spell Checker
  4. Data Validator

 

  1. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as……….

(A) Data Model

(B) E-R Model

(C) DBMS

(D) All of the above

Answer

(A) Data Model

 

  1. Dr.E.F. Codd represented ……. rules that a database must obey if it has to be considered truly relational.

(A) 10

(B) 15

(C) 14

(D) 12

Answer

(D) 12

 

  1. In E-R Diagram, weak entity is represented by…….

(A) Rectangle

(B) Square

(C) Double Rectangle

(D) Circle

Answer

(C) Double Rectangle

 

  1. An entity that is related with itself is known as…….

(A) binary relationship

(B) Recursive relationship

(C) ternary relationship

(D) None of the above

Answer

(B) recursive relationship

 

  1. ……. is a bottom-up approach in which two lower level entities combine to form a higher level entity.

(A) Aggregation

(B) Specialization

(C) Generalization

(D) None of the above

Answer

(C) Generalization

 

  1. An entity set that does not have sufficient attributes to form a primary key, is a………

(A) Primary entity set

(B) Weak entity set

(C) Strong entity set

(D) None of the above

Answer

(B) Weak entity set

 

  1. Which SQL command delete all the records and does not remove the structure?

(A) Drop

(B) Insert

(C) Truncate

(D) None of the above

Answer

(C) Truncate

 

  1. Which of the following is a Data Definition Language (DDL) command?

(A) Delete

(B) Insert

(C) Drop

(D) Merge

Answer

(C) Drop

 

  1. In…….. Database, data is organized in the form of trees with nodes.

(A) Hierarchical

(B) Relational

(C) Network

(D) None of the above

Answer

(A) Hierarchical

 

  1. Which command is used to retrieve records from one or more table?

(A) Delete

(B) Insert

(C) Drop

(D) Select

Answer

(D) Select

 

  1. Rows of a relation are called ________

(A) entity

(B) degree

(C) Tuples

(D) None of the above

Answer

(C) tuples

 

  1. The number of tuples in a relation is termed as ______

(A) Cardinality

(B) entity

(C) column

(D) None of the above

Answer

(A) cardinality

 

  1. In SQL, Which of the following is a Data Manipulation Language (DML) command?

(A) create

(B) alter

(C) Merge

(D) drop

Answer

(C) merge

 

  1. ……… is a top-down approach in which one higher level entity can be divided into two lower level entities.

(A) Aggregation

(B) Specialization

(C) Generalization

(D) None of the above

Answer

(B) Specialization

 

  1. Which of the following is not a type of database?

(A) Hierarchical

(B) Relational

(C) Network

(D) Transition

Answer

(D) Transition

 

  1. In a relational database, each tuple is divided into fields called_______

(A) Relations

(B) Domains

(C) Queries

(D) None of the above

Answer

(B) Domains

 

  1. In E-R Diagram, attribute is represented by…….

(A) Rectangle

(B) Square

(C) Double Rectangle

(D) eclipse

Answer

(D) eclipse

 

  1. In SQL, TCL stands for______

(A) Transmission Control Language

(B) Transaction Central Language

(C) Ternary Control Language

(D) Transaction Control Language

Answer

(D) Transaction Control Language

 

  1. Which of the following is a part of the Oracle database system?

(A) Free lists

(B) Front end

(C) Network

(D) None of the above

Answer

(B) Front end

 

  1. Which of the following is used with database?

(A) ATM

(B) Payment gateway

(C) Data Mining

(D) None of the above

Answer

(C) Data Mining

 

  1. 4 The language used in application programs to request data from the DBMS is referred to as the ______

(A) DML

(B) DDL

(C) DCL

(D) None of the above

Answer

(A) DML

 

  1. In Oracle, who owns the data dictionary?

(A) DBA

(B) SYS

(C) SYSTEM

(D) None of the above

Answer

(B) SYS

 

  1. In SQL, which command is used to update existing row in a table?

(A) Insert

(B) Delete

(C) Update

(D) None of the above

Answer

(C) Update

 

  1. A ________ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

(A) Record

(B) Field

(C) Table

(D) None of the above

Answer

(B) Field

 

  1. A relation between two entities is treated as a single entity is called__________

(A) Aggregation

(B) Specialization

(C) Generalization

(D) None of the above

Answer

(A) Aggregation

 

  1. Data mining evolve as a mechanism to cater the limitations of _______ systems to deal massive data sets with high dimensionality.

(A) OLAP

(B) OLTP

(C) DWH

(D) None of the above

Answer

(B) OLTP

 

  1. In Relational table, the term “Attribute” is also used to represent _______

(A) row

(B) Column (or) field

(C) entity

(D) None of the above

Answer

(B) column (or) field

 

  1. Which of the following categories of the data integrity RDBMS will enforce specific business rules?

(A) Entity Integrity

(B) Domain Integrity

(C) User-Defined Integrity

(D) None of the above

Answer

(C) User-Defined Integrity

 

  1. E-R Modeling technique is a _______

(A) Top-down approach

(B) bottom-up approach

(C) User-Defin

(D) None of the above

Answer

(A) top-down approach

 

  1. The number of attributes in a relation is called its _____

(A) row

(B) column

(C) Degree

(D) None of the above

Answer

(C) degree