MS SQL Server 2005, Databases

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
Question: What exactly is a Foreign key?
A
A Foreign key is a column or a set of columns that uniquely identifies rows in a table

B
A Foreign key checks the number of columns in a table which have non-null values

C
A Foreign key is used to match columns in other tables

D
A Foreign key checks the number of rows in a table which have non-null values

Note: Not available
1. Report
Question: Which of the following is not a relational operation?
A
Restriction

B
Extraction

C
Projection

D
Intersection

E
Union

Note: Not available
1. Report
Question: Which of the following statements regarding Trigger and Stored Procedures is correct?
A
Triggers are fired manually and Stored Procedures are fired automatically

B
Triggers can call Stored Procedures but Stored Procedures cannot call Triggers

C
Both Stored Procedures and Triggers can pass parameters

D
None of These

Note: Not available
1. Report
Question: A table of employees has the following values for its salary field: 10000, 11000, 12000, 10000, 14000, 12000, 13000, 10000, 14000, 10000 What will the following query return? Select distinct (salary) from employees
A
10000, 14000, 12000, 10000, 11000

B
10000, 11000, 12000, 10000, 14000, 12000

C
10000, 11000, 14000, 12000, 13000, 10000

D
10000, 11000, 12000, 13000, 10000, 14000

E
10000, 11000, 12000, 14000, 13000

Note: Not available
1. Report
Question: Which one of the following statements regarding "views" is incorrect?
A
A view is like a window through which data on tables can be viewed or changed

B
A view is stored as a select statement only

C
A view cannot be derived from another view

D
A view has no data of its own

Note: Not available
1. Report
Question: What will the following query do? Delete Orders
A
It will remove the Orders Table from the database

B
It will remove up to 1000 rows from the Orders Table

C
It will remove all rows from the Orders Table

D
It will remove all the rows as well as the indexes and constraints from the Orders Table

E
It will produce error on execution

Note: Not available
1. Report
Question: The - (Negative) and ~(Bitwise NOT) are examples of the _________ type of operators.
A
logical

B
arithmetical

C
assignment

D
unary

Note: Not available
1. Report

First Prev 1 2 3 4 5 Next Last

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?

Question: What exactly is a Foreign key?

Question: Which of the following is not a relational operation?

Question: Which of the following statements regarding Trigger and Stored Procedures is correct?

Question: A table of employees has the following values for its salary field: 10000, 11000, 12000, 10000, 14000, 12000, 13000, 10000, 14000, 10000 What will the following query return? Select distinct (salary) from employees

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

Question: What will the following query do? Delete Orders

Question: The - (Negative) and ~(Bitwise NOT) are examples of the _________ type of operators.