Database Management System (DBMS)

51. Which is proper subset designed to support ‘views’ belonging to different classes of users in order to hid or protect information:

1. Schema
2. Subschema
3. Non-schema
4. None-subschema

View answer

52. A data dictionary is a repository that manages ___________:

1. Database
2. Memory
3. Metadata
4. All of these

View answer

53. Which languages are used to define and query a database:

1. Database
2. Memory
3. Metadata
4. All of these

View answer

54. DDL stand for:

1. Data definition language
2. Data description languages
3. Data design languages
4. Database dictionary languages

View answer

55. Which are the not most frequently used DDL statements:

1. CREATE
2. DROP
3. ALTER
4. None of these

View answer

56. VDL stand for:

1. View data languages
2. View design languages
3. View definition languages
4. View done languages

View answer

57. SDL stands for

1. Stand definition languages
2. Storage definition languages
3. Select definition languages
4. system definition languages

View answer

58. The DDL is used to specify the ___________:

1. Conceptual schemas
2. Internal schemas
3. Both
4. None

View answer

59. The SDL is used to specify the ___________:

1. Conceptual schemas
2. Internal schemas
3. Both
4. None

View answer

60. DML stands for:

1. Data description languages
2. Data design languages
3. Database dictionary languages
4. Data manipulation languages

View answer