Ethiopian University Of Computer Science Students page

Ethiopian University Of Computer Science Students page technology
the application of scientific knowledge for practical purposes, especially in industry. "advances in computer technology

13/04/2018

three types of network structure are :domian,home & workgroub but what is the server name of your workgroub and home network called.....??? please put your suggestion..!

02/01/2018

InfoTechSite




•Tutorials ◦CS/IT Turotials
◦Web Designing Tutorials
◦Programming Tutorials

•MCQS ◦CS/IT MCQs
◦Web Designing MCQs
◦Programming MCQs

•Guides & Reviews ◦SEO Guides
◦Blogging Guides
◦Online Earning Guides
◦Products & Services Reviews

•Downloads
•About
= Menu =HomeTutorials→ CS/IT Turotials→ Web Designing Tutorials→ Programming TutorialsMCQS→ CS/IT MCQs→ Web Designing MCQs→ Programming MCQsGuides & Reviews→ SEO Guides→ Blogging Guides→ Online Earning Guides→ Products & Services ReviewsDownloadsAbout

InfoTechSite > CS/IT MCQs > MCQ on Basic SQL Queries with Answers set-1

MCQ on Basic SQL Queries with Answers set-1

shuseel August 23, 2014 0 Comments

CS/IT MCQs, Uncategorized

Database Management System, Multiple Choice Question (MCQ)

1. DML is provided for

A) Description of logical structure of database

B) Addition of new structure in the database system.

C) Manipulation & processing of database

D) Definition of physical structure of database system

2.’AS’ clause is used in SQL for

A) Selection operation

B) Rename Operation

C) Join operation

D) Projection Operation

3. Count function in SQL returns the number of

A) values

B) distinct values

C) groups

D) columns

4. The statement in SQL which allows to change the definition of a table is

A) Alter

B) Update

C) Cteate

D) Select

5. Which of the following is correct.

A) A SQL query automatically eliminates duplicates

B) SQL permits attribute names to be repeated in the same relation

C) A SQL query will not work if there are no indexes on the relations

D) None of the above

6. Which of the following operation is used if we are interested in only certain columns of a table?

A) PROJECTION

B) SELECTION

C) UNION

D) JOIN

7. Which of the following is a legal expression in SQL?

A) SELECT NULL FROM EMPLOYEE;

B) SELECT NAME FROM EMPLOYEE;

C) SELECT NAME FROM EMPLOYEE WHERE SALARY=NULL;

D) None of the above

8. Which of the following is a valid SQL type?

A) CHARACTER

B) NUMERIC

C) FLOAT

D) All of the above

9. Which command is used to select distinct subject (SUB) from the table (BOOK)?

A) SELECT ALL FROM BOOK

B) SELECT DISTINCT SUB FROM BOOK

C) SELECT SUB FROM BOOK

D) All of the above

10. In SQL, which of the following is not a data definition language commands?

A) RENAME

B) REVOKE

C) GRANT

D) UPDATE

Answers:

1. DML is provided for

C) Manipulation & processing of database

2.’AS’ clause is used in SQL for

B) Rename Operation

3. Count function in SQL returns the number of

A) values

4. The statement in SQL which allows to change the definition of a table is

A) Alter

5. Which of the following is correct.

D) None of the above

6. Which of the following operation is used if we are interested in only certain columns of a table?

A) PROJECTION

7. Which of the following is a legal expression in SQL?

B) SELECT NAME FROM EMPLOYEE;

8. Which of the following is a valid SQL type?

D) All of the above

9. Which command is used to select distinct subject (SUB) from the table (BOOK)?

B) SELECT DISTINCT SUB FROM BOOK

10. In SQL, which of the following is not a data definition language commands?

D) UPDATE

About shuseel

Shuseel Baral is a web programmer and the founder of InfoTechSite has over 5 years of experience in software development, internet, SEO, blogging and marketing digital products and services is passionate about exceeding your expectations.

View all posts by shuseel | Website

← Previous post

Next post →

Related Posts

