S
  1. study help
  2. subject categories
  3. computer science
  4. databases
  5. january 2021
  6. 20

Databases Questions and Answers January 20, 2021

Expert-verified solutions to help you succeed

Arithmetic Questions (A-G 2 marks each) Do these questions by hand, show your steps. Feel free to check your answer with a calculator so you don't get it wrong. If you need extra space, expand the boxes. A: Unsigned Hexadecimal Subtraction (Based on section 3.2 in the text) Calculate the following values by hand. All numbers represent unsigned
image text in transcribed

SQL Database Run the file to create the students table. Write the command that will list the structure of the STUDENTS table. Display a list of all data contained in the STUDENTS table

Excel calculates addition operations before operatien within parentheses are performed.
image text in transcribed

(6) A random point (X, Y) in the unit square has joint density for 0 x 1 and 0 y 1, for some constant c. . Evaluate c. Find P(X a), 0 a 1. Find P(Y b), 0 b 1
image text in transcribed

Pipelining Computer Architecture Questions 2-part question. From the diagram included below. What is the speedup of the pipelined execution (bottom) over the single cycle execution (top) for the three instructions ? (This is an unusual question, b) is the normal speedup.) For a large number of instructions we consider how often an instruction can
image text in transcribed

Write a procedure [stub] named UseThree that has three unsigned integer stack parameters: a byte, a word, and a doubleword.[Use PROC header parameter declarations. RR]

An asterisk in a search query is used to represent a wildcard. True False
image text in transcribed

Please do questions 1-8 and please provide screenshots of the result and code Lab 4 Scouting and Fingerprinting using Nmap and Ncat The following are required for this lab: A working installation of kali linux Internet Access Functioning VPN from labi nmap and ncat Follow these instructions to verify your nmap installation PART 1-NMAP Verify nmap
image text in transcribedimage text in transcribedimage text in transcribed

The grading scheme for a Stat 100 class is as follows: 20% Assignments 80% Best 3 out of 4 Exams Suppose a student scored 85% on the assignments, and their four exam grades (out of 100) are 85, 55, 76, and 12. Use a weighted mean to calculate their grade in this course. Round to the nearest whole number. Grade = Obviously the student didn't really
image text in transcribed

NMR: \\\\delta 1.28(3H,t,J ) = ( 7Hz);\\\\delta 3.91(2H,q,J ) = ( 7Hz);\\\\delta 5.0(1H,d,J ) = ( 4Hz);\\\\delta 6.49(1H,d,J ) = ( 4Hz)ppm \ IR: 3100,1644 (strong), 1104, 1166, 694cm^(-1) (strong)\ no IR absorptions in the range 700-1100cm^(-1) or above 3100cm^(-1) \ Mass spectrum: (m)/(z)=152,150 (equal intensity; double molecular ion) NMR:
image text in transcribed

In OS , the response time is very critical Desktop b . Real Time c . Batch d . Multitasking e . Distributed
image text in transcribed

Import on Excel. Premiere Movie Source April 2021 Data A B C D E F G H 4. Genre Week 1 Week 2 Week 3 Week 4 Category Totals % of Month Summary 5. Action & Adventure 2,105 1,985 2,241 2,424 8,755 23.4% 6.Comedy 1,800 1,805 2,045 1,945 7,595 20.3% 7.Drama 1,645 1,503 1,475 1,304 5,927 15.8% 8.Horror 1,206 1,121 945 917 4,189 11.2% 9.Sci-Fi & Fantasy

Define the following method in MyList and implement it in MyAbstractList. // Adds the elements in otherList to this list. // Returns true if // this list changed as a result of the call. public boolean addAll(MyList otherlist) *********Add code to TestMyArrayList.java to demonstrate that this method works correctly . Display the modified list

Please answer as soon as possible and answer as much as possible. JAVA! Class Member is defined as follows: public class Member { String name; double fees; } A) How do you completely encapsulate data? B) Write a method for this class that gets a positive double as a discount that should be subtracted from the fees. The method should throw
image text in transcribed

