AMCAT DBMS Quiz-1

Question 1

Time: 00:00:00

Question 1:-

Which Oracle database storage subunit is the smallest?

Data Block

Segment

Extent

Data File

Question 2

Time: 00:00:00

Question 2:-

Information stored in a database at a specific moment is referred to as _____

Instance of Database

Objects in Databases

Data structure

Database Schema

Question 3

Time: 00:00:00

Question 3:-

Which of these database models is the oldest?

Deductive

Physical

Network

Relational

Question 4

Time: 00:00:00

Question 4:-

In order to logically group data together, a ____________ is utilized.

Database

Tablespace

Datafiles

Object

Question 5

Time: 00:00:00

Question 5:-

A group of tables that are physically stored together as a single table and share a common column is known as a _______

Index

Object

Datafiles

Cluster

Question 6

Time: 00:00:00

Question 6:-

A/an is a collection of data intended for usage by various persons

Organization

Database

Relationship

Schema

Question 7

Time: 00:00:00

Question 7:-

SQL is platform independent. This statement is

true

false

correct

right

Question 8

Time: 00:00:00

Question 8:-

Which of the following describes the process of choosing the database's data access and storage options?

Logical database design

Physical database design

Testing and performance tuning

Evaluation and selecting

Question 9

Time: 00:00:00

Question 9:-

There is a partnership between the DEPARTMENT and the EMPLOYEES.

One to one relationship

One to many relationship

Many to many relationships

Many to one relationship

Question 10

Time: 00:00:00

Question 10:-

Which of the following doesn't fit into one of the three categories for action assertion classification?

Condition

Integrity Control

Authorization

Enabler

Unlock this article for Free, by logging in

Unlock this article for Free,
by logging in