> > Database Management MCQs > Basic Database Management MCQs

Basic Database Management MCQ

1. The ____ macro action will move the focus to a specific control.

GoToControl

False

Back Style

Font Color

Answer

Correct Answer: GoToControl

Note: This Question is unanswered, help us to find answer for this one

2. A struct is a(n) ____________________, not a declaration.

Definition

The values and the length

Either by value or by reference

Heterogeneous

Answer

Correct Answer: Definition

Note: This Question is unanswered, help us to find answer for this one

3. ________ problems are encountered when removing data with transitive dependencies.

Insertion

Modification

Deletion

Merging

Answer

Correct Answer: Deletion

Note: This Question is unanswered, help us to find answer for this one

4. ________ tools and techniques process data and do statistical analysis for insight and discovery.

Operational intelligence

Business intelligence

Information accessibility

Information fluidity

Answer

Correct Answer: Business intelligence

Note: This Question is unanswered, help us to find answer for this one

5. 1nf, 2nf, and 3nf are ____.

Normalization stages

Denormalization stages

Anomalies

Repeating groups

Answer

Correct Answer: Normalization stages

Note: This Question is unanswered, help us to find answer for this one

6. A(n) ____ is the equivalent of a field in a file system.

Attribute

Entity

Relationship

Constraint

Answer

Correct Answer: Attribute

Note: This Question is unanswered, help us to find answer for this one

7. To normalize a data structure, you apply the ______________________ in sequence.

Indexes

Normal forms

Composite indexes

None of the above

Answer

Correct Answer: Normal forms

Note: This Question is unanswered, help us to find answer for this one

8. To make changes to existing data in a table, you would use the ____ command.

DELETE

SELECT

UPDATE

CHANGE

Answer

Correct Answer: UPDATE

Note: This Question is unanswered, help us to find answer for this one

9. The index key can have multiple attributes, this is called a(n) ____________________ index.

Credibility,

Confidence,

Competence

Composite

Answer

Correct Answer: Composite

Note: This Question is unanswered, help us to find answer for this one

10. A ________ view is materialized when referenced.

Virtual

Dynamic

Materialized

Base

Answer

Correct Answer: Dynamic

Note: This Question is unanswered, help us to find answer for this one

11. The ________ states that no primary key attribute may be null.

Referential integrity constraint

Entity integrity rule

Partial specialization rule

Range domain rule

Answer

Correct Answer: Entity integrity rule

Note: This Question is unanswered, help us to find answer for this one

12. When a subquery is used, ____ is(are) evaluated first.

False

Enclose in square brackets

Question Mark (?)

The subquery query

Answer

Correct Answer: The subquery query

Note: This Question is unanswered, help us to find answer for this one

13. The field ______ defines the maximum number of characters a field can contain.

Length

Width

Capacity

Size

Answer

Correct Answer: Size

Note: This Question is unanswered, help us to find answer for this one

14. The catalog is maintained by ____.

The user

The database administrator

The author of the tables in the database

The DBMS

Answer

Correct Answer: The DBMS

Note: This Question is unanswered, help us to find answer for this one

15. Only one ____ constraint can exist for each table.

PRIMARY KEY

FOREIGN KEY

NONE OF THESE

Answer

Correct Answer: PRIMARY KEY

Note: This Question is unanswered, help us to find answer for this one

16. Information in the data dictionary is called: _______________

It is an iterative process

Context diagram

Metadata

True

Answer

Correct Answer: Metadata

Note: This Question is unanswered, help us to find answer for this one

17. In the data hierarchy, the smallest element is the _____.

Record

Bit

Byte

Character

File

Answer

Correct Answer: Bit

Note: This Question is unanswered, help us to find answer for this one

18. If b (an attribute) is functionally dependent on a, we can also say that ____.

Update anomalies

False

A functionally determines B

Multivalued dependencies

Answer

Correct Answer: A functionally determines B

Note: This Question is unanswered, help us to find answer for this one

19. Data that are never physically altered once they are added to the store are called ________ data.

Complete

Override

Transient

Periodic

Answer

Correct Answer: Periodic

Note: This Question is unanswered, help us to find answer for this one

20. An entity cluster is formed by combining multiple interrelated entities into ____.

A single abstract entity object

A single entity object

A multiple entity object

Answer

Correct Answer: A single abstract entity object

Note: This Question is unanswered, help us to find answer for this one

21. A star schema contains both fact and ________ tables.

Dimension

Event.

Natural join

Outer join

Answer

Correct Answer: Dimension

Note: This Question is unanswered, help us to find answer for this one

22. A ________ is the smallest component in the computer system data hierarchy.

Byte

Bit

Field

File

Answer

Correct Answer: Bit

Note: This Question is unanswered, help us to find answer for this one

