A Simple Transaction Model - DBMS

1.

The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints

   A.) 6789
   B.) 2345
   C.) 1234
   D.) 456789

Answer: Option 'B'

2345

2.

When SQL statements are embedded inside 3GL, we call such a program as

   A.) Nested query
   B.) Nested programming
   C.) Distinct query
   D.) Embedded SQL

Answer: Option 'D'

Embedded SQL

3.

What are the different events in Triggers?

   A.) Define, Create
   B.) Drop, Comment
   C.) Insert, Update, Delete
   D.) Select, Commit

Answer: Option 'C'

A database trigger is a procedural code that is automatically executed in response to certain events on a particular table or view in a database.

4.

Which of the following SQL command can be used to modify existing data in a database table?

   A.) MODIFY
   B.) UPDATE
   C.) CHANGE
   D.) NEW

Answer: Option 'B'

Syntax : UPDATE table_name
SET column1=value1,column2=value2,…
WHERE some_column=some_value; .

5.

Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?

   A.) Data Definition Language
   B.) Data Manipulation Language
   C.) Data Described Language
   D.) Data Retrieval Language

Answer: Option 'A'

Data Definition Language

A Simple Transaction Model - DBMS Download Pdf