DBMS exam quiz with answer

This iDBMS exam quiz with answer. You can give online exam without any charges and test as well as improve your knowledge. Simply start, finish for see result and share on social media #OnlineQuiz #OnlineMCQ #MCQ #OnlineMCQExam

You can do Practice all DBMS online mcq before start quiz. View complete Online MCQ Practice Set Link.

Try now DBMS exam quiz with answer

DBMS

1 / 20

Q: Because it contains a description of its own structure, a database is considered to be....

1. described

2. metadata compatible

3. self-describing

4. an application program

2 / 20

Q: When using the SQL INSERT statement:

1. rows can be modified according to criteria only

2. rows cannot be copied in mass from one table to another only

3. rows can be inserted into a table only one at a time only

4. rows can either be inserted into a table one at a time or in groups

3 / 20

Q: Which of the following is an ordered collection of elements of the same type?

1. Set

2. Bag

3. List

4. Dictionary

4 / 20

Q: One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.

1. True

2. False

5 / 20

Q: In a database, data is stored in spreadsheets which have rows and columns.

1. True

2. False

6 / 20

Q: The benefits of object-oriented modeling are which of the following?

1. The ability to tackle more challenging problems

2. Reusability of analysis, design, and programming results

3. Improved communication between users, analysts, etc

4. All of the above

7 / 20

Q: The term Complete for a UML has the same meaning as which of the following for an EER diagram?

1. Overlapping rule

2. Disjoint rule

3. Total specialization rule

4. Partial specialization rule

8 / 20

Q: Composition is a stronger form of which of the following?

1. Aggregation

2. Encapsulation

3. Inheritance

4. All of the above

9 / 20

Q: The object definition language (ODL) is which of the following?

1. Used to develop logical schemas

2. A data definition language for OODB

3. A method to implement a logical schema

4. All of the above

10 / 20

Q: The SQL ALTER statement can be used to:

1. change the table structure

2. change the table data

3. add rows to the table

4. delete rows from the table

11 / 20

Q: The SQL statement to create a view is:

1. CREATE VIEW

2. MAKE VIEW

3. SELECT VIEW

4. INSERT VIEW

12 / 20

Q: The primary key is selected from the:

1. [A]. composite keys

2. [B]. determinants

3. [C]. candidate keys

4. [D]. foreign keys

13 / 20

Q: The DBMS acts as an interface between what two components of an enterprise-class database system?

1. Database application and the database

2. Data and the database

3. The user and the database application

4. Database application and SQL

14 / 20

Q: Which of the following is a single valued attribute

1. Register_number

2. Address

3. SUBJECT_TAKEN

4. Reference

15 / 20

Q: "For each attribute of a relation, there is a set of permitted values, called the...of that attribute."

1. Domain

2. Relation

3. Set

4. Schema

16 / 20

Q: The command to remove rows from a table 'CUSTOMER' is:

1. REMOVE FROM CUSTOMER

2. DROP FROM CUSTOMER

3. DELETE FROM CUSTOMER WHERE

4. UPDATE FROM CUSTOMER

17 / 20

Q: Which of the following are the five built-in functions provided by SQL?

1. "COUNT, SUM, AVG, MAX, MIN"

2. "SUM, AVG, MIN, MAX, MULT"

3. "SUM, AVG, MULT, DIV, MIN"

4. "SUM, AVG, MIN, MAX, NAME"

18 / 20

Q: Transaction . ensures that the transaction are being executed successfully.

1. concurrency

2. consistency

3. serialisability

4. non serialiasability

19 / 20

Q: An integral part of database that can restore database to consistent state of before failure is called

1. Recovery scheme

2. Backup scheme

3. Restoring scheme

4. Transaction scheme

20 / 20

Q: "Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?"

1. Data Definition Language(DDL)

2. Data Manipulation Language(DML)

3. Both of above

4. None

Insert details

Insert correct name and email for result and review correct answer. We never spam or sale your data.

Your score is

FAQ DBMS exam quiz

Q1: Is this free online quiz for DBMS?

Answer: Yes! you can test your skills and its 100% free to give test from DBMS subjects. You can study from question bank on home pages and search from entire question bank.

Q2: How many question in this online quiz for DBMS multiple choice question?

Answer: There are 20s multiple choice question from question bank of DBMS. Every time question will swap from online question bank. So you can test your knowledge and check percentages of correct/incorrect along-with answers.

Q3: How do I take the MCQ test online of DBMS?

Answer: Simply go in DBMS online quiz, click on Start button and choose correct answer one-by-one. After final the quiz, you have to insert Name and valid email id for result and view correct/incorrect answers. We never spam our visitor/customer, so you can trust and insert your valid email.

DBMS exam quiz with answer

Try now DBMS exam quiz with answer

Insert details

FAQ DBMS exam quiz

Submit a Comment Cancel reply

Latest MCQs

Archives

Categories