Code Bluff

Search This Blog

Infosys Preparation | Free Mock Tests

on September 26, 2019

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Centralized and Client-Server Architectures | Advanced Database Systems | BE - IT Part(1)

Centralized and Client-Server Architectures: Centralized Architectures: - In a centralized database, there is a single database file at one location in the network - Multiple users can access this single database, it is called a centralized database - This kind of database provides multiple advantages - As there is an only single database file, it is easier to get a complete view of data Here we have installed our server on Site3, other sites can remotely access to the database. For e.g.: If Site5 needs any data then they can request it to site3 and retrieve data easily Advantages of Centralized Database: - The data integrity is maximized as the whole database is stored at a single physical location. This means that it is easier to coordinate the data and it is as accurate and consistent as possible - The data redundancy is minimal in the centralized database - Since all the data is in one place, there can be stro

Write a Function | Hackerrank Solutions

We add a Leap Day on February 29, almost every four years. The leap day is an extra, or intercalary day and we add it to the shortest month of the year, February. In the Gregorian calendar three criteria must be taken into account to identify leap years: The year can be evenly divided by 4, is a leap year, unless: The year can be evenly divided by 100, it is NOT a leap year, unless: The year is also evenly divisible by 400. Then it is a leap year. This means that in the Gregorian calendar, the years 2000 and 2400 are leap years, while 1800, 1900, 2100, 2200, 2300 and 2500 are NOT leaping years. Source Task You are given the year, and you have to write a function to check if the year is a leap or not. Note that you have to complete the function and remaining code is given as a template. Input Format Read y, the year that needs to be checked. Constraints Output Format The output is taken care of by the template. Your function mus

OLAP Operations | Hackerrank Solutions

1. This OLAP operation involves computing all of the data relationships for one or more dimensions. A. Dice B. Slice C. Pivot D. Roll Up Answer. D. OLAP consists of three basic analytical operations: consolidation (roll-up), drill-down, and slicing and dicing. Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions. ... By contrast, the drill-down is a technique that allows users to navigate through the details. 2. This OLAP Operation rotates the data and delivers an alternative to the original presentation. A. Pivot B. Slice C. Roll-Up D. Dice Answer. Pivot

Powered by Blogger

Infosys Preparation | Free Mock Tests

Comments

Post a Comment