1. In the relational modes, cardinality is termed
as : Number of tuples.
2. Relational calculus is a : Non- Procedural language.
3. The view of total database content is : Conceptual view.
4. Cartesian product in relational algebra is-a Binary operator.(It requires two
operands)
5. DML is provided for -manipulation & processing of database.
6. Data stored in the database is processed or
manipulated using data
manipulation language commands as its name
7. ‘AS’ clause is used in SQL for-Rename operation.
8. ODBC stands for-Open Database Connectivity.
9. Architecture of the database can be viewed as-three levels.
10. In a relational model, relations are termed as-Tables.
11. The database schema is written in-DDL
12. In the architecture of a database system
external level is the-view
level.
13. An entity set that does not have sufficient
attributes to form primary key is -weak entity set
14. In a Hierarchical model records are organized
as-Tree.
15. In tuple relational calculus
P1 _ P2 is equivalent to ¬P1 Ú P2. (The logical implication expression
A _ B, meaning if A then B,is equivalent to ¬A Ú B)
16. The language used in application programs to
request data from the DBMS is referred to as the-DML
17. A logical schema-is the entire database.
18. Related data fields in database are grouped to
form :data record(Record is collection of related fields)
19. The database environment has all of the
following components except: Users
20. The language which has recently become the
defacto standard for interfacing application programs with relational database
system is- 4GL
21. The way a particular application views the data
from the database that the application uses is a-sub schema.
22. The DBMS language component which can be
embedded in a program is-DML
23. The relational model feature is that
there-is much more data
independence than some other database models.
24. Conceptual design-involves modelling independent
of the DBMS.
25. A method in which records are physically stored
in a specified order according to a key field in each record is -hash.(In hash method, a hash function is performed on the key value to
determine the unique physical address of the record to store or retrieve)
26. A subschema expresses-the external view.
27.
Data
elements in the database can be
modified by changing the data dictionary
28. An advantage of the database management approach
is-data is integrated
and can be accessed by multiple programs.
29. Transaction processing is associated
with everything below except-confirming an
action or triggering a response.
30. SET concept is used in :- Network Model
31. Relational Algebra is-Procedural query Language
32. Cartesian product-produces the relation that has attributes of R1
and R2
33. The file organization that provides very fast
access to any arbitrary record of a file is Hashed File
34. Which of the following is correct:
A. a SQL query automatically eliminates duplicates.
B.
SQL
permits attribute names to be repeated in the same relation.
C. a SQL query will not work if there are no
indexes on the relations
D. None of these Ans-D
