Database Concepts
Which of the following should NOT be used as a primary key in a table? A. Username B. First name C. Employee ID D. Social Security Number
What is (B) First Name?
Primary keys must always be unique values. Since multiple people can have the same first name it is a poor primary key.
User-friendly interface for adding to or retrieving information from a database.
A. Report
B. Form
C. Table
D. Query
What is (B) Form?
A database user and her supervisor has asked them to generate a report form the structured database. The database user does not know how to write SQL commands and no forms have been created. Which of the followign would be their best option to generate the report ?
A. Direct access
B. Progammatic access
C. User interface access
D. Query builder
What is (D) Query Builder?
A graphical user interface is provided, where people can select what actions they want to perform. Then the builder translates the user's choice into SQL commands and runs them.
The idea of programming by modeling real-world things into computer code is called __________.
A. Polymorphism
B. Encapsulation
C. Inheritance
D. Object-Oriented Programming
What is (D) Object-Oriented Programming?
Creates programs by modeling real-world things into code.
A program will store the value of a single character.
What is Char?
Char is used to hold a single character.
A NOT NULL _______ is a rule that prevents certain fields in a database from being left blank. A. Constraint B. Query Builder C. Schema D. Scalability
What is (A) Constraint?
A value that's used to identify a record from a linked table is called a ___________.
A. Linked Key
B. Foreign Key
C. Primary Key
D. Borrowed Key
When a primary key from one table is used as a field in another "linked" table, it is called a foreign key.
Alberto works in human resources and wants to move all personnel files to a system that would provide a user interface for adding, updating, and removing personnel records. He also wants to ensure the data cannot be viewed without correct premissions. Which of the following would be the BEST option to store and retrieve this data?
What is a Database?
In object-oriented programming, _____________ is the principle that limits access to certain parts of the code. By doing this, the programmer ensures the data will always be handled in an appropriate way.
A. Polymorphism
B. Encapsulation
C. Inheritance
D. Attributes
What is (B) Encapsulation?
Encapsulation limits access to certain parts of a program to public methods.
A programmer is creating an application that needs to store a value indicating if the user is logged in or not. Which of the following would be the BEST data type to accomplish this?
A. String
B. Float
C. Boolean
D. Integer
What is (C) Boolean?
Used to store a true or false value, that cannot be used to store characters or numbers.
In relational database tables, rows are known as __________ A. Fields B. Records C. Instances D. Categories
What is (B) Records?
A database administrator is setting up a new table that will contain customer information. The fields include name, address, company, phone, email and customer ID. The admin is using the Customer ID as the identifier unique to each record. What is the customer ID ?
What is a Primary Key ?
This database feature provides a formatted, easy-to-read listing of the results of a query.
What is a Report?
Using HTML and CSS to provide visual elements to the end user would be considered part of a website's ________.
A. Backend
B. Full Stack
C. Protocols
D. Frontend
What is (B) Frontend?
A programmer is fixing a bug in a programming code written by another developer. He descovered the code with the bug is repeated in several places. Instead of fixing the bug in multiple places, which of the following programming features should he use so the code is only located in one place?
A. Loops
B. Container
C. Variables
D. Functions
What is (D) Functions?
Functions are computer routines, or snippets of code, that can be reused in a computer program.
In relational database tables, columns are known as __________
A. Fields
B. Records
C. Instances
D. Categories
What is (A) Fields ?
For one table to reference records in another table.
What is a Foreign Key ?
The data can be organized into separate tables that are related to each other.
What is the benefit of using a relational database?
Databases, authentication, and user accounts are all part of a website's _____________.
A. Backend
B. Protocols
C. Frontend
D. Full stack
What is (A) Backend?
An identifier used to store a single value that does not change.
What is Constants?
Information in a database does not appear to have a clear pattern, such as photos, newspapers articles, interview and notes.
What is non-structured database?
The general structure of a database, defines the logical groupings and relationships between objects such as tables and fields.
What is a Schema?
Which of the following SQL commands would you use to delete an entire table and all of its data?
A. DELETE
B. ALTER TABLE
C. UPDATE
D. DROP
What is (D) Drop?
The DROP command deletes an entire table, including all the data stored in it.
This data type is used for numbers that have decimal places. The computer stores two values behind the scenes: The digits in the number and the location of the decimal point.
What is a Float?
the decimal can "float" around to any location within the number.
Type of variable that can hold many values at the same time?
A. Array
B. Constant
C. Value
D. Variable
What is (A) array?
A special kind of variable that can hold onto many values at the same time.