IT Questions and Answers :)

Saturday, July 18, 2020

In Microsoft .Net, the value of VBNULL is

In Microsoft .Net, the value of VBNULL is

  • 0
  • 1
  • Nothing
  • -1 
In Microsoft .Net, the value of VBNULL is

EXPLANATION

Indicates that the type of a variant object is Nothing. Returned by the VarType function.
C#
public const Microsoft.VisualBasic.VariantType vbNull = 1;
 
vbNull is a Long with a value of 1. It is probably the most misunderstood constant in all of Visual Basic. It is a variable type constant like vbEmpty (0), vbInteger (2), vbLong (3) etc 

 


Share:

Which PowerShell command helps you search for cmdlets currently available to you?

Which PowerShell command helps you search for cmdlets currently available to you?

  • All-Commands
  • Get-Command
  • Search-Command
  • Find-Command 

EXPLANATION


The PowerShell Get-Command cmdlet (‘command let’) in my opinion is the first PowerShell command you should know – that is if you are new to PowerShell.
PowerShell Get-Command lists all available PowerShell Cmdlets, Functions and Modules in your computer. I guess you are already beginning to see how helpful PowerShell Get-Command can be.
This is why I said that the Get-Command is a Cmdlet you need to know. The reason is simple. If you need a Cmdlet but you don’t know the Cmdlet or you cannot remember it, PowerShell Get-Command will help you find it.


Share:

Which of the following is not considered an input device for a computer?

Which of the following is not considered an input device for a computer?

  • USB hub
  • Keyboard
  • Mouse
  • MFP printer 
Which of the following is not considered an input device for a computer?

EXPLANATION

In computing, a printer is a peripheral device which makes a persistent representation of graphics or text, usually on paper.
While most output is human-readable, bar code printers are an example of an expanded use for printers. The different types of printers include 3D printer, inkjet printer, laser printer, thermal printer, etc.


Share:

Which of the following protocols is NOT normally used by someone surfing the web?

Which of the following protocols is NOT normally used by someone surfing the web?

  • HTTP
  • RIP
  • RTSP
  • TCP 
Which of the following protocols is NOT normally used by someone surfing the web?

EXPLANATION

The Transmission Control Protocol is one of the main protocols of the Internet protocol suite. It originated in the initial network implementation in which it complemented the Internet Protocol. Therefore, the entire suite is commonly referred to as TCP/IP. 

 Hypertext Transfer Protocol (HTTP) is an application-level protocol for distributed, collaborative, hypermedia information systems.

Routing information protocol is most commonly deployed routing protocols, most of the operating windows, Linux and novel system use RIP. Routing information protocol is normally suitable for small office, medium office, branch office environment and flat networks. RIP is an interior routing protocol and used in inter-domain environment.  RIP have following three versions:

1. RIPv1 (version 1)
2. RIPv2 (version 2, VLMS and authentication support)
3. RIP NG (new generation, support IPV6)

 The Real Time Streaming Protocol is a network control protocol designed for use in entertainment and communications systems to control streaming media servers. The protocol is used for establishing and controlling media sessions between end points.
Share:

What does SQL stands for?

What does SQL stands for?

  • Just SQL
  • Simple Query Language
  • Structured Query Language
  • Server Query Language 
What does SQL stands for?

EXPLANATION

 SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system. It is particularly useful in handling structured data

SQL stands for Structured Query Language which is the best programming language held in relational database management system. SQL is mainly used to handle and manage the data. SQL is domain specific language which is used to manage the data. We need to handle structured data in so many cases. So SQL language is mainly used to manage structured data.
Following are some bullet points related to SQL Language :

1.SQL also known as – SEQUEL stands for Structured Query Language.

2.SQL is first created by IBM systems database research team in early 1970.

3.SQL is used as universal programming language to handle and manage data by multiple database management systems.

Database Management Systems which uses SQL :

1.Oracle

2.Sybase

3.Microsoft SQL Server

4.Access

5.PostgreSQL

6.MySQL

7.Ingress

4.SQL language is responsible for querying the information in specified database.

Example of query :

Fetch the data from Customer table.

Select * from Customer;

5.SQL is best performing database programming language and now a days so many giants using SQL as database programming language.

6.So many database management system depends on SQL for managing the data like- Oracle,MySQL,MS-SQL,PostgreSQL.

7.SQL uses ANSI standards which stands for American National Standard Institute.

8.SQL is used to perform multiple tasks on database – Examples – Update the data in database, Insert the data in database table.

9.There are following important SQL commands used by most of database management systems:

1.Select : Select Command is used to select data

Example : Select all data from Customer table.

    Select * from Customer;

2.Insert: Insert command is used to insert the data

Insert a data in customer table.

    Insert into Customer(Cust_id,name)

    values(‘1′,’Amit S’);

The above statement will insert data in customer table.

3.Update: Update command is used to update the data from database.

    Update Customer set Cust_id=’100′ where name=’Amit S’;

The above statement will update the customer id from 1 to 100 where name=’Amit S’

4.Delete : Delete command is used to delete the data.

    Delete from Customer where cust_id=100;

The above statement will delete the data where cust_id is 100.

10.SQL language is designed to stored the data but this data is not static data. User can modify data anytime.

These are some key points for What does SQL stand for ? Hope you get better idea about different SQL statement.

I am hoping that with this article you will get to know idea about What does SQL stands for? I have tried to give you example of each and every point.

SOURCE

https://www.complexsql.com/what-does-sql-stand-for/

 


Share:

Popular Posts