AMCAT Computer Science Syllabus & Questions 2023: For IT job seeking candidates, Computer Science plays a huge role. Most of the IT companies look for people having knowledge in Computers. Especially AMCAT score is one of the most demanding parameters by recruiters. Hence, AMCAT Computer Science section must be attempted by all IT aspirants.
Note: AMCAT is playing vital role in offering thousands of IT jobs to freshers, hence our genuine advise would be that all job seekers must take the amcat test.
The syllabus explicitly includes basics of operating system and computer architecture, computer networks and database concepts. Furthermore, we will see AMCAT Normalisation, Architecture, Indexing Questions.
AMCAT Normalisation, Architecture, Indexing Questions with Solutions 2023
Computer Science section in AMCAT additionally helps in making great profiles for job opportunities like Software Developers, Database Administrator and Network Engineers. In particular, this module constitutes of 25 questions and the time allocated is 26 minutes.
As has been noted, from Normalisation, Architecture, Indexing topic,mostly 3-4 questions come. They are logical and comparatively the difficulty level is easier.
Overview of Normalisation, Architecture, Indexing 2023
To reduce duplicacy, dependency and redundancy of data in a database table, Normalisation, Architecture and Indexing techniques are used.
Normalisation
This is a process of arranging or organizing data in certain forms or patterns. Based on the types and bulk of data available, normalisation has following categories:
- First normal form (1NF): Each cell consists of a single record which is unique.
- 2NF (Second Normal Form) Rules: A single column is a primary key with the help of which multiple tables can be linked. The data from this column acts as foreign key for other table.
- 3NF (Third Normal Form) Rules: Here tables can be divided with no functional dependencies.
- Boyce-Codd Normal Form (BCNF): This is also called as 3.5 Normal Form.
- 4NF (Fourth Normal Form) Rules: If no database table instance contains two or more, independent and multivalued data describing the relevant entity, then it is in 4th Normal Form.
- 5NF (Fifth Normal Form) Rules: A table is in 5th Normal Form only if it is in 4NF and it cannot be decomposed into any number of smaller tables without loss of data.
- 6NF (Sixth Normal Form) Proposed: 6th Normal Form is not yet standardized.
Architecture
The architecture of DBMS data is based on accessibility to users. It can be in the form of centralized, decentralized or hierarchical. Depending on the data complexity, DBMS architecture is of 3 types-
- 1-tier: Here the user can directly access data.
- 2-tier: In this case, data can be accessed through an application as on required basis.
- 3-tier: In this tier, data is divided into layers- database, application and presentation
Indexing
Indexing is yet another process of ordering data. They are of three types-
- Primary index
- Secondary index
- Clustering index
Download pdf on Normalisation, Architecture, Indexing Questions
AMCAT Sample Questions on Normalization, Architecture, Indexing Questions with solutions
Mock AMCAT Normalisation, Architecture, Indexing Questions
Question 1: Which of the following one is not true?
A. A relation is in BCNF if it is 4NF
B. BCNF is stricter than 3NF
C. A relation is BCNF is ever determinant of a relation is candidate key
D. All of these
Answer: Option D
Question 2: Which forms are based on the concept of functional dependency: a) b) 2NF c) 3NF d) 4NF
A. 1NF
B. 2NF
C. 3NF
D. 4NF
Answer: Option C
Explanation: The table is in 3NF if every non-prime attribute of R is non-transitively dependent (i.e. directly dependent) on every superkey of R.
Question 3: A BCNF is:
A. Loss less join and dependency preserving
B. Loss less join and not dependency preserving
C. Not loss less join and dependency preserving
D. None of these
Answer: Option B
Question 4: Tables in second normal form (2NF):
A. Eliminate all hidden dependencies
B. Eliminate the possibility of a insertion anomalies
C. Have a composite key
D. Have all non key fields depend on the whole primary key
Answer: Option A
Explanation: The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.
Question 5: What does isolation in Acid rules for transaction in database mean?
A. The effects of whole transaction reflects on database
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: Option B
Also practice questions from-
Relational algebra and SQL questions.
Feel free to add any remarks or comment on AMCAT Normalisation, Architecture, Indexing Questions.
More topics on AMCAT CSE Module Question Papers:
Operating System and Computer Architecture
- Basics of OS and Computer Architecture
- Process Management and Synchronization
- Memory and I/O Management
DBMS (Data Base Management System)
- Data model
- Relational Algebra and SQL
- Normalization, Architecture, Indexing
Computer Networks
- Basics of networking and communication
- OSI, TCP/IP layers and protocols
- Network Devices and Routing Algorithms
Looking for discounts on amcat test?
Use amcat discount code for amcat test