NEW
Font size
WorksheetsDATABASE DESIGN MANAGEMENT SYSTEMS
Total questions: 25
Worksheet time: 13mins
The data model which describes how the data is actually stored is
internal model
external model
logical model
none of these
Data about data is normally termed as
directory
data bank
meta data
none of the above
A view of database that appears to an application program is known as
schema
subschema
virtual table
none of the above
Collection of information stored in a database at a particular moment is
view
schema
instance
none of the above
DBA stands for
Data Bank Access
Database Access
Data Bank Administration
Database Administrator
Data items grouped together for storage purposes are called a :
Record
title
list
string
A function that has no partial functional dependencies is in _______ form
3NF
2NF
4NF
BCNF
Every Boyee-Codd normal form is in
1NF
2Nf
3NF
all the above
If every non-key attribute is functionally dependent on the primary key, then the relation will be in :
1NF
2NF
3NF
4NF
Which command is used to remove all rows from a table ?
Delete
Remove
Truncate
Both [A] and [B]
What is the language used by most of the DBMS for helping their users to access data ?
High level language
Query language
SQL
4GL
This is an authorization command of SQL
Access
Grant
Allow
None of these
What is returned by SUBSTR(‘TUTORIALS POINT’, 1, 9)
TUTORIAL
POINT
TUTORIALS
UTORIALS
Count function in SQL returns the number of
Values
Distinct values
Groups
Columns
The statement in SQL which allows to change the definition of a table is
Alter
Update
Create
Select
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
Number, char, varchar2 are examples for _________ types
Data
Field
Record
Attribute
