DBMS Quiz 2019

DBMS Quiz 2019

a) A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
b) A ________ in a table represents a relationship among a set of values.
a) Column
b) Key
c) Row
d) Entry
c) The term attribute refers to a ___________ of a table.
a) Record
b) Column
c) Tuple
d) Key
d) Course(course_id, sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________
a) Relations, Attribute
b) Attributes, Relation
c) Tuple, Relation
d) Tuple, Attributes
e) 1. In the __________ normal form, a composite attribute is converted to individual attributes.
a) First
b) Second
c) Third
d) Fourth
f) SQL can be used to:
a) Create database structures only
b) Query database data only
c) Modify database data only
d) All of the mentioned
g)  Using which language can a user request information from a database ?
a) Query
b) Relational
c) Structural
d) Compiler
h) The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
a) Select
b) Join
c) Union
d) Intersection
i) The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
a) Join
b) Projection
c) Select
d) Union
j) Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
k) To remove a relation from an SQL database, we use the ______ command.
a) Delete
b) Purge
c) Remove
d) Drop table
l) Which of the following makes the transaction permanent in the database ?
a) View
b) Commit
c) Rollback
d) Flashback
m) In order to maintain the consistency during transactions database provides
a) Commit
b) Atomic
c) Flashback
d) Retain
n) A transaction completes its execution is said to be
a) Committed
b) Aborted
c) Rolled back
d) Failed
o) The default extension for an Oracle SQL*Plus file is:
a) .txt
b) .pls
c) .ora
d) .sql
p) What type of join is needed when you wish to include rows that do not have matching values?
a) Equi-join
b) Natural join
c) Outer join
d) All of the mentioned
q)  Which forms are based on the concept of functional dependency:
a) 1NF
b) 2NF
c) 3NF
d) 4NF
r) The entity set person is classified as student and employee. This process is called _________
a) Generalization
b) Specialization
c) Inheritance
d) Constraint generalization
s) Functional Dependencies are the types of constraints that are based on______
a) Key
b) Key revisited
c) Superset key
d) None of the mentioned
t) A deadlock exists in the system if and only if the wait-for graph contains a ___________
a) Cycle
b) Direction
c) Bi-direction
d) Rotation
U)Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema

V)Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema

W) To remove a relation from an SQL database, we use the ______ command.

a) Delete
b) Purge
c) Remove
d) Drop table

X) Updates that violate __________ are disallowed.

a) Integrity constraints
b) Transaction control
c) Authorization
d) DDL constraints

Y) The user defined data type can be created using

a) Create datatype
b) Create data
c) Create definetype
d) Create type

Z) In the __________ normal form, a composite attribute is converted to individual attributes.

a) First
b) Second
c) Third
d) Fourth