Databases - Upwork

Question: Which of the following statements is wrong?
A
Truncate is faster than Delete

B
Truncate is a DDL command

C
Truncate retains the identity of the table

D
Truncate cannot be rolled back

E
Truncate removes all rows from the table

Note: Not available
1. Report
Question: The table Comments has an auto incremented column called "Commentid" and a "UserComments" column, both of which store the comments of the users visiting the site. What will be the correct query to display the latest comments first?
A
Select usercomments From Comments Order by commentid

B
Select usercomments From Comments Order by commentid desc

C
Select usercomments From Comments Order by usercomments

D
Select usercomments From Comments Order by usercomments desc

Note: Not available
1. Report
Question: Consider the following table: Order - - - - - Orderid Customerid Orderdate Comments Select ISNULL (Comments, 'No comments') AS comments From Order What will be the output of the above query?
A
The output will always be "No comments" irrespective of the value in the Comments field

B
The output will be null in all the rows

C
The output will be "No comments", when the database entry is Null

D
The output will be "No comments", when the database entry is Not Null

E
This query is erroneous

Note: Not available
1. Report
Question: What is the maximum storage capacity of XML data type in SQL SERVER 2005?
A
1GB

B
2GB

C
4GB

Note: Not available
1. Report
Question: Columns are called _____________ of a table in a relational model.
A
Tuples

B
Elements

C
Objects

D
Attributes

E
Constraints

Note: Not available
1. Report
Question: Which is the best method to handle errors and deadlocks?
A
Errors and deadlocks can be handled by using stored procedures

B
Errors and deadlocks can be handled by using cursors

C
Errors and deadlocks can be handled by using Try and Catch constructs

D
Errors and deadlocks can be handled by using inline queries

Note: Not available
1. Report
Question: Which of the following is not a Data type in the SQL SERVER 2005?
A
ntext

B
nvarchar(n)

C
xml

D
nsmallmoney

Note: Not available
1. Report
Question: Which command is used to create User defined Data Type in the SQL SERVER 2005?
A
sp_addtype

B
Create Type

C
Create Data Type

D
None of these

Note: Not available
1. Report
Question: Which of the following mechanisms is used by "ENCRYPTION by passphrase" to encrypt the data in the SQL SERVER 2005?
A
DES (Data Encryption Standard)

B
AES (Advanced Encryption Standard)

C
user defined password

Note: Not available
1. Report
Question: Which one of the following statements about Indexes is wrong?
A
Indexes are created in an existing table to locate rows more quickly and efficiently

B
It is possible to create an index on one or more columns of a table

C
A table is scanned when index is not available

D
Indexes can only be implemented on integer datatypes

Note: Not available
1. Report

First Prev 62 63 64 65 66 Next Last

Question: Which of the following statements is wrong?

Question: The table Comments has an auto incremented column called "Commentid" and a "UserComments" column, both of which store the comments of the users visiting the site. What will be the correct query to display the latest comments first?

Question: Consider the following table: Order - - - - - Orderid Customerid Orderdate Comments Select ISNULL (Comments, 'No comments') AS comments From Order What will be the output of the above query?

Question: What is the maximum storage capacity of XML data type in SQL SERVER 2005?

Question: Columns are called _____________ of a table in a relational model.

Question: Which is the best method to handle errors and deadlocks?

Question: Which of the following is not a Data type in the SQL SERVER 2005?

Question: Which command is used to create User defined Data Type in the SQL SERVER 2005?

Question: Which of the following mechanisms is used by "ENCRYPTION by passphrase" to encrypt the data in the SQL SERVER 2005?

Question: Which one of the following statements about Indexes is wrong?