The database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company database may include tables for products, employees, and financial records. In this section, we are focus on Advanced Database Management System Mcqs.
Database Mcqs set 4
- DCL stands for
A) Data Control Language
B) Data Console Language
C) Data Console Level
D) Data Control Level - …………….. is used to determine whether a table contains duplicate rows.
A) Unique predicate
B) Like Predicate
C) Null predicate
D) In predicate - …………….. is the complex search criteria in the where clause.
A) Substring
B) Drop Table
C) Predict
D) Predicate - State true or false
i) A candidate key is a minimal super key.
ii) A candidate key can also refer to as a surrogate key.
A) i-true, ii-false
B) i-false, ii-true
C) i-true, ii-true
D) i-false, ii-false
- The database schema is written in
A. HLL
B. DML
C. DDL
D. DCL
- Which one of the following statements is false?
A. The data dictionary is normally maintained by the database administrator
B. Data elements in the database can be modified by changing the data dictionary.
C. The data dictionary contains the name and description of each data element.
D. The data dictionary is a tool used exclusively by the database administrator.
- Which database level is closest to the users?
A. External
B. Internal
C. Physical
D. Conceptual
- A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.
A) Weak entity
B) Strong entity
C) Non attributes entity
- The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ………………..
A) Degree, Cardinality
B) Cardinality, Degree
C) Rows, Columns
D) Columns, Rows
D) Dependent entity
- ………………… is preferred method for enforcing data integrity
A) Constraints
B) Stored Procedure
C) Triggers
D) Cursors