WorksheetsDBMS
Total questions: 25
Worksheet time: 13mins
The Collection of information stored in database at a Particular moment is called _________
Instance
Language
Schema
Data Dictionary
A DBMS consists a collection of _________
Tables
Fields
Records
Keys
The term attribute refers to a _____ of a table.
Record
column
Key
Tuple
In relational model, the row of table is known to be a ______
Relation
Entity field
Tuple
Attribute
A table is a collection of relationships, there is a close correspondence between concept of _______
Table and variables
Tables and instances
Tables and Entries
Tables and relations.
DDL Statement is a set of tables that is stored in a special file called_________
Data Dictionary
Data Set
Data Library
Data isolation
Which Language is used to define the integrity constraints?
DDL
DCL
DML
SQL
A Language that enables users to access and manipulate data is __________
SQL
Data Language
Database Manipulation Language
DDL
DDL Stands for____________
Data Definition Language
Database Decision Language
Data Domain Language
Data Dictionary Language
DBMS provides _________ of data
Whole
Hidden
Part
Abstract
Number, char, varchar2 are examples for _________ types
Data
Field
Record
Attribute
An example for an Aggregate function is _______________
Minus
Join
Union
Sum
Query languages used in practice includes _______.
Elements
Instances
Tuples
Fields
Logical design of database, is known to be________
Database relation
Database instance
Database Schema
Database entity
__________ is a procedural language.
Relational algebra
Domain relational calculus
Tuple relational calculus
Query language
A statement that executed automatically by the system is called
Assertion
Trigger
Referential integrity
Integrity constraints
All aggregate functions except __________ ignore null values in their input collection.
Count (attribute)
Count(*)
Avg
Sum
Which of the following is used to define the schema of the database?
DDL
DCL
DML
DLL
In E-R diagram Rectangle represents __________
Attributes
Weak entity sets
derived attributes
entity set
In E-R Diagram ellipse represent ______________
Attributes
entity set
derived attibutes
weak entity set
Weaker Normal Form called ______ Normal Form
Secord
First
Third
Boyce Codd
NF stands for ___________________
Natural Form
Nutural Form
Null Form
Normal Form
PL/SQL Block Contains __________ section.
1
2
3
4
The _____ statement change at the flow of control within a PL/SQL block.
GoTo
If….Else
If Condition
For ... loop
Roll back of transition is normally used to___________.
Recover from the transaction failure
Update the transaction
Retrieve old records
Repeat a transition
