A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Correct Answer :
C. with
Related Questions
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Triggers are also called
active rules
passive rules
inferences
none of the above
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
The ability to modify the conceptual schema without causing any change to the application program is known as
Physical data independence
Logical data independence
External data independence
Static data
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key