•What Is PDF Reader And What It Does
•How To Start PHP With Basic Coding Scripts
•Multiple Choice Questions On PHP Basis Part-2
•Multiple Choice Questions On PHP Basis Part-1
•Top 20 MCQ Questions On Exception Handling In Java
•Top 20 Objective Questions On Applets In Java
•Top 20 MCQ Questions On Streams In Java
•MCQ On Inheritance, Package And Interface In Java










Most Popular

CS/IT MCQ Questions
DBMS MCQ Questions
Data Structure MCQs
Operating System MCQs
Software Engineering MCQs
Computer Networking MCQs
C/C++ MCQ Questions
Basic IT MCQs
System Analysis Design MCQs
Web Designing MCQs
Programming Tutorials

Advertise Here

Recent Posts
What Conditional Statements Used In PHP
4 Great Keyword Research Tools You Should be Implementing Today
What Are Different Types of PHP Operators
What is Keyword Research and How to Do It
Selecting the Perfect WordPress Theme: 10 Points to Consider

Top Categories
Blogging Guides (16)
CS/IT MCQs (190)
CS/IT Turotials (15)
Online Earning Guides (18)
Products & Services Reviews (5)
Programming MCQs (56)
Programming Tutorials (51)
SEO Guides (23)
Uncategorized (364)
Web Designing MCQs (62)
Web Designing Tutorials (62)

Find Us On FaceBook




About Us| Privacy Policy| Sitemap| Contact Us

© 2017 InfoTechSite All rights reserved.



MENU

•Tutorials ◦CS/IT Turotials
◦Web Designing Tutorials
◦Programming Tutorials

•MCQS ◦CS/IT MCQs
◦Web Designing MCQs
◦Programming MCQs

•Guides & Reviews ◦SEO Guides
◦Blogging Guides
◦Online Earning Guides
◦Products & Services Reviews

•Downloads
•About





InfoTechSite




•Tutorials ◦CS/IT Turotials
◦Web Designing Tutorials
◦Programming Tutorials

•MCQS ◦CS/IT MCQs
◦Web Designing MCQs
◦Programming MCQs

•Guides & Reviews ◦SEO Guides
◦Blogging Guides
◦Online Earning Guides
◦Products & Services Reviews

•Downloads
•About
= Menu =HomeTutorials→ CS/IT Turotials→ Web Designing Tutorials→ Programming TutorialsMCQS→ CS/IT MCQs→ Web Designing MCQs→ Programming MCQsGuides & Reviews→ SEO Guides→ Blogging Guides→ Online Earning Guides→ Products & Services ReviewsDownloadsAbout

InfoTechSite > CS/IT MCQs > MCQ on Basic SQL Queries with Answers set-1

MCQ on Basic SQL Queries with Answers set-1

shuseel August 23, 2014 0 Comments

CS/IT MCQs, Uncategorized

Database Management System, Multiple Choice Question (MCQ)

1. DML is provided for

A) Description of logical structure of database

B) Addition of new structure in the database system.

C) Manipulation & processing of database

D) Definition of physical structure of database system

2.’AS’ clause is used in SQL for

A) Selection operation

B) Rename Operation

C) Join operation

D) Projection Operation

3. Count function in SQL returns the number of

A) values

B) distinct values

C) groups

D) columns

4. The statement in SQL which allows to change the definition of a table is

A) Alter

B) Update

C) Cteate

D) Select

5. Which of the following is correct.

A) A SQL query automatically eliminates duplicates

B) SQL permits attribute names to be repeated in the same relation

C) A SQL query will not work if there are no indexes on the relations

D) None of the above

6. Which of the following operation is used if we are interested in only certain columns of a table?

A) PROJECTION

B) SELECTION

C) UNION

D) JOIN

7. Which of the following is a legal expression in SQL?

A) SELECT NULL FROM EMPLOYEE;

B) SELECT NAME FROM EMPLOYEE;

C) SELECT NAME FROM EMPLOYEE WHERE SALARY=NULL;

D) None of the above

8. Which of the following is a valid SQL type?

A) CHARACTER

B) NUMERIC

C) FLOAT

D) All of the above

9. Which command is used to select distinct subject (SUB) from the table (BOOK)?

A) SELECT ALL FROM BOOK

B) SELECT DISTINCT SUB FROM BOOK

C) SELECT SUB FROM BOOK

D) All of the above

10. In SQL, which of the following is not a data definition language commands?

