MySQL MCQs

Name:

Set 2| Time: 20 min                        

MySQL

1) Which commend/function is used to list table information in a database:

a. Show tables;             b. Mysql_list_tables ();

c. List tables;                d. Mysql_show_tables ();

2) MySQL is

a) A Programming language       b) A Programming language

c) A technique for writing reliable programs

d) A Relational Database Management System

3) Which of the following commands should be used to create a database named “student”?

a) CREATE? I student                b) CREATE DATABASE student

c) DATABASE /student              d) DATABSE student

4) How much storage space does DATETIME require?

a.    4 bytes                          b.     2 bytes

c.    8 bytes                          d.    1 bytes

5) Which of these field types would be best to hold a .jpg image?

a) blob      b) text              c) nchar binary                  d) char binary

6) Which SQL statement is used to insert new data in a database?

                 a) INSERT NEW                 b) INSERT INTO

                 c) ADD NEW                      d) ADD ROW

7) Which Numeric Data type has the largest range?
             a. Mediumint    b. Smallint        c. Int                 d. Tinyint

8) Which of the following ways below are the correct way to get the current date?

a.    SELECT CURTIME();                       b.     SELECT CURDATE();

c.    SLELCT CURRRENT_TIME()            d.    All of the above

9) What is the default format for “Datetime” data type?

a. YYYY-MM-DD HH:MM:SS     b. MM-YYYY-DD HH:MM:SS

c. DD-YYYY-MM MI:HH:SS       d. None of these

10) The number of indexes allowed per table in MYSQL are:

                a. 16                       b. 32                      c. 64                       d. 84

11) Mysql supports both signed and unsigned data types.

                a) True                                  b) False

13) Create a database named FruitDB and create table tbl_fruit in that    database as follows (Use appropriate data type).Also insert any 2 values.

Fruit_id, name, color, cost                                                             - 4 marks

Decision Tree

Decision tree in Rapid miner

Rapid Miner is a software platform that provides a unified environment for machine learning, data mining, text mining, predictive analytics and business analytics. It is used for business and industrial applications as well as for research, education, training, rapid prototyping, and application development. It is an open source software. How to make a decision tree in Rapid miner step by step soln is given. Download the pdf file from below link.
Download from here

Some amazing & interesting sites and their links

Site link	Description
Modern.ie	to test a website and many more
Whois.net or registry.in	to check whether the website is authentic or not
Posible.com	makes your dreams possible
world4free	Download free Songs and movies
23andme	Personal DNA Test
plagiarism dection	Plagiarasm detection- Ddtect whether the contains are copied from somewhere else
indiabix	Very helpful for students about reaseaning, apptitude,programming,interview and so on
w3schools.com	Get help and tutorials of sql,join,normalization,all html,Xml related things
Oracle certification programmes	Oracle Certification Programs Global Site
CSS Generator	It can help in designing the CSS for better website design
Slamboook	make your own slambook
Online feedback	Get feedback from your friends and others online
Privenote	Send a self destructive messages.The message is destructed automatically after the user read it.
inspiredclassroom	Get all the information about the TEACHER ART
	Make attractive textures for your site easily
Ruby Monk	Learn Ruby Programming

---

How to increase internet speed ?

How to increase your internet speed without software?
Steps:

•  Start >> Run
•  Type gpedit.msc
•  This opens the Policy Editor
•  Now, Local Computer Policy >> Computer Configuration
•  Then, Administrative Templates >> Network
•  Now, click on QOS Packet Scheduler
•  Now, on Right hand side
•  Double Click Limit reservable bandwidth
•  Now in Setting Tab

NOTE

 It says : Not Configured

 Reality : The Explain Tab says "By default, the Packet Scheduler limits the system to 20 percent of the bandwidth of a connection"

•  So, on Setting Tab select Enabled
•  Now, change Bandwidth limit (%) to 0 (Zero)
• Click OK 
• That's all

Common Configuration files of Linux

Configuration files and their information

