Section 1
Preview this deck
The default size of a VARCHAR2 column is one character.
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (80)
Section 1
(50 cards)
The default size of a VARCHAR2 column is one character.
False
A DBMS includes which of the following capabilities?
security data dictionary multi-user access Correct ---> all of the above
Which of the following terms represents a collection of fields?
record
If multiple column names are listed in the SELECT clause of a SELECT statement, the columns must be separated by a comma (,).
True
The default format of a DATE column in Oracle 12c is DD-MON-YY.
True
Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?
SELECT contact person, name FROM publisher;
By default, data within a character or data column is right-aligned when it is displayed. _________________________
False
Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?
field
Two tables can be linked or joined together through a common field.
True
The maximum width of a VARCHAR2 column is 2000 characters.
False
The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.
True
What type of relationship is depicted in Figure 2?
one-to-many
A field is a basic unit of data also referred to as a record.
False
A column represents a field in the physical database table.
True
The columns displayed in the results of a SELECT statement will be in the same order as they are stored in the database table.
False
The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.
False
Structured Query Language (SQL) is generally used to interact with a database.
True
In a(n) SELECT statement, keywords, table names, and column names are not case sensitive. _________________________
True
A table name can be up to 30 characters in length.
True
Based upon the contents of the BOOKS table, which of the following is a valid SQL statement?
select pubid, isbn, from books; select * FROM pubid; select pubid, "Publisher ID" from books; Correct! - none of the above
Every table name within a specific schema must be unique.
True
A one-to-many relationship cannot be included in a relational database.
False
A table name can consist of numbers, letters, and blank spaces.
False
In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?
entity
Which of the following is used to create and maintain the physical database?
Database Management System (DBMS)
Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?
SELECT name, publisherID FROM publishers;
The DISTINCT keyword can be used to indicate that duplicate data should be suppressed in the results of a query. _________________________
True
The syntax for a SQL statement gives the basic structure required to execute the statement.
True
The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.
True
The DESCRIBE command is used to view data in a table.
False
A many-to-many relationship cannot exist in a relational database.
True
What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle 12c when solving equations?
13
When solving arithmetic expressions, Oracle 12c always resolves addition and subtraction operations first from left to right in the expression. _________________________
False
If a column alias contains a blank space, it must be enclosed in double quotation marks. _________________________
True
A bridging table can be used to eliminate a many-to-many relationship in a relational database.
True
A foreign key uniquely identifies each row in a table.
False
When a user asks the database a question, the user is issuing a query.
True
The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.
True
A string literal must be enclosed in double quotation marks. _________________________
True
The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^).
False
DML commands are used to create or modify database tables.
False
A character is a basic unit of data and can consist of a number, letter, or special symbol.
True
Suppose that a patient in a hospital can only be assigned to one room. However, the room may be assigned to more than one patient at a time. This is an example of what type of relationship?
one-to-many
If a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?
many-to-many
A foreign key appears on the many side of a one-to-many relationship.
True
A datatype identifies the type of data to be stored in a column.
True
What type of relationship is depicted in Figure 1?
one-to-one
By default, data within a numeric column is right-aligned when it is displayed. _________________________
True
Concatenation refers to combining the results of several SELECT statements into one result.
False
A ____ is a storage structure designed to hold a collection of data.
Database
Section 2
(30 cards)