July 17, 2021 in C and CPP, MySql

In the Java programming language char values represent

A. Button B. Abstract C. Inner
D. Nested E. Label F. Stream
G. Sequence H. Multithreading I. Collaboration
J. State K. PreparedStatement L. Activity
M. Unicode

4.1 In the Java programming language char values represent ________ characters.
4.2 ________ is a number of lightweight processes that are run in a single process/task or
program by a single processor.
4.3 ________ classes cannot be instantiated, but they can be subclassed.
4.4 As with instance methods and variables, a ________ class is associated with an instance of its enclosing class and has direct access to that object's methods and fields.
4.5 The ________ component is generally used to show the text or string in your application that never performs any type of action.
4.6 The Java IO classes, which mostly consists of ________ and readers / writers, are addressing various purposes.
4.7 ________ is used to execute precompiled sql queries with or without parameters.
4.8 In UML the ________ Diagrams emphasize the order in which things happen.
4.9 Based upon the events that occur, the ________ diagram shows how the object changes from start to finish.
4.10 ________ diagrams are used to show workflow in parallel and conditionally. They are useful when working out the order and concurrency of a sequential algorithm.

July 17, 2021 in C and CPP, MySql

What is the basic difference between Statement interface and PreparedStatement interface?

1.7 What is the basic difference between Statement interface and PreparedStatement interface?
A) Statement interface is used for static SQL, PreparedStatement interface is used for dynamic SQL
B) There is no difference between Statement interface and PreparedStatement interface.
C) Statement interface is used for dynamic SQL , PreparedStatement interface is used for Static SQL
D) None of the above

July 17, 2021 in C and CPP, MySql

An object is implicitly passed to a method by

A. IOException static B. InvalidMarkException C. final
D. javap E. default F. ResultSet
G. private H. FlowLayout I. PreparedStatement
J. reference K. SQLException L. ReadOnlyBufferException
M. objects

4.1 A class declared as ________ cannot be inherited.
4.2 An object is implicitly passed to a method by ________.
4.3 The class variable is also called as a(n) ________ variable.
4.4 getNextException method belongs to ________ class.
4.5 The object of ________ class is thrown when an attempt is made to reset a buffer when its mark is not defined.
4.6 The jdk development tool which is used as a class file disassembler is known as ________.
4.7 A SQL statement is precompiled and stored in a ________ object.
4.8 ________ is the default access modifier for instance variables in Java.
4.9 UML depicts information systems as a collection of ________.
4.10 The default layout manager of a JPanel container is ________.

July 12, 2021 in MySql, Php, Technology, Tips and Tricks

How to create static html page from dynamic php page

Opportunity to working on live project
Learn Advance topic in low cost
Get experience certificate
Learn Advance topic in limited time period
Get job opportunity
Topic cover on fast track

<?php
include ("include/conn.php");
error_reporting(E_ALL);
ini_set('display_errors', '1');
$cmdm="select * from satta_cms";
 $resultm=mysqli_query($link,$cmdm); 
 if($rowm=mysqli_fetch_array($resultm)){ 
	 $srno=$rowm['srno']; 
	 $message1=nl2br($rowm['message1']); 
	 $message2=nl2br($rowm['message2']); 
	 $message3=nl2br($rowm['message3']); } 
date_default_timezone_set('Asia/Kolkata');
$cmd1="select * from record"; $result1=mysqli_query($link,$cmd1);
 while($row1=mysqli_fetch_array($result1)){
	  $recno=$row1['recno'];
	 $tablename=$row1['tablename'];
			
 $cmd="select * from $tablename";
$result=mysqli_query($link,$cmd);
while($row=mysqli_fetch_array($result)){
	$recname=$row['recname'];
	$recdate=$row['recdate'];
	$rec=$row['new'];
	$recdispdate=date('d-M-Y',strtotime($recdate)); 
	ob_start();
?>
 
<!DOCTYPE html>
<html lang="en">
<head>
  <?php include('common/head.php'); ?>
 <style>
 h1.text-center {
    background-color: #000000;
    color: white !important;
    padding: 15px;
    text-align: center;
}
 </style>
  </head>
  <body>
<?php include('common/nav.php'); ?>


<div class="container">
<div class="row">
<?php include('common/advertise1.php'); ?>
<div class="col-lg-12"><h1 class="text-center"><?php echo date('d-M-Y',strtotime($recdate)); ?></h1></div>
<div class="live text-center">
    <h1><img src="satta-king.gif" width="70px"></h1>
 <div id="recbadge"> <h4 id="rectime"><?php echo $rec;?></h4><h2 id="recname" class="text-uppercase"><?php echo $recname;?></div>
 </div>

</div>
<hr>

</div>


<div class="container">
<div class="row">
<div class="col-lg-12">
<?php include('common/advertise0.php'); ?>
<?php include('common/message1.php'); ?>
<?php include('common/message2.php'); ?>
<?php include('common/message3.php'); ?>
    <?php include('common/advertise.php'); ?>
<?php //$cmd="select * from record order by rectime"; include('common/record-display.php');
?>
</div>
</div>
</div>
<?php
include('common/script.php');
 ?>

  </body>
</html>
<?php


$MainDir="satta-king-result";
 if(!is_dir($MainDir))
{
	mkdir($MainDir,0777);
}
$fileName=str_ireplace(' ','-',$recname).'-'.$recdispdate;

//
//$fp=fopen($MainDir.$QuestionId.".html","w");
$fp=fopen($MainDir."/".$fileName.".html","w");
$html = ob_get_contents();
fputs($fp,$html);


  } } ?>

