Chapt 7 Flashcards
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
update
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
d) oscar will no longer be able to view the database bacause a deny overrides a grant
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
semi-structured data
which of the following consists of columns and rows of numerical or text data?
database dump, key/value database, document database, relational database
relational database
you have created a relational database. which of the following elements uniquely identifies a record in the database?
field, primary-key, foreign key, schema
primary key
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
CREATE
which of the following descriptions best describes the type of structure that stores values as blobs?
document, key/value, relational, non-relational database
key/value
a user is granted permissions to access a database, what is this an example of?
direct/manual access, data manipulation, data collection, data definition
data definition
joe creates a database, what does he need to do next to make it useable?
run queries, import data, enable permissions, create forms
import data
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
SSD
an admin needs to add a column to an existing table, which command should he use?
UPDATE, INSERT, ALTER, DELETE
ALTER
A database admin needs to add records into a database. which command should they use?
INSERT, CREATE, UPDATE, ALTER
INSERT
Henry wants to understand which of his customers has purchased part number 234. which command should he use?
FIND, SEARCH, SELECT, QUERY
SELECT
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
b) allows databases to stretch between onsite servers and the cloud
george needs to remove a customers info completely from a table. which command should he use?
DROP, DELETE, UPDATE, ALTER
DELETE
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
a field in a table
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
direct/manual access
your manager instructs you to remove a table from a database permanently. which command should you use?
DROP, ALTER, DELETE, REMOVE
DROP
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
non-relational database
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
constraints
what is the SQL command used to create queries?
SELECT
what is the SQL command used to add records to a relational database?
INSERT
what is the SQL command used to remove records from a relational database?
DELETE
what is the SQL command used to modify data in an existing record in a relational database?
UPDATE
what is the SQL command used to define a new database or table in a database?
CREATE
what is the SQL command used to add, remove or modify fields in a relational database?
ALTER
what is the SQL command used to delete databases or tables in a database?
DROP
the rules and structure of a relational database are called what?
schema
rows in a relational database are also called what?
records
columns in a relational database are also called what?
fields
a(n) ________ uniquely identifies a record in a relational database.
primary key
data arranged in columns and rows in referred to as ________ data
structured
data such as pictures, emails, and text is referred to as _____ data
un-structured or nonstructured
data such as pictures, emails, and text is referred to as _____ data
un-structured or non-structured
data such as pictures that have been tagged with metadata are known as ________ data
semi-structured
re retrieve raw, unformatted data from a database use a(n) ________?
query
to retrieve formatted data from a database, use a(n) _______?
report or report builder
a(n) _________ key is one that refers to data in another table in a database
foreign
two types of nonrelational databases are ______ and _____.
document and key/value
limitations put on a field in a database are called?
constraints
which type of key in a database table is required?
primary key
stores data virtually and makes it available quickly
speed, scalability, variety of data, security
variety of data
processes and accesses large amount of data rapidly.
speed, scalability, variety of data, security
speed
provides much more intricate form of safety to the data
speed, scalability, variety of data, security
security
allows databases to stretch between on-site servers and the cloud
speed, scalability, variety of data, security
scalability
used to change or view data by directly going into the table of a database
manual, direct, programmatic, utility
manual
used to access the database tables directly across a network connection
manual, direct, programmatic, utility
direct
used to work with data in databases by accessing the data
manual, direct, programmatic, utility
programmatic
used to access the database tables by using a graphical interface
manual, direct, programmatic, utility
utility
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
data definition
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
ALTER - used to add, delete and modify columns
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
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
kate, a database administrator, needs to add records into a database. which command should she use?
A) CREATE
B) UPDATE
C) ALTER
D) INSERT
INSERT - used to insert records into an existing database
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
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
