Databases - Upwork

Question: You have a table "engineers" with the following table structure: enggid int(4) name varchar(50) salary int(4) You want to select the top 2 engineers in the decreasing order of their salaries, starting with the maximum salary. Which of the following SQL queries will fetch this data?
A
SELECT TOP 2 * FROM engineers ORDER BY max(salary) DESC

B
SELECT TOP 2 * FROM engineers ORDER BY salary DESC, GROUP BY salary

C
SELECT TOP 2 * FROM engineers GROUP BY salary DESC

D
SELECT TOP 2 * FROM engineers ORDER BY salary DESC

E
SELECT TOP 2 [name], salary FROM engineers ORDER BY salary DESC

Note: Not available
1. Report
Question: SQL SERVER 2005 provides a new feature to enable partitioning of the data in the database. But only those database objects can be partitioned which store data in the database. In accordance with the above statement, which of the following database objects can be partitioned?
A
Functions

B
Triggers

C
Table

D
Indexes

E
Assemblies

Note: Not available
1. Report
Question: Which of the following are the SQL Transaction statements?
A
REVERT STATEMENT

B
ROLLBACK STATEMENT

C
START STATEMENT

D
COMMIT STATEMENT

E
END STATEMENT

Note: Not available
1. Report
Question: Which of the following operators perform pattern matching?
A
%

B
_ (underscore)

C
=

D
==

E
is =

Note: Not available
1. Report
Question: Which of the following statements regarding "views" are incorrect?
A
A view has a data of its own

B
Data can be inserted into the table using its own view

C
Data can be updated in the table using its own view

D
A table can be altered by altering its corresponding view

E
A View is derived from another table

Note: Not available
1. Report
Question: You have a table named 'employees', having the following structure. empid int(4) deptname varchar(50) salary int(4) And a view is created as follows: create view viemployees as select * from employees You want to insert a new row into the table having the following values: empid=1010, deptname=HR, salary=10000. Which of the following are the correct insert SQL queries?
A
insert into employees values (1010, HR, 10000)

B
insert into employees values (1010, 'HR', 10000)

C
insert into viemployees values (1010, 'HR', 10000)

D
insert into viemployees (empid, deptname, salary) values (1010, HR, 10000)

E
insert into employees (empid, deptname, salary) set values (1010, 'HR', 10000)

Note: Not available
1. Report
Question: Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY Allen 10 3000 Miller 20 1500 King 20 2200 Davis 30 5000 Which of the following sub-queries work?
A
SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id)

B
SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id)

C
SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id)

D
SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id)

E
SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))

Note: Not available
1. Report
Question: Which of the following are not Database Models?
A
Hierarchical model

B
Network model

C
Composite model

D
Relational model

E
Recursive model

Note: Not available
1. Report
Question: Which functions does the following SQL QUERY perform? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
A
It checks the current identity field value of the specified table

B
It sets the identity field value to the new reseed value

C
It sets the identity field value to 1

D
None of these

Note: Not available
1. Report
Question: You have a table named "employees" with the following table structure: empid int(4) deptname varchar(50) salary int(4) The following select query is executed on this table: SELECT * FROM employees ORDER BY deptname DESC, salary DESC What will be the output of the above query?
A
The above SQL query will give an error

B
Records will be shown with the salary field displayed in the descending order

C
Records will be shown with the deptname field in the ascending order and salary in the descending order

D
Records will be shown with the deptname field and the salary field in the descending order

E
Records will be shown in a jumbled manner

Note: Not available
1. Report

First Prev 59 60 61 62 63 Next Last

Question: You have a table "engineers" with the following table structure: enggid int(4) name varchar(50) salary int(4) You want to select the top 2 engineers in the decreasing order of their salaries, starting with the maximum salary. Which of the following SQL queries will fetch this data?

Question: SQL SERVER 2005 provides a new feature to enable partitioning of the data in the database. But only those database objects can be partitioned which store data in the database. In accordance with the above statement, which of the following database objects can be partitioned?

Question: Which of the following are the SQL Transaction statements?

Question: Which of the following operators perform pattern matching?

Question: Which of the following statements regarding "views" are incorrect?

Question: Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY Allen 10 3000 Miller 20 1500 King 20 2200 Davis 30 5000 Which of the following sub-queries work?

Question: Which of the following are not Database Models?

Question: Which functions does the following SQL QUERY perform? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

Question: You have a table named "employees" with the following table structure: empid int(4) deptname varchar(50) salary int(4) The following select query is executed on this table: SELECT * FROM employees ORDER BY deptname DESC, salary DESC What will be the output of the above query?