info@tutorialdiary.com

Wednesday, May 25, 2016

AMCAT Previous Year DATABASE QUESTIONS | AMCAT Details

12:23 PM

Share it Please

AMCAT Previous Year DATABASE QUESTIONS | AMCAT Details
Compiled by: AMCAT DETAILS

Q. Which of the following statements is/are true for Tue Relational Calculus(TRC)?
I) TRC is a declarative language
2) TRC makes use of predicate calculus
3)In TRC, x=>y means y is true if and only if x is true
Options are:
1) Only 1
2) Both 2 and 3
3) Both 1 and 2
4) Both 1 and 3 
Answer: 3)

Q. Number of tuples in a relation is called ________ and number of attributes is called _______ 
1) domain, cardinality 
2)degree, cardinality 
3)cardinality, degree 
4) domain, degree

Answer: 3)

Q. Cooperating processes require an Interprocess Communication (IPC) mechanism that will allow them to exchange data and information. Which of the following options is/are the method(s) of Interprocess Communication(IPC)? 
1) Message passing 
2)Cooperation 
3) Shared memory 
4)Both 2 and 3 
5) Both 1 and 3 

Answer: 5)

Q.

 1. lnsertions and deletions musl be simple.
2.Maintaining the index should be easy.
3.High performance when data is accessed randomly.
4. Most often queries executed on the table are equality queries.

Reema wants to create an index on a table. She wants the given requirements to be fulfilled (as given in the passage). Which of the following indices she must use? 
1)Clustered index 
2)Non-clustered index 
3)Hash table index
4)B-tree index 

Answer: 3)

Q. Places(location,name, type) 
Choose the correct option

Which of the following queries can be used to retrieve name and type from table “Places”(given in the passage), where column ‘location” has value Delhi and output should be in alphabetically increasing order of column “name’? 
1)SELECT name, type FROM Places WHERE locationDelhi SORT BY 1;
2)SELECT name,type FROM Places WHERE location’Delhi’ SORT BY name;
3) SELECT name, type FROM Places WHERE location=’Delhi’ ORDER BY 1;
4) SELECT name, type FROM Places WHERE location=’Delhi’ ORDER BY 2; 
5)SELECT name, type FROM Places WHERE location’Delhi SORT BY 2;

Answer: 3)

Q. Amit hs some knowledge about darabase normalization.He has created a table "customer",which has the following characteristics.
1)Table has transitive dependencies.
2)there are no partial dependencies in the table
3)There is no column with redundant data in the table
In which normal form is the table?
a)1NF
b)2NF
c)3NF
d)BCNF

Answer: b)

Q. What does isolation in Acid rules for transaction in database mean?
a)either the effects of whole transaction is reflected on database or database is rolled back to its original state
b)No transaction can interfere in the end result of another transaction
c)effects of a successful transaction must persist in a database
d)Every individual transaction must leave database in a cosistent state .maintaining the integrity of the database


Answer: b)

Q. Anil is designing a database of motor vehicles.It has one base entity "vehicles"which is classified into two sub-entries.2 wheeler and 4-wheeler.He further breaks them down into more entities.what is the process being used here?
a)Generalization
b)Specialization
c)Aggregation
d)segregation

Answer: b)

Q. Piyush used a hashing function that resulted in collision. Since backtracking will take up a lot of time, he decided to use a collision resolution technique. Which of the given techniques can he use for the same?
1. Open Addressing
2. Simulation
3. Chaining
Options:
a)Only 1 
b)Only 3
c) Both 1 and 3
d) Both 2 and 3
e) Both 1 and 2

Answer: 3)

Q. The minimal set of a super key is?

options: candidate key, primary key, foreign key, secondary key

Answer: Candidate Key

Q. Sunil is working on a database management system. He wants to program transactions such that a transaction is completed only if all the database operations are completed and commited, otherwise the transaction is
o Atomicity 
o Consistency
o Isolation 
o Durability

Answer: Atomicity
  

0 comments:

Post a Comment