Job Search

Q.1 In the relational modes, cardinality is termed as:
(A) Number of tuples. (B) Number of attributes.
(C) Number of tables. (D) Number of constraints.
Ans: A

Q.2 Relational calculus is a
(A) Procedural language. (B) Non- Procedural language.
(C) Data definition language. (D) High level language.
Ans: B

Q.3 The view of total database content is
(A) Conceptual view. (B) Internal view.
(C) External view. (D) Physical View.
Ans: A

Q.4 Cartesian product in relational algebra is
(A) a Unary operator. (B) a Binary operator.
(C) a Ternary operator. (D) not defined.
Ans: B Cartesian product in relational algebra is a binary operator.
(It requires two operands. e.g., P X Q)

Q.5 DML is provided for
(A) Description of logical structure of database.
(B) Addition of new structures in the database system.
(C) Manipulation & processing of database.
(D) Definition of physical structure of database system.
Ans: C 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)
DC10 DATABASE MANAGEMENT SYSTEMS
2

Q.6 ‘AS’ clause is used in SQL for
(A) Selection operation. (B) Rename operation.
(C) Join operation. (D) Projection operation.
Ans: B ‘AS’ clause is used in SQL for rename operation.
(e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

Q.7 ODBC stands for
(A) Object Database Connectivity.
(B) Oral Database Connectivity.
(C) Oracle Database Connectivity.
(D) Open Database Connectivity.

Ans: D

Q.8 Architecture of the database can be viewed as
(A) two levels. (B) four levels.
(C) three levels. (D) one level.
Ans: C

Q.9 In a relational model, relations are termed as
(A) Tuples. (B) Attributes
(C) Tables. (D) Rows.
Ans:

Q.10 The database schema is written in
(A) HLL (B) DML
(C) DDL (D) DCL
Ans: C

Q.11 In the architecture of a database system external level is the
(A) physical level. (B) logical level.
(C) conceptual level (D) view level.
Ans: D

Q.12 An entity set that does not have sufficient attributes to form a primary key is a
(A) strong entity set. (B) weak entity set.
(C) simple entity set. (D) primary entity set.
Ans: B

Q.13 In a Hierarchical model records are organized as
(A) Graph. (B) List.
(C) Links. (D) Tree.
DC10 DATABASE MANAGEMENT SYSTEMS
3

Ans: D

Q.14 In an E-R diagram attributes are represented by
(A) rectangle. (B) square.
(C) ellipse. (D) triangle.
Ans: C

Q.15 In case of entity integrity, the primary key may be
(A) not Null (B) Null
(C) both Null & not Null. (D) any value.

Ans: A

Q.16 In tuple relational calculus P1 → P2
is equivalent to
(A) ¬P1 ∨ P2
(B) P1 ∨ P2
(C) P1 ∧ P2
(D) P1 ∧ ¬P2
Ans: A 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)

Q.17 The language used in application programs to request data from the DBMS is referred
to as the
(A) DML (B) DDL
(C) VDL (D) SDL
Ans: A

Q.18 A logical schema
(A) is the entire database.
(B) is a standard way of organizing information into accessible parts.
(C) describes how data is actually stored on disk.
(D) both (A) and (C)
Ans: A

Q.19 Related fields in a database are grouped to form a
(A) data file. (B) data record.
(C) menu. (D) bank.
Ans: B Related data fields in a database are grouped to form a data record.
(A record is a collection of related fields)

Q.20 The database environment has all of the following components except:
(A) users. (B) separate files.
(C) database. (D) database administrator.
Ans: B

Note: Tomorrow I am going to share 200 DBMS and 200 Networking most important questions in my facebook group. So if you guys want to view those questions please join this group::

https://www.facebook.com/groups/1030527110304071

Regards,

Sachin.

Directions for questions 1 to 40: Select the correct alternative from the given choices.

Note: use rectangle sign to match your correct answer.

Question:1

Who among the following recently won the Cincinnati Masters title of tennis in the men's single category?

Options:

1.	Daniel Nestor
2.	Roger Federer
3.	Rafael Nadal
4.	Andre Agassi
5.	Pete Sampras

Question:2

Which of the following states was in news recently to be the first state in India to launch an 'Agro-Solar Policy' to encourage the farmers to tap the solar energy?

Options:

1.	Gujarat
2.	Karnataka
3.	Tamil Nadu
4.	Kerala
5.	Telangana

Question:3

Bandhan Bank has become the first micro-finance company in India to start operation as full-fledged scheduled commercial bank. In which of the following states does it have its largest presence?

Options:

1.	Kerala
2.	Karnataka
3.	Madhya Pradesh
4.	West Bengal
5.	Chattisgarh

Question:4

Who among the following has won the world 100 metre title in the World Athletics Championships held in Beijing, China?

Options:

