Skip to main content

Posts

Showing posts from April, 2020

Format bootable pendrive - Ubuntu to Fat 32 in Ubuntu 18.04

Below were the steps to Erase bootable ubuntu pendrive. Step1: Insert the Pendrive Step 2: Open GParted App in ubuntu. Step 3: In the top right side corner, click on the dropdown to choose pendrive. Step 4: Right click on the ubuntu partition, select format to option, in that select FAT 32. Step 5: Apply the operation by click on the top middle 'Tick option'. While doing the format, this will show below error operation windows. No problem with them, just ignore it. Click 'OK'. Step 6: Once this operation completed, your pendrive spaces will become unallocated space(Its not free space). Step 7: Now select the pendrive unallocated partition, In the menu bar, click on device and It will throw a drop down. Select 'Create Partition'. Then you will get below window. Step 8:  Select msdos as partition table type. Click Apply. You will get more error like below. Just ignore them. Step 9: Once everything is done, You will again s

SQL Interview Questions- Oracle - Find top 2 department that contains more employees

Enter into mysql by using below command mysql Step1: Create a database by using below query. mysql> create database nippo; Step 2: List down the databases and check the created database is available or not. mysql> show databases; Step 3: Move within the database using below command. mysql> use nippo; Step 4: Create a table called employee. mysql> create table employee (id int primary key auto_increment, dept_name varchar(255), name varchar(255)); Step 6: Check the given columns and attributes exactly available in the table. mysql> desc employee; Step 5: Insert the values in the table. mysql> insert into employee values(NULL, 'infra', 'mika'); mysql> insert into employee values(NULL, 'infra', 'soomu'); mysql> insert into employee values(NULL, 'infra', 'mulla'); mysql> insert into employee values(NULL, 'support', 'maari'); mysql> insert into employee values(NULL,