Exam 1 prep

Question 1

What makes a SQL script file?

Answer 1

These are text files that contain 1 or more SQL statements that are run in some sequence of operations.

Question 2

The client server components of a relational database

Answer 2

I do not know

Question 3

What is a daemon process?

Answer 3

A background process

Question 4

Client-server communication is also known as:

Answer 4

2-Tier computing

Question 5

What does SQL most commonly stand for?

Answer 5

Structured Query Language

Question 6

Put in order the evolutionary steps databases went through?

Answer 6

File System, Hierarchical, Networked, Relational, Object Relational

Question 7

Which is not a valid language group?

Answer 7

Data Selection Language

Question 8

Which of the following is a DDL command?

Answer 8

A DROP statement

Question 9

What does the acronym ACID represent?

Answer 9

Atomic, Consistent, Isolated, and Durable

Question 10

Which command is a DCL?

Answer 10

GRANT

Question 11

Which cannot be created with the CREATE statement (multiple answers possible)?

Answer 11

row

Question 12

Which of the following is not true for the truncate command?

Answer 12

Is recoverable

Question 13

What is an optimistic (non-state aware) network connection is, and how it works

Answer 13

An optimistic connection sends a message and receives an acknowledgment, which breaks the connection to the database.

Question 14

What is DML?

Answer 14

Data Manipulation Language.

commands let you query, add, modify, or remove data from structures via SELECT, INSERT, UPDATE, and DELETE statements

Question 15

What is DDL?

Answer 15

Data Definition Language. commands let you create and modify structures in the database via CREATE, ALTER, DROP, RENAME, TRUNCATE, and COMMENT statements

Question 16

What is DCL?

Answer 16

Data Control Language. Lets you give and retrieve privileges to act in the database. GRANT, REVOKE.

Question 17

What is TCL?

Answer 17

Transaction Control Language. When you transact across more than a single table, you use SAVEPOINT, ROLLBACK, and COMMIT

Question 18

Hierarchal databases

Answer 18

This model organizes data in a tree structure with parent child data segments. Implies that a record can have repeating info generally in the child data segments. Only one parent segment with many children

Question 19

Networked databases

Answer 19

More than one parent per child. Many to many relationships in data. An owner record type can also be a member or owner in another set

Question 20

Relational databases

Answer 20

Allows the definition of data structures, storage and retrieval operations and integrity constraints. the relations between them are organized in tables. A table is a collection of records and each record in a table contains the same fields.
Each column has a unique name, eat row is unique, column values are of the same kind, sequence is insignificant, values are atomic.

Question 21

re-runnable batch or script file

SQL

Answer 21

demo file:
@create_data.sql does the job but limits to specific directory.
@C:\Data\create_data.sql
@ is synonymous with the SQL*Plus command START. This means you can also run a script file based on its relative file name: START create_data.sql

Question 22

re-runnable batch or script file

oracle

Answer 22

instead of @ use the the ?

?\redms\somescript.sql

Question 23

describe client component of the relational database

Answer 23

Client sends a request. is a command line console. It submits requests to the server-side engine and the engine returns result sets or acknowledgments of success or failure.
provides background processes that run components that support the database.
server is the listener

Question 24

‘ls’ command

Answer 24

lists whats in the current directory

Question 25

cd

Answer 25

to move directories type ‘cd’ then the extension.

‘cd Data/’

Question 26

lib folder

Answer 26

where the pre run scripts are

Question 27

how to begin with Oracle sqlplus?

Answer 27

type '$ sqlplus' then enter the username and password
! is the bang symbol
SQL> !ls 
SQL> !pwd
to run a file use @ symbol
'@create_oracle_store.sql'

Question 28

mySQL

Answer 28

-u student -p means we are using a parameter for the password.
To run a file use:
mysql> \. filename   or
source filename
use specific database:
mysql> use studentdb

Question 29

sudo:

Answer 29

use to run with elevated priviledges

Question 30

What does SQL most commonly stand for?

Answer 30

Structured Query Language