Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
Correct Answer :
B. nonprocedural query language
Related Questions
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
Triggers are also called
active rules
passive rules
inferences
none of the above
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
The raw facts and figures are:
Data
Data field
DBMS
DBASE
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
The index table has …… Columns.
1
2
3
4
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
An entity set that does not have sufficient attributes to form a primary key is a
strong entity set.
weak entity set.
simple entity set.
primary entity set.
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
Which of the following is true statement ?
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Noisy channel has ……… .. types of protocols
two
three
four
none
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse