All Matches

Solution Library

Expert Answer

Textbooks

Search Textbook questions, tutors and Books

Oops, something went wrong!

Change your search query and then try again

Result Not Found

Books FREE
Tutors
Study Help
Ask a Question

Search
Sign In
Register

study help
computer science
oracle 12c sql

Questions and Answers of Oracle 12c SQL

Create a list containing the publisher’s name, the person usually contacted, and the publisher’s telephone number. Rename the contact column “Contact Person” in the displayed results.
List the customer number for each customer in the CUSTOMERS table, along with the city and state in which the customer lives.
List the title and publication date for each book in the BOOKS table. Use the column heading “Publication Date” for the Pubdate field.
List the title only of all books available in inventory, using the BOOKS table.
Display a list of all data contained in the BOOKS table.
Which of the following lines of the SELECT statement contains an error?1 SELECT *2 FROM publishers;a. line 1b. line 2c. There are no errors.
Which of the following lines of the SELECT statement contains an error?1 SELECT name, contact2 "Person to Call", phone3 FROM publisher;a. line 1b. line 2c. line 3d. There are no errors.
Which of the following lines of the SELECT statement contains an error?1 SELECT title, category2 FORM books;a. line 1b. line 2c. There are no errors.
Which of the following lines of the SELECT statement contains an error?1 SELECT ISBN, || ' is the ISBN for the book named ' ||2 title3 FROM books;a. line 1b. line 2c. line 3d. There are no errors.
Which of the following lines of the SELECT statement contains an error?1 SELECT name, contact,2 "Person to Call", phone3 FROM publisher;a. line 1b. line 2c. line 3d. There are no errors.
Which of the following lines of the SELECT statement contains an error?1 SELECT title, cost,2 cost*23 'With 200% Markup'4 FROM books;a. line 1b. line 2c. line 3d. line 4e. There are no errors.
Which of the following lines of the SELECT statement contains an error?1 SELECT ISBN,2 retail-cost3 FROM books;a. line 1b. line 2c. line 3d. There are no errors.
Which of the following lines of the SELECT statement contains an error?1 SELECT title, isbn,2 Pubdate "Date of Publication"3 FROM books;a. line 1b. line 2c. line 3d. There are no errors.
Which clause is not required in a SELECT statement?a. SELECTb. FROMc. WHEREd. All of the above clauses are required.
Which of the following commands displays a listing of the category for each book in the BOOKS table?a. SELECT title books, category FROM books;b. SELECT title, books, and category FROM books;c.
When must a comma be used in the SELECT clause of a query?a. When a field name is followed by a column aliasb. To separate the SELECT clause and the FROM clause when only one field is selectedc.
Which of the following is not a valid SELECT statement?a. SELECT cost-retail FROM books;b. SELECT retail+cost FROM books;c. SELECT retail * retail * retail FROM books;d. SELECT retail^3 from books;
Which of the following symbols is used in a SELECT clause to display all columns from a table?a. /b. &c. *d. "
Which of the following is a valid SELECT statement?a. SELECT TITLES * TITLE! FROM BOOKS;b. SELECT “customer#” FROM books;c. SELECT title AS “Book Title” from books;d. all of the above
Which of the following symbols is used for a column alias containing spaces?a. ' 'b. ||c. " "d. / /
Which of the following SELECT statements returns all fields in the ORDERS table?a. SELECT customer#, order#, orderdate, shipped, address FROM orders;b. SELECT * FROM orders;c. SELECT ? FROM orders;d.
Which of the following symbols represents concatenation?a. *b. ||c. [ ]d. ' '
Which of the following is not a valid SELECT statement?a. SELECT lastname, firstname FROM customers;b. SELECT * FROM orders;c. Select FirstName NAME from CUSTOMERS;d. SELECT lastname Last Name FROM
Which clause is required in a SELECT statement?a. WHEREb. ORDER BYc. GROUP BYd. FROMe. all of the above
Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table?a. SELECT customer names FROM customers;b. SELECT "Names" FROM customers;c. SELECT firstname,
What is a NULL value?
How can you concatenate columns in a query?
What are the guidelines to keep in mind when using a column alias?
When is it appropriate to use a column alias?
How do you indicate that a column alias should be used?
What is the purpose of a column alias?
What does an asterisk (*) in the SELECT clause of a SELECT statement represent?
What is the purpose of the SELECT statement?
What are the two required clauses for a SELECT statement?
Your company receives the following memo. First, based on the memo, create an initial database design (E-R model) for the City Jail that indicates entities, attributes (columns), primary keys, and
The normalization process was shown for just the BOOKS table. The other tables in the Just Lee Books database are shown after normalization. Because the database needs to contain data for each
Data for an information technology conference needs to be collected. The conference has a variety of sessions scheduled over a two-day period. All attendees must register for the sessions they plan
An online retailer of coffee beans maintains a long list of unique coffee flavors. The company purchases beans from a number of suppliers; however, each specific flavor of coffee is purchased from
A movie megaplex needs to collect movie attendance data. The company maintains 16 theaters in a single location. Each movie offered can be shown in one or more of the available theaters and is
Create a simple E-R model depicting entities and relationship lines for data scenario. Every employee in a company is assigned to one department. Every department can contain many employees.
A college needs to track placement test scores for incoming students. Each student can take a variety of tests, including English and math. Some students are required to take placement tests because
If a customer inquired about a book written in 2003 by an author named Thompson, which access path (tables and fields) would you need to follow to find the list of books meeting the
Explain how you would determine how much profit was generated from orders placed in April 2009.Figure 1-5: ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost
If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this information?Figure 1-5: ORDERS Order# Customer#
How would you determine which orders have not yet been shipped to the customer?Figure 1-5: ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS
Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped?Figure 1-5: ORDERS Order# Customer# Orderdate Shipdate Shipstreet
Which of the following is used to join data contained in two or more tables?a. Primary keyb. Unique identifierc. Common fieldd. Foreign key
When part of the data in a table depends on a field in the table that isn’t the table’s primary key, it’s known as:a. Transitive dependencyb. Partial dependencyc. Psychological dependencyd. A
Which of the following defines a relationship in which data can have multiple occurrences in each entity?a. One-to-oneb. One-to-manyc. Many-to-manyd. None of the above
Which of the following represents a field in a table?a. A recordb. A rowc. A columnd. An entity
Which of the following, when used in an E-R model, indicates the need for an additional table?a. Sometimes-to-always relationshipb. One-to-one relationshipc. One-to-many relationshipd. Many-to-many
Which of the following symbols represents an optional relationship in an E-R model?a. A straight lineb. A dashed linec. A straight line with a crow’s foot at both endsd. A straight line with a
A unique identifier for a data row that consists of more than one field is commonly called a:a. Primary plus keyb. Composite primary keyc. Foreign keyd. None of the above
Which of the following fields also serves as a primary key in another table when two tables are joined together on that value?a. Foreign keyb. Primary keyc. Turn keyd. Repeating group key
The unique identifier for a record is called the:a. Foreign keyb. Primary keyc. Turn keyd. Common field
Which of the following has no repeating groups but can contain partial or transitive dependencies?a. Unnormalized datab. 1NFc. 2NFd. 3NF
Which of the following has no partial dependencies but can contain transitive dependencies?a. Unnormalized datab. 1NFc. 2NFd. 3NF
Which of the following symbols represents a one-to-many relationship in an E-R model?a. A straight lineb. A dashed linec. A straight line with a crow’s foot at both endsd. A straight line with a
Which of the following has no partial or transitive dependencies?a. Unnormalized datab. 1NFc. 2NFd. 3NF
Which of the following defines a relationship in which each occurrence of data in one entity is represented by only one occurrence of data in the other entity?a. One-to-oneb. One-to-manyc.
Which of the following can contain repeating groups?a. Unnormalized datab. 1NFc. 2NFd. 3NF
Which of the following symbols represents a many-to-many relationship in an E-R model?a. A straight lineb. A dashed linec. A straight line with a crow’s foot at both endsd. A straight line with a
Which of the following is not an E-R model relationship?a. Some-to-manyb. One-to-onec. One-to-manyd. Many-to-many
An entity is represented in an E-R model as a(n):a. Arrowb. Crow’s footc. Dashed lined. None of the above
Which of the following defines a relationship in which each occurrence of data in one entity is represented by multiple occurrences of the data in the other entity?a. One-to-oneb. One-to-manyc.
Which of the following represents a row in a table?a. An attributeb. A characteristicc. A fieldd. A record

Showing 500 - 600 of 566

1
2
3
4
5
6

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Campus Ambassador

Company Info

Security
Copyrights
Privacy Policy
Terms & Condition
SolutionInn Fee
Scholarship

Services

Sitemap
Fun
Definitions
Become Tutor
Study Help Categories
Recent Questions
Expert Questions

Copyright © 2024 SolutionInn All Rights Reserved.

Get the SolutionInn - Study Help App