databases Online Quiz - 235
Description: databases Online Quiz - 235 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual?
Functions for error trapping are contained in which section of a PL/SQL block?
What is the result if two NULL values are compared to each other?
PL/SQL raises an exception, in which TWO of the following cases?
What output will the follwing statement produce? Select NVL2(NULL,NOT NULL, NULL) from dual?
Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'?
COALESCE (A,B)is equivalent to?
In which case would you use a FULL OUTER JOIN?
mod(-15, 4)would return ?
instr(Tech on the net, e, -3, 2) would retrun
power(-5, 3) would return ?
TRUNC(44.647, -1) would retrun ?
Your company has created a custom application that will require the use of several stored procedures. The lifetime of this application is relatively short and you wish to create the stored procedures such that they can all be dropped with a single DROP PROCEDURE statement command at the end of the application's lifetime. How can you group the procedures together such that they can all be dropped with a single DROP PROCEDURE statement?
You have a mission critical database named MCDB1 that you want to configure for automatic failover. You have decided to utilize database mirroring. Which database mirroring operating mode should you use?
You have been assigned the task of designing a relational database for a client. The database will be used to store an exact copy of specific XML documents that the client needs to retrieve on a regular basis. The client wants to be able to use an application that they created to enter the documents into the database as well as retrieve them. You are in the process of designing a table for the database. What should you do?
EasyYatra is a travel booking company that has a web site available for customers to view and book their vacations online. You have been hired to look after the back-end SQL Server that is used to store customer and booking information. You are creating a table called Booking to keep track of vacations booked by customers. This table will contain a computed column called Total that is derived from other columns in the table. You want to be able to create an index on this Total column to increase performance when any queries are executed using this column. To do this, you want to physically store the computed column in the table. How can this be done?
You are gathering performance and optimization data for your SQL Server 2005 database. Your company has three custom applications that routinely make use of the database. Each application accesses the database using separate login credentials. You wish to gather information concerning the queries executed by each custom application. To gather this data you decide to create a trace using the SQL Server Profiler. You decide to use one of the predefined SQL Server Profiler templates to define what data should be gathered. Which predefined SQL Server Profiler template would best suit your requirements?
NA
Which task can you perform using only the TO_CHAR function?
In which scenario would an index be most useful?