File	Information/service
aliases	Mail aliases file for use with the Sendmail and Postfix mail server. Running a mail server on each and every system has long been common use in the UNIX world, and almost every Linux distribution still comes with a Sendmail package. In this file local user names are matched with real names as they occur in E-mail addresses, or with other local addresses.
apache	Config files for the Apache web server.
bashrc	The system-wide configuration file for the Bourne Again SHell. Defines functions and aliases for all users. Other shells may have their own system-wide config files, like cshrc.
crontab and the cron.* directories	Configuration of tasks that need to be executed periodically - backups, updates of the system databases, cleaning of the system, rotating logs etc.
default	Default options for certain commands, such as useradd.
filesystems	Known file systems: ext3, vfat, iso9660 etc.
fstab	Lists partitions and their mount points.
ftp*	Configuration of the ftp-server: who can connect, what parts of the system are accessible etc.
group	Configuration file for user groups. Use the shadow utilities groupadd, groupmod and groupdel to edit this file. Edit manually only if you really know what you are doing.
hosts	A list of machines that can be contacted using the network, but without the need for a domain name service. This has nothing to do with the system's network configuration, which is done in /etc/sysconfig.
inittab	Information for booting: mode, number of text consoles etc.
issue	Information about the distribution (release version and/or kernel info).
ld.so.conf	Locations of library files.
lilo.conf, silo.conf, aboot.conf etc.	Boot information for the LInux LOader, the system for booting that is now gradually being replaced with GRUB.
logrotate.*	Rotation of the logs, a system preventing the collection of huge amounts of log files.
mail	Directory containing instructions for the behavior of the mail server.
modules.conf	Configuration of modules that enable special features (drivers).
motd	Message Of The Day: Shown to everyone who connects to the system (in text mode), may be used by the system admin to announce system services/maintenance etc.
mtab	Currently mounted file systems. It is advised to never edit this file.
nsswitch.conf	Order in which to contact the name resolvers when a process demands resolving of a host name.
pam.d	Configuration of authentication modules.
passwd	Lists local users. Use the shadow utilities useradd, usermod and userdel to edit this file. Edit manually only when you really know what you are doing.
printcap	Outdated but still frequently used printer configuration file. Don't edit this manually unless you really know what you are doing.
profile	System wide configuration of the shell environment: variables, default properties of new files, limitation of resources etc.
rc*	Directories defining active services for each run level.
resolv.conf	Order in which to contact DNS servers (Domain Name Servers only).
sendmail.cf	Main config file for the Sendmail server.
services	Connections accepted by this machine (open ports).
sndconfig or sound	Configuration of the sound card and sound events.
ssh	Directory containing the config files for secure shell client and server.
sysconfig	Directory containing the system configuration files: mouse, keyboard, network, desktop, system clock, power management etc. (specific to RedHat)
X11	Settings for the graphical server, X. RedHat uses XFree, which is reflected in the name of the main configuration file, XFree86Config. Also contains the general directions for the window managers available on the system, for example gdm, fvwm, twm, etc.
xinetd.* or inetd.conf	Configuration files for Internet services that are run from the system's (extended) Internet services daemon (servers that don't run an independent daemon).

Some Linux C Shell Commands

#	Marks a command.
alias	Displays alias.
bg	Resumes job in the background.
break	Resumes execution after the loop.
breaksw	Breaks from a switch command; resumes after the endsw command.
case	Defines a label in a switch command.
cd	Changes directory.
chdir	Changes directory, same as cd.
continue	Continues a loop.
default	Specifies the default case in a switch.
dirs	Displays the directory stack.
echo	Writes arguments to the standard output of the shell.
eval	Evaluates a command.
exec	Executes the command in the current shell.
exit	Exits the shell.
fg	Brings a job in the foreground.
foreach	Specifies a looping control statement and execute a sequence of commands until reaching an end command.
glob	Writes arguments to the standard output of the shell, like the echo command, but without the new line.
goto	Continues execution after the specified label.
hashstat	Displays hash table statistics.
history	Displays the history list.
if	Executes a command if condition met.
jobs	Lists active jobs.
kill	Sends a signal to a process. term (terminate) is the default signal.
limit	Sets or list system resource limits.
login	Logs on.
logout	Logs out.
nice	Changes the priority of commands run in the shell.
nohup	Ignores the hangup signal.
notify	Notifies the user about changes in job status.
onintr	Tells the shell what to do on interrupt.
popd	Pops the top directory off the directory stack and changes to the new top directory.
pushd	Exchanges the top two elements of the directory stack.
rehash	Re-computes the hash table of the contents of the directories in the path shell variable.
repeat	Repeats the execution of a command.
set	Displays or set the value of a shell variable.
setenv	Sets environment variables.
shift	Shifts shell arguments.
source	Reads commands from a script.
stop	Stops a background job.
suspend	Stops the current shell.
switch	Starts a switch.
time	Displays the time used to execute commands.
umask	Shows or set file permissions.
unalias	Removes command alias.
unhash	Disables the internal hash table.
unlimit	Removes limitations on system Resource.
unset	Deletes shell variables.
unsetenv	Deletes environment variables.
wait	Waits for background jobs to complete.
while …end	Executes the commands between the while and matching end statements repeatedly.
@	Displays or set the values of all the shell variables.