Continue with Freshius the online provider of fresh organic meal kits. Use the following summary of the Revenue cycle to complete the requirements below. Sales Orders are received from customers via the web site and reviewed by a sales clerk A meal preparation employee pulls the necessary ingredients from the stock of fresh organic food maintained
image text in transcribed

What element creates a drop - down menu? input type = "menu" > input type = "select" >
image text in transcribed

Based on the following UML diagram, the Student class has been defined in Java. Inside the driver method, If the first instantiation statement assigns John" and 1111 for the data-fields name' and 'id' referred to by S1, what would the second instantiation-statement assign to the data fields 'name' and id referred to by the reference variable S2.
image text in transcribed

S. (10 points) Simlify the block diagram shown in Figure 1 and obtain the closed-loop transfer function C(s)/R(s). R(S) X(s) Cs) G G2 HO Fig. 1
image text in transcribed

A Personal Fitness Tracker is a wearable device that tracks your physical activity, calories burned, heart rate, sleeping patterns, etc. One common physical activity that most of these devices track is the number of steps you take each day. The steps.txt file (provided in the assignment folder) contains the number of steps a person has taken each

How many times will this ?loop execute int vali 7; while (vall
image text in transcribed

Assume the usage of 2-bit dynamic branch prediction scheme where the change of prediction occurs only if it is predicted wrongly twice. Assume the predictions are T, T, NT, NT while actual outcomes of branches are NT,NT,NT,T. What is the next prediction? T indicates 'Taken' and NT indicates 'Not Taken'. * Taken Not Taken cannot determine Taken or
image text in transcribed

Exploratory Data Analysis with Python In this assignment, you have been provided with a dataset that contains unit cost, sales, and profit as a synthetic dataset designed to simulate real - world scenarios. However, the dataset is not perfect and presents some challenges that you must overcome. It contains missing values and outliers, which can
image text in transcribed

1. a) "RADIUS" is an acronym for Remote Authentication Dial In User Service. Most companies implement a RADIUS server to enhance their network security. RADIUS associates with a client, such as a wireless access point, authenticating and authorizing users attempting to access the network. Illustrate the implementation of RADIUS server for scalable
image text in transcribed

describe a scenario where each type of the above database management systems is being used

Create a 5 by 7 matrix of random integers, each in the inclusive range from 6 to 15. Perform each of the following: a) subtract 5 from each element, then square each element. b) get the minimum and the maximum values of the matrix in (a). c) count how many are positive, how many are negative, how many elements are equal 0 in the matrix in (a).

What is the major difference between the software methodologies the Waterfall Method and the Agile method from the requirements perspective?

Please Explain step by step also. Thank you Write a nested loop to extract each digit of n and print digit X's per line. Example Output (if n==3452): XXX XXXX XXXXX XX
image text in transcribed

Please help with the following: Make a list of all connectors you have on your computer. how would I see it on windows 10

Assume the schedule S: W4(y) R1(x) R1(w) W1(w) W2(x) C2 W3(w) C3 W4(w) C4 W1(z) C1 Where Rn(x)/Wn(x) indicates transaction Tn reads/writes data item x, and Cn indicates Tn commits. 1.Show the precedence graph of S. 2.Prove S is correct, i.e., serializable. 3.Enumerate all serial schedules that are equivalent to S.

