Today's Topic Basic Concepts & Terminologies Of DataBase Solved MCQs

Basic Concepts & Terminologies Of DataBase Solved MCQs

What is Db?

Actully database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).

Q01) The row of relation can be of order.

1. Any
2. Same
3. Sorted
4. Conse

Answer:Any

Explanation:The relational data model represents a table of values (or data table). Each row of the table, therefore, represents a collection of related data values and hence typically corresponds to real world entity or relationship

Q02) The row of table is also called:

1. Entity
2. Attributes
3. Cell
4. Record

Answer:Record

Explanation:A table has records (rows) and fields (columns).

Q03) Which is used to indicate characteristics of an object?

1. Relationship
2. Cardinality
3. Modality
4. Attribute

Answer:Attribute

Explanation:An attribute value system is a basic knowledge representation framework comprising a table with columns designating "attributes"

Q04) Which object is used to define the structure and stores the data?

1. Query
2. Form
3. Macro
4. table

Answer:Table

Explanation:A database object in a relational database is a data structure used to either store or reference data. The most common object that people interact with is the table.

Q05) Which of the foliowing can be a primary key?

1. Last name
2. Salary
3. Customer ID
4. Region

Answer:Customer ID

Explanation:A primary key is either an existing table column or a column that is specifically generated by the database according to a defined sequence.

Q06) Which of the following keys possesses the uniqueness property?

1. Foreign key
2. Secondary Key
3. Sort Key
4. Composite Key

Answer:Composite Key

Explanation:It must contain unique values. Candidate key in SQL may have multiple attributes.

Q07) Who is responsible to design, implement and maintain a databases?

1. Database administrator
2. End users
3. Web designer
4. Application programmer

Answer:Database administrator

Explanation:A DBA (Database administrator) designs, implements, and monitors data management systems (DBMs) and ensures design, consistency, quality, and security.

Q08) A relation is also known as:

1. Table
2. Tuple
3. Entity
4. Attribute

Answer:Table

Explanation:A relation, also known as a table or file, is a subset of the Cartesian product of a list of domains characterized by a name.

Q09) A table is a two dimensional structure that consist of

1. X and Y coordinates
2. Matrix elements
3. Intersection of data
4. Row and column

Answer:Row and column

Explanation:A table is a two-dimensional structure that has columns and rows.

Q10) A relation is analogous to a

1. Table
2. Field
3. Record
4. Row

Answer:Table

Explanation:Tables are database objects that contain all the data in a database.

Q11) An Attribute is also known as

1. Relation
2. Row
3. Field
4. Tuple

Answer:Field

Explanation:A column or Field can also be called an attribute.

Q12) Which is used to indicate characteristics of an object

1. Relationship
2. Cardinality
3. Modality
4. Attribute

Answer:Attribute

Explanation:An object has identity. An object has state (it has various properties, which might change).

Q13) A Table must have a

1. Primary key
2. Secondary key
3. Composite key
4. Sort key

Answer: Primary key

Explanation:A database table must have a primary key for Optim to insert, update, restore, or delete data from a database table. PK is also known as a Index key

Q14) Which of the following is also known as control key?

1. Foreign key
2. Primary key
3. Composite key
4. Sort key

Answer:Sort key

Explanation:A sort key is a field in your table that determines the order in which the data is physically stored in the database.

Q15) Foreign key is found in

1. Parent Table
2. Dependent Table
3. Pivot Table
4. Index Table

Answer:Dependent Table

Explanation:Dependent Table or Child Table. A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables.

Q16) The columns of a table correspond to:

1. Table
2. Records
3. Field
4. Cell

Answer:Field

Explanation:The column of the table correspond to​ field. The tables' columns are referred to as fields.

Q17) The category of data that describes an entity is called:

1. Attribute
2. Data items
3. Record
4. Tuple

Answer:Attribute

Explanation:An attribute defines the information about the entity that needs to be stored.

Q18) The data or information that describes an entity is called:

1. Attribute
2. Record
3. Tuple
4. Data Item

Answer:Attribute

Explanation:An attribute defines the information about the entity that needs to be stored.

Q19) Teacher, students and cars are example of:

1. Relationship
2. Identifiers
3. Attributes
4. Entities

Answer:Entities

Explanation:An entity in a database is a thing, place, person or object that is independent of another.

Q20) Which of the following is not included in the definition of entity

1. Action
2. Object
3. Person
4. Concept

Answer:Concept

Explanation:Concept. Because an entity in a database is a thing, place, person or object that is independent of another.

Q21) The selected candidate key is called

1. Foreign
2. Composite key
3. Primary key
4. Super key

Answer:Primary key

Explanation:Primary key is the Candidate key selected by the database administrator to uniquely identify tuples in a table.

Q22) In admission table, Student Roll no. is used as a

1. Sort Key
2. Foreign key
3. Primary key
4. Secondary key

Answer:Primary key

Explanation:A primary key is the column or columns that contain values that uniquely identify each row in a table​.

Q23) An index may be created on

1. ) Secondary key
2. Forcign key
3. Primary key
4. All of these

Answer: Primary key

Explanation:Indexes can be created using one or more columns of a database table.

Q24) How many primary keys a relation can have

1. Only One
2. No Limit
3. Three
4. At least One

Answer:Only One

Explanation:A table can have only one primary key, which may consist of single or multiple fields.

Q25) A Primary key that consist of two or more attributes of a relation is called

1. Sort Key
2. Sub key
3. Composite key
4. Primary Key

Answer:Composite key

Explanation:A primary key that made up of more than one attribute is known as a composite key.