Do you have a problem with Micromax modem in windows 8. Here is a soluation

Currently Micromax MMX352G modem doesn’t support windows 8 by default, but there is a workaround for this.

To connect the modem in windows 8 follow these steps.

---

1.Insert the MMX352G modem in usb slot, Then it will ask to tap or click the message that appears.

---

2.Click the message, it will show various options, Do not autorun, click on open folder in windows explorer.

---

3.Now right click on showmodem.exe and select properties, then click on compatibility tab.

---

4.select windows 7 in run this program in compatibility mode for and check the check box of run this program as administrator. Click on ok.

---

5.Now double click or run the showmodem.exe and install the drivers.

---

6.Restart your computer.

---

7.Again insert your modem in usb slot and run the MMX352G usb manager.

---

8.Now open device manager and uninstall the following devices.

---

9.Uninstall Mobile connector (Modem)

---

10.Uninstall Device Application Interface (Ports)

---

11.Uninstall Device Diagnostic Interface (Ports)

---

12.Uninstall Device Pipe (Ports)

---

13.After uninstalling check for hardware changes and restart MMX352G usb manager.

Some list of C/C++ Projects

• BOOK STALL AUTOMATION SYSTEM
• Data Encryption and Decryption using some specified algorithm
• Departmental Store
• Employee Information System
• Employee Pay Slip
• FAST FOOD MANAGEMENT SYSTEM
• GAME GUESS THE NUMBER
• Hardware management system
• Hospital management
• Inventory Management System
• Library management System
• Mobile billing System
• MOBILE INFORMATION SYSTEM
• Movie Stall Management System 
• Online Movie Ticket Reservation
• PERSONAL DIARY
• POSTAL Manegement system
• RAILWAY RESERVATION SYSTEM
• Report card generation
• Restaurant Billing System
• Salary Management System
• SCIENTIFIC CALCULATOR
• STUDENT ATTENDENCE MANAGEMENT SYSTEM
• STUDENT GRADING SYSTEM
• STUDENT MANAGEMENT SYSTEM
• Telephone billing system
• Telephone Directory
• TextEditor
• Tic Tac Toe Game
• Ticket Reservation System(AIRWAYS)
• Travel Agency
• Typing Practice System
• University Course Details Management system

Do You Need a Nepali Calender

Calender 2071

Some Command Tricks

C/C++ MCQS

1)
#include <stdio.h>
#define a 10
main()
{
#define a 100
printf("%d",a);
}

option
1) 10
2) 100

2)

enum colors {BLACK,BLUE=10,GREEN}
main()
{
printf("%d..%d..%d",BLACK,BLUE,GREEN);
return(1);
}

1)BLACK..BLUE..GREEN
2) 0..1..2
3)0..10..11
4)0..10..2

3)
void main()
{
char far *farther,*farthest;
printf("%d..%d",sizeof(farther),sizeof(farthest));
}

Option
1)1,1
2)4,4
3)4,2

4)
main()
{
int i=400,j=300;
printf("%d..%d");
}

1) 300,400
2) 400,300
3) garbage value

5)

main()
{
int i=1;
while (i<=5)
{
printf("%d",i);
if (i>2)
goto here;
i++;
}
}
fun()
{
here:
printf("PP");
}

Option

1)error
2) 1 2 3 PP
3)1 2 3 PP 4 PP 5 PP

Answers:

1) 2
2) 3
3) 3
4) 2
5) 1