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
Correct Answer :
D. both B and C
Related Questions
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
A logical schema
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
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
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
Database
Data
Transaction
Record
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
Isolation of the transactions is ensured by
Transaction management
Application programmer
Concurrency control
Recovery management
The cost of reading and writing temporary files while evaluating a query can be reduced by
building indices
pipelining
join ordering
none of the above
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
The part of a database management system which ensures that the data remains in a consistent state is
authorization and integrity manager
buffer manager
transaction manager
file manager
_____ command can be used to modify a column in a table
alter
update
set
create
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
A top-to-bottom relationship among the items in a database is established by a
Hierarchical schema
Network schema
Relational Schema
All of the above
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
______ keyword is used to find the number of values in a column.
TOTAL
ADD
COUNT
SUM
The graphical representation of a query is .
B-Tree
graph
Query Tree
directed graph
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational