Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” -Technology

Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” -Technology
by

1 Answer

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);
by

Related questions

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()

While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.

What is the role of database administrator? -Technology

Description : What is the role of database administrator? -Technology

Last Answer : DBA is a person who manages the database of an organisation.

A table named School (containing data of students of the whole school) is created -Technology

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.

Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology

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.

Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Description : Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Last Answer : (i) New DelhiFaridabadGurugram(ii) 2(iii) 11000(iv) Ms. Neena

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

What steps should I take when considering database administrator training?

Description : What steps should I take when considering database administrator training?

Last Answer : For this training your need to do your research and find a technical school that fits your schedule, wether online or in class. Also check the prices they vary allot form school to school.

Mr. Harry wants to draw a line chart using a list of elements named LIST. -Technology

Description : Mr. Harry wants to draw a line chart using a list of elements named LIST. -Technology

Last Answer : (i) PLINE.plot(LIST)(ii) PLINE.ylabel(“Sample Numbers”)

Which Of The following Institutions Is Responsible For The Implementation Of Reforms In Teaching Profession? Options: A) University Grants Commission. B) National Council For Teacher's Education C) National Council For Educational Research And Training D) National Institute Of Educational Planning And Administration.

Description : Which Of The following Institutions Is Responsible For The Implementation Of Reforms In Teaching Profession? Options: A) University Grants Commission. B) National Council For Teacher's ... For Educational Research And Training D) National Institute Of Educational Planning And Administration.

Last Answer : D) National Institute Of Educational Planning And Administration.

Which one of the following is not situated in New Delhi? (A) Indian Council of Cultural Relations (B) Indian Council of Scientific Research (C) National Council of Educational Research and Training (D) Indian Institute of Advanced Studies

Description : Which one of the following is not situated in New Delhi? (A) Indian Council of Cultural Relations (B) Indian Council of Scientific Research (C) National Council of Educational Research and Training (D) Indian Institute of Advanced Studies

Last Answer : Answer: D The Indian Institute of Advanced Study (IIAS) is a research institute based in Shimla, India. It was set up by the Ministry of Education, Government of India in 1964 and it started functioning from October 20, 1965.

Yesterday, Rahul created a file named detail.txt and saved it. -Technology

Description : Yesterday, Rahul created a file named detail.txt and saved it. -Technology

Last Answer : He can find his file by using Search option.

Albert works as a Website developer in Global Website Designers company. Currently he has created following tags in XML : -Technology

Description : Albert works as a Website developer in Global Website Designers company. Currently he has created following tags in XML : -Technology

Last Answer : These tags are part of XML code. These are different because XML is a case sensitive language.

Write the relationship between a database and a table. -Technology

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.

A database can have only one table. -Technology

Description : A database can have only one table. -Technology

Last Answer : False No, database does not have a limit on the number of tables. It depends on the disk space.

The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla. -Technology

Description : The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla. -Technology

Last Answer : 1. Number of fields-62. Number of records-73. If a new child joins the SummerCamp, then SummerCamp would add a record to the table.4. If a child is shifted from one group to another, then ... the SummerCamp, then SummerCamp would delete a record of that child from the table.6. Text and Date/Time.

Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

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)

Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Description : Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Last Answer : (i)(ii)(iii)(iv)

What is Database Administrator ( DBA) ?

Description : What is Database Administrator ( DBA) ?

Last Answer : Answer : In DBMS , the person or organization who has the overall responsibility of database management is called Database Administrator .

What's the average database administrator salary?

Description : What's the average database administrator salary?

Last Answer : The average database administrator's salary can range anywhere between; $30,000 and above. If you don't have a degree and a lot of experience you can start at the salary above.

What is the average salary for a database administrator?

Description : What is the average salary for a database administrator?

Last Answer : The average salary for a database administrator depends on the level of experience. The range would be lower for someone straight out of school versus someone who has been in the field for a long time.

What responsibilities does an Oracle Database Administrator have?

Description : What responsibilities does an Oracle Database Administrator have?

Last Answer : The responsibilities are quite important. Interacting with consumers and employees is a main responsibility. Database design and repair are also other main responsibilities.

Where can I train for a database administrator career?

Description : Where can I train for a database administrator career?

Last Answer : www.devry.edu This is one I found, and I know DeVery is a good technology school. But there are many other schools that will train you. Good Luck on your search!

What are the primary duties of a remote database administrator?

Description : What are the primary duties of a remote database administrator?

Last Answer : A database administrator's responsibilities can include the following tasks: future storage requirements for the database system. Creating primary database and the database tools and applications are executed on remote computers.

What exactly is a remote database administrator?

Description : What exactly is a remote database administrator?

Last Answer : Someone who's responsible for the design, implementation and maintenance of an organizations online database. They have to not only keep an eye out for any problems with the system but be ready to fix it if something's wrong.

The Perks of Being an IT Database Administrator ?

Description : The Perks of Being an IT Database Administrator ?

Last Answer : From Small to LargeIn the past, IT database administrators were only found at a few select companies. As the Information Age matured, small businesses, medium businesses, and the large businesses ... rely heavily on their database administrators to keep the company going and pay well for i

Some Duties of a Database Administrator?

Description : Some Duties of a Database Administrator?

Last Answer : As a company expands and business grows, they will have an increased need for support of their network and databases which store all of their information. Many businesses end up hiring professional database ... it so it can be altered and expanded as the needs of the business begins to change.

