Show
Terms in this set (29)Students also viewedSets found in the same folderOther sets by this creatorVerified questions
computer science Verified answer computer science Verified answer
computer science Ackermann’s Function is a recursive mathematical algorithm that can be used to test how well a computer performs recursion. Write a function A(m, n) that solves Ackermann’s Function. Use the following logic in your function: If m = 0 then return n + 1 If n = 0 then return A(m−1, 1) Otherwise, return A(m−1, A(m, n−1)) Test your function in a driver program that displays the following values: A(0, 0) A(0, 1) A(1, 1) A(1, 2) A(1, 3) A(2, 2) A(3, 2) Verified answer
computer science Verified answer Recommended textbook solutions
Other Quizlet setsIn the space provided type in code for a join query that selects the Worker's LastName, Phone, BirthDate, and the ProjectDescription. Only select rows where the LastName begins with 'Jo'. The table information for this problem is shown below: Table 1 is named Workers and it has columns named: ID, LastName, FirstName, Phone, HireDate, and BirthDate. The ID is the primary key of this table Table 2 is named Projects and it has columns named ProjNo, ID, DateAssigned, ProjectDescription, and DueDate. The PrimaryKey on this table is a composite of the ProjectNO and the ID. The ID is a foreign key in addition to being part of the primary key. Students also viewedUpgrade to remove ads Only ₩37,125/year
Terms in this set (97)If the results of a SELECT statement include more than one column of data, the column names must be separated in the SELECT clause by which of the following symbols? , What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle 12c when solving equations? 1.336 When resolving arithmetic expressions, Oracle 12c always performs the operations by starting on the ____________________ side of the expression. left Contents of the BOOKS table Based upon the contents of the BOOKS table, which of the following columns will be displayed with a right-aligned column heading? pubid A query is accomplished by issuing a SELECT statement. true When a user asks the database a question, the user is issuing a query. true The DISTINCT keyword can be used to indicate that duplicate data should be suppressed in the results of a query. _________________________ true Choosing specific columns to be displayed by a SELECT statement is known as projection. true Contents of the PUBLISHER table 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; Contents of the PUBLISHER table Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results? none of the above Which of the following symbols represents all the columns contained in a table? * A ____________________ is used to end a SQL statement. ; The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias. true What is the correct answer for the arithmetic expression 9+2*(3-4) using the order of operations employed by Oracle 12c when solving equations? 7 The majority of operations performed on a typical database table utilize the SELECT statement. true A clause is a section within a SQL statement that begins with a keyword. true If a column alias contains a blank space, it must be enclosed in double quotation marks. _________________________ true Parentheses can be used to override the order of operations in an arithmetic expression. true Which of the following keywords can be included in a SELECT statement to suppress duplicate data? DISTINCT The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved. _________________________ false The DESCRIBE command is used to view data in a table. false A(n) ____________________ is included in the SELECT clause to indicate that all columns in the specified table should be listed in the results. * By default, data within a numeric column is right-aligned when it is displayed. _________________________ true A(n) ____________________ is an alternative column heading displayed in the output of a query. column alias Contents of the BOOKS table Which of the following is a valid SQL statement? SELECT title, retail-cost FROM books; Each section of a SQL command that begins with a keyword is known as a statement. false Insignificant zeros are displayed for numeric columns by default to show two decimal places. _________________________ false A(n) CRBMDS is a software program that can be used to create a relational database and allows you to enter, manipulate, and retrieve data. _________________________ false Which of the following types of columns will automatically right-align the data when it is displayed? numeric Each clause of a SELECT statement must be entered on a new line in SQL*Plus. _________________________ false The only required clauses for a SELECT statement are the WHERE and FROM clauses. _________________________ false By default, the data for a numeric column is ____________________ aligned when it is displayed. right Contents of the BOOKS table Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory? SELECT title, retail+retail FROM books; Combining the contents of two or more columns is known as ____________________. concatenation The ____ for a SQL statement gives the basic structure, or rules, required to execute the statement. syntax
Structure of the ORDERS table Which of the following statements can be used to view the structure of the ORDERS table? DESCRIBE ORDERS The SELECT clause identifies the table containing the data to be queried. _________________________ false What is used to indicate the end of an SQL statement? ; The syntax for a SQL statement gives the basic structure required to execute the statement. true A double backslash (\\) is used to indicate concatenation in a SELECT statement. false Contents of the BOOKS table Based upon the contents of the BOOKS table, which of the following columns will be displayed with a right-aligned column heading? pubid Contents of the BOOKS table Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory? SELECT title, retail+retail FROM books;
If you assign a column alias to a column, it must be enclosed in double quotation marks (" "). false Which of the following is a mandatory clause in a SELECT statement? FROM Which of the following statements is correct? The columns will be listed in the results in the same order they are listed in the SELECT clause of the SELECT statement. If a column heading is longer than the assigned width of a character column, the column heading will be ____________________. truncated Contents of the BOOKS table Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table? SELECT title, retail-cost FROM books; The names of the columns to be retrieved are listed in the ____________________ clause. SELECT A double backslash (\\) is used to indicate concatenation in a SELECT statement. false ____________________ statements can be used to retrieve data from database tables. SELECT A column heading that is longer than the width of a column will not be truncated for a column that is defined to store character data. _________________________ false Combining the contents of two or more columns is known as projection. _________________________ false A user can indicate that all columns of a table should be displayed in the results of a SELECT statement by including an asterisk (*) in the SELECT clause. true By default, the data for character fields are displayed ____________________ aligned when they are displayed. left What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle 12c when solving equations? 15 A column alias must be contained within double quotation marks (" ") if it contains which of the following? all of the above Which of the following commands is used to issue a query? SELECT SQL*Plus can only be accessed via an internet interface. false Structure of the ORDERS table Based upon the structure of the ORDERS table, which of the following is a valid SQL statement? SELECT order#, orderdate DateOrdered FROM orders; Each section of a statement that begins with a keyword is known as a(n) buffer . _________________________ false Contents of the BOOKS table Based upon the contents of the BOOKS table, which of the following SQL statements will display five rows in its results? SELECT DISTINCT pubid FROM books; 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 If you do not want a column alias to appear in all upper case characters, the column alias must be enclosed in ____________________ marks. double quotation The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^). false By default, data within a numeric column is right-aligned when it is displayed. _________________________ true The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results. false Structure of the ORDERS table Based upon the structure of the ORDERS table, the column heading for which column will be truncated in the results? shipzip By default, the data for a numeric column is ____________________ aligned when it is displayed. right Contents of the BOOKS table Which of the following is a valid SQL statement? SELECT title, retail-cost FROM books; Which of the following are case sensitive in Oracle 12c? none of the above The SELECT command can be used to display the structure of a database table. _________________________ false A string literal must be enclosed in double quotation marks. _________________________ false Contents of the BOOKS table Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table? SELECT title, retail-cost FROM books; Contents of the BOOKS table Which of the following is a valid SQL statement? SELECT title, retail-cost FROM books; A string literal must be enclosed in ____. single quotation marks (' ') A query can be executed in the SQL*Plus tool. _________________________ true The DIST or UNIQ keywords can be used to suppress duplicate data in the results of a SELECT statement. false A(n) ____________________ can consist of numbers, characters, or special symbols that should be included in the output exactly as entered by the user. string literal In a(n) SELECT statement, keywords, table names, and column names are not case sensitive. _________________________ true The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table. false The ____________________ keyword can be included in a SELECT statement to suppress the display of duplicate data. UNIQUE or DISTINCT To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause. FROM The optional keyword ____________________ can be used to distinguish between a column name and a column alias. AS Structure of the ORDERS table Based upon the structure of the ORDERS table, the column heading for which column will be truncated in the results? shipzip A(n) WHERE statement allows a user to retrieve data from a database table. _________________________ false 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 If a column name is entered in lower case in the SELECT statement, the data for the column will be displayed in lower case in the results. false Contents of the PUBLISHER table Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement? SELECT contact, name A(n) ____ has a predefined meaning in Oracle 12c. keyword Structure of the ORDERS table Based upon the structure of the ORDERS table, which of the following SQL statements will return an error message upon execution? SELECT order#, "order number" FROM orders; A string literal must be enclosed in ____________________ marks. single quotation or ' ' You can include ____________________ to override the order of operations when solving arithmetic expressions. ( ) or parentheses A script file containing SQL statements can be executed from SQL*Plus. true Contents of the BOOKS table Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory? SELECT title, retail+retail FROM books; Which of the following symbols can be used to combine data from different columns into one column of output? || SQL*Plus is an Oracle tool used to enter and edit SQL statements. true ... ... Students also viewedDatabase concepts Ch213 terms awol17 AIT 524 - WK 7 (SQL Queries)51 terms zcmurphy87 Oracle 12c: SQL - Chapters 1 & 250 terms ebu188jl Oracle 12c: SQL - Chapter 350 terms ebu188jl Sets found in the same folderData Manipulation and Transaction Control116 terms Adrianna_Laferriere Constraints123 terms ZainabSR Oracle 12c: SQL - Chapter 350 terms ebu188jl database concepts ch 3 5 839 terms ben_roseman
Other sets by this creatorAIT 542 Midterm Study Guide121 terms Adrianna_Laferriere 502 Quiz 329 terms Adrianna_Laferriere Restricting Rows and Sorting Data87 terms Adrianna_Laferriere Table Creation and Management91 terms Adrianna_Laferriere Verified questions
computer science A particular talent competition has five judges, each of whom awards a score between 0 and 10 to each performer. Fractional scores, such as 8.3, are allowed. A performer’s final score is determined by dropping the highest and lowest score received, then averaging the three remaining scores. Write a program that uses this method to calculate a contestant’s score. It should include the following functions: - void getJudgeData () should ask the user for a judge’s score, store it in a reference parameter variable, and validate it. This function should be called by main once for each of the five judges. - void calcScore () should calculate and display the average of the three scores that remain after dropping the highest and lowest scores the performer received. This function should be called just once by main and should be passed the five scores. The last two functions, described below, should be called by calcScore, which uses the returned information to determine which of the scores to drop. - int findLowest () should find and return the lowest of the five scores passed to it. - int findHighest () should find and return the highest of the five scores passed to it. Input Validation: Do not accept judge scores lower than 0 or higher than 10. Verified answer computer science Internally, the CPU consists of the _______ and the _______. Verified answer
computer science Use what you’ve learned about the binary numbering system to convert the following binary numbers to decimal: 1101 1000 101011 Verified answer
computer science T F A pointer variable that has not been initialized is called a null pointer. Verified answer Recommended textbook solutions
Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 726 solutions
Information Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions Service Management: Operations, Strategy, and Information Technology7th EditionJames Fitzsimmons, Mona Fitzsimmons 103 solutions
Information Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions Other Quizlet setsChapter 6 - Reviewing and Correcting Charge Errors43 terms Teletran_1 Julia Fiore 6,7,8 Safety20 terms jfiore5 Pro Sem Test 1 (Spring)31 terms efeather22 chp 8 microbial pt 236 terms tylerannabel How would you code a SELECT clause so it return all columns from base table?The SELECT clause specifies one or more columns to be retrieved; to specify multiple columns, use a comma and a space between column names. To retrieve all columns, use the wild card * (an asterisk). The FROM clause specifies one or more tables to be queried.
Which of the following symbols is used in a SELECT clause to display all columns from a table?Detailed Solution. The * symbol is used to see every column of a table.
What keyword can you code in the SELECT clause to prevent duplicate rows from being returned?The DISTINCT keyword in the SELECT clause is used to eliminate duplicate rows and display a unique list of values. In other words, the DISTINCT keyword retrieves unique values from a table.
Which clause of the SELECT statement specifies the table that contains the data to be retrieved?In queries where all the data is found in one table, the FROM clause is where we specify the name of the table from which to retrieve rows. In other articles we will use it to retrieve rows from multiple tables.
|