1.	Usain Bolt
2.	Allyson Felix
3.	Mo Farah
4.	Asafa Powell
5.	Tyson Gay

Question:5

To which of the following countries does Zaina Erhaim, who recently won the prestigious 2015 Peter Mackler Award, belong to?

Options:

1.	Iraq
2.	Iran
3.	Syria
4.	Lebanon
5.	Palestine

Question:6

Who among the following is the head of the High powered committee on Urban Cooperative Banks which recently submitted its report?

Options:

1.	S S Mundra
2.	Urjit R Patel
3.	Nachiket Mor
4.	R Gandhi
5.	Y H Malegam

Question:7

The A P Shah committee has recommended that Minimum Alternate Tax (MAT) should not be imposed on FII's retrospectively. Who among the following has appointed this committee?

Options:

1.	RBI
2.	Ministry of Commerce and Industry
3.	Ministry of Corporate Affairs
4.	Ministry of Finance
5.	Ministry of Skill Development and Entrepreneurship

Question:8

Which of the following has won the 2014 Maulana Abdul Kalam Azad (MAKA) trophy?

Options:

1.	Benaras Hindu University
2.	Punjabi University
3.	Guru Nank Dev University
4.	JNTU Hyderabad
5.	Osmania University

Question:9

Which of the following committee’s recommendations lead to the formation of the High Powered Committee on Urban Cooperative Banks?

Options:

1.	BD Thakar Committee
2.	Malegam Committee
3.	Bhave Committee
4.	Damle Committee
5.	Gadgil Committee

Question:10

Who among the following recently won the prestigious Ladies British Amateur Stroke-play Championship 2015 at Leeds?

Options:

1.	Saaniya
2.	Amandeep
3.	Aditi Ashok
4.	Vani Kapoor
5.	None of these

Question:11

On which of the following dates is the National Sports Day observed annually?

Options:

1.	29th July
2.	24th August
3.	9th August
4.	29th August
5.	4th September

Question:12

Which among the following state’s high court was in news recently for staying the implementation of the compulsory voting in the panchayat and municipal polls?

Options:

1.	Himachal Pradesh
2.	Maharashtra
3.	Gujarat
4.	Haryana
5.	Rajasthan

Question:13

Changalikodan banana variety from Thrissur district of Kerala has been accorded Geographical Indication (GI) status by the Chennai based Central GI registry. Which among the following is NOT a GI tagged product of Kerala?

Options:

1.	Pokkali Rice
2.	Alleppey Coir
3.	Navara Rice
4.	Vazhakulam pineapple
5.	Hadagali Jasmine

Question:14

Who among the following was recently sworn in as the PM of Srilanka?

Options:

1.	Ranil Wickremesinghe
2.	Maithripala Sirisena
3.	N M Perera
4.	Mahinda Rajapaksa
5.	Sirimavo Bandaranaike

Question:15

Who among the following is the Greek Prime Minister who has announced his resignation in a televised address to the debt ridden nation?

Options:

1.	Antonis Samaras
2.	Alexis Tsipras
3.	Lucas Papademos
4.	George A. Papandreou
5.	None of these

Question:16

59 Entities are barred from trading in Bombay Stock Exchange due to alleged manipulation of the stock exchange route for evading taxes. Who among the following can issue such an order?

Options:

1.	SEBI
2.	RBI
3.	IRDA
4.	PFRDA
5.	Ministry of Finance

Question:17

With which of the following did YouTube partnership to set up 'YouTube Space' in Mumbai?

Options:

1.	National School of Design
2.	Film and Telivision Institute of India
3.	Whistling Woods International
4.	Flash Frame Visuals Academy of Film and Telivision
5.	None of these

Question:18

Which among the following states was in news for reaching an agreement with the Joint Committee on the Inner Line Permit System (JCILPS) over the issue of implementation of Inner Line Permit (ILP) system?

Options:

1.	Arunachal Pradesh
2.	Nagaland
3.	Mizoram
4.	Manipur
5.	Assam

Question:19

With which of the following countries did Pakistan recently ink a deal to acquire 4 advance Mi-35 'Hind E' combat helicopters?

Options:

1.	China
2.	USA
3.	Canada
4.	Russia
5.	Germany

Question:20

Which of the following is the web portal launched by the Government for the students seeking educational loans?

Options:

1.	www.studentfund.co.in
2.	www.vidyalakshmi.co.in
3.	www.vidhyardhikusal.co.in
4.	www.myfund.gov.in
5.	None of these

Question:21

Which among the following airports has become the first airport in the world to fully operate on solar power?

Options:

1.	Cochin
2.	Bangalore
3.	Ahmedabad
4.	Chennai
5.	Goa

Question:22

Which among the following became the first country in the world to receive funds from United Nations for its fast growing Solar Home Systems?

Options:

1.	Bhutan
2.	Srilanka
3.	Bangladesh
4.	India
5.	Pakistan

