Q. Which of the following join is also called as an 'inner-join'?

View solution

Q. The result of a SQL SELECT statement is a ________ .

View solution

Q. Which of the following query is correct for using comparison operators in SQL?

View solution

Q. How to select all data from student table starting the name from letter 'r'?

View solution

Q. Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

View solution

Q. Select the right statement to insert values to the student table.

View solution

Q. ............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

View solution

Q. In SQL, which command is used to change a table's storage characteristics?

View solution

Q. 'AS' clause is used in SQL for

View solution

Q. The type of function which allows performing additional operations and sending messages to other tables in database program is considered as

View solution

Q. The technique in which source program are replaced by database management generated code is classified as

View solution

Q. In database management systems, the record which contains all the data regarding tuples of database is called

View solution

Q. The database program which handles software applications and include database servers calls to update the data is classified as

View solution

Q. The database interface in which the data is directly entered into the monitor is classified as

View solution

Q. The type of iterator which is used to list the types of attributes that are included in the query result is called

View solution

Q. In query result, the type of variable which is used to loop tuples is called

View solution

Q. The variable in DBMS used to communicate error conditions between database management system and program are

View solution

Q. In database management system, if the cursor is to be moved to next rows in queries result then the command is classified as

View solution

Q. The general purpose programming languages such as COBOL and ADA is classified as

View solution

Q. The kind of record which is used to keep the information of specific database connection is classified as

View solution