Cloud final assessment

1)Strategic benefitof cloud
Ans:Speed of completion
2)command to get Azure published stings file
Ans:Get-AzurePublishSettingsFile
3)Command to generate client certu
Ans: makecert -sky exchange…
4)Security parameters provided by azure
Ans:Both a and b
5)Storage class for long term archive storage
Ans: glacier
6)file size range in s3
Ans: 0-5tb
7)what do ttl settings control
Ans: determines the amount of time for specific…
8)How many languages supported by cloud search
Ans: 34
9)types of files windows azure storage BLOB contain
Ans: video/image/audio,VHD…
10)Types of storage that you can have with storage account
Ans: tables,blobs,queus
11)Which of these is a cloud deployment model
Ans: ALL of the above
12)When is cloud computing not a suitable option for organizations
Ans: Both A and B
13)Cloud computing is potentially suitable for
Ans: all of the above
14)Intended user for IaaS
Ans: IT professional
15)Different delivery methods available while creating CDN
Ans: Both 1 and 2
16)data format in s3
Ans: objects/files
17)Identify Storage classes in s3
Ans: all of the above
18) where are the steps to generate a self-signed root certificate available
Ans: at the bottom of help option
*19) underlying concept of CDN
Ans: place the content geographically nearest…
20) what server side encryption is available when uploading content to s3 bucktes
Ans: AES-256
21) when using a storage account what are main three ways to
Ans: tables, queues, blobs

Methods and tools

Methods and tools solution set(85/100)
1. Configuration files tracked using VCS
True
2. Best approach for estimation
A combination of all
3. Agile manifesto
Individual and interaction over process and tools
4. Communication between Jenkin and build agent
Bidirectional
5. report shows aggregate status in Jenkin
Weather
6. Continuous integration tool
Jenkins
7. Project health sunny 80% above
True
8. Not a characteristic of good user story
Negotiable
9.Pipeline are now replacing traditional
Production
10.automated testing tool
Selenium
11.unit of measurement size of user story
Story points
12. devOps encourage productivity and efficiency
True
13. What is pipeline
Stages that app goes when developed
14. Analysis to determine quality of code
Static code
15.Timeboxed means
Fixed
16. Different types of projects Jenkins
All of options
17.testing assesses system or solutions
System
18. Multiple changes across several files grouped
Version control
19.spike testing is
Performance
20. Plugin for code repository management
Source code management

AZURE HANDSON

////////// HANDS-ON 1 /////////////////

1) az network vnet create -g resourceaddressgiveninkatacoda -n myvnet

2) az network vnet delete -g resourceaddressgiveninkatacoda -n myvnet

////////// HANDS-ON 2 /////////////////

1) az network nsg create -g resourceaddressgiveninkatacoda -n mynetworknsg

2) az network nsg delete -g resourceaddressgiveninkatacoda -n mynetworknsg


////////// HANDS-ON 3 /////////////////

start writing from step 3:-

1) STORAGEACCT=$(az storage account create --resource-group "resourceaddressgiveninkatacoda" --name "mystorageacct17" --location eastus --sku Standard_LRS --query "name" | tr -d '"')

2) STORAGEKEY=$(az storage account keys list  --resource-group "resourceaddressgiveninkatacoda"  --account-name $STORAGEACCT  --query "[0].value" | tr -d '"')

3) az storage share create --account-name $STORAGEACCT  --account-key $STORAGEKEY  --name "myshare"

4) az storage directory create --account-name $STORAGEACCT --account-key $STORAGEKEY --share-name "myshare" --name "myDirectory"

5) az storage file upload --account-name $STORAGEACCT --account-key $STORAGEKEY --share-name "myshare" --source "/home/scrapbook/tutorial/php-docs-hello-world/index.php" --path "myDirectory/index.php"

////////// HANDS-ON 4 ////////////////////

1) az vm create -n myvm -g resourceaddressgiveninkatacoda --admin-username gaurav --image UbuntuLTS --generate-ssh-keys

2) az vm delete -g resourceaddressgiveninkatacoda -n myvm 

Agile quiz

Agile - Quiz

1) Product owner
2) It is used to measure how much work is left to be done
3) The consistency reduces complexity and overhead
4) You cannot say anything for sure
5) Planning should involve the whole team

GIT HANDS-ON

Merge handson
Step1
git branch
git checkout feature1

Step2
git checkout master
git merge feature1

Step3
git checkout feature2
git checkout master
git merge feature2

Step4
git status

Step5
git commit -a
In vim file write
status and commit the changes

Step6
git branch -d feature1
git branch -d feature2

Undoing changes handson

Step1
git log --oneline
cat hello.py

In vim write
print("Hello World")
git commit -am "updated print statement"


Step2
git diff HEAD
git checkout hello.py

Step3
git status
git diff --cached
git reset

Step4
git status
git reset --hard HEAD

Step5
git reset HEAD~1
git commit -am "commit to revert"
git log --oneline
git show HEAD
git revert HEAD

Step 6
git revert HEAD...HEAD~3 --no-edit
cat hello.py
git log --oneline
2nd handson
Step 1:
ls
git init
Step2:
git remote add origun /s/remote-repo
git remote -v

Step3
git push origin master

Step4
git pull origin master

Step5
git clone <url>

1st handson
Step3:
git add hello-world.js
Step4:
git commit -m "commit message"
Step5:
touch .gitignore
git add .gitignore


REBASE

    git clone /s/remote-project/chceknumber

    cd checkNumber

    cat check_number.py

    sed -i -e "\$aelse: \n print('{0} is Odd'.format(num))" check_number.py

    sed -i '1s/^.*$/#Checks whether number 4 is even or odd/' check_number.py

    cat check_number.py

    git add check_number.py

    git commit -m "<message>"

    git fetch origin master

    git diff master origin/master

    git pull --rebase origin master

    vim check_number.py

    >>#Read......or odd    //delete everything else from <<<<<HEAD to #blue comment

    git add check_number.py

    git rebase --continue

    git log

    git push origin master

OPS_RIO

Operations

Rio quiz

1.Discipline in execution+pursuit of excellnce+customer experience
2.consistent+proactive risk management,discipline or behaviour,operations excellence
3.prompt handling of all changes......
4.break glass
5.all of the above options

marks:(4/5)
45/50 with these answers in Ops_RiO final assessment
1. Means of production
2. Ruby
3. Shift management  (2005 texas city)
4. Project oath (support engineer)
5. Recipies (object used by chef)
6. Ansible (not puppet)
7. Test kitchen (chef Dev kit for ruby)
8. Business continuity plan (earthquake)
9. Right combination of technical and inter personnel skills
10. RCA requires... (woolworth supermarket)


Rio final quiz
1) It automation :- All of the above
2) Expectations of TCSer :- End to end
3) TCS opn day:- 24th july
4) Ron :- Ron should hv tested the script in pre production
5) Not an automation tool:- VR
6) Main obj of rio :- break free
7) Earthquake :- Buisness
8) Google :- kubernate
9) Saas platform :- Datadog
10) Software platform for VM :- Vagrant
11. Means of production
12. Ruby
13. Shift management  (2005 texas city)
14. Project oath (support engineer)
15. Recipies (object used by chef)
16. Ansible (not puppet)
17. Test kitchen (chef Dev kit for ruby)
18. Business continuity plan (earthquake)
19. Right combination of technical and inter personnel skills
20. RCA requires... (woolworth supermarket)

FINAL QUIZ DBMS SOFTWARE FOUNDATION PHASE 5

FINAL QUIZ DBMS SOFTWARE FOUNDATION PHASE 5
1. which among the following is a correct Syntax for raising the user defined exception
handlers?
- Both 1 and 2
2. Which SQL statement returns a numeric value?
- SELECT sysdate-hire_date FROM EMP;
3. when does the for loop terminate?
- When the index reaches the UPPER bound or is terminated early using EXIT statement
4. Table structure:
EmpID | EmpName | ProjId | MNGR-Id | Location | Designation
.
.
.
By referring to the above table structure, for which of the below questions, we would
require to apply the concept of SubQuery?
- All
5. Select an appropriate option for a ‘FUNCTION’ in PLSQL.
- Function can return result value.
6. The ____________ contains a set of tables and views that Oracle use as a reference to the
database
- Data Dictionary
7. What are defined as exceptions in PL/SQL?
- Run time errors
8. From the below table:
EmpId | EmpNAme | ProjId | ProjName | No.OfHoursWorked
…
What are the probable and decomposed tables after performing second normal form?
Let us assume that…..
- Table1:
EmpId | EmpName
Table2:
ProjId | ProjName
Table3:
EmpId | ProjId | No.OfHoursWorked
9. From the below table …….. What would be the primary key to get unique record from the
table? (Pls Confirm)
- EmpID and ProjId together
10. A column with regerence to a record in a table should not have multiple values.
Which normal form, Talks about the above statement?
- First
11. DELETE * FROM STUDENT
What will be the output?
- Deletes all rows from STUDENT table
12. What are the complications, when as exception occurs?
- All of these.
13. The formal classifications describing the level of database normalization in a model are
called normal forms.
- TRUE
14. We can use Transaction control statements in database triggers
- False
15. Select the suitable option from below to create an index on “job” column in emp table?
- Create index emp_ind on emp(job);
16. Which of the statements helps in terminating the PL/SQL LOOP?
- EXIT WHEN
17. Database trigger can be fired when the table is TRUNCATED?
- False
18. Types of SQL statements
- TCL
- DDL
- DML
19. In the below table:
EmpID | EmpName | ProjId
.
.
.
By referring the above table, Select a suitable query which gets all employees whose
project is same as project of ‘d’?
- SELECT * FROM EMP WHERE ProjId=(SELECT ProjId FROM EMP WHERE EMPNAME=’d’)
20. On which of the below statements, acts as trigger firing events?
- All of these
21. We can enable or disable a database trigger
- True
22. Which is the below statement is used to remove access or privileges on database object to
users?
- Revoke
23. A stored function will not allow any parameter to be passed
- False
24. DCL Commands are used to enforce database security in a multiple user environment
- True
25. DDL commands
- CREATE
- ALTER
- DROP
26. Which is the correct syntax for handling Exception handlers?
- WHEN ex_name THEN stmt
27. Which of the below constraints will make sure to allow, only the values of a column (in a
master) to the respective column of a child table?
- Foreign key
28. What does TRUNCATE statement do?
- Remove all rows from a table
29. Select the suitable statement for PLSQL
- Bringing Programming language features to SQL

30. Which of the following is true with respect to Referential Integrity?
- Every foreign key value must match primary key value in the associated table ie
Parent table
31. What is the grant statement to grant select, insert, delete privileges on table: Emp to user:
TestUser?
- Grant Select, Insert, Delete on Emp to TestUser
32. Table 1 : Emp
EmpId | EmpName | ProjId
…
Table2: Proj
ProjId | ProjName
…
By referring to the above table structure, select the query which would Fetch EMPID,
EMPNAME, ProjId, ProjName for each employee?
- Select A.EmpID, A.EmpNAme, A.ProjId, B.ProjName from EMP A, Proj B WHERE
A.ProjID = B.ProjID
33. Select the suitable option for SubQuery
- Inner query executes first…
34. Which Prefixes are available to Oracle triggers?
- Both :new and :old
35. Evaluate the set of SQL statements: CREATE TABLE dept(dept_id NUMBER(2) dname
VARCHAR2(14), Loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT. What is true about the
set?
- The DESCRIBE DEPT statement displays the structure of the DEPT table