Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
Correct Answer :
C. Attributes
Related Questions
The index table has …… Columns.
1
2
3
4
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
Triggers are also called
active rules
passive rules
inferences
none of the above
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
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)
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
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
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
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
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
none of the above