databases Online Quiz - 52
Description: databases Online Quiz - 52 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Choose the best statement that best describes the relationship between JSP and servlets
Which property of Exception class provides the line number of the code that caused exception:
If a Runtime Exception is thrown in the finalize method
Choose the correct statement from the given choice?
Which of the following command options of aspnet_regiis is used to encryption config sections?
Which character is used to continue a statement in SQL*Plus?
Which character function can be used to return a specified portion of a character string?
The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?
In which one of the following scenairos the IMS status code AM will be issued
The process to assemble and link edit the macro instructions that specify an application programs view of one or more databases is called.
What tool should you recommend for a junior DBA to use to create a simple backup strategy for a SQL Server database?
You have a 1TB SalesDB database running on SQL Server 2003 Enterprise Edition. You have noticed that the nightly DBCC CHECKDB ('SalesDB') job is starting to take too long, and you want to reduce the amount of time that the check will take. What command should you schedule to run nightly instead?
You want to create a replication strategy that will allow users in four branch offices to have a fresh copy of data from the database in the central office every day at 5 a.m. for their daily reports. Although there are many changes to the data during the course of a day, the entire publication is not that large. Which replication strategy should you use in SQL Server?
You write a SQL Server stored procedure that will return data for a report. The accuracy of the data is not so important; however, you want to avoid dirty reads. Which isolation level should you avoid?
You want to identify the top 10 queries in SQL Server that have been recompiled the most times on your server. What can you do?
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
What does PCB stands for in IMS?
If any higher-level segements is retrieved during IMS seqential retrieval it is indicated by which one of the following status code
Which one of the following status code indicates a duplicate insertion of a segment in IMS