Databases - Upwork

Question: Which of the following "insert queries" will be inserted in the XML field? The creation query of the table is: CREATE TABLE Branches(recordID int, description XML)
A
INSERT Into Branches(recordID, description) VALUES(1, '<log><application>Sales</application><description>The connection timed out.</description></log>')

B
INSERT UniversalLog(recordID, description) VALUES(1, 'database unavailable')

C
INSERT Into Branches(recordID, description) VALUES(1, '<log><application>Sales<description>The connection timed out')

D
XML cannot be inserted into database

E
XML can be inserted but syntax in all queries is wrong

Note: Not available
1. Report
Question: Which of the following is not an Aggregate function?
A
AVG()

B
LEN()

C
COUNT()

D
SUM()

E
MAX(column)

Note: Not available
1. Report
Question: Consider the following query: Select name from employees where name like "%_n_" Which names will be displayed?
A
Names starting with n

B
Names containing n

C
Names containing n as the second letter

D
Names containing n as the second last letter

E
Names having 3 ns

Note: Not available
1. Report
Question: You want to select a row using cursors in the table 'qlist'. Which of the following statements DECLARES a cursor 'qselect' to perform the desired operation?
A
DECLARE qselect CURSOR ON SELECT * FROM qlist

B
DECLARE qselect CURSOR FOR SELECT * FROM qlist

C
DECLARE qlist CURSOR ON SELECT * FROM qselect

D
DECLARE qselect CURSOR AS SELECT * FROM qlist

Note: Not available
1. Report
Question: Which query will be used for a particular column of a table, if 'Reading' is to be replaced by 'Writing'?
A
Update [Table Name] set [Field Name]= (replace('Reading','Writing'))

B
Update [Table Name] set [Field Name]= (replace('Writing',' Reading'))

C
Update [Table Name] set [Field Name]= (replace([Field Name],' Writing'))

D
Update [Table Name] set [Field Name]= (replace([Field Name],' Reading '))

E
Update [Table Name] set [Field Name]= (replace([Field Name],'Reading','Writing'))

F
Update [Table Name] set [Field Name]= (replace([Field Name],'Writing ','Reading'))

Note: Not available
1. Report
Question: What is wrong with the following query in accordance with performance? SELECT * FROM [Table_Name] WHERE LOWER(Field_Name) = 'name'
A
The required keyword ('name') is already in the LOWER case

B
The query requires more time to convert to the LOWER case

C
T-Sql is not case sensitive. Hence, the LOWER keyword is not required

D
Instead of '=' the operator, 'LIKE' should be used

Note: Not available
1. Report
Question: How is the following query incorrect? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)
A
In the sub-query, '*' should be used instead of 'OrderID'

B
The sub-query can return more than one row, so, '=' should be replaced with 'in'

C
The sub-query should not be in parenthesis

D
None of these

Note: Not available
1. Report
Question: Which data type in the SQL SERVER 2005 converts itself into the type of data that is inserted into it?
A
real

B
rowversion

C
type_var

D
sql_variant

E
monetary

Note: Not available
1. Report
Question: Which of the following is not a logical operator?
A
between

B
any

C
some

D
like

E
with

Note: Not available
1. Report
Question: Which of the following methods is used to backup the Transaction log on to a secondary database in order to backup and recover data in a synchronized manner?
A
Using the backup of Transaction log (ldf) file

B
Taking Backup using flat files

C
Using Log Shipping

D
Taking Database Snapshot of Transaction log

Note: Not available
1. Report

First Prev 65 66 67 68 69 Next Last

Question: Which of the following "insert queries" will be inserted in the XML field? The creation query of the table is: CREATE TABLE Branches(recordID int, description XML)

Question: Which of the following is not an Aggregate function?

Question: Consider the following query: Select name from employees where name like "%_n_" Which names will be displayed?

Question: You want to select a row using cursors in the table 'qlist'. Which of the following statements DECLARES a cursor 'qselect' to perform the desired operation?

Question: Which query will be used for a particular column of a table, if 'Reading' is to be replaced by 'Writing'?

Question: What is wrong with the following query in accordance with performance? SELECT * FROM [Table_Name] WHERE LOWER(Field_Name) = 'name'

Question: How is the following query incorrect? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

Question: Which data type in the SQL SERVER 2005 converts itself into the type of data that is inserted into it?

Question: Which of the following is not a logical operator?

Question: Which of the following methods is used to backup the Transaction log on to a secondary database in order to backup and recover data in a synchronized manner?