• databases Online Quiz - 90
Back
0

databases Online Quiz - 90

Description: databases Online Quiz - 90
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which of the below commands is used to find more information about the SQL Server installed such as edition, product level etc. ?

technology databases

  1. Select * from sys.servers

  2. sp_get_serverinfo

  3. select @@version

  4. sp_serverproperty

Show answer
Correct Option: C

What is ACID property?

technology databases

  1. Atomicity,Concurrently,Isolation,Durability

  2. Atomicity,Consistency,Incremental,Durability

  3. Atomicity,Consistency,Isolation and Durability

  4. Atomicity,Concurrently,Incremental,Durability

Show answer
Correct Option: A

Identity is a column that automatically generates numeric values.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the following are different locks in SQL SERVER?

technology databases

  1. Intent

  2. Shared

  3. Exclusive

  4. Delete

Show answer
Correct Option: A,B,C

Which of the following are different Isolation levels in SQL Server?

technology databases

  1. Read Uncommitted

  2. Read Committed

  3. Serializable

  4. Repeatable Read

Show answer
Correct Option: A,B,C,D

Linked Servers cannot be created to SQL and Non-SQL data sources such as Oracle, MySQL, Sybase etc.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following is a SQL Server 2005 Build number?

technology databases

  1. 10.5.1702

  2. 8.00.223

  3. 9.00.4285

  4. 7.00.1152

Show answer
Correct Option: C

Which of the following statements about subqueries are true? (Choose 3)

technology databases

  1. Subqueries can have up to 16 levels of nesting

  2. Subqueries can have up to 50 levels of nesting

  3. Subqueries returning only one row can follow “=” in a WHERE clause

  4. Subqueries returning only one row can follow “IN” in a WHERE clause

Show answer
Correct Option: A,C,D

For which of the following queries may a merge join be considered?

technology databases

  1. Outer joins

  2. Multi-table updates and deletes

  3. Equi-joins

  4. Equi-join with a text column in select list

Show answer
Correct Option: C

A UNION of two or more queries is valid provided the queries meet which of the following conditions? (Choose 3)

technology databases

  1. All select lists in the UNION must have the same number of expressions

  2. Corresponding columns must have the same column names

  3. Corresponding columns must be of the same datatype or the server must be able to implicitly convert them

  4. Corresponding columns must be in the same order

Show answer
Correct Option: A,C,D

Choose the correct statements about the union clause in ASE (Choose 2)

technology databases

  1. Duplicate rows are removed from the result set by default

  2. ASE evaluates a statement containing union operators from left to right

  3. Order by and group by clauses are not allowed in a union query

  4. The into clause can be used only in the first query

Show answer
Correct Option: A,B,D

Which of the following are true about triggers? (Choose 2)

technology databases

  1. the inserted and deleted tables are created manually

  2. triggers can be disabled using alter table

  3. a single trigger can be created for both insert and delete

  4. @@sqlstatus contains the number of rows affected

Show answer
Correct Option: B,C

Table t and trigger trig are created as follows: create table t (a int) go create trigger trig on t for insert, update, delete as begin if @@rowcount > 1 rollback trigger end go The following transaction is now executed: begin tran insert t values (1) insert t values (2) insert t select * from t insert t values (3) commit go After completing this transaction, how many rows will table t contain?

technology databases

  1. 0

  2. 1

  3. 2

  4. 3

Show answer
Correct Option: D

Which T-SQL elements can be used in a stored procedure? (Choose 2)

technology databases

  1. 'return', without a return value

  2. 'rollback transaction'

  3. 'rollback trigger'

  4. the built-in function 'update()'

Show answer
Correct Option: A,B

Which ASE table contains the source code of a stored procedure?

technology databases

  1. sysprocedures

  2. syscomments

  3. syslogs

  4. systext

Show answer
Correct Option: B

What is the maximum number of characters that can be passed to a stored procedure through a single char or varchar parameter without being truncated?

technology databases

  1. 127

  2. 255

  3. 16384

  4. equal to the server page size

Show answer
Correct Option: C

The following trigger exists: create trigger trig on t for insert, update, delete as begin print 'This is 'trig' ' end The following command is now executed: create trigger trig on t for insert as begin print 'This is 'trig' ' end After executing this command, for which DML actions on table 't' will a trigger be fired?

technology databases

  1. insert

  2. update

  3. insert, update, delete

  4. delete,update

Show answer
Correct Option: A

Creation of which DB objects will cause a DDL trigger to fire?
technology databases

  1. Index

  2. Cluster

  3. Package

  4. DB links

  5. Function

Show answer
Correct Option: A,C,E

A call statement inside the trigger body enables you to call:

technology databases

  1. Package

  2. Function

  3. Procedure

  4. Another DB trigger

Show answer
Correct Option: C
Explanation:

To answer this question, the user needs to know the purpose of a trigger and what it can do.

A trigger is a set of instructions that are automatically executed in response to certain events in the database. A call statement inside the trigger body enables you to call other procedures or functions.

Now, let's go through each option and explain why it is right or wrong:

A. Package: A package is a collection of related functions, procedures, and other program objects. While a trigger can call a procedure or a function inside a package, it cannot directly call a package.

B. Function: A function is a named PL/SQL block that returns a value. A trigger can call a function to retrieve a value and use it in the execution of the trigger.

C. Procedure: A procedure is a named PL/SQL block that performs one or more specific tasks. A trigger can call a procedure to perform a specific task as part of the execution of the trigger.

D. Another DB trigger: A trigger can call another trigger inside the same schema, but it cannot call a trigger in another schema.

Therefore, the correct answer is:

The Answer is: C. Procedure

What part of a DB trigger determines the number of times a trigger body executes?

technology databases

  1. Trigger type

  2. Trigger body

  3. Trigger event

  4. Trigger timing

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions