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
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