Q. 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?

View solution

Q. Problems occurs if we don’t implement proper locking strategy

View solution

Q. Which of the following fixed database roles can add or remove user IDs?

View solution

Q. By default sql server has ___________ isolation level

View solution

Q. Which feature converts row data to column for better analytical view?

View solution

Q. Which of the following statements is/are not true for SQL profiler?

View solution

Q. Which global variables can be used to determine if a transaction is still open?

View solution

Q. Which statement is used to define a cursor?

View solution

Q. What is the default “SORT” order for a SQL?

View solution

Q. Capabilities of RAISERROR

View solution

Q. How inserting data through stored procedure do reduces network traffic and increase database performance?

View solution

Q. Stored procedures are safe from SQL injection attacks

View solution

Q. Which of the following connection type supports application role permissions and password encryption?

View solution

Q. Cursor that reflects the changes made to the database table even after the result set is returned

View solution

Q. _______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.

View solution

Q. ___________ combines the data manipulating power of SQL with the data processing power of Procedural languages.

View solution

Q. _______________ has made PL/SQL code run faster without requiring any additional work on the part of the programmer.

View solution

Q. A line of PL/SQL text contains groups of characters known as

View solution

Q. We use ______________ name PL/SQL program objects and units.

View solution

Q. A ___________________ is an explicit numeric, character, string or Boolean value not represented by an identifier.

View solution