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.
Correct Answer :
D. all of the above.
Related Questions
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
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
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
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.
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
View never contains derived columns.
True
False
Cant say
none
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
Event condition action model is related to
Views
Cursors
Triggers
None of these.
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
The raw facts and figures are:
Data
Data field
DBMS
DBASE
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.
Object based data models are used in describing the abstraction of the following levels?
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.