30 Basic Easy DBMS aptitude Questions 2019/20

We have added New DBMS Questions so check em out

Here are some great latest 2019 DBMS basic easy questions which will help u greatly in the interviews ahead so boys and girls say thanks to MNCPLACEMENT blog and remember you can get these updates before anyone else.

JUST DROP ur EMAIL ADDRESS IN THE TOP LEFT CORNER for daily updates

Great NEW DBMS QUESTIONS LINK 
2019 DBMS QUESTIONS LINK 1

2019 DBMS QUESTIONS LINK 2

Remember a lotta these questions with detailed explanation can be found At this Website

READ ANSWER and EXPLANATION

Latest C aptitude DBMS questions and Quantitative aptitude Questions

Here are some frequently asked C aptitude questions & these questions have proper answers given so mnc team suggest you should go over these Apptitude questions before your job job interview.

 

Q How do you decide that integer type to use?

Q What should the 64-bit type on a machine that can support it?

Q What is the best way to declare & define global variables & functions?

Q What does extern mean in a function declaration?

And Many more Such Questions are available On our Excellent C Aptitude Questions Site

 

We have Featured several C aptitude questions in march & quntitative questions also so do check them out.

Remember a lotta these questions with detailed explanation can be found At this Website

READ ANSWER and EXPLANATION

Excellent Sql Aptitude questions

Sql Apptitude Very neat collection

Q. What will be the output of the following query? SELECT  DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );
Answer :    NO.
Explanation : 
The query checks whether a given string is a numerical digit. 

 Q. What command is used to create a table by copying the structure of another table?  Q. What will be the output of the following query? 
 Q. What does the following query do? Q. What is the difference between TRUNCATE & DELETE commands? For answers Go Here

For more Sql Questions we suggest you come back to the original site(mncplacement)& check out more sql questions asked in 2019/2020.

More C/C++ Aptitude Questions

More Excellent SQL QUESTIONS collection

Remember a lotta these questions with detailed explanation can be found At this Website

READ ANSWER and EXPLANATION

Placement preparation: C aptitude questions

Great C Aptitude Questions for placement preparations

Q Does C have boolean variable type?

Q Where may variables be defined in C?

Q What does the typedef keyword do?

Q What is the difference between constants defined through #define & the constant keyword?

Q What are Trigraph characters?

Q How are floating point numbers stored? Whats the IEEE format?

Q. When should the register modifier be used?

Q. When should a type cast be used?

Q. Can structures be assigned to variables & passed to & from functions?

Q What is the difference between the declaration & the definition of a variable?.

Q Do Global variables start out as zero?

• 
  
Q To what does the term storage class refer? What are auto, static, extern, volatile, const classes?

GET THE ANSWERS to these APTITUDE questions HERE

Remember a lotta these questions with detailed explanation can be found At this Website

READ ANSWER and EXPLANATION

