Interview Questions and Answers for 'AT' | Search Interview Question

Interview Questions and Answers - Order By Newest

Q1021. How would you securely migrate a database to RDS?

^{This question was recently asked at 'Cognizant (C?TS),Overstock'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws rds aws database amazon cloud database Asked in 2 Companies}

Q1022. Are CloudWatch metrics available with free tier ?

Amazon Web Services (AWS)

Ans. Only Basic not advanced

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws cloudwatch amazon cloudwatch}

Q1023. What are the Default metrics available for EC2 in CloudWatch ?

Amazon Web Services (AWS)

Ans. CPU, Disk, Network, Status

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws cloudwatch amazon cloudwatch}

Q1024. How frequently Cloudwatch monitor AWS services for generating metrics ?

Amazon Web Services (AWS)

Ans. 5 mins for Standard / Basic
1 min for Detailed / advanced

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws cloudwatch amazon cloudwatch}

Q1025. Difference between CloudWatch and CloudTrail ?

Amazon Web Services (AWS)

Ans. CloudWatch is for monitoring resources whereas CloudTrail is for auditing activity.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws cloudwatch amazon cloudwatch aws cloudtrail aws cloudwatch amazon cloudwatch vs aws cloudtrail}

Q1026. What are inline functions ?

Programming Language

Ans. Inline functions , just like C++ Macros is an optimized technique used by compiler to reduce the execution time. If the function is working on pre identified values ( which aren't resolved at runtime ), the function can execute the method and evaluate the outcome at compile time only instead of making a function call at runtime.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve inline functions inline methods C++ Asked in 1 Companies}

Q1027. Difference between Route53 aliasis and cname ?

Amazon Web Services (AWS)

Ans. Cname doesn't support naked domain names whereas aliasis does.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws route53 Asked in 3 Companies}

Q1028. Difference between multi AZ RDS and Read replicas ?

Amazon Web Services (AWS)

Ans. Multi AZ RDS is for disaster recovery and failover whereas Read replicas are for scaling.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws rds aws database amazon cloud database multi az aws rds aws database amazon cloud database read replica}

Q1029. What is the limit of read replicas per database ?

Amazon Web Services (AWS)

Ans. 5

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws rds aws database amazon cloud database aws rds aws database amazon cloud database read replica}

Q1030. What is the ideal use case for DynamoDB ?

Amazon Web Services (AWS)

Ans. Fast reads
Much more reads than writes

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws dynamodb aws nosql database amazon cloud nosql database}

Q1031. What are the factors on which RedShift is priced on ?

Amazon Web Services (AWS)

Ans. Compute Node Hours
Backup
Data Transfer

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws data warehouse aws database aws redshift}

Q1032. Can you explain what are NAT instances and what are they used for ?

Amazon Web Services (AWS)

Ans. If instances in private subnet need to access internet without exposing the IP address to outside world , we use Nat gateway or nat instance. So there is a direct outbound traffic but not direct inbound traffic.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws ec2 aws computing amazon cloud computing amazon ec2 nat instances}

Q1033. create an SQL query across multiple tables involving outer joins

Database

Ans. Select * from table1 t1Left outer join table2 t2 on t1.tid = t2.id

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql query database outer joins Asked in 2 Companies}

Q1034. Why should we disable source / destination check for NAT Gateway ?

Amazon Web Services (AWS)

Ans. Source / destination check means that the instance should wither be a source or end destination as a security check. The purpose of NAT Instance is to provide a gateway for internet access and hence this needs to be unchecked.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws nat gateway aws vpc}

Q1035. Do we need to disable source / destination check for NAT Gateway ?

Amazon Web Services (AWS)

Ans. It needs to be done for NAT Instances , not NAT gateway.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws nat gateway aws vpc}

Q1036. Can we have NAT instance in private subnet ?

Amazon Web Services (AWS)

Ans. No

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws nat instance}

Q1037. Write a Program to print all nodes of the data structure ?

Algorithm

^{This question was recently asked at 'Overstock.com'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve data structure algorithm Asked in 1 Companies}

Q1038. Difference between composite , primary and unique key ?

Database

^{This question was recently asked at 'Thomson reuters'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q1039. Can we load Yaml files into AWS DynamoDB ?

Amazon Web Services (AWS)

Ans. No

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws dynamodb aws nosql database amazon cloud nosql database}

Q1040. Can we ssh into subnet without a internet gateway ?

Amazon Web Services (AWS)

Ans. No

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws subset aws internet gateway}

Q1041. Can a constructor be declared static ? Why ?

Core Java

Ans. No.

When we declare a method static, it means that "this belongs to class as whole and not particular instance". The whole purpose of constructor is to initialize a object and hence there is no sense having static constructor.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve constructor static static constructor Asked in 1 Companies}

Q1042. What is the minimum number of tables required to perform a SQL join?

Database

Ans. 1 , We can do self join

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql join Asked in 1 Companies}

Q1043. Implement a queue, using only stacks

Data Structure

^{This question was recently asked at 'IBM India'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve queue stack Asked in 1 Companies}

Q1044. How to write an iterator for an iterator of iterators?

Core Java

Ans. CustomArrayList myarrayList = new CustomArrayList();
      myarrayList.add("Value 1");
      myarrayList.add("Value 2");
      myarrayList.add("Value 3");

      for (String string : myarrayList) {
         System.out.println(string);
      }

package sample.utils;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class CustomArrayList implements Iterable {

   private ArrayList mylist = new ArrayList();

   public void add(T t) {
      this.mylist.add(t);
   }

   @Override
   public Iterator iterator() {
      return new CustomIterator(mylist);
   }

   class CustomIterator implements Iterator {

      private int indexPosition = 0;
      private List internalList;

      public CustomIterator(List internalList) {
         this.internalList = internalList;
      }

      @Override
      public boolean hasNext() {
         if (internalList.size() >= indexPosition 1) {
            return true;
         }
         return false;
      }

      @Override
      public E next() {
         E val = internalList.get(indexPosition);
         indexPosition ;
         return val;
      }

   }

}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve iterator Asked in 1 Companies}

Q1045. How many heaps will be there with 3 threads ?

Core Java

Ans. All threads share a common heap.

Each thread has a private stack, which it can quickly add and remove items from. This makes stack based memory fast, but if you use too much stack memory, as occurs in infinite recursion, you will get a stack overflow.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve memory management heap memory Asked in 1 Companies}

Q1046. Explain when you would decide to use open authentication ?

Authentication

Ans. Google OAuth can be used when we want to grant the access of our google credentials to the service provider ( most likely a cloud-based mobile application) by using the option ' Login via Google'

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve open authentication Asked in 1 Companies}

Q1047. Why Hadoop serialized data types are not using in Spark serialization ?

BigData

^{This question was recently asked at 'Tavant Technology'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q1048. Is HashMap Synchronized ?

Core Java

Ans. No HashMap isn't synchronized. ConcurrentHashMap and Hashtable are synchronized.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve hashmap synchronization}

Q1049. Sort an Employee Object based on Name or Age

Database

Ans. Use Comparable or Comparator interface

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql query Asked in 1 Companies}

Q1050. What is cluster ?

^{This question was recently asked at 'idealake information technologies'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.