Unit-II RDBMS - Revision Q & A

Unit-II RDBMS - Revision Q & A

University

30 Qs

quiz-placeholder

Similar activities

UTS Bahasa Pemrogaman II Semester 4A , B & C

UTS Bahasa Pemrogaman II Semester 4A , B & C

University

25 Qs

CCC16 - Chapter 5 - Presentation

CCC16 - Chapter 5 - Presentation

University

25 Qs

Pag-ahon

Pag-ahon

University

25 Qs

Ulangan Harian

Ulangan Harian

University

25 Qs

IT 104A Quiz - Module 3

IT 104A Quiz - Module 3

University

25 Qs

Speed Cup de Ingeniería 2022 (Nivel Avanzado)

Speed Cup de Ingeniería 2022 (Nivel Avanzado)

University

25 Qs

SQL Basics

SQL Basics

University

29 Qs

Chapter 5.3

Chapter 5.3

University

26 Qs

Unit-II RDBMS - Revision Q & A

Unit-II RDBMS - Revision Q & A

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Ajitha Padmanabhan

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

A personal database system assumes that no transactions will happen at the same

time on one table. So the tables are not locked by the database system. This concept is known as

______________ This concepts leads to an error.

Optional Locking, update

No Locking, Update

Optional Locking, Insert

No Locking, Insert

2.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

A personal database management system does not lock table automatically.

True

False

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Expand CTL

Create Transaction Log

Central Transaction Lock

Central Transaction Log

Correct Transaction Log

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

ORACLE 9i is a client/server database based on ____________________

database model

relational object oriented model

object based database model

relational database model

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Dynamic SQL execution commands, such as ____________which integrate the

standard SQL statements with a procedural programming language

INSERT and UPDATE

INSERT and DELETE

PREPARE and OPEN

UPDATE and ALTER

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Client communicate with the ORACLE database server through a middle ________ an

interface through a web browser.

SQL* Plus

iSQL* Plus

Query

none of the above

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

__________is an ORACLE‟s extension to SQL for creating procedural code to manipulate data.

SQL

iSQL

DML

PL/SQL

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?