Answer:
LIKE.
Explanation:
A structured query language (SQL) can be defined as a domain-specific language designed and developed for managing the various data saved in a relational or structured database.
In Computer programming, any word restricted for use, only in object names because they belong to the SQL programming language are called reserved word.
Hence, these reserved words can only be used as the name of an object but not as an identifier e.g the name of a function, label or variable.
Some examples of reserved words in structured query language (SQL) are UPDATE, GROUP, CURRENT_USER, CURRENT_DATE, CREATE, DELETE etc.
Hence, SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value matches a value contained within a subset of listed values is LIKE.
If you have an array of 100 sorted elements, and you search for a value that does not exist in the array using a binary search, approximately how many comparisons will have to be done?
a)7
b)100
c)50
Answer:
50
Explanation:
as binary search will search the array by dividing it into two halves till it find the value.
Write a method intersect that accepts two sorted array lists of integers as parameters and returns a new list that contains only the elements that are found in both lists.
Answer:
Explanation:
The following code is written in Java. It creates a function called equalElements that takes two ArrayList of integers as parameters loops through both of them to find the elements that are equal in both and then adds those elements to a new ArrayList called repeated. Then the ArrayList is returned to the user.
public static ArrayList<Integer> equalElements(ArrayList<Integer> arrOne, ArrayList<Integer> arrTwo) {
ArrayList<Integer> repeated = new ArrayList<>();
for (int x: arrOne) {
for (int i: arrTwo) {
if (x == i) {
repeated.add(x);
break;
}
}
}
return repeated;
}
Question # 2 Multiple Choice The _____ method returns an integer between the two provided numbers. It can take the value of either of the provided numbers. seed randint random range
Answer:
randint
Explanation:
Answer:
randint
Explanation:
ed 2021
In this exercise, you will get some practice with the __add__ method by implementing it for a class called ContactBook. This class represents a collection of names and phone numbers. ContactBook stores its information as a dictionary, where the key is a name and the value is a phone number or group of phone numbers. The keys and values in this dictionary are stored as strings. When printed, a ContactBook might look like this:
Answer:
class ContactBook():
def __init__(self):
self.contacts ={}
def __repr__(self):
return str(self.contacts)
def add_contact(self,name,number):
self.contacts[name] = number
def __add__(self, other):
new_contact = ContactBook()
other_contact = other.contacts.keys()
for name,num in self.contacts.items():
if name in other_contact:
new_contact.add_contact(name,num or other_contact[name])
else:
new_contact.add_contact(name,num)
for name,num in other.contacts.items():
if name not in self.contacts:
new_contact.add_contact(name, num)
return new_contact-
cb1 = ContactBook()
cb2 = ContactBook()
cb1.add_contact('Jonathan','444-555-6666')
cb1.add_contact('Puneet','333-555-7777')
cb2.add_contact('Jonathan','222-555-8888')
cb2.add_contact('Lisa','111-555-9999')
print(cb1)
print(cb2)
cb3 = cb1+cb2
print(cb3)
Explanation:
The ContactBook class holds the contact details of an instance of the class. The class has three magic methods the '__repr__', '__init__', and the '__add__' which is the focus of the code. The add magic method in the class adds the contact book (dictionary) of two added object instance and returns a new class with the contact details of both operand instances which is denoted as self and other.
Write a program with total change amount as an integer input, and output the change using the fewest coins, one coin type per line. The coin types are Dollars, Quarters, Dimes, Nickels, and Pennies. Use singular and plural coin names as appropriate, like 1 Penny vs. 2 Pennies.
If input is 0 or less, output is 'No Change'
For Example: Input: 45
Output:
1 Quarter
2 Dimes
input_val = int(input())
if input_val <= 0:
print('No change')
else:
num_dollars == input_val // 100
input_val %= 100
num_quarters == input_val // 25
input_val %= 25
num_dimes == input_val // 10
input_val %= 10
num_nickels == input_val // 5
input_val %= 5
num_pennies == input_val
if num_dollars > 1:
print('%d dollars' % num_dollars)
elif num_dollars ==1:
print('%d dollar' % num_dollars)
if num_quarters > 1:
print('%d quarters' % num_quarters)
elif num_quarters ==1:
print('%d quarter' % num_quarters)
if num_dimes >1:
print('%d dimes' % num_dimes)
elif num_dimes ==1:
print('%d dime' % num_dimes)
if num_nickels >1:
print('%d nickels' % num_nickels)
elif num_nickels ==1:
print('%d nickel' % num_nickels)
if num_pennies >1:
print('%d pennies' % num_pennies)
elif num_pennies ==1:
print('%d penny' % num_pennies)
Answer:
b ,/knlk
Explanation:
A system administrator at Universal Containers created a new account record type. However, sales users are unable to select the new record type when creating new account records. What is a possible reason for this? (Choose 2)
Explanation:
We have these reasons below as the
The reason why sales users are not able to select the new record type while they are trying to create a new account:
1. The users profile does not contain the record type yet. That is, this record type has not been added to the profile of the sales user.
2. This record type is yet to be activated.