gs gs117 Transactions - A Simple Transaction Model - Quiz No.1
gs gs117 Database Management System Quiz
This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Transactions. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
CREATE PACKAGE
CREATE SCHEMA
CREATE CLUSTER
All of the mentioned
Question 2: In SQL, the CREATE TABLESPACE is used
To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
To create a database trigger
To add/rename data files, to change storage
All of the mentioned
Question 3: Which character function can be used to return a specified portion of a character string?
INSTR
SUBSTRING
SUBSTR
POS
Question 4: Which of the following is TRUE for the System Variable $date$?
Can be assigned to a global variable
Can be assigned to any field only during design time
Can be assigned to any variable or field during run time
Can be assigned to a local variable
Question 5: What are the different events in Triggers?
Define, Create
Drop, Comment
Insert, Update, Delete
Select, Commit
Question 6: Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?
Data Definition Language
Data Manipulation Language
Data Described Language
Data Retrieval Language
Question 9: When SQL statements are embedded inside 3GL, we call such a program as
Nested query
Nested programming
Distinct query
Embedded SQL
Question 10: _______________ provides option for entering SQL queries as execution time, rather than at the development stage.
PL/SQL
SQL*Plus
SQL
Dynamic SQL
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117
Database Management System Online Quizzes
