Chapt 7

Question 1

an employee at your office just got married and changed their last name. which command do you use to change their last name in the employee database?

modify, edit, update, alter

Answer 1

update

Question 2

oscar’s user account has been granted permissions to view the database. nathan then uses the deny command in an attempt to deny oscar the ability to view the database and applies it to a group to which oscar belongs. which of the following are true?

a) oscar will still be able to view the database because a grant overrides a deny
b) oscar will still be able to view the database because granted permissions must be removed with the revoke command
c) oscar will no longer be able to view the database because they deny cancels the grant, giving oscar no specific permissions
d) oscar will no longer be able to view the database bacause a deny overrides a grant

Answer 2

d) oscar will no longer be able to view the database bacause a deny overrides a grant

Question 3

a database admin has created a database for her website. it contains pics of vacations that people have uploaded. in the db pictures have associated info about who uploaded them and the date. what is this an example of?

non-structured data, structured data, schema definition, semi-structured data

Answer 3

semi-structured data

Question 4

which of the following consists of columns and rows of numerical or text data?

database dump, key/value database, document database, relational database

Answer 4

relational database

Question 5

you have created a relational database. which of the following elements uniquely identifies a record in the database?

field, primary-key, foreign key, schema

Answer 5

primary key

Question 6

a school has a database with 4 tables, but needs a 5th table, which command is used to accomplish this task?

ALTER, CREATE, UPDATE, INSERT

Answer 6

CREATE

Question 7

which of the following descriptions best describes the type of structure that stores values as blobs?

document, key/value, relational, non-relational database

Answer 7

key/value

Question 8

a user is granted permissions to access a database, what is this an example of?

direct/manual access, data manipulation, data collection, data definition

Answer 8

data definition

Question 9

joe creates a database, what does he need to do next to make it useable?

run queries, import data, enable permissions, create forms

Answer 9

import data

Question 10

a database dev is working on generating queries. if the dev needs to ensure that the output of the query has data persistence, to where should the data be written?

SSD, cache, RAM, CPU

Answer 10

SSD

Question 11

an admin needs to add a column to an existing table, which command should he use?

UPDATE, INSERT, ALTER, DELETE

Answer 11

ALTER

Question 12

A database admin needs to add records into a database. which command should they use?

INSERT, CREATE, UPDATE, ALTER

Answer 12

INSERT

Question 13

Henry wants to understand which of his customers has purchased part number 234. which command should he use?

FIND, SEARCH, SELECT, QUERY

Answer 13

SELECT

Question 14

which of the following statements defines the scalability feature of a database?

a) provides much more intricate form of safety to the data
b) allows databases to stretch between onsite servers and the cloud
c) process and accesses large amount of data rapidly
d) stores data virtually and makes it available quicky

Answer 14

b) allows databases to stretch between onsite servers and the cloud

Question 15

george needs to remove a customers info completely from a table. which command should he use?

DROP, DELETE, UPDATE, ALTER

Answer 15

DELETE

Question 16

Which of the following statements most accurately describes what a primary key refers to?

a schema in a database
a table in a schema
a field in a table
a record in a table

Answer 16

a field in a table

Question 17

peter is accessing a database using JDBC connection. which of the following terms best describes the type of access he is using?

programmatic access, direct/manual access, query/report builder, user interface/utility access

Answer 17

direct/manual access

Question 18

your manager instructs you to remove a table from a database permanently. which command should you use?

DROP, ALTER, DELETE, REMOVE

Answer 18

DROP

Question 19

A medical office needs to create a solution to manage patient records. they have about 10k patients and 8 staff, they want to include notes from medical professionals, emails to and from patients, and images such as x-ray. what should they create?

primary key, spreadsheet, relational database, non-relational database

Answer 19

non-relational database

Question 20

an admin creates a field and designates it to hold integer data. a user tries to enter his name into the field, but it doesnt let him save the data, what is this an example of?

primary key, foreign key, constraints, schema rules

Answer 20

constraints

Question 21

what is the SQL command used to create queries?

Answer 21

SELECT

