> > 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. Which of the following statements about normal forms is/are true?

If a relation is in 1NF. then it must be in 2NF

If every attribute is functionally dependent on a candidate key, then the relation is always is in 2NF.

Any relation in BCNF is also in 3NF.

Every binary relation is in BCNF.

Answer

Correct Answer: Any relation in BCNF is also in 3NF.
Every binary relation is in BCNF.

Note: This question has more than 1 correct answers

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

27.
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

28. Restriction of_ from the basic relational model has been removed in the nested relational model.

1NF

2NF

3NF

5NF

Answer

Correct Answer: 1NF

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

29. 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

30. A database system without concurrency control may cause:

Dirty read problem

Phantom read problem

Lost update problem

Missing and double read problem caused by row updates

All of the above problems

Answer

Correct Answer: All of the above problems

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

31. 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

32. What is the order of execution of operations during a pessimistic concurrency control technique?

Read. Compute. Validate. Write

Compute, Validate, Read, Write

Validate. Read. Compute. Write

Validate. compute. Read. Write

Answer

Correct Answer: Validate. Read. Compute. Write

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

33. Which of the following indexes in databases is usually dense?

Primary index

Clustering index

Secondary index

Both primary and secondary indexes

Answer

Correct Answer: Secondary index

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

34. Which of the following relations is also called a snapshot relation?

Temporal relation

Bitemporal relation

Nontemporal relation

Answer

Correct Answer: Nontemporal relation

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

35. Database normalization is used to .

improve the security of a database

minimize redundancy

improve eff‌iciency of a database

reduce errors in a database

Answer

Correct Answer: minimize redundancy

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

36.
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

37. 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

38. Consider a table titled "StudentDetails“ having the following attributes:

Rollno {Primary key)

StudentName

ClubEnrolled

Answer

Correct Answer: StudentName

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

39. 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

40. Which of the following is NOT the correct syntax to write the REVOKE statement that is used to revoke a privilege on a table named, Employee from user2?

REVOKE DELETE ON Employee FROM user2;

REVOKE DELETE ON TABLE Employee FROM user2;

REVOKE DELETE ON Employee FROM PUBLIC;

REVOKE FROM user2 DELETE ON Employee;

Answer

Correct Answer: REVOKE FROM user2 DELETE ON Employee;

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

41. How can a timestamp be implemented in a database?

By a system clock only.

By a thread-safe shared counter only.

Either by system clock. or by thread-safe shared counter. or by both together.

Neither by system clock nor by thread-safe shared counter.

Answer

Correct Answer: Either by system clock. or by thread-safe shared counter. or by both together.

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

42.
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

43.
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

44.
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

45.
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

46.
Which of the following relational algebra expressions represents the query that will f‌ind names of customers having an account balance of over Rs. 5.000?

customer_name (o balance>5000 (Account))

customer_name (n balance>5000 (Account))

Answer

Correct Answer:

customer_name (o balance>5000 (Account))

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

47. 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

48. Which of the given options is targeted and focused on a single subset of an organization?

Enterprise-wide data warehouses

Data marts

Virtual data warehouses

Answer

Correct Answer: Data marts

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

49.
Which of the following database security mechanisms is used to enforce multilevel security by classifying users and data into various security levels?
1. Mandatory security mechanisms
2. Discretionary security mechanisms

Only1

Only 2

Both 1 and 2

Answer

Correct Answer:

Only1

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

50.
Suppose there are two relations: R1 and R2. If C1 and C2 are the selection conditions, and A1 and A2 are the attributes of the relation R1, then which of the given query transformations are correct?
1. 0C1 (0C1 (R1)) -> 0C2 (0C2 (R1))
2. 0C1 (nA1 (R1)) -> nAl (0C1 (R1))
3. 0C1 (R1 U R2) -> 0C1 (R1) U 0C1 (R2)

Only 1 and 2

Only1 and 3

Only 2 and 3

1. 2 and 3

Answer

Correct Answer:

Only 2 and 3

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

51.
Which of the following attributes is represented by the entity-relationship (E-R) diagram given in the image?

Composite attribute

Derived attribute

Key attribute

Multivalued attribute

Answer

Correct Answer:

Derived attribute

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

52.
State whether the following statement is true or false:
A database table must have only one primary key and one super key.

True

False

Answer

Correct Answer:

False

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

53. Which one of the given options is not a component of a storage manager in a database management system?

Logical manager

File manager

Buffer manager

Transaction manager

Answer

Correct Answer: Logical manager

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

54. Which of the following levels of a data storage virtualization technology involves block-level striping with distributed parity?

RAID 0

RAID1

RAID 3

RAID 5

Answer

Correct Answer: RAID 5

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

55. Which of the following options is defined as the tendency to change the internal schema without affecting the conceptual schema?

Performance monitoring

Logical data independence

Relationship inheritance

Physical data independence

Answer

Correct Answer: Physical data independence

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

56.
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

57. 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

58.
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

59.
Consider a relation "Book" with the following structure:
book_id (Primary key)
book_name
book_title
date_of_issue
Which of the following relational algebra operations will return all the entries of book_id and book_title from the relation "Book“?

book_id. book_title (Book)

Answer

Correct Answer:

book_id. book_title (Book)

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

60. 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

61.
Which Of the given figures represents a weak entity as used in Entity-Relationship (ER) diagrams?

Figure 1

Figure 2

Figure 3

Figure 4

Answer

Correct Answer:

Figure 3

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

62.
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

63. 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

64. 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

65. An Object-oriented database stores persistent object(s) that is/are not shared among multiple applications or programs, in a permanent storage.

True

False

Answer

Correct Answer: False

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

66. Which of the following access control policies ensures a high degree of protection from malicious attacks?

