MCQ of Database Management System(DBMS) with answer set-7

0

1. Processed data is called ………………..

A) Raw data

B) Information

C) Useful data

D) Source


2. …………….. is a utility to capture a continuous record of server activity and provide auditing capability.

A) SQL server Profile

B) SQL server service manager

C) SQL server setup

D) SQL server wizard.


3. Data items grouped together for storage purposes are called a

A) record

B) title

C) list

D) string


4. …………. contains data assisting day to day activities of the organization.

A) Control database

B) Operational database

C) Strategic database

D) Sequential database


5. ………………… approach reduces time and effort required for design and lesser risk in database management.

A) Single global database

B) Top-down approach

C) Multiple databases

D) None of the above


6. HSAM stands for ……….

A) Hierarchic Sequential Access Method

B) Hierarchic Standard Access Method

C) Hierarchic Sequential and Method

D) Hierarchic Standard and Method


7. SQL server stores index information in the ………… system table

A) syst indexes

B) system indexes

C) sysind

D) sys indexes


8. The one guideline to be followed while designing the database is

A) A database design may be ambiguous.

B) Unrelated data should be in the same table so that updating the data will be easy.

C) It should avoid/reduce the redundancy.

D) An entity should not have attributes.


9. Which of the following is not a logical database structure?

A) Chain

B) Network

C) Tree

D) Relational


10. ……………. is a preferred method for enforcing data integrity

A) Constraints

B) Stored procedure

C) Triggers

D) Cursors


Answers:

1. B) Information
2. B) SQL server service manager
3. A) record
4. B) Operational database
5. C) Multiple databases
6. A) Hierarchic Sequential Access Method
7. D) sys indexes
8. C) It should avoid/reduce the redundancy.
9. A) Chain
10. A) Constraints



List of bad ways for building backlinks

0
List of bad ways for building backlinks
Since they are fastest ways for making huge amount of backlinks for their websites or blogs, some link building methods which you are using currently for promoting your website to increase the PageRank and Traffic may harm your website or blog instead of getting high PR and Traffic. I have presented here some bad ways of building backlinks which may get your site banned, penalized, and filtered from major search engine or both. 

1. Submitting your site to 100's of paid directories which send no traffic and sell off topic. 

2. As a new member, asking same questions at many forums on the same day.

3. Asking and answering the questions by making different accounts form same IP address. 

4. Signing up blogs with spammy keywords to comment on blogs. 

5. Using automated bots for blog commenting. 

6. Making unnecessary and unrelated links while commenting others blog. 

7. Sending huge link exchange emails which look like an automated bot sent them. 

8. Signing up for profiles on forums you never intended coming again there. 

9. Exchanging links on huge amount sites and placing their unrelated links on your site.

You may also wanted to view the following related posts

You can view the following other posts

List of good ways of building quality backlinks

0
 It is well known fact that quality backlinks helps to increase the page ranks as well as increase the traffic for any websites or blogs. But creating quality backlinks is not easy tasks for anyone who doesn't have good knowledge about that. I have listed here some good ways to get quality backlinks for your site of blog.                                                                                 
  1. Create twitter account, facebook page and pages on the top Social Networking Site for your site.
  2. Submit your site to Dmoz and other directories that allows free submissions.
  3. Ask questions or answer questions on Yahoo Answers and provide links to suitable topics.
  4. Ask questions or answer questions of Google Groups and provide links to suitable topics.
  5. Submit article at article sites like EzineArticles, GoArticles, iSnare etc. The great thing about good article sites is that their article pages actually rank highly and send highly qualified traffic.
  6. Submit a story to Digg that links to an article on your site.
  7. Publish RSS feed and your content is useful and regularly updated.
  8. Create a profile for forums and give profile link and submit links by giving your answer on suitable topics.
  9. Link to other blogs from your blog. Many bloggers also track who is linking to them or where their traffic comes from, so linking to them is an easy to get noticed and they also links to you.
  10. Comment on other blogs. If your comments are useful and relevant they can drive the direct traffic.
  11. Technorati tag pages rank well in Yahoo and MSN. Even if your blog is fairly new you can have your posts featured on the Technorati tag pages by tagging your posts with relevant tags.
  12. Depending on your sites category and offer, submit your link to classified service.
  13. Backlink on .edu and .gov sites much valuable than others, so try to list your site on your local government business directory. There are so many wordpress blogs of .edu and .gov, post relevant comments on them.
  14. Exchange links to related sites on a small scale that will send you traffic.
  15. Create and release open source site design templates for Content Management System(CMS) like Wordpress, blogger with designed by link on the footer.
If you know some other than listed above you are welcomed to post that on the comment session. 

You may also wanted to view the following related posts

You can view the following other posts

Solved MCQ for Computer Officer Exam part-1

0

1. Firewalls are used to protect against.
A) Unauthorized Attacks
B) External resources
C) Data Driven Attacks
D) Fire Attacks

2. A gigabyte represents
A) 1 billion bytes
B) 1000 kilobytes
C) 230 bytes
D) 1024 bytes

3. Personal computers use number of chips mounted on a main circuit board. What is the common name for such boards?
A) Daughter board
B) Mother board
C) Father board
D) Bread board

4.  In analog computer
A) Input is first converted to digital form
B) Input is never converted to digital form
C) Output is displayed in digital form
D) All of the above

5. Computer follows a simple principle called GIGO which means.
A) Garbage input good output
B) Garbage in garbage out
C) Great instructions great output
D) Good input good output

6. A data Structure where elements can be added or removed at either end but not in the middle.
A) Linked list
B) Stacks
C) Queues
D) Deque