Question:23

Which of the following states recently launched the RISHTA project, which is an efficient smart LED based street lighting project?

Options:

1.	Himachal Pradesh
2.	Haryana
3.	Sikkim
4.	Punjab
5.	Meghalaya

Question:24

Who among the following is the new CMD of Air India limited?

Options:

1.	Rohit Nandan
2.	Ashwani Lohani
3.	Arun Bhatia
4.	Uma Shankar
5.	Poonam Malakondaiah

Question:25

With which of the following countries did India sign a pact to curb black money?

Options:

1.	Bangladesh
2.	Pakistan
3.	Burma
4.	Seychelles
5.	None of these

Question:26

Which among the following Indian companies was NOT named among the world's 100 most innovative companies by Forbes?

Options:

1.	Tata Consultancy Services
2.	Hindustan Unilever
3.	Sun Pharma Industries
4.	Reliance Industries
5.	None of these

\Question:27

Which among the following is the date set to introduce Bharat Stage IV compliant four wheeler vehicles through out the country?

Options:

1.	1 April 2017
2.	1 April 2018
3.	1 April 2019
4.	1 April 2020
5.	1 April 2021

Question:28

Who among the following was recently conferred with the Maharashtra Bhushan Award 2015?

Options:

1.	Bhimsen Joshi
2.	Purushottam Laxman Deshpande
3.	Babasaheb Purandare
4.	Ratan Tata
5.	Sachin Tendulkar

Question:29

Who among the following has won the James Tait Black Award 2015, UK's oldest literary prize?

Options:

1.	Padgett Powell
2.	Alan Warner
3.	Jim Crace
4.	Zia Haider Rahman
5.	Sebastian Barry

Question:30

In which of the following countries did the NATO's airborne drills, dubbed as 'Swift Response 15', take place?

Options:

1.	Germany
2.	Turkey
3.	Italy
4.	Poland
5.	Greece

Question:31

Which of the following countries has recently won its maiden Under-16 South Asian Football Federation (SAFF) championship title 2015?

Options:

1.	India
2.	Paksitan
3.	Bangladesh
4.	Srilanka
5.	Afghanistan

Question:32

Which of the following cities will soon be conferred with the title of 'Twin National Heritage Cities' by the Union Tourism Ministry?

Options:

1.	Rishikesh and Haridwar
2.	Varanasi and Gaya
3.	Tirupati and Srisailam
4.	Madurai and Kanchi
5.	None of these

Question:33

Who among the following is the new president of International Association of Athletics Federations (IAAF) ?

Options:

1.	Primo Nebiolo
2.	Lamine Diack
3.	Sebastian Coe
4.	Lord Burghley
5.	Adriaan Paulen

Question:34

Union Government has constituted a three member panel to assess the situation over the student protests in Film and Television Institute of India (FTII). FTII is located at _______.

Options:

1.	Mumbai
2.	Pune
3.	Delhi
4.	Kolkata
5.	Bangalore

Question:35

Reserve Bank of India has granted ‘in-principle’ approval to 11 applicants to start payments banks. Which among the following is NOT one of them?

Options:

1.	Reliance Industries
2.	Tech Mahindra
3.	Paytm
4.	Sun Pharma
5.	Tata Finance

Question:36

Lenovo has partnered with the electronics contract manufacturer Flextronics to start manufacturing at its facility in Sriperumbudur. Lenovo is headquarted in ______.

Options:

1.	South Korea
2.	China
3.	Germany
4.	Japan
5.	UK

Question:37

Union Government has completed the demarcation of eco-sensitive zone (ESZ) around the Okhla Bird Sanctuary. In which of the following cities is the Bird sanctuary located?

Options:

1.	Bangalore
2.	Mangalore
3.	Delhi
4.	Mumbai
5.	Kolkata

Question:38

Which among the following has emerged as the most attractive travel hotspot in the world according to the Ultimate Travelist of Lonely Planet?

Options:

1.	The Temples of Angkor
2.	The Great Barrier Reef
3.	Inca City of Machu Picchu
4.	Great Wall of China
5.	Taj Mahal

Question:39

Which of the following has instituted the new system of Suspicious Transaction Reports(STRs) for reporting suspicious trades in order to check money laundering through stock markets?

Options:

1.	Bombay Stock Exchange
2.	National Stock Exchange
3.	SEBI
4.	Vadodara Stock Exchange
5.	None of these

Question:40

Who among the following have been recommended for the Prestigious Dhyan Chand Award 2015?

Options:

1.	TPP Nair
2.	Romeo James
3.	SP Misra
4.	All of the above
5.	None of these

Job Search

Company Name: Ericsson

Job Category: Graduate Engineers

Part Time Jobs for Students/Graduates/Anyone interested in making some Extra Cash

Some important DBMS questions.

Download IBPS RRB 250 current affairs questions PDF