Here`s an sql aptitude questions collection ( quite easy)

Here Are More Sql aptitude questions

as we were asked by several of our readers for Sql related questions for aptitude preparations & sql questions are asked a lot in placement papers so if u have any requests email us (kusumm14@yahoo.com)

Q. What is the use of the DROP option in the ALTER TABLE comm&?

It is used to drop constraints specified on the table.

Q. What is the value of ‘comm’ & ‘sal’ after executing the following query if the initial

value of ‘sal’ is 10000?

UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;

sal = 11000, comm = 1000 .

Q. Why does the following comm& give a compilation error?

DROP TABLE &TABLE_NAME;

Variable names should start with an alphabet. Here the table name starts with an '&' symbol.

Q. What is the advantage of specifying WITH GRANT OPTION in the GRANT comm& in sql?

The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.

Q. What is the use of DESC in SQL?

Answer :

DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.

Explanation :

The query SELECT * FROM EMP ORDER BY ENAME DESC will display the output sorted on ENAME in descending order.

Q. What is the use of CASCADE CONSTRAINTS?

When this clause is used with the DROP comm&, a parent table can be dropped even when a child table exists.

 

READ ANSWER and EXPLANATION

Great Basic SQL aptitude Questions

Some SQL Aptitude questions

Q  Which  is  the  subset  of  SQL  commands  used  to  manipulate  Oracle  Database
structures, including tables?
Q  What operator performs pattern matching?
Q  What operator tests column for the absence of data?
Q  Which command executes the contents of a specified file?
Q  What is the parameter substitution symbol used with INSERT INTO command?
Q  Which command displays the SQL command in the SQL buffer, and then executes it?.

Q.  What are the wildcards used for pattern matching?
Q  State true or false. EXISTS, SOME, ANY are operators in SQL.
Q  State true or false. !=, <>, ^= all denote the same operation.
Q. What are the privileges that can be granted on a table by a user to others?

For Answers Click HERE
 

Remember a lotta these questions with detailed explanation can be found At this Website

READ ANSWER and EXPLANATION

New SAPIENT DBMS Preparation Questions

Here are some Very easy DBMS placement questions for various papers...

Q. What is an Entity?
It is a 'thing' in the real world with an independent existence.

Q. What is an Entity type?
It is a collection (set) of entities that have same attributes.

See the rest of these questions and more great Aptitude questions HERE

Remember a lotta these questions with detailed explanation can be found At this Website

See also: 2026-updated placement papers on PapersAdda →

READ ANSWER and EXPLANATION

Some Great DBMS Questions for sapient 2019 interview

Here are some great DBMS basic easy questions which will help u greatly in the interviews ahead so boys and girls say thanks to MNCPLACEMENT blog and remember you can get these updates before anyone else.

JUST DROP ur EMAIL ADDRESS IN THE TOP LEFT CORNER for daily updates

2019 DBMS QUESTIONS LINK 1

2019 DBMS QUESTIONS LINK 2

See also: 2026-updated placement papers on PapersAdda →

READ ANSWER and EXPLANATION

2008 SAPIENT Placement paper pattern (EXCLUSIVE)

Updated for 2026

The current version of this guide — verified for 2026 placement season — is on PapersAdda. Read the latest →

PAPER PATTERN





2 programs to write .They are only looking at the logic...they don't care how u wrote the program,,,,ya..little bit they will c.. then there is a Techical +business interview.It was cool...they were very friendly.....so it was not a problem.



Program 1. Reservation. there are 67 seats in train . there are only 5 seats in a row & in last row there are only 2 seats. One person can reseve only 5 seat at a time. If person reserving seat , the care is taken that he may get all in row. if seats are not available in row then the arrangement is so that person group get nearby seats. the following class is given public class seat { char name; int seat; boolean isSeatempty } 1.Draw require class digram & object diagram. 2.Write function seatallot(int noofperson) to allocate seat with seat nuber printed for the each name.

Program 2. Stringreplace The forum is going on & administartor find that some people use abusing or bad lnaguage in discussion.so he decided that when he uses such language it was replacedc with beap. question for interview: 1. draw class digram,& use appropriate data structure. 2. write function replacestring()





1) Write a program for the problem: the array of

inetegers indicating the marks of the students is

given, U have to calculate the percentile of the

students aaccording to this rule: the percentile of a

student is the %of no of student having marks less

then him. For eg:

suppose



Student Marks

A 12

B 60

C 80

D 71

E 30

F 45



percentile of C = 5/5 *100 = 100 (out of 5 students 5

are having marks less then him)

percentile of B = 3/5*100 = 60% (out of 5, 3 have

markses less then him)

percentile of A = 0/5*100 = 0%.



2) The code was given for a problem & u have to

identitfy the logical error in it. That was simple.

The code was to merge the Danagrams of 2 words. The

danagram of a word is the letters of word arranfed in

sequential order. eg danagram of abhinav is aabhinv.

merging of danamagram is to merge the danagrams of 2

or more words such that the highest no of occurance

are coming for each alphabet.eg









PAPER 2





round1: write 2 programs on paper in 1 hour

{

.based on chair char in trains function to

allot seats to people with some conditions like try to

give them consecutives one etc

.based on strings like give string remove

toxic words like stupid etc by ###

}

round2: write 2 programs on paper in 1 hour

{

.based on postal system,how to decide the amt

payable to companies sending post everyday, sorting

them,discount & many more requirements.

.to compress the data send across the company

& filter out the corrupted data.

}

round3: technical discussion for abt 45 mins on 2

programs of round 2

additional 2 programs to seach an element

immediately gr8r then all present in an array without

sorting

& a modified version of it to handle all

error conditions. etc

what questions I have

round4: behavioual interview 1(HR) for abt 45 mins

{

tell abt urself

strengths

weaknesses

describe deployment of one full project any

one

why sapient

what can u bring on table

conflicts in team & how were they ressolved

etc.

what questions I have



PAPER 3



The test contained 3 questions:



1. design a class diagram or date model for this

problem:



A company has some clients & some officers. Also it has some rooms to be used for meetings between client & officers. one officer is responsible for each room. & room has unique room id. a meeting will be aranged only when the officer & client are free & room is also free. the officer & clients must be registered to the system which will give them unique email ids. arrange the meetings. dont write ode.

2. write a program to find the occurance of charachers '!', '$' '?' '.' ',' etc. Also write a function to replace all odd occurance of '?' to '.'.

3. there was a given program to insert a value at the proper postion in a doubly linked list. there was some logical error in that due to which it was not working properly. find out that error. it was easy.

Remember a lotta these questions with detailed explanation can be found Here

---

Note: This article is from the original mncplacement archive (2008+). For the 2026-current version with verified offers, salary data, and exam patterns, visit the updated guide on PapersAdda.

READ ANSWER and EXPLANATION