Question 22

what is the SQL command used to add records to a relational database?

Answer 22

INSERT

Question 23

what is the SQL command used to remove records from a relational database?

Answer 23

DELETE

Question 24

what is the SQL command used to modify data in an existing record in a relational database?

Answer 24

UPDATE

Question 25

what is the SQL command used to define a new database or table in a database?

Answer 25

CREATE

Question 26

what is the SQL command used to add, remove or modify fields in a relational database?

Answer 26

ALTER

Question 27

what is the SQL command used to delete databases or tables in a database?

Answer 27

DROP

Question 28

the rules and structure of a relational database are called what?

Answer 28

schema

Question 29

rows in a relational database are also called what?

Answer 29

records

Question 30

columns in a relational database are also called what?

Answer 30

fields

Question 31

a(n) ________ uniquely identifies a record in a relational database.

Answer 31

primary key

Question 32

data arranged in columns and rows in referred to as ________ data

Answer 32

structured

Question 33

data such as pictures, emails, and text is referred to as _____ data

Answer 33

un-structured or nonstructured

Question 34

data such as pictures, emails, and text is referred to as _____ data

Answer 34

un-structured or non-structured

Question 35

data such as pictures that have been tagged with metadata are known as ________ data

Answer 35

semi-structured

Question 36

re retrieve raw, unformatted data from a database use a(n) ________?

Answer 36

query

Question 37

to retrieve formatted data from a database, use a(n) _______?

Answer 37

report or report builder

Question 38

a(n) _________ key is one that refers to data in another table in a database

Answer 38

foreign

Question 39

two types of nonrelational databases are ______ and _____.

Answer 39

document and key/value

Question 40

limitations put on a field in a database are called?

Answer 40

constraints

Question 41

which type of key in a database table is required?

Answer 41

primary key

Question 42

stores data virtually and makes it available quickly speed, scalability, variety of data, security

Answer 42

variety of data

Question 43

processes and accesses large amount of data rapidly. speed, scalability, variety of data, security

Answer 43

speed

Question 44

provides much more intricate form of safety to the data speed, scalability, variety of data, security

Answer 44

security

Question 45

allows databases to stretch between on-site servers and the cloud speed, scalability, variety of data, security

Answer 45

scalability

Question 46

used to change or view data by directly going into the table of a database manual, direct, programmatic, utility

Answer 46

manual

Question 47

used to access the database tables directly across a network connection manual, direct, programmatic, utility

Answer 47

direct

Question 48

used to work with data in databases by accessing the data manual, direct, programmatic, utility

Answer 48

programmatic

Question 49

used to access the database tables by using a graphical interface manual, direct, programmatic, utility

Answer 49

utility

Question 50

a user, ann, is granted permissions to access a database. what is this an example of? A) data collection B) data definition C) direct/manual access D) data manipulation

Answer 50

data definition

Question 51

michael, an admin, needs to add a column to an existing table. which command should he use? A) ALTER B) INSERT C) UPDATE D) CREATE

Answer 51

ALTER - used to add, delete and modify columns

Question 52

david works as a database administrator for xyz inc. he wants to remove a column from an existing database. which of the following commands should he use to accomplish the task? A) ALTER B) DELETE C) DROP D) REMOVE

Answer 52

ALTER - used to add, remove or modify columns in a database DROP - used to remove a table or database DELETE - used to delete a record REMOVE - invalid command

Question 53

kate, a database administrator, needs to add records into a database. which command should she use? A) CREATE B) UPDATE C) ALTER D) INSERT

Answer 53

INSERT - used to insert records into an existing database

Question 54

you are creating a table in a relational database. which of the following is required? A) foreign key B) primary key C) logical schema D) constraints

Answer 54

primary key - is one or more fields whose data is used to uniquely identify a record. every table in a relational database is required to have a primary key foreign key - can contain duplicate and null values, and there are no limits to the number of foreign keys in a table constraints - ensures the accuracy and reliability of the data in the database logical schema - outlines the structure of the database, such as the tables and their fields(columns) and relationships between tables