Technology | Practice Questions | Aliensbrain

Multiple choice technology mainframe

When you compile a CICS program, the (pre)compiler puts an extra chunk of code. Where does it get included and that is it called?

DFHEIBDK, DFHCOMMAREA
DFHEIBLK, DFHCOMNAREA
DFHEEBLK, DFHCOMMAREA
DFHEIBLK, DFHCOMMAREA

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

In which table would you make an entry for a BMS map?

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

How do you read from a TSQ?

Permanent Storage read command
Transaction storage read command
Temp storage read command
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Using EM Database Control, you’ve identified that the following SQL statement is the source of a high amount of disk I/O: SELECT NAME, LOCATION, CREDIT_LIMIT FROM CUSTOMERS What might you do first to try to improve performance?

Run the SQL Tuning Advisor.
Run the SQL Access Advisor.
Check the EM Database Control main screen for alerts.
Click the Alert Log Content link in the EM Database Control main screen.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Your users have called to complain that system performance has suddenly decreased markedly. Where would be the most likely place to look for the cause of the problem in the EM Database Control?

Main screen
Performance screen
Administration screen
Maintenance screen

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

By default, how long will database statistics be retained in the AWR?

7 days
30 days
7 hours
Indefinitely

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following is not one of the three primary sources of performance metric information in the EM Database Control Performance screen?

Host
Session
Instance
Network

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following is a performance metric that could be defined as “the amount of work that a system can perform in a given amount of time”?

Response time
Uptime
Throughput
Runtime

Reveal answer Fill a bubble to check yourself

Multiple choice technology web technology

While Developing a Cognos BI Application what product you would use to model Metadata?

Cognos Datamanager
Framework Manager
Cognos Metrics Manager
Cognos Metric Designer

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

You have just created a database using scripts that you wrote. Now you notice that the automatic collection of database statistics by the EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_ PROCS procedure is not running. What might be the cause?

The PFILE/SPFILE parameter GATHER_STATS=FALSE.
Only databases created using Database Configuration Assistant have automatic statistics
The SYSMAN user who owns the AWR is not logged in.
The operating system does not support automatic statistics collection.

Reveal answer Fill a bubble to check yourself

Tag: technology

Questions Related to technology