MCQ-RDBMS

 MCQ-RDBMS:

What is relation in RDBMS?

Key b) Data type

c) Tables    c)Row

Does RDBMS have ACID properties?

Follows ACID properties b) Attribute

c) Doesn‟t follow ACID properties d) can‟t say

Which of the following commands do we use to delete a relation from a database?

Delete table RDBMS b) Drop table RDBMS

c) Drop relation RDBMS d) Delete from RDBMS

Which of the following systems use RDMS?

Oracle b) Microsoft SqlServer

c) IBM d) All of the mentioned

Which of the following constraints RDBS doesn’t check before creating the tables?

Not null b) Primary keys

c) Data Structure d) Data integrity

What is a relation in RDMS?

Key b) Table

c) Row d) Data types

The default extension for an oracle SQL*plus file is:

.txt b) .pls

c) .ora d) .sql

The variables in the triggers are declared using

- b) @

c) / d) /@

Drop table cannot be used to drop a table referenced by a constraint.

Local key b) Primary key

c) Composite key d) Foreign key

Which one of the following uniquely identifies the elements in the relation?

Secondary key b) Primary key

c) Foreign key d) Composite key

Which of the following systems use RDMS?

Oracle b) Microsoft SqlServer

c) IBM d) All of the mentioned

Which of the following constraints RDBS doesn’t check before creating the tables?

Not null b) Primary keys

c) Data Structure d) Data integrity

The most open source RDBMS is

MySQL b) Oracle

c) Microsoft Access d) Microsoft SQL Server

A relational database consists of a collection is

Keys b) Tables

c) Fields d) Records

ER model is used in

Applications b) Physical refinement

c) Schema refinement d) Conceptual database

Entity is a________.

Object of relation b) Present working model

c)Thing in real world c)Model of relation

The descriptive property possessed by each entity set is ________.

Entity b) Attribute

c) Relation d) Model

The function that an entity plays in a relationship is called that entity’s_______.

Participation b) Position

c) Role d) Instance

The attribute AGE is calculated from DATE_OF_BIRTH.The attribute  AGE is

Single valued b) Multi valued

c) Composite d) Derived

The subset of a super key is a candidate key under what condition?

No Proper subset is a super key b) All subsets are super keys

c) Subset is a super key d) Each subset is a super key.

Which of the following systems use RDMS?

Oracle b) Microsoft SqlServer

c) IBM d) All of the mentioned

Which of the following constraints RDBS doesn’t check before creating the tables?

Not null b) Primary keys

c) Data Structure d) Data integrity

The most open source RDBMS is

MySQL b) Oracle

c) Microsoft Access d) Microsoft SQL Server

A relational database consists of a collection is

Keys b) Tables

c) Fields d) Records

ER model is used in

Applications b) Physical refinement

c) Schema refinement d) Conceptual database

6. Entity is a________.

Object of relation b) Present working model

c)Thing in real world c)Model of relation

The descriptive property possessed by each entity set is ________.

Entity b) Attribute

c) Relation d) Model

The function that an entity plays in a relationship is called that entity’s_______.

Participation b) Position

c) Role d) Instance

The attribute AGE is calculated from DATE_OF_BIRTH.The attribute  AGE is

Single valued b) Multi valued

c) Composite d) Derived

The subset of a super key is a candidate key under what condition?

No Proper subset is a super key b) All subsets are super keys

c) Subset is a super key d) Each subset is a super key