point ich of these loops will decrement p while w is less or equal to 5 0 . none of these for ( int i = 0 ; i 1 0 ; i + + p - - ; w + + ; hile p - - ; w + + ; { + + ile ) > ( 5 0
image text in transcribed

What is a functional program? A. A program that runs not based on a requirement B. A system that does not work C. A software that works or functions as required D. A system that functions in a wrong way

I need help with this program. I need it to be able to sum strings and also when summing two decimal values, the result must be decimal as well. It does identify the tokens, basicallyreads them and implement them through mathematical calculations, but with strings it doesn't work. C programs starts but once you input a statement it explodes, but

The program I am using is IntelliJ. The DrawingPan class is provided underneath. // The DrawingPanel class provides a simple interface for drawing persistent // images using a Graphics object. import java.awt.*; import java.awt.event.*; import java.awt.image.*; import javax.swing.*; import javax.swing.event.*; import static javax.swing.JFrame.*;
image text in transcribed

Noonian is a designer currently working on a social media app for robotics engineers. He shows you a black - and - white sketch depicting a single screen where users would create profiles for their robots in the app. The sketch includes a navigation bar, a field to type in the robot's name, and a drop - down menu for a few of the robot's

Select the best answer from among the given options: An algorithm can be defined as a well - defined and produces output. natural artificial mechanical All of these answers are valid. computational

A Managerial Dashboard typically provides detailed project execution instructions. True False
image text in transcribed

(c) Let f be a function R{3}R{1} with f(x)=x+3x. i. Show that f is a bijective function ii. Find the inverse function f1 iii. Plot the curves of both function f and f1 on the same graph. iv. suppose we change the co-domain of the function f to be R : f:R{3}R v. Is f still a bijective function? Explain your answer. (d) How many binary sequences of
image text in transcribed

Can someone please show me their code and JavaDoc it. I am using Eclipse (Java) to code. Thanks! Write a program, StringManipulation, that implements a method toUpperCase that for a given string converts all its characters to uppercase and returns the new String. The method should not modify the string passed as input parameter to the method. The

1 2 . What is a project in RSLogix software? How is it created? 1 3 . Explain the process 'Configuring System Communication'

OLAP is the main source of data for OLTP True False
image text in transcribed

Overview: Modern companies compete in a challenging environment. To remain competitive, they must react rapidly to problems and opportunities that arise from extremely dynamic conditions. Enterprise information systems (EIS) include any kind of information system that improves the functions of enterprise business processes. EIS helps companies

What is meant by the term nesting of procedures?

tals een kiem een MIC waarde heeft hoger dan de wild type populatie is de kiem onbehandelbaar

In Verilog, a module cannot be nested, but a ( case ) can. Select one: True False
image text in transcribed

A company recently experienced a security incident in which a USB drive containing malicious software was able to covertly install malware on a workstation. Which of the following actions should be taken to prevent this incident from happening again? ( Select two ) . A . Install a host - based IDS. B . Restrict log - in times. C . Enable a BIOS

Provisioning is a key factor of device management. Which of the following best describes provisioning? Select one: a. When a new device is added to the system, the device should securely register itself with the device management service b. registering the metadata for the device c. Registering the device provides it with identity and credentials.

Question 1. (25 POINTS): Given the recurrence: 762)={2++ if n = 2 if n = 2k for k > 1 use substitution method to check if T(n) = O(nlgn). Please show your work
image text in transcribed

1 . Define the AWS service used for creating a volume instance to be attached to an EC 2 instance. Give the abbreviation, full form, and details. 2 . What is the main type of storage provided in AWS for uploading and storing files? Provide the abbreviation, full form, and its explanation. 3 . What protocol is used for connecting to an EC 2

Complete exercise 14.47 on page 552 Submit the Responder.java file Responder.java file: import java.io.*; import java.nio.charset.Charset; import java.nio.file.*; import java.util.*; public class Responder{ //Default responses to use if we dont recognise a word private List DefaultResponses; //Tha name of the file containing the default responses
image text in transcribed

Which of the following about the Total row in Query design is fa / se ? The Total row applies only to non - numeric fields. The Total row is hidden by default in all new queries. The Total row is located between the Table and Sort rows. The Total row enables you to apply aggregate functions to the fields.
image text in transcribed

An American Standard Code for Information Interchange ( ASCII ) file defines up to a . 6 4 characters. b . 1 2 8 c . 2 5 6 d . 1 0 2 4
image text in transcribed

In the three - tiered model, which layer has the fastest switches?

In C#, write an application to sell tickets to an event. There are 8 rows in our small event center. Rows 1 and 2 are considered VIP seats and sell for $450 each. Seats in rows 3 and 4 are sold for $350 each. Seats in rows 5, 6, and 7 are $300. Seats in row 8 are $250. The application is simplified and assumes the seats are always available. You

er Knall 1 ) Das Auto gab pl tzlich einen lauten Knall von sich.

Objectives This research is a security assessment of a small group of systems. In this assessment, students will apply security tools and resources learned in labs to a set of unknown systems. They will synthesize the output of security tools and the results of research into a report evaluating the security of each unknown system. 1 Scope of

Quel est l'avis des acadiens vis - - vis le projet de conf d ration ?

What is the expected output from the statements below int x, y: x = (4*2) + (10/2) - 2; y = x + 2; printf("x = %d, y = %d", x, y); A x = 22, y = 24 B. x = 10, y = 15 C) x = 18, y = 20 D x = 11, y = 13
image text in transcribed

Fill in the blank: Privacy protection means safeguarding from unauthorized use. business networks personal information compliance processes documentation
image text in transcribed

/ * * * 4 points * * If a given character x is in a given string, then * return the substring of characters after * the first occurrence of x . Otherwise return the * empty string ( which is just " " ) . * This can be accomplished without any loops at * all if you use methods of the String class. * Check the Java API for String.

I need help with this Binary Search Tree Node (BTSNode). /* * File: bst.cpp * ------------- * This file implements the bst.h interface. */ #include #include #include "bst.h" using namespace std; BSTNode *findNode(BSTNode *t, const string & key) { if (t == NULL) return NULL; if (key == t->key) return t; if (key key) { return findNode(t->left, key);
image text in transcribedimage text in transcribedimage text in transcribed

What algorithm can be used to determine whether the system will be in a safe state if it decides to grant a request for a resource to a process?

3. Consider the grammar SABCAaACBbBCBAd 1. For each non-terminal, say if the non-terminal satisfies the first condition for predictive parsing (First condition: For every non-terminal if A and A are grammar rules, then FIRST () FIRST()=) 2. For each non-terminal, say if the non-terminal satisfies the second condition for predictive parsing (Second
image text in transcribed

Please answer the following questions: Ql [1.5 pts]: For each of the following relation schemas and set of FD's: o R(A,B,C,D) with FD's ABC, C- D, and D o R(A.B.C.D) with FD's B C and B D A o R(A,B,C,D) with FD's AB C, BC -> D, CD > A and AD> B o R(A,B,C,D) with FD's A B.B -> C, C D and D A o R(A,B,C,D.E) with FD's AB C, DE -> C, and B -> D o
image text in transcribed

Which of the following is NOT a method often used to capture structured data: Question 2 1 options: Check boxes Free text note Radio buttons Standard vocabularies

Due to the changes, the original implementation of the following methods will no longer work. Please based on this change, make necessary changes to the following methods public int size() //return the number of nodes public Node parent(Node p) throws IllegalArgumentException //return the parent node for a node referred by p Add and implement the

Push-relabel algorithm: what is the definition of the height function? Suppose we are able to discharge the excess from every vertex and continue to have a valid height function. Why must the flow be maximum? Suppose we have not discharged the excess from vertex u. Why must there exist a path from u to s in the augmenting graph? What is the max

Please show how you calculate the address of command also. Question 2 [1 point] Fill in the table with correct values. One value for each of the two right columns is shown as an example which you should use to show your answers Line Assembly # Instruction Machine Language Instruction Address of command in memory 1 Iw $t3, 4($t0) Ox0040fffO 2 add
image text in transcribed

Find an insertion order for the keys S , E , A , R , C , H , X , and M that leads to a 2-3 tree of height 1. In the problem, you should use the alphabetical ascending order of the letters to construct the 2-3 tree. Note that the height of an empty tree is height -1. And the height of a tree with only a root node is 0.

Question 1: Find the output of the following piece of code: (5 marks String s1, s2, s3; s1 -"Mental-Break" s2 = "Lasted" ; System.out.printin(s1.length0) System.out.printin s1.lastlndexOf'e)): System.out.printin(s1.compareTok(S2)) System.out.println(s1.charAt(1)) s3-s1.substring(7); for (int ias3 length-1 ; i >-o; i..) Na
image text in transcribedimage text in transcribedimage text in transcribed

In at most 80 characters on one line, answer the following question - Assume that the variable my_input is bound to a string representing an employee's salary without decimals. Write a Python expression that binds the variable s alary to a numeric representation of the employee's salary.

Consider F and C below.\ F(x,y,z)=yzi+xzj+(xy+16z)k \ C is the line segment from (2,0,-1) to (4,4,2) \ (a) Find a function f such that F=gradf .\ f(x,y,z)= \ (b) Use part (a) to evaluate \\\\int_C F*dr along the given curve C .\ Need Help? Consider F and C below. F(x,y,z)=yzi+xzj+(xy+16z)k C is the line segment from (2,0,1) to (4,4,2) (a) Find a
image text in transcribed

HostA has established a TCP connection with HostB in a remote network. HostA is sending packets to HostB. Assume we have configured TCP , somehow, to ACK every segment ( no ACKing every other segment ) . Assume that the timeout is the same for all packets. HostB's "window size" is 2 0 0 0 0 bytes. HostB has already received and acknowledged
image text in transcribed

Model reduction Project Write a matlab code to create a reduced model for the transient diffusion equation Use PGD with 3 variables: k,x,t The space-time-diffusivity domain is x t k = (0, 1) (0, 0.1) [1, 5]. For the the source term, take f = 1. Regarding the initial and boundary conditions, take: u(x, t = 0) = u(x = 0, t) = u(x = 1, t) = 0, Use

6. For the following grammar (6 points) S ABa A Aab |A B + Bb|A to find a grammar without A productions that generates the same language, we first identify non-terminals that drive A. These non-terminals are: A and B. Then from S ABa, we construct S from A Aab, we construct A from B Bb, we construct B So, the grammar without A that generates the
image text in transcribed

The assassination of President William McKinley occurred on Sept. 6 t h , 1 9 0 1 in Buffalo, NY . The assassin covered the gun with a cloth. Who published methods to match a bullet to the barrel that fired it ? Sir Edward Henry Henry Faulds Alexandre Lacassagne Carl Scheele
image text in transcribed

2 0 - 0 0 2 . what information about the department are members prohibited from posting on social media accounts?

Consider the mutex algorithm of Ricart and Agrawala. Recall the assumptions: 1. Each thread executes at non-zero speed. 2. Communication lines and input ports are non-FIFO (non here means not necessarily). 3. Each thread can receive its input messages independently, without synchronization issues with other threads inputs. In each question, a

Please complete the functions given in the chart below: CONSTANTS = { 'N_COLUMNS': 5, 'N_ROWS': 4, 'BLACK_SQUARE': '#', 'RED_SQUARE': 'R', 'YELLOW_SQUARE': 'Y', 'ACROSS': 'across', 'DOWN': 'down', 'DOWN_RIGHT': 'dright', 'DOWN_LEFT': 'dleft' } # The next several lines contain constants for you to use in your code. # You must use these constants
image text in transcribed

Objectives Work with File I/O Work with 2 dimensional arrays Description: You are to read a file of numbers. You will break apart each number into an array (a set). Compare each array of numbers (set) to tell me if one is the subset of another. Requirements: ANSWER MUST BE IN C No more than 10 sets will be in the file No more than 5 numbers in a

It has to be done in java // Concat: you should be able to join together two arrays function concat(arri, arr2) { return; }
image text in transcribed

1. For the following logic expressions, build the static CMOS implementation. Your solution should be a clearly labeled transistor schematic. (a) [2 pts] Z =!((a&b&c)|d) (b) [2 pts] Z =!((a|b)&((c&d)|((e|f)&g))) (c) [2 pts] Z =!((a&b)|(c&d&e)|(f&g&h))

To prevent malware infection in your network system, you decide that it's critical to prevent malware attacks, such as ransomware and phishing, by restricting access to sites that might be malicious. Which of the following BEST represents this type of prevention technique?

Coding in Python, implement a function that modifies an existing user account. Your function should give the following options: Lock the account Change the real name associated with the account Add the user to the root group

What kind of threats are eliminated by replacing bar codes with radio - frequency identification tags?

E 3 B . 1 Consider a system consisting of two protons sepa - rated by a distance of 2 . 0 nm .

Given the expression: int array[3]; What is the datatype of the following expression? array[2] is it.. int & or int ** or int * or int

What feature of VirtualBox is the most compelling

An AVL tree is used to count the number of times each word occurs in a text file. Each node of the tree stores a word, with its count. The tree is ordered alphabetically by words. If there are k distinct words , and n words in total , what would be the worst case big O time to store all the words with their counts in the tree? Only Count word

What is the vCenter Serve Appliance? Question 3 options: A prepackaged Windows - based VM that is optimized for running vCenter Server and associated services. A prepackaged Linux - based VM that is used as a service of vCenter Server, allowing for easier access to it . A prepackaged Windows - based VM that is used as a service of vCenter Server,

Using tables like STORE _ ADDRESS, CUST _ ADDRESS, EMP _ ADDRESS, and VEND _ ADDRESS, database designers should consider breaking which attribute to make it easier to query, for example, where most products are coming from to improve shipment expenses and logistics ? EMP _ ADDRESS VEND _ ADDRESS STORE _ ADDRESS CUST _ ADDRESS
image text in transcribed

Question 1 4 Alan Turing described the basic mechanisms needed to design a machine that could: drive an autonomous vehicle add, subtract and multiply play chess compute any function for which an algorithm exists
image text in transcribed

An organization frequently implements changes, reconfigurations, and patches to enhance its IT infrastructure's security and efficiency. The cybersecurity analyst must carefully analyze dependencies between services, applications, and interfaces to avoid unintended outages and disruptions during service restarts or downtime events. How does

project 2 - 1 : exploring common vulnerabilities and exposures

Recursively Defined Sequence #1: Bit Strings Define the sequence Bn = Number of different n-bit binary strings that contain at least one bit, but that do not contain the substring 101 111. For example B3 = 7 because the following seven bit strings of length 3 do not contain 111: 000, 001,010, 011, 100, 101, 110. Note that this question was
image text in transcribed

Write a Java Code for the following GUI application
image text in transcribed

What is the output of the following code? System. out. print ln ( Math . pow ( 3 , 2 ) ) ; 5 4 6 9
image text in transcribed

Can you please explain me with example primitive polynomial irreducible polynomial Reducible polynomial I am having difficulty understanding trying to solve crypotography fundamental questions

An assertion that is always true is called a:

Please do not include C++ code. I need regular expressions. Such as (/\*([^*]|[ ]|(\*+([^*/]|[ ])))*\*+/)|(//.*) (20pt) Assume you have a C++ source file which you edit using the BBEdit editor (barebones.com). You need to replace all comments in the /* ... */ style that span a single line with the same comment in the // ... style. This can be done
image text in transcribed

Your boss wants to create a report that shows the contents of your database in a structured manner. To accomplish that, you will need to convert your data to a text format so that you can lay it out properly in your report. You want to organize the results using the Where Clause. You need to create a report (Query output) that uses the Cast

Showing 1100 - 1200 of 1500
  • 12 / 15