database

SQL Query;

Drop Table : Delete whole structure of the relation, which we cannot be obtain in future

Update: use to modify existing record

Delete: is used for deleting the record.



To remove a relation from an SQL database, we use the ______ command.
a) Delete
b) Purge
c) Remove
d) Drop table

Comments

Post a Comment

Popular posts from this blog

Networking

Suppose that everyone in a group of N people wants to communicate secretly with the N–1 others using symmetric key cryptographic system. The communication between any two persons should not be decodable by the others in the group. The number of keys required in the system as a whole to satisfy the confidentiality requirement is (A) 2N (B) N(N – 1) (C) N(N – 1)/2 (D) (N – 1) 2 Answer We need to find the total number of possible pairs from the N given people, each pair will share a key. So, number of ways to choose two persons from N people =  N C 2  = N! / ((N −2)!×2!) =  N(N-1)/2 Therefore, correct answer is Option  (C)
Read more

algorithmn

Consider the following pseudo-code fragment, where m is a non-negative integer that has been initialized: p=0; k=0; while(k < m)         p = p + 2 k ;         k=k+1; end while Which of the following is a loop invariant for the while statement? (Note: a loop variant for a while statement is an assertion that is true each time guard is evaluated during the execution of the while statement).
Read more

set theory-1

Image
A  Set  is an unordered collection of objects, known as elements or members of the set. An element ‘a’ belong to a set A can be written as ‘a ∈ A’,  ‘a ∉ A’ denotes that a is not an element of the set A. Representation of a Set A set can be represented by various methods. 3 common methods used for representing set: 1. Statement form. 2. Roaster form or tabular form method. 3. Set Builder method. Statement form In this representation, the well-defined description of the elements of the set is given. Below are some examples of the same. 1. The set of all even number less than 10. 2. The set of the number less than 10 and more than 1. Roster form In this representation, elements are listed within the pair of brackets {} and are separated by commas. Below are two examples. 1. Let N is the set of natural numbers less than 5. N = { 1 , 2 , 3, 4 }. 2. The set of all vowels in the English alphabet. V = { a , e , i , o , u }. Set builder form ...
Read more