COMPUTER SCIENCE AND ENGINEERING
SOFTWARE ENGINEERING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Instance
|
|
|
Segment
|
|
|
Database
|
|
|
Dictionary
|
Detailed explanation-1: -When you use the Database Configuration Assistant to create a database, Oracle automatically creates the data dictionary. Thereafter, whenever the database is in operation, Oracle updates the data dictionary in response to every DDL statement.
Detailed explanation-2: -Data dictionaries are used to provide detailed information about the contents of a dataset or database, such as the names of measured variables, their data types or formats, and text descriptions. A data dictionary provides a concise guide to understanding and using the data.
Detailed explanation-3: -Explanation: Data dictionary is also called as system catalog.
Detailed explanation-4: -What is a Data Dictionary? In SQL Server, the data dictionary is a set of database tables used to store information about a database’s definition. & The dictionary contains information about database objects such as tables, indexes, columns, datatypes, and views.