Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology
Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);
Description : Write SQL query to create a table Inventory with the following structure : -Technology
Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :
Description : Write SQL query to create a table Player with the following structure : -Technology
Last Answer : CREATE TABLE Player(};
Description : Write SQL Query commands based on the following table: -Technology
Last Answer : This answer was deleted by our moderators...
Description : Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the 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 : Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height ... number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21
Last Answer : (C) 10
Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology
Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5
Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology
Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.
Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology
Last Answer : The update command can be used to makes changes in the rows of a table in SQL.
Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology
Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.
Description : Write a query to display customer’s name who has withdrawn the money. -Technology
Last Answer : Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';
Description : Write a query to display customer’s name along with their transaction details. -Technology
Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;
Description : Write a query to display customer’s name who have not done any transaction yet. -Technology
Last Answer : Select cust_name from customer c,transaction t where c.Acc_No!=t.Acc_No;
Description : What is better: One big SQL query or several?
Last Answer : It’s difficult without examples. But what you describe seems like a simple join.
Description : What is SQL Query ?
Last Answer : SQL Query is a query that uses SQL 's DDL and DML languages to find , display , print , and perform certain conditions in one or more tables in a database .
Description : In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed?
Last Answer : ADO.NET handles most of the database communication for you behind-thescenes. You would only use SQL statements when generating ad-hoc queries for the database. You execute SQL statements by ... returning statements, such as DELETE, INSERT INTO, or UPDATE statements, use the ExecuteNonQuery method.
Description : SQL stands for Structured Query Language Statistical Query Language Superior Questions Lot Superior Questions Lo
Last Answer : Structured Query Language
Description : What is JDBC? Describe the steps needed to execute a SQL query using JDBC.
Last Answer : Ans. The JDBC is a pure Java API used to execute SQL statements. It provides a set of classes and interfaces that can be used by developers to write database applications. The steps needed to execute a ... . 2. Execute a SQL statement. 3. Process th results. 4. Close the connection to the database.
Description : For execution of DELETE SQL query in JDBC, ............. method must be used. A) executeQuery() B) executeDeleteQuery() C) executeUpdate() D) executeDelete()
Last Answer : C) executeUpdate()
Description : ………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language
Last Answer : A) Standard query language
Description : The employee information of an Organization is stored in the relation: Employee (name, sex, salary, deptname) Consider the following SQL query Select deptname from Employee Where sex = M' ... D) Average salary of male employees in a department is more than average salary of the organization.
Last Answer : (D) Average salary of male employees in a department is more than average salary of the organization.
Description : The STUDENT information in a university is stored in the relation STUDENT (Name, Sex, Marks, DEPT_Name) Consider the following SQL Query SELECT DEPT_Name from STUDENT where SEX='M' group by ... The average marks of students is more than the average marks of male students in the University
Last Answer : (B) The average marks of male students is more than the average marks of the students in the University
Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively
Last Answer : (D) 4 and 2 respectively
Description : In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats
Last Answer : (B) Fragments
Description : Consider the following relation: Works (emp_name, company_name, salary) Here, emp_name is primary key. Consider the following SQL query Select emp_name From Works T where salary>(select avg ( ... 4) Find all employees who earn more than the average salary of all employees of their company.
Last Answer : Find all employees who earn more than the average salary of all employees of their company.
Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology
Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur
Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology
Last Answer : The correct answer is : (a) 50
Description : Write the SQL command that will display the current time and date. -Technology
Last Answer : Select now();
Description : Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology
Last Answer : i. select round(8459.2654);ii.select round(8459.2654,-2);
Description : Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology
Last Answer : commands to display:(a)“occupied” (b)“cup”
Description : Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology
Last Answer : (a)select instr 'Preoccupied' , ‘ 'cup'));(b)select left 'Preoccupied',4);
Description : Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology
Last Answer : (i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)
Description : Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology
Last Answer : The HTML code is ADMNO SNAMENAMEDOB1110MANJITRANJIT4-MAR-1998
Description : Write an HTML code to create the following table: 100 Amit 10 A -Technology
Last Answer : The HTML code is Roll NumberNameClass 100 Amit 10 A 101 Ankit 10 B 102 Arnab 10C Footer 1 Footer 2 Footer 3
Description : Write the complete … tags to create a table with the following contents. -Technology
Last Answer :
Description : In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMA C. CREATE CLUSTER D. All of theabove E. None of the above;
Last Answer : CREATE SCHEMA
Description : The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select
Last Answer : (A) Alter.
Description : Define query in the context of database. -Technology
Last Answer : A query is an inquiry into the database using the SELECT statement. These statements give you filtered data according to your conditions and specifications indicating the fields, records, and summaries which a user wants to fetch from a database.
Description : A query is used to retrieve data from the database based on one or more criteria. -Technology
Last Answer : False Because MS-Access 2007 supports the database object query.
Description : What is the purpose of SQL? -Technology
Last Answer : SQL is structured query language. It is a standard language of all the RDBMS.
Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology
Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.
Description : What is the use of COMMIT in sql ? -Technology
Last Answer : Commit is used to save all the DML transactions, and once saved they cannot be rolled back.
Description : Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology
Last Answer : (i) ASCII () function returns a number.(ii) LCASE () function returns lowercase letters .(iii) DAYNAME () function returns names of days.(iv) DAYOFWEEK () function returns weekday number
Description : To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology
Last Answer : The correct code is :SELECT ID, Salary FROM empsalaryWHERE Salary = 56000 ;
Description : Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully -managed web service that allows you to create , ... large applications into logical components that can be share stateful services and communicate in secure fashion.
Last Answer : A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud
Description : A command tab which allows to create the table in an interactive manner is called (a) Home -Technology
Last Answer : (d) MS-Access provides a command tab named Create which allows creating the table in an interactive manner.
Description : To store object like image, you need to create a field in a table, having field type as …………. . -Technology
Last Answer : To store object like image, you need to create a field in a table, having field type as OLE Object.
Description : Cellspacing is used to create space between different…………… in a table. -Technology
Last Answer : Cellspacing is used to create space between different cells in a table.
Description : Mrs. Sharma is the classteacher of Class ‘XII A’. She wants to create a table ‘Student’ to -Technology
Last Answer : (i) RolINo, Name can be the attributes of Student table.(ii) Primary key of the table Student is RolINo, because RolINo is a field in Student table which uniquely identifies each rows/records in a database table.