Explore topic-wise MCQs in Database.

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.

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» E.
Discussion
2.

_______________ provides option for entering SQL queries as execution time, rather than at the development stage.$

A. PL/SQL
B. SQL*Plus
C. SQL
D. Dynamic SQL
Answer» E.
Discussion
3.

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» C. CHANGE
Discussion
4.

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

A. 6789
B. 2345
C. 1234
D. 456789
Answer» C. 1234
Discussion
5.

What are the different events in Triggers?

A. Define, Create
B. Drop, Comment
C. Insert, Update, Delete
D. Select, Commit
Answer» D. Select, Commit
Discussion
6.

Which of the following is TRUE for the System Variable $date$?

A. Can be assigned to a global variable
B. Can be assigned to any field only during design time
C. Can be assigned to any variable or field during run time
D. Can be assigned to a local variable
Answer» C. Can be assigned to any variable or field during run time
Discussion
7.

Which character function can be used to return a specified portion of a character string?

A. INSTR
B. SUBSTRING
C. SUBSTR
D. POS
Answer» D. POS
Discussion
8.

In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?

A. CREATE PACKAGE
B. CREATE SCHEMA
C. CREATE CLUSTER
D. All of the mentioned
Answer» C. CREATE CLUSTER
Discussion