In the relational modes, cardinality is termed as:
In an E-R diagram attributes are represented by
The database environment has all of the following components except:
The language which has recently become the defacto standard for interfacing applicationprograms with relational database system is
A hash table can store a maximum of 10 records, currently there are records in location 1, 3,4,7,8,9,10. The probability of a new record going into location 2, with hash functions resolving collisions by linear probing is
The file organization that provides very fast access to any arbitrary record of a file is
What is the purpose of the index in sql server?
How many types of indexes are there in sql server?
How non clustered index point to the data?
Which of the following is true?
A B+ tree can contain a maximum of 7 pointers in a node. What is the minimum number of keys in leaves?
Relational calculus is a
The way a particular application views the data from the database that the applicationuses is a
The method in which records are physically stored in a specified order according to a keyfield in each record is
A technique for direct search is
The goal of hashing is to produce a search that takes
Cartesian product in relational algebra is
‘AS’ clause is used in SQL for
In a relational model, relations are termed as
The relational model feature is that there
Transaction processing is associated with everything below except
A _________ consists of a sequence of query and/or update statements.
Which of the following makes the transaction permanent in the database?
______ will undo all statements up to commit?
A table on the many side of a one to many or many to many relationship must:
