Google+ – Posts, Circles, Sparks & Hangouts !!!

Google+ (Google Plus) is an interest-based social networking site owned by Google Inc. Launched in 2011, this platform brings together people with similar interest. Such group of people can build a community and share their ideas through photos and posts.

Google+ is unique in way in that it allows more transparency in what one shares and with whom it is shared. The Google+ menu bar is displayed on other Google services when one logs in the google account.

Some of the most prominent features of Google+ are as follows −

  • Posts where one can update the status.
  • Circles are used to share information with different groups.
  • Sparks offer videos that users might like.
  • Hangouts & Huddles are for video chat with a friend or a group of friends.

Uploading a Post:

We can upload posts on our Google+ profile easily and share it with people in our communities/circles or others who we want to share it with. When we share our post, it is visible on the receiver’s news feed. The post also appears on our profile page and people can comment, like, or share the post. We can also tag people to our post using “+ and their name.

Let’s go step by step and learn how we can upload a post in Google+.

Step 1 − Open your Google+ account.

Step 2 − On the profile page, at right bottom corner click on write icon to write new post.

Step 3 − Write the post. We can also copy paste the content.

Step 4 − Tag anyone if desired. Add the location if needed.

Step 5 − Select whether the post should be public or private.

Step 6 − Once done, click the ‘Post’ option. The post appears on our page as well as on the profile page of the persons tagged to the post.

Google Plus – Circles

Google Circles can be used to group together different people. It may different members of the family, colleagues, or a group of people having similar interest. When we add people to a particular circle, they receive a notification of being added to the circle. Members of a circle can view the posts and photos in the circle. We can also add or remove people from circles at any time. Circles help to share the right information with the right people.
For example, it is a great way to share jokes with ‘friends’ circle, while sharing business matters with ‘work’ circle. People added to circles can also be available on our Google Hangout. By default people and pages added to circles are publicly visible. However, we can change the privacy options from settings. 

How to Create a Circle?

Step 1 − Open Google+ account.

Step 2 − Click ‘People’ from the navigation menu.

Step 3 − Click the ‘Following’ tab as shown in following screenshot.

Step 4 − Scroll down and click New Circle as seen in the above screenshot.

Step 5 − Name the circle and once done, click ‘Create’.

Adding People to Circles

Step 1 − Open the profile of the person who is to be added to the circle.

Step 2 − Click the circle that the person is to be added to.

Step 3 − Click Done.

Removing People From Circles

Step 1 − Open the profile of the person to be removed from the circle.

Step 2 − Click the circle that the person is in and from the menu uncheck the circle.

Step 3 − Click Done.

Google Plus – Hangouts

Google Hangouts is a communication platform developed by Google which includes instant messaging, video chat, SMS and VOIP features. It replaces three messaging products that Google had implemented concurrently within its services, including Google Talk, Google+ Messenger (formerly: Huddle), and Hangouts, a video chat system present within Google+. Google has also stated that Hangouts is designed to be “the future” of its telephony product, Google Voice, and integrated some of the capabilities of Google Voice into Hangouts. Users can be messaged by their Google+ accounts.

This platform also offers “hangouts on Air” option using which we can broadcast live video chatting and discussions to the world through your Google+. These video chats and discussion is accessible to all. It can be edited and a copy of the broadcast can be shared though YouTube channel.

To broadcast our Hangouts on Air, all we need is −

YouTube channel − Make sure to have a YouTube account. Create an account, if there isn’t one.

Google+ profile − Make sure the Google+ page is connected to YouTube account. Nowadays they are automatically connected, however existing users should connect it to Google+ page.

Creating a Hangout

Step 1 − Open Google+ page.

Step 2 − Search for Hangouts in the drop-down menu located on the left side of the page.

Step 3 − Click “+ New Hangout”. Check and add people to be added to Hangouts.

Step 4 : Choose the format for Hangouts, i.e. either video or text hangout. We can also alter text chat to video chat any time by clicking the camera button that appears on the top of the chat window.

We can share emoticons or pictures through Hangouts. We can also add filters to the pictures and videos. When we are done chatting, click the Close (x) button.

Google Plus – Events

Google+ Events page helps in organizing an upcoming event or occasion. It helps anyone using Gmail to add certain events in their calendars. All information about the particular event can be populated with just one click.

The event automatically gets added to Google calendar of those who are invited and are already in the circles. We can invite as many people or even the entire circle/community at the same time. Click ‘+invite name, circles’ and select the privacy as ‘public’. By doing so, anyone can find the event and access the details.

Events automatically get synchronized with guests’ calendars. Everyone attending can share the photos/videos to the shared album. Guests can even inform whether they are going to attend the event or not. If there is a change in the date of the event, guests will be notified by email. They will receive a notification for the change in place, date, time, etc.

Creating a Google+ Event

Step 1 − Open Google+ account.

Step 2 − Click the ‘Events’ tab.

Step 3 − Click ‘Create event’.


Step 4 − Fill all the information about the event such as ‘Title’, ‘start/end date’, ‘location’, ‘description’.