July 7, 2021 in C and CPP, MySql

Consider the following database tables and answer queries using SQL.

a) Consider the following database tables and answer queries using SQL.
Student (snum, sname, major, age)
Faculty (fid, fname, deptname)
Course (cname, meets_at, room, fid)
Enrolled (snum, cname)
i) Find the names of the students who have enrolled in course Database Systems.
ii) Find all the courses which are NOT using room R128.
iii) Find all the students who are in any of the courses that professor “Ajay Kumar” teaches.

July 6, 2021 in MySql, Technology, Tips and Tricks

Developer Setup: Multiconnect on Minikube

This document shows you how to set up a developer machine installation of the WhatsApp Business API client with Multiconnect on Minikube. Before you start any of these set ups, check our list of requirements.

To set up a High Availability cluster, follow these steps:

To set up a Highly Available multiconnect cluster, follow these steps:

July 5, 2021 in MySql, Only Happened In India, Php, Technology, Tips and Tricks

Server Migration Checklist

Server migration checklists

Validation Checklist

Set the hosts file to locally load services
Check to see if all required services are functioning
Check your site for 404 errors, 500 errors, PHP warnings, etc.
Update all server software to the latest version
Tune LAMP performance (Apache, MySQL, PHP)
Test the cron
Check email deliverability and email records (DKIM, SPF, etc.)
Verify mail is synced (i.e. that all messages are there and all contacts have been migrated)
Check backups are still working

Security Checklist

Audit firewall configuration
Identify and implement non-standard security requirements
Restrict access where appropriate
Implement programs to educate staff
Ensure setup is compliant with all protocols

Configuration Checklist

Analyse configurations of both old and new hosting environments
Configure web server modules (i.e. suexec, mod_php, mod_perl, mod_ssl, etc.)
Identify shared libraries and other code/program dependencies
Set up SSL certificates
Create fresh (or import existing) configuration files
Import databases
Fine-tune server performance
Check and reconfigure applications that connect from remote sources

User Account Checklist

Migrate user accounts and passwords
Consider forcing password reset on next login
Purge old/inactive accounts

File System Checklist

Ensure all files copied over
Check that permissions are correct
Crawl website to identify 404 not found errors

Final Check Checklist

Were all of the issues addressed during migration?
Was the migration painless? If not, what went wrong?
Are you happy with your new server?
What else (if anything) needs doing?

June 28, 2021 in MySql, Tips and Tricks, Ubuntu

what happened when we remove all files and folders in ubuntu from /var/log folder

Delete all of /var/log?

If you delete everything in /var/log, you will most likely end up with tons of error messages in very little time, since there are folders in there which are expected to exist (e.g. exim4, apache2, apt, cups, mysql, samba and more). Plus: there are some services or applications that will not create their log files, if they don’t exist. They expect at least an empty file to be present. So the direct answer to your question actually is “Do not do this!!!”.

How to clean log files in Linux

1.Check the disk space from the command line. Use the du command to see which files and directories consume the most space inside of the /var/log directory.

$ sudo du -h /var/log/

The du command prints the estimated disk space usage of each file and directory for the path that you specified.

The -h argument causes the command to print the information in a human-readable format.

The output of the du command :

$ sudo du -h /var/log/

4.0K /var/log/landscape
196K /var/log/apt
80M /var/log/apache2
12K /var/log/dbconfig-common
4.1G /var/log/journal/ec2d37b34f2f9fd221dd8855017d9f76
4.1G /var/log/journal
du: cannot read directory ‘/var/log/amazon/ssm/audits’: Permission denied
4.0K /var/log/amazon/ssm/audits
208K /var/log/amazon/ssm
212K /var/log/amazon
4.0K /var/log/lxd
4.0K /var/log/dist-upgrade
36K /var/log/mysql
152K /var/log/unattended-upgrades
4.5G /var/log/

List Disk Usage of current directory

 $ du -h *

After finding that my /var/log/journal folder was taking several GB, I followed:

$ sudo journalctl --vacuum-time=10d

which cleared 90%+ of it

June 5, 2021 in Learning, MySql, Technology, Tips and Tricks

What is clustering in MySQL, What Is comment in MySQL

1. What is clustering in MySQL?
2. What Is comment in MySQL?
3. Why clustering is used in MySQL?
4. How comment is useful in MySQL?
5. Column level, Table level, Database level comment.

Subscribe Our YouTube Channel for Learning

May 31, 2021 in MySql, Tips and Tricks

Mysqldump and mysql command for backup and restore example

*Mysqldump command for backup of databases, tables
*Mysql command for restore database
*How to take backup of mysql database?
*How to restore mysql database from backup?
*What command is used for MySQL database backup, MySQL database restore?

Aditya Kumar singh by profession he is a website developer, manage AWS or other server, also working on virtualization and server security, lots of websites has created by him currently running website is instadiet.in, delhijurix.com, task.soatechnology.net, laughingadda.com etc. you also visit adityakumarsingh.co.in to see their profile.

In the Java programming language char values represent