A) RENAME

B) REVOKE

C) GRANT

D) UPDATE

Answers:

1. DML is provided for

C) Manipulation & processing of database

2.’AS’ clause is used in SQL for

B) Rename Operation

3. Count function in SQL returns the number of

A) values

4. The statement in SQL which allows to change the definition of a table is

A) Alter

5. Which of the following is correct.

D) None of the above

6. Which of the following operation is used if we are interested in only certain columns of a table?

A) PROJECTION

7. Which of the following is a legal expression in SQL?

B) SELECT NAME FROM EMPLOYEE;

8. Which of the following is a valid SQL type?

D) All of the above

9. Which command is used to select distinct subject (SUB) from the table (BOOK)?

B) SELECT DISTINCT SUB FROM BOOK

10. In SQL, which of the following is not a data definition language commands?

D) UPDATE

About shuseel

Shuseel Baral is a web programmer and the founder of InfoTechSite has over 5 years of experience in software development, internet, SEO, blogging and marketing digital products and services is passionate about exceeding your expectations.

View all posts by shuseel | Website

← Previous post

Next post →

Related Posts

•What Is PDF Reader And What It Does
•How To Start PHP With Basic Coding Scripts
•Multiple Choice Questions On PHP Basis Part-2
•Multiple Choice Questions On PHP Basis Part-1
•Top 20 MCQ Questions On Exception Handling In Java
•Top 20 Objective Questions On Applets In Java
•Top 20 MCQ Questions On Streams In Java
•MCQ On Inheritance, Package And Interface In Java










Most Popular

CS/IT MCQ Questions
DBMS MCQ Questions
Data Structure MCQs
Operating System MCQs
Software Engineering MCQs
Computer Networking MCQs
C/C++ MCQ Questions
Basic IT MCQs
System Analysis Design MCQs
Web Designing MCQs
Programming Tutorials

Advertise Here

Recent Posts
What Conditional Statements Used In PHP
4 Great Keyword Research Tools You Should be Implementing Today
What Are Different Types of PHP Operators
What is Keyword Research and How to Do It
Selecting the Perfect WordPress Theme: 10 Points to Consider

Top Categories
Blogging Guides (16)
CS/IT MCQs (190)
CS/IT Turotials (15)
Online Earning Guides (18)
Products & Services Reviews (5)
Programming MCQs (56)
Programming Tutorials (51)
SEO Guides (23)
Uncategorized (364)
Web Designing MCQs (62)
Web Designing Tutorials (62)

Find Us On FaceBook




About Us| Privacy Policy| Sitemap| Contact Us

© 2017 InfoTechSite All rights reserved.



MENU

•Tutorials ◦CS/IT Turotials
◦Web Designing Tutorials
◦Programming Tutorials

•MCQS ◦CS/IT MCQs
◦Web Designing MCQs
◦Programming MCQs

•Guides & Reviews ◦SEO Guides
◦Blogging Guides
◦Online Earning Guides
◦Products & Services Reviews

•Downloads
•About

INFO TC
01/01/2018

INFO TC

Our 1000+ Computer Organization & Architecture questions and answers focuses on all areas of Computer Organization & Architecture subject covering 100+ topics in Computer Organization & Architecture. These topics are chosen from a collection of most authoritative and best reference books on Computer...

31/12/2017

An operator is a symbol that tells the compiler to perform specific mathematical or logical manipulations. C++ is rich in built-in operators and provide the following types of operators −
Arithmetic Operators
Relational Operators
Logical Operators
Bitwise Operators
Assignment Operators
Misc Operators

This chapter will examine the arithmetic, relational, logical, bitwise, assignment and other operators one by one.

Arithmetic Operators

There are following arithmetic operators supported by C++ language −

Assume variable A holds 10 and variable B holds 20, then −

Show Examples

Operator

Description

Example

+ Adds two operands A + B will give 30
- Subtracts second operand from the first A - B will give -10
* Multiplies both operands A * B will give 200
/ Divides numerator by de-numerator B / A will give 2
% Modulus Operator and remainder of after an integer division B % A will give 0
++ Increment operator, increases integer value by one A++ will give 11
-- Decrement operator, decreases integer value by one A-- will give 9

