COMPUTER SCIENCE AND ENGINEERING
SOFTWARE ENGINEERING
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Tablespace
|
|
Segments
|
|
Extents
|
|
Blocks
|
Detailed explanation-1: -4. A is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes. Explanation: A tablespace is a storage location where the actual data underlying database objects can be kept.
Detailed explanation-2: -A schema is a logical grouping of database objects (tables, views, etc.). Each schema belongs to a single database.
Detailed explanation-3: -A logical grouping of database objects, such as tables, indexes, views, and queries, that are related to each other. Usually, a schema belongs to a single user or application. A symbol that can be used as a general substitute for one or more characters in a SQL LIKE clause condition.
Detailed explanation-4: -All the data dictionary tables and views for a given database are stored in that database’s SYSTEM tablespace.