Database Administration Questions


Q:

Which among the following is the disadvantage of circular list?

A) An info field that contains the information stored in the node B) Can’t traverse the list backward
C) A pointer to the node is given we cannot delete the node D) Both 2 and 3
 
Answer & Explanation Answer: D) Both 2 and 3

Explanation:

Both 2 and 3 are clearly the diadvantages of circular list

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2999
Q:

Which IT giant has launched learning app 'InfyTQ' for engineering students?

A) GOOGLE B) TCS
C) Infosys D) Cognizant
 
Answer & Explanation Answer: C) Infosys

Explanation:

Infosys has announced the launch of a digital platform offering learning and engagement experiences for engineering students.

InfyTQ is a free platform open to all engineering students in their third and fourth year. The platform encourages holistic development by imparting technical as well as professional skills and helps them become industry ready.

Report Error

View Answer Report Error Discuss

1 2996
Q:

The SQL keyword BETWEEN is used:

A) for ranges B) as a wildcard
C) to limit the columns displayed D) All the above
 
Answer & Explanation Answer: A) for ranges

Explanation:

In SQL, BETWEEN Keyword is used for ranges like Number Ranges, Date Ranges, etc...

Report Error

View Answer Report Error Discuss

0 2994
Q:

6 divided by 2(1 + 2) =

A) 1 B) 0
C) 9 D) Can't be determined
 
Answer & Explanation Answer: C) 9

Explanation:

The given expression can be simplified as

÷ 2 (1 + 2)

The expression can be simplified further by the order of operations, using BODMAS rule.

 

First evaluate Parentheses/Brackets, then evaluate Exponents/Orders, then evaluate Multiplication-Division, and finally evaluate Addition-Subtraction.

 

Now, the expression becomes ÷ 2 (3)

 

According to the order of operations, division and multiplication have the same precedence, so the correct order is to evaluate from left to right. First take 6 and divide it by 2, and then multiply by 3.

6 ÷ 2 × 3

= 3 × 3

= 9

But not  6÷2×3 = 6 ÷ 6 = 1

Screenshot_(21)1528090844.jpg image 

 

Hence, 6 ÷ 2 (1 + 2) = 9.

Report Error

View Answer Report Error Discuss

3 2969
Q:

STUFF and REPLACE are used to replace characters in a string

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

They both are used to replace characters in a string

Report Error

View Answer Workspace Report Error Discuss

0 2968
Q:

How can you describe an operational level agreement (OLA) ?

A) It is a legally binding contract outlining services delivered to an IT service provider that underpin a service that provider delivers to its customers. B) It is a written agreement between a supplier and the IT customer(s), defining the key service targets and responsibilities of both parties.
C) It contains targets that underpin those within an SLA to ensure that targets will not be breached by failure of the supporting activity. D) It is an agreement between a supplier and another part of the same organization that assists with the provision of services.
 
Answer & Explanation Answer: D) It is an agreement between a supplier and another part of the same organization that assists with the provision of services.

Explanation:

An agreement between an IT service provider and another part of the same organization. An OLA supports the IT service provider's delivery of services to customers. The OLA defines the goods or services to be provided and the responsibilities of both parties.

 

* For an example there be an OLA - between the IT service provider and a acquiring department to obtain hardware in discussed times - between the Service Desk and a support group to provide Incident resolution in accepted times.

Report Error

View Answer Report Error Discuss

7 2967
Q:

Recently deleted files are stored in

A) Taskbar B) My Computer
C) Recycle Bin D) Desktop
 
Answer & Explanation Answer: C) Recycle Bin

Explanation:

Deleted files are not permanently removed from the hard drive or the computers memory. Before they are permanently removed from the system they are stored in Recycle Bin. Recycle Bin is a folder or directory where deleted items are temporarily stored. It is also called as trash.

Report Error

View Answer Report Error Discuss

6 2957
Q:

Which datatype in c language has least storage?

A) char B) double
C) int D) float
 
Answer & Explanation Answer: A) char

Explanation:

Data types are used for declaration of variables in computer programming languages. These determine the type and size of data associated with variables.

Data types examples - int, char, float, etc...

 

char datatype is the least storage data type with 1 byte.

int with 2 or 4 bytes.

float with 4 bytes

double with 8 bytes.

datatype_in_c_language_has_least_storage1562156854.png image

Report Error

View Answer Report Error Discuss

Filed Under: Computer
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

2 2951