oracle dba beginner words

Question 1

SQL

Answer 1

Structure query language

Question 2

SQL server

Answer 2

microsoft’s own version of the sql database

Question 3

tier 3 connection

Answer 3

user who needs application to read sql for them

Question 4

tier 2 connection

Answer 4

developer who can speak sql

Question 5

tier 1 connection

Answer 5

user who goes into the server first to get into the database

Question 6

server

Answer 6

A server is a software or hardware device that accepts and responds to requests made over a network, On the Internet, the term “server” commonly refers to the computer system that receives requests for a web files and sends those files to the client.

Question 7

listener

Answer 7

The listener is a separate database server process that runs locally on the database server or remotely on the Oracle RAC environment. … Once the client is connected to the database instance successfully, it hands over the client connection to the server process.

Question 8

backup

Answer 8

a data backup is a copy of the data that we keep so as to restore our original data in the case of events such as data loss

Question 9

storage

Answer 9

Data storage refers to the use of recording media to retain data using computers or other devices. The most prevalent forms of data storage are file storage, block storage, and object storage, with each being ideal for different purposes

Question 10

binary

Answer 10

Binary (or base-2) a numeric system that only uses two digits — 0 and 1. Computers operate in binary, meaning they store data and perform calculations using only zeros and ones.

Question 11

parameter

Answer 11

the parameter is the guidelines for which the database will run, parameters tell the database what to do and where to get information

Question 12

VPN

Answer 12

A virtual private network, or VPN, is an encrypted connection over the Internet from a device to a network. The encrypted connection helps ensure that sensitive data is safely transmitted. It prevents unauthorized people from eavesdropping on the traffic and allows the user to conduct work remotely.

Question 13

network

Answer 13

A network database is a type of database model wherein multiple member records or files can be linked to multiple owner files and vice versa. Like a store where the customer and clerk can see the same information

Question 14

database

Answer 14

System intended to store , organize, retrieve data , provide protection and security

Question 15

files

Answer 15

Database Files are data files that are used to store the contents of the database in a structured format into a file in separate tables and fields. Database files are commonly used by dynamic websites (eg. Facebook, Twitter, etc.) to store data.

Question 16

disk

Answer 16

All data stored on disk, disk I/O needed to move data into main memory when needed. Data is always persisted to disk. Traditional data structures like B-Trees designed to store tables and indices efficiently on disk. Virtually unlimited database size

Question 17

data block

Answer 17

A data block is the smallest logical unit of data storage in Oracle Database. One logical data block corresponds to a specific number of bytes of physical disk space, for example, 2 KB. Data blocks are the smallest units of storage that Oracle Database can use or allocate.

Question 18

processor

Answer 18

In a relational database system the query processor is the module responsible for executing database queries. The query processor receives as input queries in the form of SQL text, parses and optimizes them, and completes their execution by employing specific data access methods and database operator implementations.

Question 19

table

Answer 19

Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.

Question 20

client

Answer 20

The client executes the database application that accesses database information and interacts with a user through the keyboard, screen, and pointing device such as a mouse. The server executes the Oracle software and handles the functions required for concurrent, shared data access to an Oracle database.

Question 21

host

Answer 21

Database host is the computer hosting your database on a MySQL server.

Question 22

application

Answer 22

A database application is a computer program whose primary purpose is retrieving information from a computerized database. From here, information can be inserted, modified or deleted which is subsequently conveyed back into the database.

Question 23

memory

Answer 23

temporary and fast information from a database

Question 24

operating system

Answer 24

An operating system allows many users to use the same hardware concurrently, i.e. in parallel, and a database system allows the same database to be concurrently accessed by many application programs.

Question 25

linux

Answer 25

an operating system

Question 26

folder

Answer 26

A folder holds one or more files, and a folder can be empty until it is filled. … Files are always stored in folders.

Question 27

data

Answer 27

Data, in the context of databases, refers to all the single items that are stored in a database, either individually or as a set. Data in a database is primarily stored in database tables, which are organized into columns that dictate the data types stored therein.

Question 28

cloud

Answer 28

A cloud database is a database service built and accessed through a cloud platform. It serves many of the same functions as a traditional database with the added flexibility of cloud computing. … Enables enterprise users to host databases without buying dedicated hardware.

Question 29

unix

Answer 29

Unix is an operating system. It supports multitasking and multi-user functionality

Question 30

query

Answer 30

A query is a request for data results, and for action on data. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data.