Relational Operators

There are following relational operators supported by C++ language

Assume variable A holds 10 and variable B holds 20, then −

Show Examples

Operator

Description

Example

== Checks if the values of two operands are equal or not, if yes then condition becomes true. (A == B) is not true.
!= Checks if the values of two operands are equal or not, if values are not equal then condition becomes true. (A != B) is true.
> Checks if the value of left operand is greater than the value of right operand, if yes then condition becomes true. (A > B) is not true.
< Checks if the value of left operand is less than the value of right operand, if yes then condition becomes true. (A < B) is true.
>= Checks if the value of left operand is greater than or equal to the value of right operand, if yes then condition becomes true. (A >= B) is not true.

28/12/2017

9 Types Of Computer Viruses That You Should Know About – And How To Avoid Them

Posted by admin on 4/14/16 • Categorized as Others

bits bytes

Being a long-term recipient of them myself, I could say with certainty that every one of us hates to be on the receiving end of viruses. While the infection that they cause to our computer and the files that they disturb are quantifiable, one thing that is beyond comprehension is the mental stress that they cause.

However, despite the aforementioned factors, only a small percentage of us want to look at the other side of the picture. However, thanks to the researchers who have spent a lot of time in this field, people like me could now concur about the programming of this viruses, along with their transmission mechanism and damage causing ability.

Even if you belong to that group of Computer users who think that learning about computer viruses isn’t worth your time – as you leave it to your antivirus like Soft2Secure to remove ransomware, let me assure you that there are some viruses that bypass the security system of your device. Thus, if you want to know what to do when such a situation arises, read on as we have got some very useful tips for you.

Here are 9 Computer Viruses that you should know about:
1. Boot Sector Virus.

Even though this virus has now become obsolete, it still pops out in one way or the other. This virus got attention when floppy disks were used to boot a computer. In modern computers, this virus could appear on the “Master Boot Record”. In the partitioned storage device of your computer, it is the first sector to take place.

However, thanks to the fact evolution of Internet, the threat of this virus is now mitigated.
2. Web Scripting Virus.

Similar to the hyperlinks that we used in Microsoft Word, many websites rest on codes to provide engaging content to their users. For example, since the trends of watching videos online have now become very popular – more than 2 Billion Videos are streamed on Facebook every day, these videos also execute a specific code.

These codes can be exploited and it is very troublesome to note that this exploitation has taken place on some very notable sites. All the hackers have to do it to leave a comment in the Comments Section of the website which contains that code. Thus, even without the Webmaster knowing it, the code gets exerted into the site.
3. Browser Hijacker.

Ever faced a problem where the homepage of your web page gets automatically directed to a particular site? Well, that is the most common way by which this ransomware hijacks your browser.

While its visual effects might epitomize the threat, this hijacker is nothing more than a tactic to increase income from web ads. However, if you still want to clean your computer from this virus, give Soft2Secure a go.
4. Resident Virus.

After inserting itself directing into the memory of your system, this virus has the capability to take a number of actions. One of its more troublesome features is its ability to run away. Leaving behind the file which was originally infected, this virus has the ability to run on its own.
5. Direct Action Virus.

Similar to the Vienna virus which shocked computers in 1998, this virus comes into action after you have executed the file. The load is delivered to your computer and the virus becomes active.

However, this virus has a limitation. It takes no action unless the file which is infected gets implemented again.
6. Polymorphic Virus.

One of the factors that epitomize the usefulness of this virus is its ability to evade. The Antivirus programs that are enabled on our computers detect the presence of any virus by detecting its code.

Polymorphic virus has exploited this limitation beautifully as it changes its code every time the infected file is executed. Thus, it becomes nearly impossible for any ordinary antivirus to track it down.
7. File Infector Virus.

Although the word “file” in its name might suggest otherwise, this virus does not take the help of files every time. In fact, the file is only the starting point as the file infector dwarfs the first file after which it re-writes the file.
8. Multipartite Virus.

If you have read carefully the aforementioned viruses, you might have noticed that they use two methods for their transmission. Either they use one method or a single payload is delivered.

However, this virus wants to claim both. Depending upon the operating system of your computer or the files that exist on your computer, it might use any of the two methods to spread.
9. Macro Virus.

