All categories

3 years ago

What is the difference between the Paste Special and Paste Link options?

Computers and Technology

2 answers:

kotegsom [21]3 years ago

8 0

Paste Link lets you automatically update the referenced document.

vivado [14]3 years ago

4 0

Answer:

paste link lets you automatically update the referenced document

Explanation:

The paste link option lets you automatically update the referenced document, the paste link option is used to paste a link to a website or the link you copied using the copy link option. the paste link option makes referencing a website easy and you automatically update the referenced document as well.

paste special helps you determine how the contents that you are pasting from a clipboard will be displayed both paste link and paste special options are applied after the copy option has been done already.

You might be interested in

I need the SQL statements for these questions:

zimovet [89]

Answer:

Explanation:

/* From the information provided, For now will consider the name of table as TRIPGUIDES*/

/*In all the answers below, the syntax is based on Oracle SQL. In case of usage of other database queries, answer may vary to some extent*/

Select R.Reservation_ID, R.Trip_ID , C.Customer_Num,C.Last_Name from Reservation R, Customer C where C.Customer_Num=R.Customer_Num ORDER BY C.Last_Name

/*idea is to select the join the two tables by comparing customer_id field in two tables as it is the only field which is common and then print the desired result later ordering by last name to get the results in sorted order*/

Select R.Reservation_ID, R.Trip_ID , R.NUM_PERSONS from Reservation R, Customer C where C.Customer_Num=R.Customer_Num and C.LAST_NAME='Goff' and C.FIRST_NAME='Ryan'

