Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Power Point And U Certify > Chapt 7 > Flashcards

Chapt 7 Flashcards

1
Q

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

A

update

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

semi-structured data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

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

A

relational database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

field, primary-key, foreign key, schema

A

primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

CREATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

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

A

key/value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

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

A

data definition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

run queries, import data, enable permissions, create forms

A

import data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

SSD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

UPDATE, INSERT, ALTER, DELETE

A

ALTER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

INSERT, CREATE, UPDATE, ALTER

A

INSERT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

FIND, SEARCH, SELECT, QUERY

A

SELECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

DROP, DELETE, UPDATE, ALTER

A

DELETE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

a field in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

direct/manual access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

DROP, ALTER, DELETE, REMOVE

A

DROP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

non-relational database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

what is the SQL command used to create queries?

A

SELECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

INSERT

23
Q

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

A

DELETE

24
Q

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

A

UPDATE

25
Q

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

A

CREATE

26
Q

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

A

ALTER

27
Q

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

A

DROP

28
Q

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

A

schema

29
Q

rows in a relational database are also called what?

A

records

30
Q

columns in a relational database are also called what?

A

fields

31
Q

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

A

primary key

32
Q

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

A

structured

33
Q

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

A

un-structured or nonstructured

34
Q

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

A

un-structured or non-structured

35
Q

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

A

semi-structured

36
Q

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

A

query

37
Q

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

A

report or report builder

38
Q

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

A

foreign

39
Q

two types of nonrelational databases are ______ and _____.

A

document and key/value

40
Q

limitations put on a field in a database are called?

A

constraints

41
Q

which type of key in a database table is required?

A

primary key

42
Q

stores data virtually and makes it available quickly

speed, scalability, variety of data, security

A

variety of data

43
Q

processes and accesses large amount of data rapidly.

speed, scalability, variety of data, security

A

speed

44
Q

provides much more intricate form of safety to the data

speed, scalability, variety of data, security

A

security

45
Q

allows databases to stretch between on-site servers and the cloud

speed, scalability, variety of data, security

A

scalability

46
Q

used to change or view data by directly going into the table of a database

manual, direct, programmatic, utility

A

manual

47
Q

used to access the database tables directly across a network connection

manual, direct, programmatic, utility

A

direct

48
Q

used to work with data in databases by accessing the data

manual, direct, programmatic, utility

A

programmatic

49
Q

used to access the database tables by using a graphical interface

manual, direct, programmatic, utility

A

utility

50
Q

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

A

data definition

51
Q

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

A

ALTER - used to add, delete and modify columns

52
Q

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

A

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

53
Q

kate, a database administrator, needs to add records into a database. which command should she use?

A) CREATE
B) UPDATE
C) ALTER
D) INSERT

A

INSERT - used to insert records into an existing database

54
Q

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

A

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

Power Point And U Certify (16 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions