Question 1

What are the advantages of cloud architecture?

Accepted Answer

- Cloud architecture uses simple APIs to provide easily accessible services to the user through the internet medium - It provides scale on demand feature to increase the industrial strength - It provides the transparency between the machines so that users don’t have to worry about their data Users can just perform the functionality without even knowing the complex logics implemented in cloud architecture - It provides highest optimization and utilization in the cloud platform

Question 2

What is the relationship between SOA and cloud architecture?

Accepted Answer

Service oriented architecture (SOA) is an architectural style that supports service oriented methodology that is being added in the cloud architecture as a mandatory component Cloud architecture support the use of on-demand access to resources and it provides lots of other facilities that are being found in SOA as well SOA makes these requirements optional to use But, to get the full functionality and more performance based efficiency there is a requirement for the mixture of SOA and cloud architecture

Question 3

What are the uses of Amazon web services?

Accepted Answer

Amazon web services consist of a component called as Amazon S3 that acts as a input as well used as an output data store It is used in checking the input and according to that gives the output The input consists of the web that is stored on Amazon S3 as object and it is update frequently to make the changes in the whole architecture It is required due to the on demand growing of the data set and to provide persistent storage

Question 4

How to use SimpleDB with Amazon?

Accepted Answer

Every architecture rely on a database that is easy to maintain and gets easily configured Amazon uses the database by the name SimpleDB This is the database that is used for cloud architecture to track the statuses of the components The component of the system are asynchronous and discrete, it requires capturing the state of the system so that in any failure the user can easily revert back to its normal configuration SimpleDB is schema-less database and there is no need to define the structure before the creation of any data Every controller in the database defines their own structure and link the data to a job

Question 5

How to upload files in Amazon S3?

Accepted Answer

Amazon S3 provides uploading of large files and retrieve small offsets for end-to-end transfer data rates The large file gets stored into small files that are smaller in size Amazon S3 stores multiple of files together in a bundle or in a compressed form, For example in gzip or gz format and then convert them into Amazon S3 objects The files get uploaded on the Amazon server by the use of FTP or another protocol and then retrieved through the HTTP GET request The request includes the defined parameters like URL, offset (byte-range) and size (length)

Question 6

What is a linked server in SQL server?

Accepted Answer

It enables SQL server to address diverse data sources like OLE DB similarly It allows Remote server access and has the ability to issue distributed queries, updates, commands and transactions

Question 7

What is the difference between UNION and UNION ALL?

Accepted Answer

UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones

Question 8

What are the rules to use the ROWGUIDCOL property to define a globally unique identifier column?

Accepted Answer

Only one column can exist per table that is attached with ROWGUIDCOL property One can then use $ROWGUID instead of column name in select list

Question 9

Explain the use of keyword WITH ENCRYPTION. Create a Store Procedure with Encryption

Accepted Answer

It is a way to convert the original text of the stored procedure into encrypted form The stored procedure gets obfuscated and the output of this is not visible to CREATE PROCEDURE Abc WITH ENCRYPTION AS << SELECT statement>> GO

Question 10

What is Analysis service repository?

Accepted Answer

Every Analysis server has a repository to store metadata for the objects like cubes, data sources etc It’s by default stored in a MS Access database which can be also migrated to a SQL Server database

Question 11

When do you use UPDATE_STATISTICS command?

Accepted Answer

This command is used when a large processing of data has occurred If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account UPDATE_STATISTICS updates the indexes on these tables accordingly

Question 12

What is SQL Server Agent?

Accepted Answer

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA) Its purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts

Question 13

Which command using Query Analyzer will give you the version of SQL server and operating system?

Accepted Answer

SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel') and SERVERPROPERTY ('edition')

Question 14

Mention the difference between clustered and a non-clustered index?

Accepted Answer

- A clustered index is a special type of index that reorders the way records in the table are physically stored Therefore table can have only one clustered index - A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk The leaf node of a non clustered index does not consist of the data pages Instead, the leaf nodes contain index rows

Question 15

How to create recursive query in SQL Server?

Accepted Answer

Recursive query can be create in SQL using stored procedure but you can also use CTE (Common table expression) It might be also worth asking about performance as CTE is not always very fast

Question 16

Define Trigger

Accepted Answer

Trigger allows us to execute a batch of SQL code when an insert, update or delete command is executed against a specific table Triggers are special types of stored procedures that are defined to execute automatically in place of or after data modifications They can be executed automatically on the insert, delete and update operation

Question 17

Write an SQL Query to find employees whose name starts with an ‘M’?

Accepted Answer

SELECT *FROM Employees WHERE EmpName like ‘M%’

Question 18

Difference between a query and a statement in SQL?

Accepted Answer

An SQL statement is a string of characters that conforms to the syntax and format specified in the international standard A query is a statement that returns a record-set

Question 19

Describe the use of PL/SQL table?

Accepted Answer

PL/SQL tables are scalar arrays that can be referenced by a binary digit They can be used to store values for later queries and calculations

Question 20

Name any three PL/SQL exceptions?

Accepted Answer

Too_many_rows No_Data_Found Zero_Error

Technology Questions