Database Administration Questions


Q:

It is necessary to sort a file before searching a particular item 

A) True B) False
C) May or may not be true D) None of the above
 
Answer & Explanation Answer: C) May or may not be true

Explanation:

If less work is involved in searching a element than to sort and then extract, then we don’t go for sort

If frequent use of the file is required for the purpose of retrieving specific element, it is more efficient to sort the file.

Thus it depends on situation

Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database
Job Role: Database Administration

1 2925
Q:

What are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms?

A) Polish B) Reverse Polish
C) Both A and B D) None of the above
 
Answer & Explanation Answer: C) Both A and B

Explanation:

Polish and Reverse Polish are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms

Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database
Job Role: Database Administration

2 1871
Q:

What is the maximum number of triggers, can apply to a single table?

A) 8 B) 10
C) 12 D) 14
 
Answer & Explanation Answer: C) 12

Explanation:

Maximim number of triggers that can be applied to a single table is 12

Report Error

View Answer Workspace Report Error Discuss

6 1864
Q:

Default read write and execute permissions given to a file for owner, group and others are

A) 6-4-4 B) 6-4-2
C) 6-4-6 D) 6-6-6
 
Answer & Explanation Answer: A) 6-4-4

Explanation:

Default permissions given to a file are:

Owner - read write and execute - 6

group - write - 4

others - write - 4

Report Error

View Answer Workspace Report Error Discuss

5 1791
Q:

Which operator performs pattern matching ?

A) LIKE operator B) EXISTS operator
C) BETWEEN operator D) None of these
 
Answer & Explanation Answer: A) LIKE operator

Explanation:

LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).

The syntax is as follows:
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN}

{PATTERN} often consists of wildcards. In SQL, there are two wildcards:



% (percent sign) represents zero, one, or more characters.
_ (underscore) represents exactly one character.

Report Error

View Answer Workspace Report Error Discuss

1 1472