Explore topic-wise InterviewSolutions in Current Affairs.

(b)  Logical

Correct answer is (b) hybrid model 

Logical level.

(d) Tuple. 

The other three terminologies indicate the same characteristic of a table.

1. View level 

2. Logical level, Physical level

Logical level

He is at Logical level of database abstraction

(a) number of tuples

(b) Hybrid model

Correct answer is (c) Key field

Correct answer is (a) Table

He is at View level of Database abstraction.

The result of Query can be displayed by clicking on Run Button

d) Data Base Management Software

Correct answer is (b) enthusiastic

A data base consists of a number of that fields contains the individual pieces of data.

SQL stands for Structural Query Language

Correct answer is (c) Memo

The characteristics of an entity is Attributes

(b) Starts with RAJU

Database/ Data source – Introduction A database is a collection of related data. It is organised in such a way that its contents can easily be accessed, managed and updated. In LibreOffice, database is also called data source. 

Database consists of interrelated data tables that are structured in a manner that ensuresdata consistency and integrity. LibreOffice base, MS Access, Oracle, SQL server, etc. Are the commonly used softwares for data base management.

DBMS is an aggregate of data, hardware, software and Users

(a) Alpha numeric

LIKe ‘A*’ used to get return a text starts with ‘A’

Anything which has a real life existence is called Entities

Form view, Layout view and Design view

A Table is a two dimensional array containing rows and columns

• Data 
• Hardware 
• Software 
• Users

Correct answer is (c) children

The new P.T. Instructor was very enthusiastic about sports and drove the children . hard – praising them, scolding and correcting them. But most of time, he encourages and advises them a lot.

Correct answer is (a) activity

These are links between tables.

It is the graphical representation of relationship between tables.

Query: 

Query is a question. Queries are used to view, change and analyse data in different ways. It creates a new table from the existing tables based upon the question/ request asked to the data base.

Yes. Other two models are complex. In RDMS, no redundancy and relationships can be formed easily.

There are 22 in relation instance with cardinality.

Answer 1

No. It is not allowed because a good DBMS does not allow duplication of the same data. i.e. data redundancy is not allowed.

Answer 2.

Yes. Same values of data is allowed if primary key or unique key is not defined in the relation.

(a) number of tuples

Account number can be set as primary key since account number is different. different customers. That is it is unique hence it can be set as primary key.

(a) σTotal>90(Student)

(b) π_Regno,Name (Student)

a. He heard the girls talking about a fast runner in Springfields school and they call her as P.T. Usha.

b. Shabnam informed this message to the other girls.

1. Rucha to

2. Vishnu to Rucha

3. Rucha’s niother to Rucha

4. Rucha’s friends to Rucha

5. Aruna to Rucha

6. Rucha to Aruna

7. PT. Instructor to Rucha

8. Shabnam to her friends

9. P.T. Instructor to Rucha

10. P.T. Instructor to the girls team

Rucha was overprotective of herself. She never did things rashly. She would be conscious of her movements, even in running and playing. Her friends used to console her and motivate her, whenever she failed in her attempts. She had hesitations, self-doubts and denials in whatever task was done by her. Her RT instructor Mr. Prakash observed these negative qualities in her and advised her to have only positive attitude towards everything. He asked her to believe in herself and don’t ever think of losing, think to win. In the relay race, she put aside all her fears and self doubts about her ability. She just remembered her P.T. Sir’s words and ran fast to the finishing line. She won the race and everyone was excited about this attempt of Rucha. She made it because she overcame her self-doubts.

Your shyness and fear can be overcome by being confident always, trying new things, engaging yourself in talks with others, giving speeches or presentations often, walking with your head high and be aware of what is happening around you.

a. She was ten years old.

b. Vishnu was teaching Rucha to ride a bicycle.

c. He had been teaching her, for the past two weeks.

(D) Tom plays hockey as well as cricket

2, 5, 1, 3, 4 

2. Rucha lost the game by a couple of points. 

5. Their house stood second in the overall tally. 

1. “I can’t seem to win, ” said Rucha remorsefully. 

3. ‘You played all right, ’ Arana consoled her. 

4. ‘The time when your opponent was at the net, if you had hit just a little harder over her head, you could have won that point’.

2, 4, 5, 3, 1

2. She stormed into the house to complain. 

4. ‘You fell. Doesn’t matter, ” said her mother calmly. 

5. We all do, when we are learning to ride a cycle. 

3. At least you are not hurt. 

1. ‘The bicycle is too big for me’ Rucha complained.

3, 4, 1, 5, 2

3. The bicycle wobbled as ten year old Rucha leaned forward in the seat and pumped the pedals. 

4. ‘Hold tight, Vishnu, I will fall!’ she shouted to the boy, who ran behind, steadying the bicycle. 

1. For the past two weeks, he had been teaching her to ride. 

5. ‘Don’t worry Ruchaji, you are doing well’ he puffed. 

2. or a few moments he let go of his hold and Rucha was on her own.

2, 4, 5, 1, 3 

2. The next few days, he saw the girls training extra hard. 

4. Prakash Sir was never far, even as he trained other children. 

5. The day of the sport meet dawned and the children piled into buses to reach the venue. 

1. There was laughter and a great deal of joviality as Prakash Sir had seen to it that they were fit and relaxed as well. 

3. The stadium, where the meet was being held, bustled with great activity.