SQL Server Interview Questions and Answers
Ques: 1 How to eliminate duplicate rows in a table?
Ans:
Use a primary key if the column is like ID or number. Alternatively, you can apply a unique constraint on the column.
Ans:
Deletion of duplicate records:
delete from emp a where a.rowid > (select min(b.rowid) from emp b where a.rowid=b.rowid)
or
delete from table t1 where t1.rowid
Ques: 2 What is the use of the ‘in’ command?
Ans:
Suppose you want to choose a specific department, then you can use the ‘in’ command.
Example:
select ename,sal from emp
Computer Studies Exam – 2nd Evaluation – Secondary 1 – March 2015
Computer Studies Exam – 2nd Evaluation [Secondary 1] – March 2015
1. Computer Model Questions
What question does a computer model answer? What specific question does your model answer for its users? (Pg. 71 Let’s Go)
“Remember, models answer the question ‘What if…?’. Your model will answer the question ‘What if a person were doing things that cause global warming and how could they change their behavior?’ for lots of different people.”
2. Advanced Search Options
Using Advanced Search, you can narrow
Read MoreIntroduction to Structures
What is a Structure?
A structure is something that supports an object or a load.
Requirements of a Structure
A structure must:
- Be strong enough to support its own weight and any load that is put on it.
- Be stable (not topple over easily when a force acts on it).
- Resist deformation without losing its shape more than expected.
Types of Structures
There are three types of structures:
- Mass Structures: Solid structures that rely on their own weight to resist loads. Examples include Roman bridges, aqueducts, walls,
Semiconductor Devices and Circuits
sec.1-1 d 3 kinds of
4mulas
a defi nition is a 4mula invented 4
a new concept.A law is a 4mula 4
a rel8on in nature.A deriv8on is a
4mula produced with mathem8cs.
sec.1-2 approxim8ons
approxim8ons r widely used in
d electronics industry.D ideal
approxim8on is useful 4 troubleshooting.
d 2nd approxim8on
is useful 4 preliminary circuit calcul8ons.
higher approxim8ons r
used with computers.
sec.1-3 voltage sources
an ideal voltage source hs no internal
resistance.
D 2nd approxim8on
of a voltage source hs an internal
resistance
C++ Programming Fundamentals: Arrays, References, Structures, and More
Arrays can only contain the same data type. Data types: bool, char, int, float, double. To declare an array: type arrayName [ arraySize ]; — This is called a single-dimension array. To declare a 10-element array called balance of type double, use this statement:
Double balance[10];
—
You can initialize C++ array elements either one by one or using a single statement:
Double balance[5] = {1000.0, 2.0, 3.4, 17.0, 50.0};
— Or you can do this this way:
Double balance[] = {1000.0, 2.0, 3.4, 17.0, 50.0}
Read MoreUnderstanding Computer Hardware: A Comprehensive Guide
Computer Hardware
Core Components
Motherboard
The motherboard, also known as the mainboard or system board, is the central printed circuit board in computers and other systems. It connects and facilitates communication between crucial electronic components, including the central processing unit (CPU), memory, and peripherals.
Microprocessor (CPU)
The microprocessor is the brain of a computer, incorporating the functions of the central processing unit on a single integrated circuit. It accepts digital
Read More