Appearing in the form of a word document which seemingly links the user to pornographic websites, Melissa is one of the most known Micro Virus. Going one step further, this virus not only exploits the user but also his/her friends by mailing the copies of the infected virus document to the contact list.

If you feel that you know another significant type of virus, please feel free to let us know in the comments section.

27/12/2017

Change Domain Name Server(DNS) settings easily. – Unblock the restricted web content. – Browse faster on the net after changing to proper DNS server. – Simple UI and easy to use. – Auto change DNS when device boot completed. – Auto change DNS when mobile data on.

16/12/2017

IT Officer (Scale -I)
1.Users can configure ……. to the port level and use the remainder of the IP address for other translations.

(1) Dynamic address translations
(2) Static address translations
(3) NAT
(4) Dynamic NAT
Answer: Static address translations
2.Which is the correct statement regarding debit/smart card?

(1) Banks are generally extending this facility to saving account with liquidity features
(2) These cards facility are not extended to cash and loan account
(3) Both 1 and 2
(4) Debit card can be issued to PMRY beneficiaries
Answer: Both 1 and 2
3.The basic logic operation is-

(1) AND
(2) NOR
(3) NAND
(4) XOR

Answer: AND
4Which can not assure data accuracy in an application?

(1) Control total
(2) Limit and reasonableness test
(3) Echo checking
(4) All of these

Answer: Echo checking
5.Once object oriented programming has been accomplished, unit testing is applied for each class. class tests include-

(1) Fault-based testing
(2) Random testing
(3) Partition testing
(4) All of the above

Answer: All of the above
6.In Garner V. Murray the deficiency of the insolvent partners in borne by other partner in the
1 profit sharing ratio
2 ratio of their capitals
3 equal share by each
4 all of these
7.Which of these is a must for understanding the organisation’s business risks associated with. Using router

(1) Network Architecture
(2) Network traffic management
(3) Network security
(4) All of the above

Answer: Network Security
8.The XYZ bank has all cisco routers connected in the network. A host connects to a router through tel-net connection. Which command will the administrator Robert uses to print the messages or the console part:

(1) Terminal monitor
(2) Terminal print
(3) Console print
(4) Console monitor
Answer: Terminal Monitor
9.Which virus creates bad sectors on hard disk?
(1) Trojan’s
(2) System infectors
(3) Boot infectors
(4) Stealth viruses

Answer: Boot Infectors.
10.The area ID is a …… bit digit number that uses dotted decimal notation of the IP address
1) 8
(2) 16
(3) 32
(4) 64
Answer: 32
Share these Specialist IT officer questions with everyone you know and improve their chances of getting selected for IBPS Specialist IT Officer (Scale -I) exam

15/12/2017

1. A network that needs human beings to manually route signals is called…. A) Fiber Optic Network         B) Bus Network C) T-switched network           D) Ring network 2. TCP/IP …………….. layer corresponds to the OSI models to three layers. A) Application           B) Prese...

infotec mcq
15/12/2017

infotec mcq

Network address MCQs quiz, learn network address multiple choice questions answers, online networking quiz MCQs, size and format of physical addresses vary depending on with answer.

26/11/2017

Awash bank computer science vaccancy questions And Please Search Carefully: what is VPN?' what is client/server?'what is symbolic link and purpose of unix operating system?,what is the d/f b/n domain and workgroub?,what is the d/f b/n interior and exterior neighbour gateway? and MCQ:U should be search about the terms b/c i write only the terms:SMTP,DHCP,RMDIR.RD,HEAD,how maney hosts r in LAN?,Fiber optic cable over UTP?,How to the system adminstor creat account in domian of groub policy?,how to prevent an email information when u transfer in security mechanism?,what is loopback ip adress?,about valid host adress?,about sql,where commands in sql?, Good Luck

24/06/2017

1) What is a Link? A link refers to the connectivity between two devices. It includes the type of cables and protocols used in order for one device to be

Address

AddEthio
Debre Mark'os

Telephone

0966914001

Alerts

Be the first to know and let us send you an email when Ethiopian University Of Computer Science Students page posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Ethiopian University Of Computer Science Students page:

Share