Q. Suppose user have Saving Account and Checking Account in the Bank. Saving Account Stores following information -

account-no
name
address
mobile

and Checking Account stores -

account-no
name
address
mobile

Which of the information is not redundant ?

View solution

Q. If in redundant file common fields are not matching then it results in _____________.

View solution

Q. Data Isolation caused due to ________ in traditional file system.

View solution

Q. If person A want to transfer fund of Rs.500 to person B. If failure occurs after removing Rs.500 from Account A and before transferring to Account B then problem caused is __________.

View solution

Q. Identify the advantages of Database management system ?

View solution

Q. If DBA modify the structure of the data record then this modification do not affect other application is called as _____________.

View solution

Q. Collection of information stored in database at particular instance of time is called as __________.

View solution

Q. Overall design of the database is called as _________.

View solution

Q. _________ is collection of operations that performs a single logical function in database application.

View solution

Q. Database Manager Performs following query related operation

View solution

Q. Duty of Database manager is to enforce integrity and _________ checks.

View solution

Q. Granting and Authorization for data access is provided by ____________.

View solution

Q. Database Manager is also known as ________.

View solution

Q. Which of the user write program in host language and embed the DML statements into it ?

View solution

Q. User which interact with the system using database query language is called as ___________.

View solution

Q. Farmer goes to ATM Center to withdraw an amount of Rs.300/-. Which type of user farmer is ?

View solution

Q. Schema Definition is written by __________.

View solution

Q. Person A is Java Developer interacts with Person D to understand the complete database schema
written by him.

Person B knows the database Schema and he is able to hit complex queries.

Unlike Person B, Person C does not use traditional database processing frameworks.

Who among the 4 user will be called as Sophisticated User.

View solution

Q. Structured data may include which of the following?

View solution

Q. Metadata enables database designers and users to do all of the following except:

View solution