A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
Correct Answer :
D. Client
Related Questions
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
The data models defined by ANSI/SPARC architecture are
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
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
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
RAM
Flash
Hard Disk
Secondary
Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
____specifies a search condition for a group or an aggregate.
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
______contains information that defines valid values that are stored in a column or data type.
Default
Index
Rule
View
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
Clustered
Hashed
Un-clustered
Collision
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
As per equivalence rules for query transformation, selection operation distributes over
Union.
Set difference.
Intersection.
All of the above.
Which two files are used during operation of the DBMS?
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
_____is a full form of SQL.
Standard query language
Sequential query language
Structured query language
Server side query language
If the closure of an attribute set is the entire relation then the attribute set is a
superkey
candidate key
primary key
not a key
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
Sub
Parent
Candidate
Super
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 transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
Precedence graphs help to find a
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Data Manipulation
Data Definition
Data Control
None
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
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