Databases - Upwork

Question: Consider the following tables: Customers - - - - - - - - Customerid Customername Address Orders - - - - - Orderid Customerid Orderdate Comments What will be the query to fetch Customername and 1st Orderdate for order placed by each customer?
A
Select Customers.Customername,(Select Min(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers

B
Select Customers.Customername,(Select Max(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers

C
Select Customers.Customername,(Select Orderdate From Orders Where Customers.Customerid=Orders.Customerid) From Customers

D
Select Customers.Customername,Min(Orders.Orderdate) From Orders,Customers Where Customers.Customerid=Orders.Customerid

E
None of these

Note: Not available
1. Report
Question: Which edition of the SQL SERVER 2005 will best meet the following scenario? A company has an online shopping website named www.shoppingxyz.com. It also has to handle its line of business portion. Its main server supports 4 CPUs and a multi-core processor.
A
SQL SERVER 2005 Enterprise Edition

B
SQL SERVER 2005 Standard Edition

C
SQL SERVER 2005 Workgroup Edition

D
SQL SERVER 2005 Developer Edition

E
SQL SERVER 2005 Express Edition

Note: Not available
1. Report
Question: State whether True or False. While using the Select query, the IN clause is a better choice than the EXIST clause.
A
True

B
False

Note: Not available
1. Report
Question: State whether True or False. Many-to-One is a type of relationship in RDBMS.
A
False

B
True

Note: Not available
1. Report
Question: State whether True or False. You can send emails through the Database engine.
A
False

B
True

Note: Not available
1. Report
Question: State whether True or False. The 'Having' clause can not be used when there is a 'Where' clause in the statement already.
A
True

B
False

Note: Not available
1. Report
Question: State whether True or False. Triggers can be created in Assemblies.
A
True

B
False

Note: Not available
1. Report
Question: State whether True or False. The "text" and "ntext" data type can store character based data. These data types can be used in joins.
A
True

B
False

Note: Not available
1. Report
Question: State whether True or False. The plus (+) and minus (-) operators cannot be used to perform increment/decrement operations on datetime and smalldatetime values.
A
True

B
False

Note: Not available
1. Report
Question: Consider the following table structure of employees: empid int(4) deptname varchar(50) salary int(4) Which query will be used to display the Department (deptname) that is giving the maximum salary?
A
select deptname from employees where salary =max(salary)

B
select deptname from employees where salary =max(salary) group by deptname

C
select deptname from employees where salary = (select salary from employees group by salary)

D
select deptname from employees where salary =(select max(salary) from employees)

E
select deptname from employees where salary in (select salary from employees group by salary)

F
select deptname from employees where max(salary) in (select salary from employees group by salary)

Note: Not available
1. Report

First Prev 60 61 62 63 64 Next Last

Question: Consider the following tables: Customers - - - - - - - - Customerid Customername Address Orders - - - - - Orderid Customerid Orderdate Comments What will be the query to fetch Customername and 1st Orderdate for order placed by each customer?

Question: Which edition of the SQL SERVER 2005 will best meet the following scenario? A company has an online shopping website named www.shoppingxyz.com. It also has to handle its line of business portion. Its main server supports 4 CPUs and a multi-core processor.

Question: State whether True or False. While using the Select query, the IN clause is a better choice than the EXIST clause.

Question: State whether True or False. Many-to-One is a type of relationship in RDBMS.

Question: State whether True or False. You can send emails through the Database engine.

Question: State whether True or False. The 'Having' clause can not be used when there is a 'Where' clause in the statement already.

Question: State whether True or False. Triggers can be created in Assemblies.

Question: State whether True or False. The "text" and "ntext" data type can store character based data. These data types can be used in joins.

Question: State whether True or False. The plus (+) and minus (-) operators cannot be used to perform increment/decrement operations on datetime and smalldatetime values.

Question: Consider the following table structure of employees: empid int(4) deptname varchar(50) salary int(4) Which query will be used to display the Department (deptname) that is giving the maximum salary?