Question 1

Could we able to create a assembly in SQL 2005?

technology databases

True
False

Answer

Correct Option: A

Question 2

Which function takes as argument a numeric value or an expression that can be evaluated to a number.

technology databases

CEILING()
SQRT()
EXP()
FLOOR()

Answer

Correct Option: D

Question 3

How will you call a function in sql server 2005

technology databases

DatabaseName.fun.FunctionName()
DatabaseName.dbo.FunctionName()
Exercise.fun.GetFullName();
Exercise.dbo.GetFullName();

Answer

Correct Option: B

Question 4

Select from the following, Transact-SQL internal keywords

technology databases

datetime
hierarchyid
status
views
value

Answer

Correct Option: A,B,C

Question 5

How to rename a existing table.

technology databases

sp_rename TableNewName, ExistingTableName;
sp_renametable ExistingTableName, TableNewName;
sp_rename ExistingTableName, TableNewName;
sp_renametable TableNewName, ExistingTableName;

Answer

Correct Option: C

Question 6

By using TOP() can we able to update a record

technology databases

True
False

Answer

Correct Option: B

Question 7

Oracle DATE columns always contain the date but not the time fields.

technology databases

True
False

Answer

Correct Option: B

Question 8

Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.

technology databases

True
False

Answer

Correct Option: B

Question 9

In general, Oracle accepts all forms of expressions in all parts of all SQL statements.

technology databases

True
False

Answer

Correct Option: B

Question 10

You may use two consecutive minus signs in arithmetic expressions to indicate the subtraction of a negative value.

technology databases

True
False

Answer

Correct Option: B

Question 11

ALL scalar functions in Oracle return null when given a null argument

technology databases

True
False

Answer

Correct Option: B

Question 12

It is a good practice to use ROWID as a table's primary key.

technology databases

True
False

Answer

Correct Option: B

Question 13

The VARCHAR datatype specifies a variable-length character string.

technology databases

True
False

Answer

Correct Option: A

Question 14

You use comments in a SQL statement to pass hints to the Oracle optimizer

technology databases

True
False

Answer

Correct Option: A

Question 15

Oracle treats zero-length character strings as nulls.

technology databases

True
False

Answer

Correct Option: A

Question 16

During a hierarchical query, Oracle always processes the WHERE clause before the CONNECT BY clause.

technology databases

True
False

Answer

Correct Option: B

Question 17

In Oracle SQL, all set operators have equal precedence

technology databases

True
False

Answer

Correct Option: A

Question 18

In Oracle, the select list appears after the SELECT keyword and before the FROM clause.

technology databases

True
False

Answer

Correct Option: A

Question 19

The UNION ALL operator does not eliminate duplicate selected rows from the result set.

technology databases

True
False

Answer

Correct Option: A

Question 20

The ALTER SEQUENCE statement can affect only the future sequence numbers

technology databases

True
False

Answer

Correct Option: A

Description: databases Online Quiz - 147
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 147

AI Explanation

Find more quizzes from top tags