Tuesday, 15 April 2014

Important Questions For Database Management System

Important Questions For Database Management System

Q1-In the relational modes, cardinality is termed as:- Number of tuples.

Q2-Relational calculus is a-Non- Procedural language.

Q3-The view of total database content is-Conceptual view.

Q4-Cartesian product in relational algebra is-a Binary operator. Cartesian product in relational algebra is a binary operator.(It requires two operands. e.g., P X Q)

Q5-DML is provided for -manipulation & processing of database.

(Data stored in the database is processed or manipulated using data manipulation

language commands as its name)

Q6-‘AS’ clause is used in SQL for-Rename operation.

Q7-ODBC stands for-Open Database Connectivity.

Q8-Architecture of the database can be viewed as-three levels.

Q9-In a relational model, relations are termed as-Tables.

Q10-The database schema is written in-DDL

Q11-In the architecture of a database system external level is the-view level.

Q12-An entity set that does not have sufficient attributes to form a primary key is a-weak entity set.

Q13-In a Hierarchical model records are organized as-Tree.

Q14-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)

Q15-The language used in application programs to request data from the DBMS is referred to as the-DML

Q16-A logical schema-is the entire database.

Q17-Related data fields in a database are grouped to form a -data record.

(A record is a collection of related fields)

Q18-The database environment has all of the following components except:

(A) users. (B) separate files.

(C) database. (D) database administrator.                   Ans-A

Q19-The language which has recently become the defacto standard for interfacing application programs with relational database system is- 4GL

Q20-The way a particular application views the data from the database that the application uses is a-sub schema.

Q21-The DBMS language component which can be embedded in a program is-DML

Q22-The relational model feature is that there-is much more data independence than some other database models.

Q23-Conceptual design-involves modelling independent of the DBMS.

Q24-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)

Q25-A subschema expresses-the external view.

Q23-Which one of the following statements is false?

(A) The data dictionary is normally maintained by the database administrator.

(B) Data elements in the database can be modified by changing the data dictionary.

(C) The data dictionary contains the name and description of each data element.

(D) The data dictionary is a tool used exclusively by the database administrator.Ans-B

Q24-An advantage of the database management approach is-data is integrated and can be accessed by multiple programs.

Q25-Transaction processing is associated with everything below except-confirming an action or triggering a response.

Q26-SET concept is used in :- Network Model

Q27-Relational Algebra is-Procedural query Language

Q28-Cartesian product-produces the relation that has attributes of R1 and R2

Q29-The file organization that provides very fast access to any arbitrary record of a file is-Hashed file

Q30-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



Post a Comment