23. A ____ is a column in a table that describes a characteristic about a record.

Table

Field

Header

Fields

Answer

Correct Answer: Field

Note: This Question is unanswered, help us to find answer for this one

24. ________ involves standardizing the format of data retrieved from different systems.

Data cleansing

Data mining

Normalization

Content mining

Answer

Correct Answer: Data cleansing

Note: This Question is unanswered, help us to find answer for this one

25. ____ yields better performance.

Denormalization

Normalization

Atomization

Compression

Answer

Correct Answer: Denormalization

Note: This Question is unanswered, help us to find answer for this one

26.
Consider the schema R = (ABCD) and the functional dependencies A -> B, B -> C, C -> D and D -> A. Let R = (R1 and R2) be a decomposition, such that R1 {'1 R2 = cp. The decomposition is in .

1NF but not in 2NF

2NF but not in 3NF

3NF but not in 2NF

both 2NF and 3NF

Answer

Correct Answer:

both 2NF and 3NF

Note: This Question is unanswered, help us to find answer for this one

27. The hash address space in static hashing is not always the same.

True

False

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

28. Concurrency control is used .

for providing security to the database

for database indexing.

for preserving the integrity of the database

Answer

Correct Answer: for preserving the integrity of the database

Note: This Question is unanswered, help us to find answer for this one

29.
Choose the incorrect statements about an object identif‌ier (01D)?
1. The value of an OlD is visible to an external user.
2. It is used by a system to identify Objects uniquely.
3. An OID cannot be assigned to variables in programs.

Only1 and 2

Only1 and 3

Only 2 and 3

All 1, 2 and 3

Answer

Correct Answer:

Only1 and 2

Note: This Question is unanswered, help us to find answer for this one

30. Which of the following SOL queries will return the details of only those students who are enrolled in the "Cricket" club?

SELECT Rollno, StudentName FROM StudentDetails WHERE StudentName LIKE (SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = 'Cricket‘);

SELECT Rollno AND StudentName FROM StudentDetails WHERE StudentName IN SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = Cricket;

SELECT Rollno, StudentName FROM StudentDetails WHERE StudentName lN (SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = 'Cricket‘);

SELECT Rollno, StudentName FROM StudentDetails WHERE StudentName lN SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = Cricket

Answer

Correct Answer: SELECT Rollno, StudentName FROM StudentDetails WHERE StudentName lN (SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = 'Cricket‘);

Note: This Question is unanswered, help us to find answer for this one

31. Which type of constraints are expressed by the application programs and not directly expressed in the schemas Of the data model?

Implicit constraints

Explicit constraints

Semantic constraints

Answer

Correct Answer: Semantic constraints

Note: This Question is unanswered, help us to find answer for this one

32.
Examine the below-given SQL statements applied on a table named, Employees and answer the following question.
1. SELECT Iast_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC
2. SELECT Iast_name, salary. hire_date FROM EMPLOYEES ORDER BY 2 DESC
Which of the answer options is true?

The two statements produce identical results.

The second statement returns an error.

There is no need to specify DESC because the results are sorted in a descending order by default

Answer

Correct Answer:

The two statements produce identical results.

Note: This Question is unanswered, help us to find answer for this one

33.
Which of the following statements will be used to delete all the records from a table named, th?
1. DELETE from tb1;
2. DELETE ‘ from tb1;
3. DELETE tb1;

Only1 and 2

Only1 and 3

Only 2 and 3

All 1, 2 and 3

Answer

Correct Answer:

Only1 and 2

Note: This Question is unanswered, help us to find answer for this one

34.
Consider a table titled "Employee" having the following attributes:
Employeeld (Primary key)
EmployeeName
Salary
Department
Which of the following correlated SQL queries will return Employeeld. EmployeeName, Salary and Department of all the employees whose salary is more than the average salary of employees in their respective departments?

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee e WHERE Salary >

(SELECT AVG(Salary) FROM Employee WHERE Salary = e.Department);

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee WHERE Salary >

(SELECT AVERAGE(SaIary) FROM Employee WHERE Department = Department);

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee WHERE Salary >

(SELECT AVG(Salary) FROM Employee WHERE Department = Department);

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee e WHERE Salary >

(SELECT AVG(SaIary) FROM Employee WHERE Department = e.Department);

Answer

Correct Answer:

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee e WHERE Salary >

(SELECT AVG(SaIary) FROM Employee WHERE Department = e.Department);

Note: This Question is unanswered, help us to find answer for this one

35.
In which of the following areas data-mining technology can be applied?
1. Marketing
2. Finance
3. Manufacturing
4. Healthcare

Only1 and 3

Only 2 and 3

Only 1. 2 and 3

All the given areas

Answer

Correct Answer:

All the given areas

Note: This Question is unanswered, help us to find answer for this one

36. Consider a table named "Account," having the following fields.

account_no

customer_name

dateofbirth

pancard_no

address

balance

Answer

Correct Answer: address

Note: This Question is unanswered, help us to find answer for this one

37.
A covert channel permits the transfer of information in such a way that it violates the system's security policy.

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

38. Which of the following statements is false?

In an object database (ODB) design. relationships among records/tuples are def‌ined by attributes with similar values.

In a relational database (RDB) design, built-in constructs do not occur for inheritance.

In an object database (ODB) design. it is strictly required to def‌ine the Operations in the design phase.

Answer

Correct Answer: In an object database (ODB) design. relationships among records/tuples are def‌ined by attributes with similar values.

Note: This Question is unanswered, help us to find answer for this one

39.
The index in which the search key defines an order that is dissimilar from the sequential order of the file is known as index.

primary

secondary

clustering

Answer

Correct Answer:

secondary

Note: This Question is unanswered, help us to find answer for this one

40. A tablespace is divided into .

tracks

extents

segments

blocks

Answer

Correct Answer: segments

Note: This Question is unanswered, help us to find answer for this one

41.
Which of the following syntaxes are used for inserting data into a table?
(1) INSERT INTO table_name
VALUES (value1,value2, value3,...);
(2) INSERT INTO table_name (columnl. column2. column3,...)
VALUES (valuel. value2. valueB....);
(3) INSERT INTO table_name1 [(column1, column2, column3, .....) ]
SELECT column1.column2.co|umn3.
FROM table_name2 [WHERE condition];

Only (1) and (2)

Only (1) and (3)

Only (2) and (3)

All of them.

Answer

Correct Answer:

All of them.

Note: This Question is unanswered, help us to find answer for this one

42. Which of the following statements about a distributed database is false?

All transactions in a distributed database follow the ACID properties.

Transactions in a distributed database are reliable.

A distributed database is modular.

No additional software is required to implement the distributed database.

Answer

Correct Answer: No additional software is required to implement the distributed database.

Note: This Question is unanswered, help us to find answer for this one

43. Object Query Language (OOL) is based on which of the following data models?

RDBMS

ODMG

ODBC

Answer

Correct Answer: ODMG

Note: This Question is unanswered, help us to find answer for this one

44. Which of the following levels of the data-storage virtualization technology involves bit-level striping with dedicated Hamming-code parity?

RAID 1

RAID 2

RAID 3

RAID 6

Answer

Correct Answer: RAID 2

Note: This Question is unanswered, help us to find answer for this one

45. In a database, transactions follow ACID properties. Which of the following are these properties?

Atomicity, Concurrency, Integrity, Durability

Atomicity, Consistency, Isolation. Durability

Atomicity, Consistency. Integrity. Durability

Atomicity, Concurrency, Independent, Durability

Answer

Correct Answer: Atomicity, Consistency, Isolation. Durability

Note: This Question is unanswered, help us to find answer for this one

46. Which of the following statements correctly describes a transitive dependency?

A dependency in which the value of a non-key column is dependent on the value of another non-key column.

A dependency in which a table can be created by joining multiple tables such that it has subsets of the attributes of each table.

A dependency in which a non-key attribute of a table is dependent on the table's primary key.

A dependency in which one attribute value is potentially a "multivalued fact" about another and the attributes are independent of each other.

Answer

Correct Answer: A dependency in which the value of a non-key column is dependent on the value of another non-key column.

Note: This Question is unanswered, help us to find answer for this one

47. Which of the following RAID levels is widely used to store log f‌iles in a database system?

RAID 0

RAID 1

RAID 2

RAID 3

Answer

Correct Answer: RAID 1

Note: This Question is unanswered, help us to find answer for this one

48.
Data dictionary can be used for which of the following options?
1. For f‌inding the location of the data.
2. For f‌inding the size of the storage disk.
3. For finding the owner of the data.

Only1 and 2

Only1 and 3

Only 2 and 3

1. 2 and 3

Answer

Correct Answer:

Only1 and 3

Note: This Question is unanswered, help us to find answer for this one

49. An ODMG object model cannot use exceptions for reporting errors.

True

False

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

Database Management MCQs | Topic-wise

MCQ on Basic Database Management

General Database Management MCQs

Database Management Subjects

More Resources

Database Management MCQ

Database Management Skill Assessment

Database Management PDF

Related MCQs

Drop.io (Online File Sharing) MCQs

eBay Web Services MCQs

Email Etiquette MCQs

Email Handling MCQs

Email Writing MCQs

Basic Database Management MCQ

1. The ____ macro action will move the focus to a specific control.

2. A struct is a(n) ____________________, not a declaration.

3. ________ problems are encountered when removing data with transitive dependencies.

4. ________ tools and techniques process data and do statistical analysis for insight and discovery.

5. 1nf, 2nf, and 3nf are ____.

6. A(n) ____ is the equivalent of a field in a file system.

7. To normalize a data structure, you apply the ______________________ in sequence.

8. To make changes to existing data in a table, you would use the ____ command.

9. The index key can have multiple attributes, this is called a(n) ____________________ index.

10. A ________ view is materialized when referenced.

11. The ________ states that no primary key attribute may be null.

12. When a subquery is used, ____ is(are) evaluated first.

13. The field ______ defines the maximum number of characters a field can contain.

14. The catalog is maintained by ____.

15. Only one ____ constraint can exist for each table.

16. Information in the data dictionary is called: _______________

17. In the data hierarchy, the smallest element is the _____.

18. If b (an attribute) is functionally dependent on a, we can also say that ____.

19. Data that are never physically altered once they are added to the store are called ________ data.

20. An entity cluster is formed by combining multiple interrelated entities into ____.

21. A star schema contains both fact and ________ tables.

22. A ________ is the smallest component in the computer system data hierarchy.

23. A ____ is a column in a table that describes a characteristic about a record.

24. ________ involves standardizing the format of data retrieved from different systems.

25. ____ yields better performance.

26. Consider the schema R = (ABCD) and the functional dependencies A -> B, B -> C, C -> D and D -> A. Let R = (R1 and R2) be a decomposition, such that R1 {'1 R2 = cp. The decomposition is in .

27. The hash address space in static hashing is not always the same.

28. Concurrency control is used .

29. Choose the incorrect statements about an object identif‌ier (01D)?1. The value of an OlD is visible to an external user.2. It is used by a system to identify Objects uniquely.3. An OID cannot be assigned to variables in programs.

30. Which of the following SOL queries will return the details of only those students who are enrolled in the "Cricket" club?

31. Which type of constraints are expressed by the application programs and not directly expressed in the schemas Of the data model?

32. Examine the below-given SQL statements applied on a table named, Employees and answer the following question.1. SELECT Iast_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC2. SELECT Iast_name, salary. hire_date FROM EMPLOYEES ORDER BY 2 DESCWhich of the answer options is true?

33. Which of the following statements will be used to delete all the records from a table named, th?1. DELETE from tb1;2. DELETE ‘ from tb1;3. DELETE tb1;

35. In which of the following areas data-mining technology can be applied?1. Marketing2. Finance3. Manufacturing4. Healthcare

36. Consider a table named "Account," having the following fields.

37. A covert channel permits the transfer of information in such a way that it violates the system's security policy.

38. Which of the following statements is false?

39. The index in which the search key defines an order that is dissimilar from the sequential order of the file is known as index.

40. A tablespace is divided into .

42. Which of the following statements about a distributed database is false?

43. Object Query Language (OOL) is based on which of the following data models?

44. Which of the following levels of the data-storage virtualization technology involves bit-level striping with dedicated Hamming-code parity?

45. In a database, transactions follow ACID properties. Which of the following are these properties?

46. Which of the following statements correctly describes a transitive dependency?

47. Which of the following RAID levels is widely used to store log f‌iles in a database system?

48. Data dictionary can be used for which of the following options?1. For f‌inding the location of the data.2. For f‌inding the size of the storage disk.3. For finding the owner of the data.

49. An ODMG object model cannot use exceptions for reporting errors.

26.
Consider the schema R = (ABCD) and the functional dependencies A -> B, B -> C, C -> D and D -> A. Let R = (R1 and R2) be a decomposition, such that R1 {'1 R2 = cp. The decomposition is in .

29.
Choose the incorrect statements about an object identif‌ier (01D)?
1. The value of an OlD is visible to an external user.
2. It is used by a system to identify Objects uniquely.
3. An OID cannot be assigned to variables in programs.

32.
Examine the below-given SQL statements applied on a table named, Employees and answer the following question.
1. SELECT Iast_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC
2. SELECT Iast_name, salary. hire_date FROM EMPLOYEES ORDER BY 2 DESC
Which of the answer options is true?

33.
Which of the following statements will be used to delete all the records from a table named, th?
1. DELETE from tb1;
2. DELETE ‘ from tb1;
3. DELETE tb1;

35.
In which of the following areas data-mining technology can be applied?
1. Marketing
2. Finance
3. Manufacturing
4. Healthcare

37.
A covert channel permits the transfer of information in such a way that it violates the system's security policy.

39.
The index in which the search key defines an order that is dissimilar from the sequential order of the file is known as index.

48.
Data dictionary can be used for which of the following options?
1. For f‌inding the location of the data.
2. For f‌inding the size of the storage disk.
3. For finding the owner of the data.