What is meant by concurrent update?
Which of the following statements creates a user account named DeptHead? a. CREATE ROLE depthead IDENTIFIED BY apassword; b. CREATE USER depthead IDENTIFIED BY apassword; c. CREATE ACCOUNT depthead;...
How do views relate to security?
Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table.
Log in to Oracle 12c with the new account created in Assignment 1. Determine the privileges currently available to the account.
Which clause of an SQL query is used to restrict the number of rows returned?
Which clause of an SQL query displays the results in a specific sequence?
Which operator can you use to find any books with a retail price of at least $24.00?
The management of Colonial Adventure Tours wants to upgrade its database and wants you to help select a different DBMS. To help management, they would like you to complete the following exercises....
Why is local control of data an advantage in a distributed database?
How many rows are returned in a Cartesian join between one table having 5 records and a second table having 10 records?
Describe problems you might encounter when using the NATURAL JOIN keywords to perform join operations.
Why are the NATURAL JOIN keywords not an option for producing a self-join?
Whats the difference between the UNION and UNION ALL set operators?
Whats the difference between an equality and a non-equality join?
For the following exercises, you will answer problems and questions from management at TAL Distributors. You do not use the TAL Distributors database for any of these exercises. 1. Fragment the...
The management of Colonial Adventure Tours asks you to research improvements it might make to its database processing. To help management, they would like you to complete the following exercises. You...
Which of the following SQL statements isnt valid? a. SELECT address || city || state || zip "Address" FROM customers WHERE lastname='SMITH'; b. SELECT * FROM publisher ORDER BY contact; c. SELECT...
How is the TRUNC function different from the ROUND function?
What functions can be used to search character strings for specific patterns of data?
Given the following query: SELECT lastname, firstname, order# FROM customers LEFT OUTER JOIN orders USING (customer#) ORDER BY customer#; Which of the following queries returns the same results? a....
Whats the difference between using the CONCAT function and the concatenation operator (||) in a SELECT clause?
Describe a situation that calls for using the DECODE function.
What format model should you use to display the date 25-DEC-09 as Dec. 25?
Why does the function NVL(shipdate, 'Not Shipped') return an error message?
Which function can be used to add spaces to a column until its a specific width? a. TRIML b. PADL c. LWIDTH d. None of the above
Which of the following format elements causes months to be displayed as a three-letter abbreviation? a. MMM b. MONTH c. MON d. none of the above
Whats the name of the table provided by Oracle 12c for completing queries that dont involve a table? a. DUMDUM b. DUAL c. ORAC d. SYS
The following list reflects the current data requests from city managers. Provide the SQL statements that satisfy the requests. For each request, include one solution using the traditional method and...
Determine the amount of total profit generated by the book purchased on order 1002. Display the book title and profit. The profit should be formatted to display a dollar sign and two decimal places....
Display the current day of the week, hour, minutes, and seconds of the current date setting on the computer youre using.
Management is proposing to increase the price of each book. The amount of the increase will be based on each books category, according to the following scale: Computer books, 10%; Fitness books, 15%;...
Which of the following is a valid SQL statement? a. SELECT customer#, order#, MAX (shipdate-orderdate) FROM orders GROUP BY customer# WHERE customer# = 1001; b. SELECT customer#, COUNT (order#) FROM...
What comparison operators are required for multiple-row subqueries?
Which query identifies customers living in the same state as the customer named Leila Smith? a. SELECT customer# FROM customers WHERE state = (SELECT state FROM customers WHERE lastname = 'SMITH');...
Which of the following queries determines which customers have ordered the same books as customer 1017? a. SELECT order# FROM orders WHERE customer# = 1017; b. SELECT customer# FROM orders JOIN...
In a MERGE statement, an INSERT is placed in which conditional clause? a. USING b. WHEN MATCHED c. WHEN NOT MATCHED d. INSERTS arent allowed in a MERGE statement.
What is the purpose of the following query? SELECT isbn, title FROM books WHERE (pubid, category) IN (SELECT pubid, category FROM books WHERE title LIKE '%ORACLE%'); a. It determines which publisher...
Which operator is used to process a correlated subquery? a. EXISTS b. IN c. LINK d. MERGE
Determine which orders were shipped to the same state as order 1014
List the shipping city and state for the order that had the longest shipping delay.
Change the CONTACT view so that no users can accidentally perform DML operations on the view.
Delete the REORDERINFO view.
Write a C# statement to accomplish each of the following tasks: a) Declare the int variable sum and initialize it to 0. b) Declare the int variable x and initialize it to 1. c) Add variable x to...
What type of iteration would be appropriate for calculating the sum of the first 100 positive integers? What type of iteration would be appropriate for calculating the sum of an arbitrary number of...
The number of calls arrive under a particular time in a cell has been established to be a Poisson distribution. The average number of calls arriving in a cell in 1 millisecond is 5. What is the...
State whether each of the following is true or false. If false, explain why. a) Software objects model both abstract and real-world things. b) The most popular database model is the relational...
Write C# statements that accomplish each of the following tasks: a) Display the message "Enter an integer: ", leaving the cursor on the same line. b) Assign the product of variables b and c to...
What should be a relationship between call arrival rate and service rate when a cellular system is in a steady state? Explain clearly.
In a transition diagram of M/M/5 model, write the state transition equations and find a relation for the system to be in each state.
State whether each of the following is true or false. If false, explain why. a) C# operators are evaluated from left to right. b) The following are all valid variable names: _under_bar_, m928134, t5,...
Find the error(s) in each of the following code segments and explain how to correct it: a) i = 1; while (i
Consider an antenna transmitting at 900 MHz. The receiver is traveling at a speed of 40 km/h. Calculate its Doppler shift.
The following table shows the density of the random variable X. (a) Find p(8) (b) Find the table for CDF F(x) (c) Find P(3 ¤ X ¤ 5) (d) Find P(X ¤ 4) and P(X < 4). Are the...
Consider a cellular system in which each cell has only one channel (single server) and an infinite buffer for storage the calls. In this cellular system, call arrival rates are discouraged, that is,...
What are the differences between fast fading and slow fading?
Path loss, fading, and delay spread are the three important radio propagation issues. Explain why those issues are important in a cellular system?
What is the role or usefulness of reflected and diffracted radio signals in a cellular system? Explain with suitable examples.
An MS is not in the direct line of sight of a BS transmitting station. How is the signal received? Explain.
Consider two random variables X and Y that are independent and Gaussian mean and the other is of mean . Prove that the density function of Z = X + Y is Rician distributed.
The density for X is given in the table of Problem 7. (a) Find E[X] (b) Find E[X - ] (c) Find Var[X] (d) Find the standard deviation for X.
An octagon shaped cell is closer to a circle than a hexagon. Explain why such a shape is not used as an ideal shape of the cell?
If each user keeps a traffic channel busy for an average of 5% time and an average of 60 requests per hour is generated, what is the Erlang value?
For the following cell pattern, (a) Find the reuse distance if radius of each cell is 2 km. (b) If each channel is multiplexed among 8 users, how many calls can be simultaneously processed by each...
The following figure shows a cellular architecture. Is there some specific reason why it could have been designed this way? (4 5 3
What is the key issue for contention-based access protocols? How is it solved? Give an example to explain your answer.
How does slotted ALOHA improve throughput as compared to pure ALOHA?
Is it impractical to use ALOHA or slotted ALOHA for MSs to access control channel associated with the BS? Explain clearly.
What is meant by a collision in data transfer and why is it not possible to decipher information from collided data? Explain clearly.
What are relative advantages and disadvantages of persistent and non-persistent CSMA protocols? What makes you select one over the other? Explain clearly.
Describe the advantages and disadvantages of 1-persistent CSMA and p-persistent CSMA respectively.
Can we use CSMA/CD in cellular wireless networks? Explain your answer with solid reasoning.
What are the major factors affecting the throughput of CSMA/CA?
What is the difference between collision detection and collision avoidance?
What are the relative advantages and disadvantages of basic CSMA/CA and CSMA/CA with RTS/CTS protocols? What makes you select one over the other?
What in your opinion should be the criteria to select the value of the contention window? Also explain how you will decide the value of the time slot for CSMA/CA.
In a CSMA/CA scheme, a random delay is allowed whenever a collision occurs. What is the guarantee that future collision between previously collided terminals will not occur? Explain the rationale...
Why does contention window need to be changed sometimes? Explain clearly.
In CSMA/CA, why do you need a contention window, even after DIFS? What is the typical size of the contention window?
How many users can a wireless AP handle? What happens if the number of MSs exceeds this value?
A clustering approach has been suggested to locally collect and aggregate information in a sensor network. What kind of aggregation is desirable?
a. In Figure 2-16, what will be the value in the destination port number field if a packet arrives for the e-mail application? (Yes, this is a repeat question.) b. When the HTTP program on a...
a. What is alphanumeric information? b. Explain how many bytes it will take to transmit Go team without the quotation marks. 22b.) How many bytes will it take to transmit "Brain Dead" without the...
Can you think of a way to allow a client on one virtual LAN to communicate with a server on another VLAN? Switches typically have no way of doing it. It involves an access control list or some other...
Explain the key general principle of network design and why you should follow it.
a. What is the definition of hacking? 9a1.) Hacking is defined as using a computer resource without authorization or in excess of authorization. a. True b. False 9a2.) Which of the following meets...
In the Ms. Betsy Davis case at the beginning of the chapter, the access point on the local network did not have security. This makes a man-in-the-middle attack much easier. a. Given what you learned...
The image of Fig. 8-54(b) contains the ASCII text of five plays by Shakespeare. Would it be possible to hide music among the zebras instead of text? If so, how would it work and how much could you...
a. How does the postal service use hierarchical sorting? b. How does this simplify delivery decisions?
A router that has the routing table in Figure 8-11 receives an incoming IPv4 packet. The source IPv4 address in the arriving packet is 10.55.72.234. The destination IPv4 address is 10.4.6.7. The TTL...
Consider a finite support signal x(t) = t, 0 t 1, and zero elsewhere. (a) Plot x(t +1) and x(t +1). Add these signals to get a new signal y(t). Do it graphically and verify your results...
a. If you need to transmit 600 million bits per second 90 meters, what signaling standard and UTP quality standard would you use? 7a1.) UTP categories rate the ______ of UTP cabling. a. Quality b....
a. In a Wi-Fi LAN, do two wireless hosts usually send frames directly to one another? Explain. 3a.) In a Wi-Fi LAN, wireless hosts generally send frames directly to one another. a. True b. False b....
a. What kind of physical device is an evil twin access point? 8a1.) An evil twin access point is usually _______. a. A reprogrammed access point b. A laptop computer c. A rogue access point d. Any of...
a. What does it mean that Bluetooth uses one-to-one operation? 15a.) Bluetooth uses _______ operation. a. All-to-all b. Point-to-multi-point c. One-to-all d. One-to-one b. Is this still true if a...
a. Create the hexadecimal multiplication table. b. Use the hexadecimal table in Figure 3.8 to perform the following addition: 2AB3 + 35DC c. Add the following numbers: 1 FF9 + F7 d. Multiply the...
What is the purpose of an IP address mask?Suppose an IP address is identified as 222.44.66.88/24. What is the network address in this case? What is the host address? How many hosts can this network...
Clusters and networks are both categorized as loosely coupled systems, but they serve different purposes. Explain the differences in purpose between clusters and networks.
Clearly and carefully discuss each of the advantages of clustering.
Obtain information and compare the features, capabilities, performance, and operational methods between Windows Server, Linux, and IBM zSeries clustering techniques.