/*Here, the explaination will be similar to the first query. Choose the desired columns from the tables, and join the two tables by equating the common field

Select T.TRIP_NAME from TRIP T,GUIDE G,TRIPGUIDES TG where T.TRIP_ID=TG.TRIP_ID and TG.GUIDE_NUM=G.GUIDE_NUM and G.LAST_NAME='Abrams' and G.FIRST_NAME='Miles'

Here,we choose three tables TRIP,GUIDE and TRIPGUIDES. Here we selected those trips where we have guides as Miles Abrms in the GUIDES table and equated Trip_id from TRIPGUIDES to TRIP.TRIP_Name so that can have the desired results

Select T.TRIP_NAME

from TRIP T,TRIPGUIDES TG ,G.GUIDE

where T.TRIP_ID=TG.TRIP_ID and T.TYPE='Biking' and TG.GUIDE_NUM=G.GUIDE_NUM and G.LAST_NAME='Boyers' and G.FIRST_NAME='Rita'

In the above question, we first selected the trip name from trip table. To put the condition we first make sure that all the three tables are connected properly. In order to do so, we have equated Guide_nums in guide and tripguides. and also equated trip_id in tripguides and trip. Then we equated names from guide tables and type from trip table for the desired results.

SELECT C.LAST_NAME , T.TRIP_NAME , T.START_LOCATION FROM CUSTOMER C, TRIP T, RESERVATION R WHERE R.TRIP_DATE='2016-07-23' AND T.TRIP_ID=R.TRIP_ID AND C.CUSTOMER_NUM=R.CUSTOMER_NUM

The explaination for this one will be equivalent to the previous question where we just equated the desired columns where we equiated the desired columns in respective fields and also equated the common entities like trip ids and customer ids so that can join tables properly

/*The comparison of dates in SQL depends on the format in which they are stored. In the upper case if the

dates are stored in the format as YYYY-MM-DD, then the above query mentioned will work. In case dates are stored in the form of a string then the following query will work.

SELECT C.LAST_NAME , T.TRIP_NAME , T.START_LOCATION FROM CUSTOMER C, TRIP T, RESERVATION R WHERE R.TRIP_DATE='7/23/2016' AND T.TRIP_ID=R.TRIP_ID AND C.CUSTOMER_NUM=R.CUSTOMER_NUM

Select R.RESERVATION_ID, R.TRIP_ID,R.TRIP_DATE FROM RESERVATION R WHERE R.TRIP_ID IN

{SELECT TRIP_ID FROM TRIP T WHERE STATE='ME'}

In the above question, we firstly extracted all the trip id's which are having locations as maine. Now we have the list of all the trip_id's that have location maine. Now we just need to extract the reservation ids for the same which can be trivally done by simply using the in clause stating print all the tuples whose id's are there in the list of inner query. Remember, IN always checks in the set of values.

Select R.RESERVATION_ID, R.TRIP_ID,R.TRIP_DATE FROM RESERVATION WHERE

EXISTS {SELECT TRIP_ID FROM TRIP T WHERE STATE='ME' and R.TRIP_ID=T.TRIP_ID}

Unlike IN, Exist returns either true or false based on existance of any tuple in the condition provided. In the question above, firstly we checked for the possibilities if there is a trip in state ME and TRIP_IDs are common. Then we selected reservation ID, trip ID and Trip dates for all queries that returns true for inner query

SELECT G.LAST_NAME,G.FIRST_NAME FROM GUIDE WHERE G.GUIDE_NUM IN

{

SELECT DISTINCT TG.GUIDE_NUM FROM TRIPGUIDES TG WHERE TG.TRIPID IN {

SELECT T.TRIP_ID FROM TRIP T WHERE T.TYPE='Paddling'

}

We have used here double nested IN queries. Firstly we selected all the trips which had paddling type (from the inner most queries). Using the same, we get the list of guides,(basically got the list of guide_numbers) of all the guides eds which were on trips with trip id we got from the inner most queries. Now that we have all the guide_Nums that were on trip with type paddling, we can simply use the query select last name and first name of all the guides which are having guide nums in the list returned by middle query.

4 0

3 years ago

Which one of the following commands will list the contents of a directory, and put those listed contents into a file called "myd

9966 [12]

Answer:

ls -pla > mydir

Explanation:

ls is the command to list the contents of the directory.

-p option indicate / as the designator for directories

-l options enables line by line entries for files

-a option lists all files including special files starting with .

> is used for redirecting the output of the ls command to the specified file.

So ls -pla > mydir will run ls command with -pla option and populate the file mydir with the contents of the result.

5 0

3 years ago

Python programming questions:

Aleksandr-060686 [28]

Answer:

Following are the program in the Python Programming Language:

1.)

l=['Ruby','Dale','Kate']

n=input('Enter the name: ')

if(n in l):

print('Hello {}'.format(n))

else:

print('No {}'.format(n))

Output:

Enter the name: Dale

Hello Dale

2.)

file=open("text1.txt", "r+") #open file

str=file.read() #read file

txt=str.replace('\n', ' ') #replace spaces

word=txt.split(' ') #split words in ' '

for words in word: #set for loop

word2=' '

for i in range(len(words)): #set for loop

if(words[i].isalpha()): #set if statement

word2 += words[i].lower()

word[word.index(words)]=word2

while(' ' in word): #set while loop

word.remove(' ') #remove spaces

st=set(word)

print('The ', len(st),' unique words which appears in document are ' \

'(in no particular order): ')

for words in st: #set for loop

print('-', word)

file.close() #close file

3.)

file=open("text1.txt", "r+") #open file

str=file.read() #read file

txt=str.replace('\n', ' ') #replace spaces

word=txt.split(' ') #split words in ' '

for words in word: #set for loop

word2=' '

for i in range(len(words)): #set for loop

if(words[i].isalpha()): #set if statement

word2 += words[i].lower()

word[word.index(words)]=word2

while(' ' in word): #set while loop

word.remove(' ') #remove spaces

dic={} #set dictionary

for words in word: #set for loop

if(words not in dic): #set if statement

dic[words]=1

else:

dic[words] +=1

print('\033[4m' + 'word frequency' + '\033[0m')

for words in dic:

print(format(words, '15s'), format(dic[words], '5d'))

file.close() #close file

Explanation:

1.) Here, we define the list data type variable 'l' then, set the variable 'n' and assign value by get input from the user,

we set if conditional statement and pass condition is that the variable 'n' is in the variable l then, print message.
otherwise, we print No message.

2.) Here, we define the variable "file" in which we open file and save that file in it.

Then, we set variable st which read the file then we set the variable in which we apply the replace().

Then. we set variable in which we split the by suing split()

2.) Here, we define the variable "file" in which we open file and save that file in it.

Then, we set variable st which read the file then we set the variable in which we apply the replace().

Then. we set variable in which we split the by suing split()

Then, we apply all that given in the question.

7 0

3 years ago

Express 42 as a product of its prime factor

salantis [7]

The only way to write 42 as the product
of primes.

Except to change the order of the factors is
2 × 3 × 7. We call 2 × 3 × 7 the prime factorization of 42.

6 0

3 years ago

Read 2 more answers

You have been asked to provide an account for an outside consultant, who needs limited access to the network for a very short pe

nata0808 [166]

Answer:

The correct answer to the following question will be "Guest account".

Explanation:

Windows Guest account is a standard, local client account, with quite limited authorizations. It can't access other user account libraries and user files. Only on the desktop and in its user folders can it create files-nowhere else in your PC can it create files and folders.
The Guest account is a Windows minimum-privilege account that occurs on all Windows computers. Users who don't have a specified account are open, and need to access a Windows system from time to time. Users who log on to use the Guest account can access local data and applications, but can not install hardware or software.

Therefore, "Guest account" is the right answer.

3 0

3 years ago