The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
Correct Answer :
A. users.
Related Questions
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
Which of the following statements is not true about two tier client server database architecture?
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion