Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Humanities
Q:
__ operation retrieves a subset of rows.
Q:
In Oracle, the statement used to display employees' social security numbers and names that don"t have any jobs assigned to them, would be which of the following?a) Select employee.ssn, employee.name From job Where employee.ssn Not In (Select Distinct job.ssn From job)b) Select employee.ssn, employee.name From job Where employee.ssn Not In (Select Distinct Employee.ssn From employee)c) Select employee.ssn, employee.name From employee Where employee.ssn Not In (Select Distinct job.ssn From job)d) Select employee.ssn, employee.name From employee Where employee.ssn In (Select Distinct job.ssn From job)
Q:
For subqueries, which of the following statements is correct?
a) Inner queries execute last and outer queries execute first.
b) Inner queries execute at the same time as outer queries.
c) Inner queries execute first and outer queries execute last.
d) Inner queries execute independently of outer queries.
Q:
Correcting an ambiguous name problem requires which of the following?
a) Changing the name in the SQL statement
b) Preceding the name with the table name
c) Following the name with the table name
d) Separating the name from the table name
Q:
In Oracle, the statement used to display employee and client names together with all of the job dates, sorted from earliest to latest, would be which one of the following?
a) Select employee.name, client.name, job.date From employee Inner Join (client Inner Join job On client.email = job.jobid) On employee.ssn = job.jobid Order by job.date
b) Select employee.name, client.name, job.date From employee, client, job Order by job.date
c) Select employee.name, client.name, job.date From employee, client, job Where client.email = employee.ssn And employee.ssn = job.jobid Order by job.date
d) Select employee.name, client.name, job.date From Where client.email = job.email And employee.ssn = job.ssn Order by job.date
Q:
In Microsoft Access, the statement used to display employee names together with job dates and times, for all jobs starting on either 3/12/06 or at 8 A.M., would be which of the following?
a) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.date = "3/12/06" And job.timestart = "8:00 AM"
b) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.jobid Where job.date = "3/12/06" Or job.timeend = "8:00 AM"
c) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.date = "3/12/06" Or job.timestart = "8:00 AM"
d) Select employee.name, job.date, job.timestart, job.timeend From employee, job On employee.ssn = job.ssn Where job.date = "3/12/06" Or job.timestart = "8:00 AM"
Q:
In Oracle, the statement used to display employee names together with job dates and times, for all jobs starting at 8 A.M., would be which of the following?
a) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.timestart = "8:00 AM"
b) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.timeend = "8:00 AM"
c) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job Where job.timestart = "8:00 AM"
d) Select employee.name, job.date, job.timestart, job.timeend From employee, job On employee.ssn = job.ssn Where job.timestart = "8:00 AM"
Q:
In Microsoft Access, the statement used to display employee names together with all of their job dates and times would be which of the following?
a) Select employee.name, job.date, job.timestart, job.timeend From employee, job Where employee.ssn = job.jobid
b) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn
c) Select employee.name, job.date, job.timestart, job.timeend From employee.ssn Inner Join On job.ssn
d) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job On employee = job
Q:
In Oracle, the statement used to calculate the number of clients from each NH zip code, labeled "Zip Clients", would be which of the following?
a) Select zipcode, Count(email) From client Group by zipcode Where state != "NH"
b) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode
c) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode Where state = "NH"
d) Select zipcode, Count(email) As "Zip Clients' From client Group by zipcode Where state is "NH"
Q:
Count function does which of the following?
a) Returns the total of the values in the column for the selected rows
b) Returns the average of the values in the column for the selected rows
c) Returns the number of values in the column for the selected rows
d) Returns the highest value in the column for the selected rows
Q:
In Oracle, the statement used to retrieve all the jobs with jobid greater than 5 and less than 8, displaying only jobids and associated dates, would be which of the following?
a) Select jobid, date From Job Where jobid between 5 and 8
b) Select jobid, date From Job Where jobid >5 And <8
c) Select jobid, date From Job Where jobid >=5 and <=8
d) Select jobid, date From Job Where jobid 5 and 8
Q:
In Oracle, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails end in "net", and who live in 03264 zip code?
a) Select contact, email, zipcode From client Where email Not Like "net" And zipcode != "03264"
b) Select contact, email, zipcode From client Where email Like "*net" Or zipcode = "03264"
c) Select contact, email, zipcode From client Where email Like "net" Or zipcode = "03264"
d) Select contact, email, zipcode From client Where email Like "*net" And zipcode = "03264"
Q:
In Oracle, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails either end in "net", or who live in 03264 zip code?
a) Select contact, email, zipcode From client Where email Not Like "net" And zipcode != "03264"
b) Select contact, email, zipcode From client Where Email Like "*net" Or zipcode = "03264"
c) Select contact, email, zipcode From client Where Email Like "net" Or zipcode = "03264"
d) Select contact, email, zipcode From client Where Email Like "*net" And zipcode = "03264"
Q:
Complex Where clauses typically involve several conditions and use which of the following logical operators?
a) +, -, *, /
b) =, <, >, <=, >=, !=
c) And, Or
d) Like, Unlike
Q:
In Oracle, which of the following statements would result in contacts and emails only for the clients in 603 area code?
a) Select contact, email From client Where phone Not Like "603*"
b) Select contact, email From client Where phone Like "603"
c) Select contact, email From client Where phone Like "603*"
d) Select contact, email From client Where phone Like "*603*"
Q:
In Oracle, which of the following statements would result in contacts and emails only for the clients in the state of New Hampshire?
a) Select contact, email From client Where state equals "NH"
b) Select contact, email From client Where state != "NH"
c) Select contact, email From client Where state = "NH"
d) Select contact, email From client Where state is "NH"
Q:
Which of the following are referred to as conditional operators?
a) +, -, *, /
b) =, >, <, >=, <=, !=
c) %, &, @, #
d) (, [, {, ), ], }
Q:
In Oracle SQL script, the condition restricting jobs to those with jobid of 5 or more, would go into which of the following commands?
a) Select
b) From
c) Order by
d) Where
Q:
Which of the following conditions would result in a list of jobs with jobid of 5 or more?
a) jobid > 5
b) jobid >= 5
c) jobid != 5
d) jobid <=5
Q:
Selecting a subset of rows meeting certain conditions is accomplished using which of the following?
a) Select statement
b) From keyword
c) Where clause
d) Condition keyword
Q:
Sorting on multiple columns in Oracle SQL script involves which of the following?
a) Placing the fields in order in which they should be sorted in Order by command
b) Placing keyword desc at the end of Order by command for Z->A sort or leaving it blank for ascending sort
c) Listing all the fields that need to be shown in Select command
d) All of the above
Q:
In Microsoft Access, which of the following would be used to sort the client list consisting of contacts and emails, alphabetically from Z to A, by contact?
a) Select * From Client Order by Contact
b) Select Contact, Email From Client Order by Contact desc
c) Select Contact, Email From Client Order by Contact
d) Select Contact, Email Order by Contact desc
Q:
Which of the following would be selected in order to display client contacts and their emails only?
a) Select contact and email From client
b) Select * From client
c) Select contact, email From client
d) Select From client Fields contact, email
Q:
In Oracle, which of the following environments allows you to create and execute SQL statements?
a) iSQL*Plus workspace
b) SQL*Plus workspace
c) SQL workspace
d) Web workspace
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.For questions 33-56, please refer to the preceding paragraph.In Oracle, the statement used to retrieve all the data from the job table, would be which of the following?a) Select job From *b) Select * From jobc) From job Select *d) From * Select job
Q:
SQL implements selection, projection, and joining operations using which of the following?a) SQL statementb) Select statementc) From keywordd) Retrieval statement
Q:
The only required element(s) for an SQL statement is(are) which of the following?
a) Select statement
b) From keyword
c) Select statement and From keyword
d) Select and SQL statements
Q:
Projection operation does which of the following?
a) Retrieves a subset of rows
b) Retrieves a subset of columns
c) Combines data from two tables
d) Makes a link between two tables
Q:
Selection operation does which of the following?
a) Retrieves a subset of rows
b) Retrieves a subset of columns
c) Combines data from two tables
d) Makes a link between two tables
Q:
Joining operation does which of the following?
a) Retrieves a subset of rows
b) Retrieves a subset of columns
c) Combines data from two tables
d) Makes a link between two tables
Q:
Which one of the following is(are) the core retrieval operation(s) for relational databases?
a) Selection
b) Projection
c) Joining
d) All of the above
Q:
In a query with a subquery, outer subquery always executes first.
Q:
Instead of using where clause to perform a join, Oracle uses the inner join keyword.
Q:
To perform a join, a Where clause specifies that the value of the primary key in a parent table equals to the value of the foreign key in a child table.
Q:
Cartesian product is a temporary table that combines all rows in one table with all rows in another table.
Q:
The types of joins most widely used are the so-called outer joins.
Q:
Combining data from different tables into a single result set is called performing a join.
Q:
Distinct keyword would be used to find out how many different values there are in a particular field.
Q:
Count(*) function returns a count of records including those with nulls.
Q:
Aggregate functions operate on a set of fields rather than a single field.
Q:
The result of two conditions with Or operator in between will be true if either of the conditions are true.
Q:
The result of two conditions with And operator in between will be true only if both of the conditions are true.
Q:
The Like operator could be used to retrieve all the clients in a particular area code.
Q:
Projection operation consists of choosing to list certain fields after the Select statement, and omitting the others.
Q:
Equal to (=), greater than (>), and less than (<) are all examples of conditional operators.
Q:
The Where clause must consist of only one condition.
Q:
For each particular record that is being examined, the Where clause evaluates either to True or False.
Q:
The selection retrieval process is implemented using Where clause in the Select statement.
Q:
In Oracle, the statement used to display all the employees, sorted first by their names, and then by birth dates would be: Select * From employees Order by birthdate, name.
Q:
An example of a multiple sort is ordering all the employees first by their social security numbers and then by their names.
Q:
In Oracle's iSQL Plus interface, SQL commands are typed into the window and then run using the Execute button.
Q:
In Oracle, queries are created in iSQL Plus interface accessible over the Web.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.For questions 5"26, please refer to the preceding paragraph.The statement used to retrieve all the data from the client table would be: Select Client From *.
Q:
The only required elements of an SQL statement are: (1) the Select statement (followed by a list of tables), and the From keyword (followed by a list of columns).
Q:
SQL implements selection, projection, and joining operations through a single statement called the Select statement.
Q:
Selection operation retrieves a subset of columns.
Q:
Selection, projection, and joining are the three core data retrieval operations for relational databases.
Q:
The most appropriate data type used to store social security numbers would be which of the following?
a) Varchar(9)
b) Char(9)
c) Number(9,2)
d) Date
Q:
The most appropriate data type to store product description is which of the following?
a) Varchar
b) Char
c) Number
d) Date
Q:
The most appropriate data type used to store 349.82 would be which of the following?
a) Number(3,2)
b) Number(4,2)
c) Number(5,2)
d) Varchar(6)
Q:
In Oracle, inserting a child record that does not have a matching parent record will generate an Orphan Cannot Exist error.
Q:
In Oracle, an extra comma at the end of a value list in an Insert statement will generate a Missing Expression error.
Q:
Oracle's default date format can be changed using alter session set nls_date_format command.
Q:
In Oracle, using level as a field name would generate Invalid Identifier error.
Q:
In Oracle, errors are always traced to the line that generated them.
Q:
In Oracle, each complete statement ends in a semicolon.
Q:
In Oracle, listing all the fields followed by the primary key reserved words would create a concatenated primary key.
Q:
In Oracle, the reserved word for defining a foreign key is references.
Q:
In Oracle, the script line used to enter the first record into the client table would be: insert into client ("[email protected]", "Dentist Pros', "James Tucker", "63 Elm Street", "Manchester", "NH", "03308", "(603)774-6698")
Q:
In Oracle, the script line setting up Email as the primary key would read: email char(30) as primary key.
Q:
The data type for Zip Code field would be Number.
Q:
Email would be set as the primary key for the client table.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.ClientEmail Name Contact Address City State Zip Code [email protected] Dentist Pros James Tucker 63 Elm Street Manchester NH 03308 (603)[email protected] Danny's Hardware Danny Stewart 5 Main Street Campton NH 03223 (603)[email protected] Jo's Furniture Jo Collins 54 High Street Brattleboro VT 05301 (802)[email protected] Johny's Pizza Anthony Vicente 54 Main Street Campton NH 03223 (603)[email protected] Plymouth Professionals Margaret Jones 84 Highland Street Plymouth NH 03264 (603)[email protected] The Corner Grocery Joan Jenkins 34 State Street Concord NH 03301 (603)[email protected] Mountain Coffee Terry McDougal 23 Main Street Plymouth NH 03264 (603)536-1288For questions 14-26, please refer to the preceding paragraph and table.In Oracle, the data type of Email field would be Char(10).
Q:
Oracle scripts are retrieved using Load Script button.
Q:
In Oracle, the workspace is a user interface where SQL commands are typed and executed.
Q:
In Oracle, Save statement is used to save changes made to the database.
Q:
Set Echo On statement is used to display script results.
Q:
A series of SQL commands saved in a file is called a script.
Q:
Drop Table command is typically placed at the bottom of the script.
Q:
Values of numeric fields must be enclosed in single quotation marks.