Database problems
- 1. A data dictionary is a special file that contains
Options- A. The width of all fields in all files
- B. The data type of all fields in all file
- C. The name of all fields in all files
- D. All of the above Also asked in: Bank Exams, Analyst, Bank Clerk, Database Administrator, IT Trainer
Correct Answer: All of the above
Explanation:
A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.
- 2. We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: FALSE
Explanation:
Can?t delete a row from primary table if there are related rows in secondary table.
- 3. A subset of the database which contain virtual data that is derived from the database files but is not explicitly stored is called
Options- A. Touple
- B. View
- C. Relation
- D. Key Also asked in: Database Administrator
Correct Answer: View
Explanation:
A view may be a subset of the database or it may contain virtual data that is derived from the database files but is not explicitly stored .
- 4. Database is a collection of concepts that can be used to describe the structure of a database
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: TRUE
Explanation:
Database provides necessary means to achieve this abstraction. By structure of a database we mean the data types, relations, and constraints that should hold on the data.
- 5. Representation level data models provide the concepts that are close to the way many users perceive data
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: FALSE
Explanation:
High level data models provide the concepts that are close to the way many users perceive data
- 6. Physical data models describe the details of how data is stored in the computers
Options- A. TRUE
- B. FALSE Also asked in: Database Administrator
Correct Answer: TRUE
Explanation:
They describe the details of how data is stored in the computers
- 7. What is schema? Also asked in: Database Administrator
Correct Answer: The description of a data base is called the database schema , which is specified during database design and is not expected to change frequently A displayed schema is called schema diagram We call each object in the schema as schema construct
- 8. The capacity to change the conceptual schema without having to change external schemas or application programs is called
Options- A. Physical Data Independence
- B. Logical Data Independence
- C. Both A and B
- D. None Also asked in: Database Administrator
Correct Answer: Logical Data Independence
Explanation:
LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.
- 9. What are different types of DBMS? Also asked in: Database Administrator
Correct Answer: 1 DBMS 2 RDBMS (Relational) 3 ORDBMS (Object Relational) 4 DDBMS (Distributed) 5 FDBMS (Federated) 6 HDDBMS (Homogeneous) 7 HDBMS (Hierarchical) 8 NDBMS (Networked)
- 10. The no of entities participating in a relation is called
Options- A. Relation
- B. Degree of relationship
- C. Recursive relationship
- D. None of the above Also asked in: Database Administrator
Correct Answer: Degree of relationship
Explanation:
The no of entities participating in relation is called Degree of relationship
More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.