Database Management System - DBMS Questions and Answers | Online Quiz for Practice

46. A functional dependency is a relationship between or among:

1. Relations
2. Tables
3. Rows
4. Attributes

47. In RDBMS, Data is presented as a collection of ............

1. Relations
2. Table
3. Attributes
4. Entities

48. In RDBMS, Data is presented as a collection of............

1. Relations
2. Table
3. Attributes
4. Entities

49. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….

1. Relations
2. Fields
3. Records
4. Keys

50. In an ER model, …………… is described in the database by storing its data.

1. Relationship
2. Entity
3. Attribute
4. Notation

51. The three basic techniques to control deadlocks are: deadlock ………………, deadlock detection, and deadlock avoidance.

1. rollback
2. prevention
3. prohibition
4. Commits

52. A tuple is a(n):

1. row of a table
2. column of a table
3. two dimensional table
4. key of a table

53. The……………… lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.

1. row-level
2. table-level
3. page-level
4. field-level

54. The number of tuples in a relation is called its ………… While the number of attributes in a relation is called its ………………..

1. Rows, Columns
2. Degree, Cardinality
3. Cardinality, Degree
4. Columns, Rows

55. Which of the following in not a function of DBA?

1. Schema Definition
2. Network Maintenance
3. Routine Maintenance
4. Authorization for data access

56. After conversion of high level queries into low level commands for file access and is called compiled………………

1. SDL
2. DDL
3. DML
4. VDL

57. Which are the not features of a DBMS which provide a number of advantages for data management:

1. SDL
2. DML
3. DDL
4. None of these

58. Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called………………

1. Second normal form
2. Boyce-Codd normal form
3. First normal form
4. All of these

59. ................ requires that data should be made available to only authorized users.

1. Security
2. Data integrity
3. Privacy
4. None of the above

60. The statement in SQL which allows to change the definition of a table is

1. Select
2. Create
3. Alter
4. Update