Have a Good Day!!

SQL Commands

DDL, DML, DCL & TCL COMMANDS IN SQL

DDL

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:

• ·         CREATE - to create objects in the database
• ·         ALTER - alters the structure of the database
• ·         DROP - delete objects from the database
• ·         TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
• ·         COMMENT - add comments to the data dictionary
• ·         RENAME - rename an object

DML

     Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:

ALL About Keyboard

INTRODUCTION OF KEYBOARD

Keyboard

As we all know that a Keyboard is an input device which is used for entering data with the help of letters, symbols and characters keys. It was invented by Christopher Latham Sholes.

Some of Important keys of the keyboard:

Typewriter Keys (Alpha numeric, Punctuation, Special Keys)

Function Keys (F1, F2, F3……….F12)

Enter Keys (Enter)

System Keys ( Print Screen, Caps Lock and Num Lock)

Toggle keys (Caps Lock, Num Lock & Scroll Lock)

Numeric Keys (0, 1, 2…..9)

Modifier Keys ( Ctrl, Alt & Shift)

Cursor Control Key (Left, Right, Up, Down Arrows)

Some Important Keyboard Shortcuts

Ctrl + P -> Print the current page

ALL ABOUT IBPS IT OFFICER

Syllabus & Pattern of IBPS IT Officer Exam

Dear readers, as we all know that most of us have their IT officer exam on coming 14^th & 15^th Feb. So here I am giving the  pattern and important topics of professional knowledge part of IT Officer Exam.

IBPS IT Officer consists of 200 Questions (Reasoning - 50, English - 25, Quantitative Aptitude - 50, IT Professional Knowledge - 50) and each question of IT Professional Knowledge is of 1.5 Marks (IT Professional Knowledge Mark = 50 x 1.5 = 75)..

Important Topics-

1. Data Base Management System (DBMS) – 15-20 Questions

• RDBMS
• Normalization
• Overview of SQL queries
• E- R Diagrams
• Transaction Management

2. Data Communication & Networking – 10-15 Questions

• Network Architecture
• OSI Model (Functions and protocols used in each layer)
• TCP-IP Model (TCP/IP protocol suite)
• Data Communication (Trasmission media, Transmission modes, topologies, switching methods, types of network etc.)
• IP Addressing (Subnetting)

MCQs of Computers

MCQ's of Fundamental of Computers 

(Part-3)

Portable computer also known as laptop computer, weighing between 4 and 10 pounds is called-

a)       General purpose application

b)       Internet

c)       Scanner

d)       Printer

e)       Notebook computer

Personal computers can be connected together to form a

a)       Server

b)       Supercomputer

c)        Network

d)       Enterprise

e)       None of these

Which of the following is the example of Bitrate?

a)       93.7 MHz

b)       128 Kbps

c)       2.0 TB

d)       5.3 GHz

e)       None of these

ALL ABOUT OSI MODEL

OSI MODEL

(OPEN SYSTEM INTERCONNECTION)

It is the most important topic of networking that is frequently asked in all competitive exams so I try to explain it in brief and easy manner.

OSI stands for Open system Interconnection model which is used for communication of applications over the network. It is the product of Open Systems Interconnection Project at the International Organization for the Standardization. This model defines a networking framework to implement protocols in seven layers. It is also called a seven layers model because the overall working of this model is divided into seven layers. Each layer receives the services from its lower layer and provide service to its upper layers.

The below four layers (i.e, Physical Layer, Data link Layer, Network Layer & Transport Layer) are called the host layers and above three layers of this model (i.e, Session Layer, Presentation Layer & Application Layer) are called the media layers.

PROTOCOLS and TECHNOLOGIES used in each LAYER

Application Layers : Http,https,Telnet,Rdp,Smtp,pop3,Smb,Ftp

IMPORTANT MCQ's OF COMPUTER
(PART-6)

The most widely used coding scheme is------------  

• ASCII
• Unicode
• EBCDIC
• Hexadecimal

A microprocessor is a:  

• Central processing unit on a chip
• Motherboard
• Memory module
• Transistor

A system bus:

• runs at 100 MHz.
• Transports data between the CPU and memory.
• Uses a set of serial electrical paths.
• Is always the same size.