Step 5 − Upload the cover picture. Make sure the cover picture depicts the event.

Step 6 − Check/uncheck the following options.

  • Guests can invite other people.
  • Guests can add photos.
  • Hide guests list.

Step 7 − Add more description via ‘Advanced’ tab.

Step 8 − Invite people who we want to come to the event by clicking the green ‘invite’ button.

Step 9 − Publish the event.

Google Sparks:



Google+ SPARKS is a feature you can use to get all the info about your interests (if you can’t see it by clicking the link, here is a screenshot).
You can click on any of the images (categories) you want, and add it to your interests. I chose to type in my interests instead, and keep up with stuff I am interested in. Creating a spark “Movies” just seems like too much.
Once you chose your interests, you will be able to see a link to each of them under your profile picture. Any time you want to see what is going on in the world, that is related to your interest, click on it and you will get a page filled with news, posts, information.
For example, I can stay up to date with anything related to “blogging”,”Programming” or which ever interest I add, as you can see it in my list of Sparks.

Want To Learn Digital Marketing?

Test Your SQL Basics – Part_3

Manipulating Data Questions

1. What all operations can MERGE statement perform in SQL?

  1. INSERT
  2. DELETE
  3. GROUP BY
  4. None of the above

2.Which of following commands is a DDL (Data Definition Language) command but is often considered along with DML commands?
  1. DELETE
  2. INSERT
  3. TRUNCATE
  4. None of the above

3. What among the following is a TRUNCATE statement equivalent to? (Choose the most suitable answer)
  1. To a DELETE statement
  2. To an UPDATE statement
  3. A DELETE statement without a WHERE clause
  4. None of the above

4.Which of the following situations indicate that a DML operation has taken place?
  1. When new rows are added to a table
  2. When two queries are combined
  3. When a table is truncated
  4. None of the above

5.What is true about the keyword VALUES in INSERT statements?
  1. VALUES can add multiple rows at a time during the INSERT
  2. VALUES can add only 100 rows at a time during the INSERT
  3. VALUES is mandatory to be used if we use the keyword INSERT
  4. VALUES add only one row at a time

6. Which of the following commands is used to save the changed data in a table permanently?
  1. ROLLBACK
  2. COMMIT
  3. INSERT
  4. UPDATE

7. Which of the following commands / statements would end a transaction?
  1. COMMIT
  2. SELECT
  3. SAVEPOINT
  4. CREATE

8.What happens when a transaction is committed?
  1. The changes made during the transaction are saved for a particular user session
  2. The changes made during the transaction are discarded
  3. If the transaction is a DDL, the commit doesn’t work
  4. None of the above

9. Which of the following reasons will the best one on the usage of string?
  1. Using sub-queries
  2. Syntax errors
  3. Access permissions
  4. Constraint violations

Answer
1-(A,B),   2-C,   3-C,   4-A,  5-D,   6-D,   7-(A,D),   8-D,   9-(C,B,D)

function mco() { var x = document.getElementById(‘myDIV’); if (x.style.display === ‘block’) { x.style.display = ‘none’; } else { x.style.display = ‘block’; } }


Using DDL Statements Questions

1.DDL statements are used for which of the following Oracle database objects?
  1. Tables
  2. Sub-queries
  3. Rows
  4. Columns

2.What is the basic unit of storage in Oracle Database that contains data?
  1. View
  2. Column
  3. Query
  4. Table

3.Which of the following database objects improves the performance of some queries?
  1. Table
  2. Synonym
  3. View
  4. Index

4. When a table can be created?
  1. When the database is not being used by any user
  2. When the database is newly created
  3. It can be created any time, even when a user is using the database
  4. None of the above

5. What is true about a table?
  1. It is not mandatory to specify the size of a table
  2. The size of each table is the same
  3. A table can be modified online
  4. None of the above

6. A table named 123_A is created for storing the number of employees in an organization. What is wrong in the name of the table?
  1. The name of a table cannot start with a digit
  2. Nothing is wrong in this name.
  3. You cannot use an underscore while naming a table
  4. None of the above

7. What among the following are the pre-requisites for creating a table?
  1. CREATE TABLE privilege
  2. Storage space
  3. Data in the table
  4. None of the above

8. What is the syntax for creating a table?
  1. CREATE TABLE [schema.] table (column datatype [DEFAULT expr] [,..] );
  2. CREATE TABLE INTO [schema.] table (column datatype [DEFAULT expr] [,..] );
  3. CREATE TABLE VALUES [schema.] table (column datatype [DEFAULT expr] [,..] );
  4. None of the above

9. What is true about a namespace?
  1. It is a group of object types
  2. Within a namespace, all the object names should be uniquely identified by schema and name
  3. The same type of objects in different namespaces can share the same name
  4. All of the above

10. Which of the following object types share the same namespace?
  1. Synonyms
  2. Table
  3. Views
  4. All of the above

11. Which of the following are the data types for date and time data?
  1. TIMESTAMP
  2. INTERVAL DAY TO SECOND
  3. TIMESTAMP WITH LOCAL TIMEZONE
  4. All of the above

