Similar Collections

.

questions

Title
You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column
Problems occurs if we don’t implement proper locking strategy
Which of the following fixed database roles can add or remove user IDs
By default sql server has ___________ isolation level
Which feature converts row data to column for better analytical view?
Which of the following statements is/are not true for SQL profiler
Which global variables can be used to determine if a transaction is still open
Which statement is used to define a cursor
What is the default “SORT” order for a SQL
Capabilities of RAISERROR
How inserting data through stored procedure do reduces network traffic and increase database performance
Stored procedures are safe from SQL injection attacks
Which of the following connection type supports application role permissions and password encryption
Cursor that reflects the changes made to the database table even after the result set is returned
_______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages
___________ combines the data manipulating power of SQL with the data processing power of Procedural languages
_______________ has made PL/SQL code run faster without requiring any additional work on the part of the programmer
A line of PL/SQL text contains groups of characters known as
We use ______________ name PL/SQL program objects and units
A ___________________ is an explicit numeric, character, string or Boolean value not represented by an identifier
total questions: 204

Questions

204

Views

2038

Best Answers

299

Points

5