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)
Correct Answer :
D. i) ii) iii) iv)
Related Questions
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.
which of the following is a binary operation?
project
select
rename
none of the above
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
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
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
Primary storage
magnetic disk
magnetic tape
juke box
cache
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
Event condition action model is related to
Views
Cursors
Triggers
None of these.
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
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
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
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
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
Authorization command in SQL
Allow
Access
Grant
none of the above
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.
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
Data stored in cursor is called ……………
record
active data set
object
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
The raw facts and figures are:
Data
Data field
DBMS
DBASE
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse