A _____ is used to define overall design of the database
code
data definition language
application program
schema
Correct Answer :
D. schema
Related Questions
Union operator is a :
Unary Operator
Ternary Operator
Binary Operator
Not an operator
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
View
Order by
Group by
Having
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
____ table store information about database or about the system.
SQL
System
Nested
None of these
Which of the following statement on the view concept in SQL is invalid?
All views are not updateable
The views may be referenced in an SQL statement whenever tables are referenced.
The views are instantiated at the time they are referenced and not when they are defined.
The definition of a view should not have GROUP BY clause in it.
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
Data items grouped together for storage purposes are called a
record
string
title
list
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
Volatile
Non - Volatile
Logical
Physical
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
Fields
Records
Relations
Keys
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
The data in the database at a particular moment of time is called the _______
Snapshot
Dynaset
Stateless
Stateful
The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software
The graphical representation of a query is .
B-Tree
graph
Query Tree
directed graph
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
ii) insert into
i-only
ii-only
Both of them
None of them
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.
Regular
Irregular
None
Weak
Which of the following ensures the atomicity of the transaction?
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS