Database Management System MCQs
Top 50 DBMS mcq questions and answers focuses on all areas of Database Management System subject covering all the topics in Database Management System.
1) A change in the order of the tables given in a query will have an impact in the final result-set of the query.
- TRUE
- False
2) A collection of related data fields is called a ____.
- byte
- record
- character
- bit
3) A DBMS is a(n) ____.
- interface between the database and application programs
- data repository
- knowledge base
- unique group of records
4) A FLAT FILE database management system is
- A database design that only has one table in it
- A DBMS that can only have simple data tables in it
- A DBMS that can only have one table in it
- A DBMS that contains records that have a large number of fields in them
5) A primary Key column should have
- Unique values but can contain NULL
- Unique values and can’t contain NULL
- May not contain Unique values but shouldn’t have NULL
- May not contain Unique values and can contain NULL.
6) A Table
- Can only store data of one type
- Consists of Alphanumeric data
- Consists of Rows and Columns
- Cannot be empty
7) A table can have only one PRIMARY KEY
- True
- FALSE
8) A table can’t have more than one UNIQUE KEY
- TRUE
- False
9) Ability of a computer system or a database to operate efficiently with larger quantities of data is called
- Linearity
- Feasibility
- Scalability
- Efficiency
10) All the locks are released when
- we issue a commit statement
- when we issue a rollback statement
- both a and B are true
- none of them is true
11) An Empty string and null are both the same
- TRUE
- False
12) Can you use select in FROM clause of SQL select ?
- YES
- NO
13) Column alias cant be used in which clause
- Select
- where
- Order by
- none
14) Commit command is used to make the changes permanent in the table
- True
- FALSE
15) Consider the table (STUDREC). Which of the following statements will list columns INIT, SNAME, GENDER and KIDS (in that order) for all students who have more then 1 child.
- SELECT init, sname, gender, kids FROM studrec WHERE kids <1;
- SELECT init, sname, gender, kids FROM studrec WHERE kids >1;
- SELECT init, sname, gender, kids FROM studrec WHERE kids >’1′;
- SELECT init sname, gender, kids FROM studrec WHERE kids >1;
16) CREATE TABLE statement is used to create
- Both relational table and object table
- Only relational table
- Only object table
- XML Table
17) CREATE TABLE table_name(column_name CHAR); The above SQL statement will create table table_name
- True
- FALSE
18) Database schema is implemented from
- Conceptual Data Model
- Logical Data Model
- Physical Data Model
- Metadata model
19) DBMS is the acronym for
- Directory Base Management System
- Database Master System
- Data Basic Management System
- Database Management System
20) Describe the use of %ROWTYPE in PL/SQL ?
- It allows you to associates a variable with a single column type
- It allows you to associate a variable with an entire table row
- It allows you to associate a variable with an entire table column
- Both A and C
21) Distinct Keyword is used for
- Selecting all duplicate rows
- Eliminating all duplicate rows from the output
- Both A & B
- None of the above
22) Domain is
- Number of attributes
- Tuple
- A pool of values from which specific attributes of specific relations draw their values
- None of the above
23) Foreign Key
- may contain NULL
- has unique values
- Either A or B
- None of the above
24) GROUP BY SQL clause
- Uniquely lists the aggregated
- items in the SELECT list
- Uniquely lists the unaggregated
- items in the SELECT list
- Nonuniquely lists the unaggregated
- items in the SELECT list
- Nonuniquely lists the aggregated
- items in the SELECT list
25) How does a database store data about its tables?
- By a data dictionary
- By entity modeling
- By normalization
- By relationships
26) IF I want to store true / false in sql values from my frontend which data type should I use at the best level in terms of minimum storage?
- Char
- Varchar
- Bit
- Int
27) In Ascending order sort null values appear in the bottom of the result set
- True
- FALSE
28) In the relational database terminology, a table is synonymous with:
- A column
- A row
- An attribute
- A relation
29) Insert, Drop table are examples of which SQL type?
- DML
- DDL
- None of the above
30) Managing data security involves
- Data Classification
- Encryption
- Data Governance
- all of the above
31) One of the goals of a DBMS is to increase data redundancy thereby making it less vulnerable to hackers.
- TRUE
- False
32) Rollback is used to reach the previous committed state
- True
- FALSE
33) SELECT * FROM R1 LEFT [OUTER] JOIN R2 ON R1.field = R2.field
– returns additional rows from?
- R1
- R2
- Both
- Neither
34) select, update are examples of which SQL type
- DML
- DDL
- None of the above
35) SQL stands for
- Sequential Question Language
- Structured Query Language
- Structured Question Language
- Sequential Query Language
36) Table partitioning splits the storage of a table into smaller individual units.
- True
- FALSE
37) To improve performance, all tables in the data warehouse should be indexed.
- TRUE
- False
38) Union All returns
- All rows selected by either query
- All rows selected by either query and including duplicates
- All distinct rows selected by both queries
- All rows selected by the first query but not the seconds
39) Unique Constraint enforces
- single number value to be entered
- single character to be entered
- multiple values in set of columns
- uniqueness of the values
- in a set of columns
40) User-Defined Integrity enforces
- null constraints
- some specific business
- rules
- check constraints
- entity integrity
41) What is a formal way to express data relationships to a database management system?
- Attributes
- Entity identifier
- Data model
- Entity-relationship diagram
42) What is Database ?
- A known fact that can be recorded and that have implicit meaning
- The data is perceived by the user as tables
- It is designed, built, and populated with data for a specific purpose
- All of the above
43) What is the default ordering of an ORDER BY clause in a SELECT statement?
- Descending
- Ascending
44) Which clause limits the rows selected in a query?
- Order By
- Where
- Select
- From
45) Which is a feature of RDBMS?
- Create multiple tables and enter data into them
- Interactive Query language
- All of these
- Retrieval of data stored in more than on table
46) Which of the following are elements of SQL?
- Data Control Language
- Data Definition Language
- Data Manipulation Language
- All of these
47) Which of the following statements does not apply to relational databases?
- Relational databases are simple to understand
- Tables are one of the basic components of relational databases
- Relational databases have a strong procedural orientation
- Relational databases have a strong mathematical foundation
48) Which one is DDL command?
- Insert
- Update
- Drop
- Select
49) Which part of the following SQL is responsible for not returning the expected output? Select * from emp where comm = null order by ename;
- order by clause should appear before where clause
- where comm = null
- we cant use select * here
- No error
50) Why is denormalization beneficial to read operations?
- Indexes are sorted.
- Disk I/O is reduced.
- complex joins is avoided
- Easy Data flow
51) DML is provided for
- Description of logical structure of database
- Addition of new structures in the database system
- Manipulation & processing of database
- Definition of physical structure of database system