Database Administration Questions


Q:

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables ?

A) Data Manipulation Language(DML) B) Data Definition Language(DDL)
C) Both A & B D) None
 
Answer & Explanation Answer: B) Data Definition Language(DDL)

Explanation:

The Data Definition Language (DDL) is used to manage table and index structure.

CREATE,

ALTER,

RENAME,

DROP and

TRUNCATE

statements are the names of few data definition elements.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: IT Trainer , Database Administration , Analyst

12 15350
Q:

I am an English word with five letters. If you remove my last four I am still pronounced the same. What am I?

Answer

An English word with five letters in which if you remove the last four letters, still pronounced the same is QUEUE.

Report Error

View answer Workspace Report Error Discuss

92 15197
Q:

At work i am quite reserved. What does it mean?

A) feel shy B) timid
C) not talkative D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

The given sentence means that, at working hours that person is reserved means he is very timid, feel shy or not talkative or won't share his feelings.

Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

19 14708
Q:

Which unit holds data temporarily?

A) Secondary storage unit B) Output Unit
C) Primary Memory Unit D) Input unit
 
Answer & Explanation Answer: C) Primary Memory Unit

Explanation:

Memory is the part of the computer that temporarily holds data and instructions before and after they are processed by the ALU.

 

Memory is also known as primary storage, primary memory, main storage, internal storage, and main memory.

 

Manufacturers often use the term RAM, which stands for random-access memory.​

Report Error

View Answer Report Error Discuss

23 14691
Q:

Which operation is not performed by computer?

A) Understanding B) Controlling
C) Processing D) Inputting
 
Answer & Explanation Answer: A) Understanding

Explanation:

A computer can perform inputting, processing and cotrolling but it can't perform understanding as it is has no brain. It can't earn from its previous experiances.

Report Error

View Answer Report Error Discuss

21 14586
Q:

Which Of The Following Statements Is Most Accurate For The Declaration X = Circle()?

A) x contains a reference to a Circle object B) You can assign an int value to x
C) x contains an object of the Circle type D) x contains an int value
 
Answer & Explanation Answer: A) x contains a reference to a Circle object

Explanation:
Report Error

View Answer Report Error Discuss

10 14515
Q:

Microprocessors as switching devices are for which generation computers?

A) Fourth generation B) Third generation
C) Second generation D) First generation
 
Answer & Explanation Answer: A) Fourth generation

Explanation:

Microprocessors are used in the computers of fourth generation computers. Personal microcomputers were possible due to the microprocessors.

 

Microprocessors further revolutionized the development of computers.

 

The first microprocessor called Intel 4004 was developed by American Intel Corporation in 1971.

Report Error

View Answer Report Error Discuss

27 14402
Q:

Which of the following is not purely output device?

A) Printer B) Speaker
C) Plotter D) Screen
 
Answer & Explanation Answer: D) Screen

Explanation:

A touch screen is the only device which works as both an input and an output device among the given options. You view the options available to you on the screen (output) and you then use your finger to touch the option that you have chosen (input).

 

Hence, Screen is not purely output device.

Report Error

View Answer Report Error Discuss

22 14394