Description

Chapter: 10 -Problem: 19 >> What’s the name of the table provided by Oracle 11g for completing queries that don’t involve a table? a. DUMDUM b. DUAL c. ORAC d. SYS
Answer Preview: b…

, Chapter: 11 -Problem: 1 >> To perform these assignments, refer to the tables in the JustLee Books database. 1. Determine how many books are in the Cooking category. 2. Display the number of books with a retail price of more than $30.00. 3. Display the most recent publication date of all books sold by JustLee Books. 4. Determine the total profit generated by sales to customer 1017. Note: Quantity should be reflected in the t
Answer Preview: 1. SELECT COUNT(*) FROM books WHERE category = 'COOKING'; 2. SELECT COUNT(*) FROM books WHERE retail …

, Chapter: 6 -Problem: 12 >> Oracle 11g automatically creates an index for which type of constraints? a. NOT NULL b. PRIMARY KEY c. FOREIGN KEY d. UNIQUE KEY e. Mone of the above f. Only a and b g. Only b and d
Answer Preview: g. …

, Chapter: 7 -Problem: 3 >> How is a user password assigned in Oracle 11g?
Answer Preview: With …

, Chapter: 8 -Problem: 1 >> To perform the following assignments, refer to the tables created in the JLDB_Build_8.sql script at the beginning of the chapter. Give the SQL statements and output for the following data requests: 1. Which customers live in New Jersey? List each customer’s last name, first name, and state. 2. Which orders shipped after April 1, 2009? List each order number and the date it shipped. 3. Which books
Answer Preview: 1. SELECT lastname, firstname, state FROM customers WHER…

, Chapter: 13 -Problem: 7 >> What’s the difference between a key-preserved and a non-key-preserved table?
Answer Preview: A key-preserved table has …

, Chapter: 10 -Problem: 1 >> Why are functions in this chapter referred to as “single-row” functions?
Answer Preview: These functio…

, Chapter: 6 -Problem: 6 >> When does Oracle 11g automatically create an index for a table?
Answer Preview: When a PR…

, Chapter: 7 -Problem: 18 >> Which of the following displays a list of all system privileges available in Oracle 11g? a. SESSION_PRIVS b. SYS_PRIVILEGE_MAP c. V$SYSTEM_PRIVILEGES d. SYSTEM_PRIVILEGE_MAP
Answer Preview: d. S…

, Chapter: 7 -Problem: 7 >> What is the purpose of a role in Oracle 11g?
Answer Preview: A role is a collection …

, Chapter: 6 -Problem: 15 >> If the CACHE or NOCACHE options aren’t included in the CREATE SEQUENCE command, which of the following statements is correct? a. Oracle 11g generates 20 integers automatically and stores them in memory. b. No integers are cached by default. c. Only one integer is cached at a time. d. The command will fail. e. Oracle 11g generates 20 three-digit decimal numbers automatically and stores them in memo
Answer Preview: a. Oracle 11g g…

, Chapter: 1 -Problem: 4 >> Which of the following is not an E-R model relationship? a. Some-to-many b. One-to-one c. One-to-many d. Many-to-many
Answer Preview: a. …

, Chapter: 6 -Problem: 6 >> Suppose the user Juan creates a table called MYTABLE with four columns. The first column has a PRIMARY KEY constraint, the second column has a NOT NULL constraint, the third column has a CHECK constraint, and the fourth column has a FOREIGN KEY constraint. Given this information, how many indexes does Oracle 11g create automatically when the table and constraints are created? a. 0 b. 1 c. 2 d. 3 e
Answer Preview: b. …

, Chapter: 7 -Problem: 5 >> If you’re logged in to Oracle 11g, how can you determine which privileges are currently available to your account?
Answer Preview: Query…

, Chapter: 12 -Problem: 7 >> How can Oracle 11g determine whether clauses of a SELECT statement belong to an outer query or a subquery?
Answer Preview: The subq…

, Chapter: 1 -Problem: 4 >> Define a one-to-many relationship.
Answer Preview: An occurrence of data in one entity …

, Chapter: 7 -Problem: 10 >> How can you remove a user account from Oracle 11g?
Answer Preview: With …

, Chapter: 7 -Problem: 6 >> What types of privileges are available in Oracle 11g? Define each type.
Answer Preview: Object privileges allow the user …

, Chapter: 1 -Problem: 1 >> What is the purpose of an E-R model?
Answer Preview: To identify the entiti…

, Chapter: 9 -Problem: 1 >> To perform these assignments, refer to the tables in the JustLee Books database. Generate and test two SQL queries for each of the following tasks: a) the SQL statement needed to perform the stated task with the traditional approach, and b) the SQL statement needed to perform the stated task with the JOIN keyword. Apply table aliases in all queries. 1. Create a list that displays the title of each
Answer Preview: 1. a) SELECT b title, p contact, p phone FROM books b, publisher p WHERE b pubid = p pubid; b) SELECT b title, p contact, p phone FROM books b JOIN publisher p USING (pubid); 2. a) SELECT c firstname, …

, Chapter: 7 -Problem: 1 >> Create and execute SQL statements to perform the following actions, using the JustLee Books database: 1. Create a new user account. The account name should be a combination of your first initial and your last name. 2. Attempt to log in to Oracle 11g with the newly created account. 3. Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an ex
Answer Preview: 1. CREATE USER finitiallastname IDENTIFIED BY apassword; 2. Co…

, Chapter: 7 -Problem: 3 >> Which of the following statements is most accurate?a. Authentication procedures prevent any data stored in the Oracle 11g database from being stolen or damaged. b. Authentication procedures are used to limit unauthorized access to the Oracle 11g database. c. Oracle 11g authentication doesn’t prevent users from accessing data in the database if they have a valid operating system account. d. Authent
Answer Preview: b. Authentication …

Additional Information

12 Reviews for Oracle 11G SQL Textbook Questions And Answers