Prev 1 2 3 4 5 Next
31. ___ is one reason for problems of data integrity.
A. Data availability constraints
B. Blocks
C. Security constraints
D. Unauthorized access of data
ANSWER:A
SOLUTION : Data availability constraints are one reason for problems of data integrity.
32. ___ means that the data contained in a database is accurate and reliable.
A. Data redundancy
B. Data integrity
C. Data reliability
D. Data consistency
ANSWER:B
SOLUTION:Data integrity means that the data contained in a database is accurate and reliable.
33. Which of the following is the drawback of DBMS?
A. Improvement in Data
B. Backup and recovery
C. Complexity
D. Maintenance of data integrity
ANSWER:C
SOLUTION:Some of the main disadvantages of DBMS are: Cost, Complexity, Scalability, Dependence on Technology, Performance issue, Data Integration, Security, and Data loss.
34. In which of the following database are used?
A. Banking
B. Finance
C. Sales
D. All of these
ANSWER:D
SOLUTION:Banking: Used to store and process financial transactions, such as balances, deposits, loans, and credit cards
Finance: Used to store information about sales and holdings, and purchasing financial stocks and bonds
Sales: Used to streamline and manage sales accounts and contacts more efficiently
35. Oracle is a____.
A. Hardware
B. High level language
C. Operating system
D. RDBMS
ANSWER:D
SOLUTION: Oracle is an RDBMS (Relational Database Management System).
36. The purpose of the primary key in a database is to _______.
A. Unlock the database
B. Provide a map of the data
C. Uniquely identify a record
D. Establish constraints on database operations
ANSWER:C
SOLUTION :A primary key is used to ensure data in the specific column is unique.
37. Which of the following types of table constraints will prevent the entry of duplicate rows?
A. Primary key
B. Unique
C. Null
D. Foreign key
ANSWER: A
SOLUTION:A primary key is a type of table constraint that prevents duplicate rows
38. Which database language is used to access data in existing database?
A. DDL
B. DML
C. DCL
D. None of these
ANSWER:B
SOLUTION:Data Manipulation Language (DML) is used to access data in an existing database.
39. An E-R diagram is a graphic method of presenting Primary keys and their relationships_______.
A. Primary keys and their relationships to instances
B. Entity classes and their relationships
C. Entity classes and their relationships to primary keys
D. None of the above
ANSWER:C
SOLUTION:An Entity-Relationship (ER) diagram is a graphic method of presenting primary keys and their relationships to entity classes.
40. In an E-R diagram, an entity set is are represented by _________.
A. Rectangle
B. Square
C. Ellipse
D. Triangle
ANSWER:A
SOLUTION:Rectangles divided into two parts represent entity sets in an ER diagram. The upper rectangle contains the name of the entity sets.