You can add a row using SQL in a database with which of the following?

The command to remove rows from a table ‘CUSTOMER’ is:

The SQL WHERE clause:

Which of the following is the original purpose of SQL?

The wildcard in a WHERE clause is useful when?

A view is which of the following?

The command to eliminate a table from a database is:

ON UPDATE CASCADE ensures which of the following?

SQL data definition commands make up a(n) ________ .

Which of the following is valid SQL for an Index?

The SQL command to create a table is:

A ________ is a stored program that is attached to a table or a view.

The DROP TABLE statement:

SQL views can be used to hide:

The SQL statement to create a view is:

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

Which of the following is NOT a type of SQL constraint?

A ________ is a program that performs some common action on database data and that is stored in the database.

For what purposes are views used?

What is an SQL virtual table that is constructed from other tables?

With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?

Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?

What mode of authentication does SQL Server NOT provide?

The strictest transaction isolation level provided by SQL Server is called:

SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):

Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

Which of the three possible types of triggers does SQL Server support?

Which of the following is a way to create and modify tables using SQL Server?

With which type of SQL Server recovery model, is no logging done?

SQL Server 2000 stored procedures can:

With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:

With this type of index, the data are stored in the bottom level of the index and in the same order as that index.

In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?

With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.

With which type of SQL Server recovery model are all database changes logged?

SQL Server automatically creates an index on:

Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

SQL Server program code that is executed after an SQL command has been processed is called a(n):

Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?

What type of join is needed when you wish to include rows that do not have matching values?

What type of join is needed when you wish to return rows that do have matching values?

Which of the following is true concerning a procedure?

A CASE SQL statement is which of the following?

Which of the following statements is true concerning routines and triggers?

Which of the following is one of the basic approaches for joining tables?

Which of the following is true concerning systems information in an RDBMS?

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

Embedded SQL is which of the following?

A UNION query is which of the following?

Which of the following statements is true concerning subqueries?

Which of the following is a correlated subquery?

How many tables may be included with a join?

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

Which of the following is true concerning triggers?

A BI reporting system does not ________ .

Which of the following are not done by Business Intelligence (BI) systems?

Business Intelligence (BI) systems do not obtain their data by which of the following means?

The “curse of dimensionality” relates to which problem of using operational data for BI reporting?

A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

RFM analysis uses customers’ purchasing patterns to ________ .

The “F” in RFM analysis stands for ________ .

We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent — Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .

Business Intelligence (BI) reporting systems cannot do which of the following operations?

Which of the following is not a component of a data warehouse?

Business Intelligence (BI) reporting analyses can be performed using ________ .

We have been given access to the company’s operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .

The reports generated by a reporting system are usually not delivered in which of the following media?

Data mining applications are used accomplish which of the following tasks?

Which of the following is an unsupervised data mining technique?

In OLAP, we are interested in ________ .

Which of the following is not a reason that operational data are difficult to read?

We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent — Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .

One popular classification technique in Business Intelligence (BI) reporting is ________ .

We have done an RFM analysis on our customer data. Mary Jones has a score of “1 1 5”. This series means that Mary ________ .

Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?

In a 1:N relationship, the foreign key is placed in:

Which of the following column properties specifies whether or not cells in a column must contain a data value?

A primary key should be defined as:

Which of the following column properties would be used to specify that cells in a column must contain a monetary value?

Which of the following type of class allows only one object of it to be created?

Which of the following is not a type of constructor?

Which of the following statements is correct?

Which of the following is not the member of class?

Which of the following concepts means determining at runtime what method to invoke?

Which of the following term is used for a function defined inside a class?

Which of the following concept of oops allows compiler to insert arguments in a function call if it is not specified?

How many instances of an abstract class can be created?

Which of the following cannot be friend?

Which of the following concepts of OOPS means exposing only necessary information to client?

Why reference is not same as a pointer?

cout is a/an __________ .

Which of the following concepts provides facility of using object of one class inside another class?

Which of the following concepts provides facility of using object of one class inside another class?

Which of the following is an abstract data type

Which of the following concepts means adding new components to a program as it runs?

Which of the following statement is correct?

Which of the following correctly describes overloading of functions?

Which of the following approach is adapted by C++?

Which of the following is correct about function overloading?

Which of the following statements is incorrect?

Which of the following statement is correct regarding destructor of base class?

Which of the following two entities (reading from Left to Right) can be connected by the dot operator?

How can we make a class abstract?

Which of the following statements is correct when a class is inherited publicly?

Which of the following statements is correct about the constructors and destructors?

Which of the following access specifies is used in a class definition by default?

Which of the following statement is correct with respect to the use of friend keyword inside a class?

Which of the following keywords is used to control access to a class member?

Which of the following can access private data members or member functions of a class?

Which of the following type of data member can be shared by all instances of its class?

Which of the following also known as an instance of a class?

Constructor is executed when _____.

Which of the following statements about virtual base classes is correct?

How many objects can be created from an abstract class?

Which of the following statements is correct when a class is inherited privately?

Which of the following statements is correct?

What does a class hierarchy depict?

Which of the following can be overloaded?

Which of the following means “The use of an object of one class in definition of another class”?

Which of the following statement is correct?

Which of the following statement is correct?

Which of the following statement is correct?

Which of the following statement will be correct if the function has three arguments passed to it?

Which of the following statement is incorrect?

Which of the following statement is correct?

Which of the following function / type of function cannot be overloaded?

Which of the following function declaration is/are incorrect?

Which of the following statement is incorrect?

Where the default value of parameter have to be specified?

Which of the following statement is correct?

Which of the following statement is correct?

A constructor that accepts __________ parameters is called the default constructor.

What happens when a class with parameterized constructors and having no default constructor is used in a program and we create an object that needs a zero-argument constructor?

For automatic objects, constructors and destructors are called each time the objects

Which constructor function is designed to copy objects of the same class type?

Which of the following statement is correct?

Which of the following statement is incorrect?

When are the Global objects destroyed?

Copy constructor must receive its arguments by __________ .

A function with the same name as the class, but preceded with a tilde character (~) is called __________ of that class.

A union that has no constructor can be initialized with another union of __________ type.

Which of the following gets called when an object goes out of scope?

Which of the following statement is correct?

_________ used to make a copy of one class object from another class object of the same class type.