12. Which of the following data types are for large objects?
  1. CLOB
  2. BLOB
  3. RAW
  4. All of the above

13. What will happen if the inserted value is of a smaller length as defined for a VARCHAR2 data type column?
  1. It will throw an ORA error
  2. It will get inserted successfully and the value will take up as much space as it needs.
  3. It will get inserted and the remaining space will be padded with spaces
  4. None of the above

14. What happens when a table which is marked Read Only is attempted for drop?
  1. It will throw an error
  2. It will no longer remain Read Only but cannot be dropped either
  3. It will be dropped without errors
  4. It will remain un-touched

15. Which of the following data types cannot be used with a GROUP BY and an ORDER BY clause?
  1. CLOB
  2. VARCHAR2
  3. CHAR
  4. LONG

16. How many LONG columns can a table contain?
  1. None
  2. Maximum 2
  3. Minimum 2
  4. Only one

Answer
1-A,   2-D,   3-D,   4-C,  5-(A,C),   6-A,   7-(A,B),   8-A,   9-D,  10-D,   11-D,  12-(A,B),  13-B,  14-C,  15-D,  16-D

function mct() { var x = document.getElementById(‘myDIV2’); if (x.style.display === ‘block’) { x.style.display = ‘none’; } else { x.style.display = ‘block’; } }


Creating Other Schema Objects Questions

1. What among the following is true about synonyms?
  1. PUBLIC and PRIVATE synonyms can have the same name for the same table
  2. DROP SYNONYM will remove a synonym
  3. DROP PUBLIC SYNONYM can be executed only by a SYSDBA
  4. None of the above

2. What is true about creating a view? (Choose the most appropriate answer)
  1. A view can only be created from a table
  2. A view can only be created from one table
  3. A view can be created from one or many tables or views
  4. None of the above

3. Which of the following privileges are required to create views in one’s own schema?
  1. CREATE TABLE system privilege
  2. CREATE VIEW system privilege
  3. ALTER VIEW system privilege
  4. CREATE ANY VIEW system privilege

4.How is a view stored in the data dictionary?
  1. As a WHERE clause
  2. As a CREATE statement
  3. As an UPDATE statement
  4. As a SELECT statement

5.Which of the following can contain single-row functions?
  1. Inline Views
  2. Simple Views
  3. Complex Views
  4. Composite Views

6.When can the rows from a view be removed?
  1. Deletion of rows through a view is not possible
  2. It should be a simple view
  3. It should be a complex view
  4. None of the above

7.When can the data in a view not be modified?
  1. When there are group expressions
  2. When there is a GROUP BY clause
  3. When ROWNUM is used in the view query
  4. All of the above

8.What is true about the WITH CHECK CONSTRAINT?
  1. INSERTs or UPDATEs performed through the view cannot create rows that the view cannot select
  2. Only INSERTs performed through the view cannot create rows that the view cannot select
  3. Only UPDATEs performed through the view cannot create rows that the view cannot select
  4. None of the above

9.How can you prevent DML operations on a View?
  1. By defining a WITH CHECK OPTION constraint
  2. By defining a WITH READ ONLY option
  3. Neither of A nor B
  4. None of the above

10.What is true about the above statement?
  1. The view will not be created
  2. INSERT operation on this view an will throw an ORA error
  3. On UPDATING the rows for all the employees in department 100, an ORA error will be thrown
  4. None of the above

11.How many rows can be deleted from the view as shown above?
  1. All rows of the view
  2. All the rows of only the department 100
  3. No rows
  4. None of the above

12.What is true about sequences?
  1. It generates integers
  2. It is a shareable object
  3. Can be used to create a PRIMARY KEY value
  4. All of the above

13.What can be the last value generated by this sequence?
  1. 0
  2. 100
  3. 101
  4. 9999

14.What is true about NEXTVAL pseudo column?
  1. It re-generates the CURRVAL of a sequence
  2. It returns the next available sequence value
  3. It can return duplicate values
  4. It generates the same values for different users

15.What is true about CURRVAL pseudo column?
  1. CURRVAL can be used before NEXTVAL with respect to a sequence
  2. CURRVAL gives the current value of a sequence
  3. CURRVAL can give duplicate values
  4. None of the above

16.Which of the following is used by an index to locate the data quickly?
  1. ROWNUM
  2. ROWID
  3. Sequence
  4. None of the above

17.What happens when there is no index on a column of a table?
  1. The data is located quickly
  2. There is a full table scan
  3. The table cannot be created
  4. The table cannot be altered

Answer
1-(A,B),   2-C,   3-B,   4-D,  5-(A,B),   6-B,   7-D,   8-A,   9-B,  10-(B,C),   11-C,  12-D,  13-D,  14-B,  15-B, 16-B, 17-B

function mctt() { var x = document.getElementById(‘myDIV3’); if (x.style.display === ‘block’) { x.style.display = ‘none’; } else { x.style.display = ‘block’; } }


Want to Learn Database Programming?