Description : Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” -Technology
Last Answer : i. Select count(name) from training where name like ‘Ms.%’;ii. Select * from training where fee is NULL;iii. Select city, fee from training where topic = ‘Cyber Security’;iv. Alter table training add feedback varchar(20);
Description : Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology
Last Answer : ALTERUPDATEIt s a DDL command.It s a DML command.It can be used for the following purpose:To add a new column.To remove an existing column.To modify a column.To add/remove a constraint.It s ... Delhi ;suitable command:(i)Show Databases(ii) Use City(iii) Drop Database Clients(iv) Drop table Club
Description : A table named School (containing data of students of the whole school) is created -Technology
Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.
Description : In URL http://www.cbse.nic.in/ is a …………. protocol. -Technology
Last Answer : In URL http://www.cbse.nic.in/ is a http protocol.
Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology
Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)
Description : Consider the following database Student:Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded -Technology
Last Answer : 1. 95.42. Mohan Garg and scholarship awarded is 50000.3. 54. 6
Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology
Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)
Description : RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology
Last Answer : (b) RDBMS stands for Relational Database Management System, which provides the operator to manipulate the data stored in the database table.
Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology
Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.
Description : Yesterday, Rahul created a file named detail.txt and saved it. -Technology
Last Answer : He can find his file by using Search option.
Description : Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology
Last Answer : SQL command to add a primary key column:Alter table employee add empid int primary key;Importance of Primary key in a table:Primary key column is used to uniquely identify each record of the table. A column defined as primary key cannot have a duplicate entry and can't be left blank.
Description : Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology
Last Answer : No, above commands will not be able to achieve desired task as update and alter commands have been interchanged.In order to achieve desired result, following corrections should be incorporated in the previously used ... give an increase of 50 Rs. to all the books:Update library set price=price+50;
Description : is_connected() is the MYSQL function to : -Technology
Last Answer : (e)verify whether the python application is connected to mysql database.
Description : Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology
Last Answer : (i) Where clause is used to show data set for a table based on a condition and having clause is used to put condition on the result set that comes after using Group by clause.(ii) COUNT ... unique as single column or combined multiple columns to the table. They are all candidates for Primary Key.
Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology
Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)
Description : What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software? -Technology
Last Answer : MySQL is a Relational Database Management System (RDBMS), used for adding, accessing and processing data in a database. Abhay can download the MySQL software setup from Internet.
Description : The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology
Last Answer : (d)Aggregate Function
Description : How can you add a record in the table in Datasheet View? -Technology
Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3When you have finished adding records in the datasheet, save it and close it.
Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology
Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.
Description : Empty entries in a mysql/php5 site database,... why?
Last Answer : How are you migrating the database? What are you using to export and import?
Description : Is there any difference in terms of performance to build my website's database using PostGreSQL than to built it using MySQL?
Last Answer : A few years back, the choice was between raw speed, in which case you chose MySQL, and features and reliability, in which case you chose PostgreSQL. (If you needed speed, features, and reliability, ... is what databases are built to do, but in older versions of MySQL there was simply no alternative.
Description : What MySQL database admin app should I be using?
Last Answer : I use CocoaMySQL
Description : Which database is the choice of yours: MYSQL vs POSTGRESQL vs SQL?
Last Answer : I think MYSQL is the best for me and I used it also it is so easy to use and very popular. I used it since January 2018, I recommend to you it to you
Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned
Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content
Description : Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System
Last Answer : Amazon Relational Database Service
Description : In JDBC ........................ imports all Java classes concerned with database connectivity. A) javax.sql.* B) java.mysql.* C) java.sql.* D) com.*
Last Answer : C) java.sql.*
Description : Use the add_group_column function to add a column to record group that was created at a design time?
Last Answer : False
Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE
Last Answer : II) FALSE
Description : Add an ID column to an already existing MySQL table?
Last Answer : I’m not an expert on MySQL [@stewartwb?], but in SQLServer that works just fine. Add the column and set the identity property and it autogenerates. What happens when you try that in MySQL? Do you get an error? or does it just not populate?
Description : Define database management system. Write two advantages of using database management system for school. -Technology
Last Answer : Database Management System (DBMS) is a collection of programs that enable users to create, maintain database and control all the access to the database. The primary goal of the DBMS is to ... centralized location.2. It provides security to the personal information of the school, stored in it.
Description : Write a statement in HTML that inserts an image named ‘school.jpg’ found in the ‘images’ folder of the current folder. -Technology
Last Answer :
Description : How can a fifth grader in the US can take admission in an India CBSE school in middle of a session?
Last Answer : answer:I live in the US, but I've had a fair amount of experience with foreign students in private schools. I'm also not sure if this is a government or private school that your child would be going ... could start at the end of a break, so he could begin the coursework with all the other children.
Description : ‘Rapid improvement in technology has been one major factor that has stimulated the globalisation process. Explain. [CBSE 2008(F)] Or Explain the role of technology in stimulating globalisation process. -SST 10th
Last Answer : Rapid improvement in technology has been one major factor that has stimulated the globalisation process. For instance, the past fifty years have seen several improvements in transportation technology. This has ... electronic mail (e-mail) and talk (voice-mail) across the world at negligible costs.
Description : Q.4. Write about the different innovations in printing technology during the 19th century? [CBSE Sept. 2010] -History
Last Answer : (i) By the mid-nineteenth century, Richard M. Hoe of New York had perfected the power-driven cylindrical press. This was capable of printing 8,000 sheets per hour. This press was ... time. (iii) From the turn of the twentieth century, electrically operated presses accelerated printing operations.
Description : Do you know webhosting server including with these details: free, about 1-2 gigabytes, php script OK, mysql OK, no adds on site?
Last Answer : Hosting a free Wordpress blog. Interesting. Did you try wordpress.com? Most hosts aren’t going to offer those serviced ad-free for free. I can’t think of a single one. Everyone needs a business model. And even if I found one, I certainly wouldn’t trust it for stability and security.
Description : how to change root password in linux. -Technology
Last Answer : Open your terminal and enter "sudo passwd root" without ""
Description : Aayush wants to send highly sensitive form data such as username and password -Technology
Last Answer : POST METHODAppends form-data inside the body of the HTTP request (data is not shown in URL)Form submissions with POST cannot be bookmarked
Description : Write the Django command to start a new app named ‘users’ in an existing project? -Technology
Last Answer : python manage.py startapp users
Description : Jim Smith, the project manager for a high-profile project, has permitted the users to add additional features to the systems project. The schedule and costs are now running over. This project suffers from poor standards.
Last Answer : Ans: False
Description : A new text document can be created by (a) File —> Open (b) File —> New —> Blank Document —> Create -Technology
Last Answer : (b) Steps to create a new document.File —> New —> Blank Document —> Create
Description : When the Edit Individual Documents option is selected, how does each letter appear in the new document created after the merge? -Technology
Last Answer : (b) When the Edit Individual Documents option is selected, separate sections for each letter appear in the new document created after the merge.
Description : What is part of a database that holds only one type of information? -Technology
Last Answer : Field. Record. is the answer
Description : A software that searches through a database of Web pages for particular information is known as (a) domain -Technology
Last Answer : (d) Search engine searches a software through a database of Web pages for particular information.
Description : Give any one use of database. -Technology
Last Answer : A database is used to store logically related information in the table.
Description : Explain Database Management. What are the features of DBMS? -Technology
Last Answer : It refers to the software that is responsible for storing, maintaining and utilising a database. It enables a user to define, create and maintain the database and provide controlled access on it. A ... Data security e.g. MS-Access, Corel Paradox, Lotus Approach, MySQL, OpenOffice.org Base etc.
Description : What is database? Give example. -Technology
Last Answer : A collection of related information organized as tables is known as the database, e.g. INGRES, MySQL etc.
Description : Write the relationship between a database and a table. -Technology
Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.
Description : Write any two advantages of using database. -Technology
Last Answer : 1. Can ensure data security.2. Reduces the data redundancy.
Description : What is field in database? Give an example. -Technology
Last Answer : A field is an area, reserved for a specific piece of data. It is also known as an attribute, e.g. Customer_Name.