7. Which of the following sorting algorithm is of divide and conquer type?
A) Bubble sort
B) Insertion sort
C) Quick sort
D) None of the above

8. A variable P is called pointer if
A) P contains the address of an element in DATA
B) P points to the address of first element in DATA
C) P can store only memory addresses
D) P contain the DATA and the address of DATA

9. Binary search algorithm cannot be applied to
A) Sorted linked list
B) Sorted binary trees
C) Sorted linear array
D) Pointer array

10. The time factor when determining the efficiency of algorithm is measured by
A) Counting microsecond's
B) Counting the number of key operations
C) Counting the number of statements                
D) Counting the kilobytes of algorithm
  
Answers:
1.       A) Unauthorized Attacks
2.       A) 1 billion bytes
3.       B) Mother board
4.       B) Input .... digital form
5.       B) Garbage in gar.. out
6.       D) Deque
7.       C) Quick sort
8.       A) P contains.addr .. DATA
9.       D) Pointer array
10.   A) Counting microsecond's

You may also wanted to view the following related posts

You can view the following other posts

For other more Multiple Choice Questions (MCQs): Click Here

List of Top Social Exchange sites

0
List of Top Social Exchange sites
Top Social Exchange Sites

Social Networking sites like FaceBook, Twitter, YoutTube have grown day by day and become major part of the internet. Most of the internet user have account on such Social Networking sites and uses that sites. According to the Alexa after Google the most visited sites are FaceBook and YouTube, Twitter also comes after that. So good presence on Social Networking sites is most important for Search Engine Optimization(SEO) of any websites or blogs. For the strong presence in Social Networking Sites we can use Social Exchange sites. I have presented here a list of Top Social Exchange sites.


  1.  Addmefast:   It is the most used and top social exchange site in which you can exchange for most of the social networks like Facebook page like, Facebook share, Facebook post like, Twitter tweets, Twitter Re-tweets, Twitter Followers, Google Circle, YouTube views, YouTube likes, Pinterest like, Pinterest repin, Stumbler Followers, Soundcloud Followers and many more. You can add unlimited site for promotion. I recommended this site as the best Social Networking Exchange site. Register now for this Network and get 50 points registration bonus and 50 points daily bonus.  To register for this site Click Here.
  2.  ProSites: This is also one of the Social Network Exchange site. There are distinct site for the Google plus one, Twitter Follows, Twitter Re-tweets and Facebook like/YouTube like. In this site also you can promote unlimited number of sites or blogs. If you registered  for one service, can use other services by using the same username and password. To register for this site Click Here.
  3. GetLikesPro: This is the Social Network Exchange site currently giving the the service for the FaceBook Network and going to add the other services like Google Plus One, Twitter and YouTube. In this site also you can promote unlimited number of sites or blogs. To register for this site Click Here.

The secret about that data received by the Facebook from you

0
Facebook receive variety of various kinds of data concerning you, that you would like to understand what data they collect concerning you. So, i'm writing here some data concerning this.

  1. Collects your data that is that the data that is needed once you sign on for the positioning like your name, email address, birthday, and gender. 
  2. The data you decide on to share on Facebook, like once you post a standing update, transfer a photograph, or investigate a friend's story. 
  3. Receive information concerning you whenever you move with Facebook, like once you examine another person's timeline, send or receive a message, explore for a friend or a Page, click on, read or otherwise move with things, use a Facebook mobile app, or purchase Facebook Credits or build different purchases through Facebook. 
  4. Once you post things like photos or videos on Facebook, they'll receive extra connected information (or metadata), like the time, date, and place you took the picture or video. 
  5. Receive information from the pc, mobile or different device you utilize to access Facebook, as well as once multiple users log in from identical device. This might embody your informational address and different data concerning things like your net service, location, the kind of browser you utilize, or the pages you visit. 
  6. Receive information whenever you visit a game, application, or website} that uses Facebook Platform or visit a site with a Facebook feature, generally through Cookies. This might embody the date and time you visit the site; the net address, or URL, you are on; technical data concerning the informational address, browser and also the software you use; and, if you're logged in to Facebook, your User ID. 
  7. Receive data that you simply value more highly to build public like your name, profile footage, cover photos, timeline, User ID, username, etc. and your public data are going to be accessible to the Facebook-integrated games, applications, and websites you and your friends use and can be show up once somebody will a search on Facebook or on a public computer program. 

Top 12 things needs to know by the Facebook user

0

Top 12 things needs to know by the Facebook user
1. You may not post unauthorized commercial communications (such as spam) on Facebook. 

2. You may not collect users' content or data, or otherwise access Facebook, exploitation machine-driven           means that (such as gather bots, robots, spiders, or scrapers) while not Facebook's previous permission.

3. You may not interact in unlawful multi-level selling, like a scheme, on Facebook.

4. You may not transfer viruses or alternative malicious code.

5. You may not solicit login data or access associate degree account happiness to some other person.

6. You may not bully, intimidate, or harass any user.

7. You may not post content that: is hate speech, threatening, or pornographic; incites violence; or contains status or graphic or gratuitous violence.

8. You may not develop or operate a third-party application containing alcohol-related, chemical analysis or alternative mature content (including advertisements) while not acceptable age-based restrictions.

9. You may follow our Promotions pointers and every one applicable laws if you publicize or provide any contest, giveaway, or sweepstakes (“promotion”) on Facebook.

10. You may not use Facebook to try to something unlawful, misleading, malicious, or discriminatory.

11. You may not do something that might disable, overburden, or impair the right operating or look of   Facebook, like a denial of service attack or interference with page rendering or alternative Facebook practicality.

12. You may not facilitate or encourage any violations of this Statement or Facebook's policies.
يتم التشغيل بواسطة Blogger.