HirePro DBMS Quiz 1

Question 1

Time: 00:00:00
Which of the following databases was the first to be created for use in business grid computing?

Oracle database

Oracle database

Google database

Google database

MongoDB

MongoDB

SQL

SQL

Question 2

Time: 00:00:00
Which PGA component holds information about binding variables and run-time buffers?

Private SQL area

Private SQL area

Session area

Session area

Stack space

Stack space

SQL area

SQL area

Question 3

Time: 00:00:00
Which of the following describes the smallest storage unit in an Oracle database?

Segment

Segment

Extent

Extent

Data Block

Data Block

Data File

Data File

Question 4

Time: 00:00:00
Which of the following groups data together logically?

Tablespace

Tablespace

Datafiles

Datafiles

objects

objects

Database

Database

Question 5

Time: 00:00:00
Which schema object instructs Oracle to establish a connection in order to access a database object remotely?

Database Link

Database Link

Data link

Data link

sequence

sequence

remote link

remote link

Question 6

Time: 00:00:00
Oracle makes a copy of the original data before making changes to it during a transaction that updates the database.
What is the name of the original copy of the altered data?

Redo Data

Redo Data

Undone Data

Undone Data

undo data

undo data

Archive Data

Archive Data

Question 7

Time: 00:00:00
Which of the following best describes the language used by application applications to query the DBMS for data?

DDL

DDL

DML

DML

Query language

Query language

Data Query

Data Query

Question 8

Time: 00:00:00
Which of the following does Data Manipulation Language not include?

UPDATE

UPDATE

CREATE

CREATE

INSERT

INSERT

DELETE

DELETE

Question 9

Time: 00:00:00
What keyword pairs with Data Control Language statements?

INSERT

INSERT

SELECT

SELECT

GRANT

GRANT

DELETE

DELETE

Question 10

Time: 00:00:00
Which of the following doesn't fit the definition of a SQL statement?

Data Definition Language

Data Definition Language

Data Control Language

Data Control Language

Data Communication Language

Data Communication Language

Data Manipulation Language

Data Manipulation Language

null
null
×

Please login to report