MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SOFTWARE ENGINEERING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A ____ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
A
Tablespace
B
Segments
C
Extents
D
Blocks
Explanation: 

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.

There is 1 question to complete.