DAC policies

MAC policies

Both DAc and MAC policies

Answer

Correct Answer: MAC policies

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

67. 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

68. 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

69. Any user-defined Object in an Object model that is not a type of collection object is called a/an _.

atomic object

extended object

inherited object

factory object

Answer

Correct Answer: atomic object

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

70. What is the use of the TRUNCATE command in SQL?

It is used to remove a table from a database.

It is used to remove data from a table. but data can be rolled back.

It is used to remove data permanently from the table so that it cannot be rolled back.

It is used to remove constraints from a table.

Answer

Correct Answer: It is used to remove data permanently from the table so that it cannot be rolled back.

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

71.
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 f‌inding the owner of the data.

Only1 and 2

Only1 and 3

Answer

Correct Answer:

Only1 and 3

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

72. What do you mean by backflushing in the construction of a data warehouse?

The process of reformatting of data.

The process of returning cleaned data back to the source.

The process of reloading data into the warehouse.

Answer

Correct Answer: The process of returning cleaned data back to the source.

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

73. 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

74. 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

75. Which of the following statements is incorrect?

DKNF (Domain! Key normal form) avoids non-temporal anomalies.

Fifth normal form is a special case of DKNF (Domain/ Key normal form)

It is always a dependency-preserving transformation to convert/transform a higher normal form to DKNF (Domain! Key normal form).

Third normal form is a special case of DKNF (Domain/ Key normal form).

Answer

Correct Answer: It is always a dependency-preserving transformation to convert/transform a higher normal form to DKNF (Domain! Key normal form).

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

76.
Which of the following inference rules for functional dependencies are correct?
1. |fA> BandA>C,thenA> BC
2. lfA>BC,thenA>BandA>C
3. |fA> B and DB>C,then DA>C
4.lfA>BandC>D.thenAC>BD

Only1, 2 and 3

Only 1, 2 and 4

Only 2, 3 and 4

All of them

Answer

Correct Answer:

All of them

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

77.
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

78. 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. Which of the following statements about normal forms is/are true?

27. 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 .

28. Restriction of_ from the basic relational model has been removed in the nested relational model.

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

30. A database system without concurrency control may cause:

31. Concurrency control is used .

32. What is the order of execution of operations during a pessimistic concurrency control technique?

33. Which of the following indexes in databases is usually dense?

34. Which of the following relations is also called a snapshot relation?

35. Database normalization is used to .

36. 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.

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

38. Consider a table titled "StudentDetails“ having the following attributes:

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

40. Which of the following is NOT the correct syntax to write the REVOKE statement that is used to revoke a privilege on a table named, Employee from user2?

41. How can a timestamp be implemented in a database?

42. 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?

43. 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;

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

46. Which of the following relational algebra expressions represents the query that will f‌ind names of customers having an account balance of over Rs. 5.000?

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

48. Which of the given options is targeted and focused on a single subset of an organization?

49. Which of the following database security mechanisms is used to enforce multilevel security by classifying users and data into various security levels?1. Mandatory security mechanisms2. Discretionary security mechanisms

51. Which of the following attributes is represented by the entity-relationship (E-R) diagram given in the image?

52. State whether the following statement is true or false:A database table must have only one primary key and one super key.

53. Which one of the given options is not a component of a storage manager in a database management system?

54. Which of the following levels of a data storage virtualization technology involves block-level striping with distributed parity?

55. Which of the following options is defined as the tendency to change the internal schema without affecting the conceptual schema?

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

57. Which of the following statements is false?

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

59. Consider a relation "Book" with the following structure:book_id (Primary key)book_namebook_titledate_of_issueWhich of the following relational algebra operations will return all the entries of book_id and book_title from the relation "Book“?

60. A tablespace is divided into .

61. Which Of the given figures represents a weak entity as used in Entity-Relationship (ER) diagrams?

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

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

65. An Object-oriented database stores persistent object(s) that is/are not shared among multiple applications or programs, in a permanent storage.

66. Which of the following access control policies ensures a high degree of protection from malicious attacks?

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

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

69. Any user-defined Object in an Object model that is not a type of collection object is called a/an _.

70. What is the use of the TRUNCATE command in SQL?

71. 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 f‌inding the owner of the data.

72. What do you mean by backflushing in the construction of a data warehouse?

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

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

75. Which of the following statements is incorrect?

76. Which of the following inference rules for functional dependencies are correct?1. |fA> BandA>C,thenA> BC2. lfA>BC,thenA>BandA>C3. |fA> B and DB>C,then DA>C4.lfA>BandC>D.thenAC>BD

77. 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.

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

27.
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 .

36.
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.

42.
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?

43.
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;

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

46.
Which of the following relational algebra expressions represents the query that will f‌ind names of customers having an account balance of over Rs. 5.000?

49.
Which of the following database security mechanisms is used to enforce multilevel security by classifying users and data into various security levels?
1. Mandatory security mechanisms
2. Discretionary security mechanisms

51.
Which of the following attributes is represented by the entity-relationship (E-R) diagram given in the image?

52.
State whether the following statement is true or false:
A database table must have only one primary key and one super key.

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

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

59.
Consider a relation "Book" with the following structure:
book_id (Primary key)
book_name
book_title
date_of_issue
Which of the following relational algebra operations will return all the entries of book_id and book_title from the relation "Book“?

61.
Which Of the given figures represents a weak entity as used in Entity-Relationship (ER) diagrams?

71.
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 f‌inding the owner of the data.

76.
Which of the following inference rules for functional dependencies are correct?
1. |fA> BandA>C,thenA> BC
2. lfA>BC,thenA>BandA>C
3. |fA> B and DB>C,then DA>C
4.lfA>BandC>D.thenAC>BD

77.
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.