Oracle Database Administrator Job Tips?

Description : Oracle Database Administrator Job Tips?

Last Answer : Oracle is one of the leading producers of servers and business databases, used by thousands of businesses to run websites, manage inventory and supply chains, and keep customer records. These ... , as well as creating a well-crafted resume that highlights job experience, can significantly improv

What are the responsibilities of a Database Administrator ?

Description : What are the responsibilities of a Database Administrator ?

Last Answer : Installing and upgrading the Oracle Server and application tools. Allocating system storage and planning future storage requirements for the database system. Managing primary database structures ... tape Backing up and restoring the database. Contacting Oracle Corporation for technical support.

A relationship cannot be created with the help of a table. -Technology

Description : A relationship cannot be created with the help of a table. -Technology

Last Answer : False A relationship is a connection between two tables of data.

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

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.

What are table sections? How can they be created? -Technology

Description : What are table sections? How can they be created? -Technology

Last Answer : In HTML tables, there are three different sections: header, body and footer. These sections can be created using (header section), (body section) and (footer section) tags.e.g MonthSavings January$100February$80Sum$180

Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Description : Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Last Answer : ANSWER: B

Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute 108 B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Description : Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute 108 B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Last Answer : ANSWER: B

Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute 98 B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Description : Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute 98 B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Last Answer : ANSWER: B

Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society يادوں کی بارات‘ کس کی سوانح حيات ہے؟’ B: ANSWER فيض احمد فيض .A احمد نديم قاسمی .B احسان دانش .C جوش مليح آبادی .D

Description : Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute B. The Scientific Society C. Muhammaden Educational Conference ... : ANSWER فيض احمد فيض .A احمد نديم قاسمی .B احسان دانش .C جوش مليح آبادی .D

Last Answer : ANSWER: D

Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Description : Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Last Answer : ANSWER: B

Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Description : Sir Syed Ahmad Khan estbalished an istitution in 1864 with the objective to translate books from English to Urdu and Persian, knwon as: A. Aligarh Institute B. The Scientific Society C. Muhammaden Educational Conference D. Ghazipur Educational Society

Last Answer : ANSWER: B

10. Manav needs a loan to set up a small business. On what basis will Manav decide whether to borrow from the bank or the moneylender? Discuss. -Economics 10th

Description : 10. Manav needs a loan to set up a small business. On what basis will Manav decide whether to borrow from the bank or the moneylender? Discuss. -Economics 10th

Last Answer : Manav wants to set up a small business. He needs to keep the below-mentioned things in mind while deciding whether to borrow money from a bank or money lender: He needs to compare the interest ... eligible documents required by the banks to get his loan approved. How he wishes to repay the lender.

Manav Seva Award has been instituted in the memory of -Awards

Description : Manav Seva Award has been instituted in the memory of -Awards

Last Answer : NEED ANSWER

Manav Seva Award has been instituted in the memory of which person? -Do You Know?

Description : Manav Seva Award has been instituted in the memory of which person? -Do You Know?

Last Answer : answer:

Who is the author of the book "Manav" ? -General Knowledge

Description : Who is the author of the book "Manav" ? -General Knowledge

Last Answer : Department of Biotechnology (DBT) and Persistent Systems

'Manav Seva Award' was institutionalized in the memory of

Description : 'Manav Seva Award' was institutionalized in the memory of

Last Answer : Rajiv Gandhi

Manav Seva Award has been instituted in the memory of (1) Indira Gandhi (2) Acharya Vinoba Bhave (3) Rajiv Gandhi (4) Dr. Rajendra Prasad

Description : Manav Seva Award has been instituted in the memory of (1) Indira Gandhi (2) Acharya Vinoba Bhave (3) Rajiv Gandhi (4) Dr. Rajendra Prasad

Last Answer : Rajiv Gandhi 

A domain name ending with .org belongs to (a) an educational institution (b) an organisation -Technology

Description : A domain name ending with .org belongs to (a) an educational institution (b) an organisation -Technology

Last Answer : (b) On the Internet, all Websites owned and operated by an organisation are part of the .org domain.

. A ………………………... is constructed manually by the system administrator using the route command. A. static routing table B. dynamic routing table C. both a and b D. neither a nor b

Description : . A ………………………... is constructed manually by the system administrator using the route command. A. static routing table B. dynamic routing table C. both a and b D. neither a nor b

Last Answer : A. static routing table

In which decade was the American Institute of Electrical Engineers (AIEE) founded? -Technology

Description : In which decade was the American Institute of Electrical Engineers (AIEE) founded? -Technology

Last Answer : The IEEE (Institute of Electrical and Electronics Engineers) was formed in 1963 by the merger of the Institute of Radio Engineers (IRE, founded 1912) and the American Institute of Electrical Engineers (AIEE, founded 1884).

Damini is a programmer in an institute and is asked to handle the records -Technology

Description : Damini is a programmer in an institute and is asked to handle the records -Technology

Last Answer : FieldNameDataTypeRollNoNumberNameTextClassTextSectioTextGenderText

Mr. Ravindra wants to send some money to her wife who is in some other city. -Technology

Description : Mr. Ravindra wants to send some money to her wife who is in some other city. -Technology

Last Answer : E-banking is the easiest way to transfer money through the bank.