Technology | Practice Questions | Aliensbrain

Multiple choice technology web technology

Which law states that "The value of a network is squared each time another peer joins the network"?

Reed's Law
Sarnoff's Law
Metcalfe Law
Archie's Law

Reveal answer Fill a bubble to check yourself

Multiple choice technology programming languages

A table has following 2 columns with the given valuesc1 c2 -------------- 1 1 1 NULL 2 0 NULL NULL . What will be the output of the following query :select count(*) , count (c1+c2) , count (distinct (c1 + c2)) from temp;

3,2,1
3,2,2
4,2,1
4,3,2

Reveal answer Fill a bubble to check yourself

Multiple choice technology programming languages

SELECT name,salary , dept FROM emp e WHERE NOT EXISTS (SELECT 1 FROM dept WHERE deptno = e.dept); Which employees are retrieved from the above query:

Employees who work for a department that is not listed in DEPT table.
Employees who work from department 1
Employees who work for a department with more than 1 employee
Employees who work for a department other than department 1

Reveal answer Fill a bubble to check yourself

Multiple choice technology web technology

One word for "Network Analyzer".

Ethereal
Wireshark
Sniffer
NetZer

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which SQL statement is used to extract data from a database?

FETCH
EXTRACT
GET
SELECT

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which SQL statement is used to delete data from a database table?

DROP
DELETE
TRUNCATE
REMOVE

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What is a trigger

A piece of logic written in PL/SQL
Executed at the arrival of a SQL*FORMS event
Both A & B
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

RENAME command is a :

DCL command
TCL command
DDL command
DML command

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Data Dictionary:

Is a collection of tables created and maintained by oracle server.
Contain user information.
Contain database information.
Both a and c
All

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

A DML statement is executed when you:

Modify existing rows in a table.
Add a new column in a table
Both a & b
None

Reveal answer Fill a bubble to check yourself

Tag: technology

Questions Related to technology