Question :- A view can be deleted using the command __________

1.REMOVE

2.DELETE

3.CLEAR

4.DROP

Question :- A view can refer to multiple tables via __________

1.UNION

2.JOIN

3.GROUP

4.SELECT

Question :- Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________

1.transparent

2.concrete

3.elaborate

4.cascaded

Question :- FULLTEXT indexes can be created only for ____________

1.MyISAM

2.InnoDB

3.MEMORY

4.TRANSITION

Question :- How many storage engines among the following are transaction-safe?

1.1

2.2

3.3

4.4

Question :- In which mode of search is the search string parsed into words and the search looks for rows?

1.Natural language

2.Boolean mode

3.Query expansion

4.Cross mode

Question :- SELECT on a MERGE table is like _____________

1.UNION ALL

2.UNION

3.UNION DISTINCT

4.JOIN

Question :- Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?

1.LIMIT

2.RESTRICT

3.COUNT

4.SORT

Question :- The “Mysql command line tool” format the results in which of the following format?

1.Rectangle

2.Square

3.Sphere

4.None of the mentioned

Question :- The “Mysql command line tool” formats are bounded by _____

1.+-|

2.+-*

3.+-/

4.+-}

Question :- The indicator of presence or absence of a word in search is used in which mode?

1.Natural language

2.Boolean mode

3.Query expansion

4.Cross mode

Question :- The property of InnoDB that enforces foreign key relationships stay intact is called _____________

1.atomicity

2.durability

3.consistency

4.referential integrity

Question :- To perform a delete on a single-table, how is the name of a column qualified?

1.qualification not necessary

2.column name

3.table name

4.database name

Question :- UPDATE statement is a DML statement. What does DML stand for?

1.Data Manipulation Language

2.Data Manipulation Level

3.Data Markup Language

4.Data Markup Level

Question :- What can be used to check for views that have been invalidated by DROP or ALTER operations?

1.CREATE TABLE

2.VERIFY TABLE

3.DETAILS TABLE

4.CHECK TABLE

Question :- What cannot be done on a view?

1.display

2.filter

3.index

4.drop

Question :- What does ‘A’ stand for in the ACID property of transactions?

1.Availability

2.Accuracy

3.Adjustability

4.Atomicity

Question :- What does ‘C’ stand for in the ACID property of transactions?

1.Compound

2.Concrete

3.Collision

4.Consistency

Question :- What is abc in the following MySQL statement?

1.row name

2.column name

3.view

4.database

Question :- What is abc in the following SQL statement?

1.column name

2.table name

3.row name

4.database name

Question :- What is generally done after the transactions are executed successfully?

1.delete

2.rollback

3.commit

4.update

Question :- What is generally done if an error occurs during the transaction?

1.delete

2.rollback

3.commit

4.update

Question :- What is known as the set of SQL statements that either executes successfully or none of them have an effect?

1.joins

2.transactions

3.filters

4.deletions

Question :- What is the command to disable autocommit and launch a transaction?

1.INITIATE TRANSACTION

2.START TRANSACTION

3.DISABLE AUTOCOMMIT

4.TRANSACTION

Question :- What is the durability property of transactions?

1.statements form a logic unit

2.database remains consistent

3.one transaction does not affect the other

4.transaction effects are recorded permanently

Question :- What is the isolation property of transactions?

1.statements form a logic unit

2.database remains consistent

3.one transaction does not affect the other

4.transaction effects are recorded permanently

Question :- What is the value of val2 in the following MySQL statement?

1.previous val1

2.updated val1

3.unchanged

4.val1 + 1

Question :- What is x in the following MySQL statement?

1.column name

2.table name

3.server name

4.database name

Question :- What is xyz in the following MySQL statement?

1.table

2.column

3.view

4.database

Question :- What is xyz in the following SQL statement?

1.column name

2.table name

3.row name

4.database name

Question :- Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

1.SET

2.MATCH

3.ON DELETE

4.ON CASCADE

Question :- Which clause is used to remove a foreign key constraint?

1.REMOVE

2.DELETE

3.DROP

4.EXCLUDE

Question :- Which clause is used to sort a UNION result as a whole?

1.LIMIT

2.ORDER BY

3.GROUP BY

4.SORT

Question :- Which clause names the parent table and the index columns in the table?

1.REFERENCES

2.ON DELETE

3.CONSTRAINT

4.FOREIGN KEY

Question :- Which command is used for taking “server side help” in Mysql command line tool?

1./h

2./c

3./e

4.None of the mentioned

Question :- Which command is used in Mysql command line tool to return to window command shell?

1.exit;

2.quit;

3.both exit; and quit;

4.only exit;

Question :- Which command is used on Mysql command line tool to return to window command shell?

1.exit

2.exit;

3.exit()

4.exit();

Question :- Which key declares that an index in one table is related to that in another?

1.primary

2.secondary

3.foreign

4.cross

Question :- Which keyword in the UPDATE statement is used to assign values to columns?

1.ASSIGN

2.SET

3.MARK

4.GET

Question :- Which keyword is used to delete all the rows from the table?

1.TRUNCATE

2.REMOVE

3.DELETE ALL

4.CLEAR

Question :- Which keyword is used to search through natural language fulltext?

1.MATCH

2.AGAINST

3.SEARCH

4.FIND

Question :- Which keyword is used to specify the foreign key after the table is created?

1.SETUP

2.SET

3.ALTER TABLE

4.SPECIFY

Question :- Which keyword used with UNION retains duplicate rows?

1.ALL

2.NARROW

3.STRICT

4.DISTINCT

Question :- Which of the following does not support a materialized view?

1.MySQL

2.Oracle

3.PostgreSQL

4.SybaseSQL

Question :- Which of these is also known as a virtual table?

1.SCHEMA

2.DATABASE

3.JOIN

4.VIEW

Question :- Which parameter determines the shortest words to index in FULLTEXT indexes?

1.ft_min_word_len

2.ft_min_len_word

3.ft_word_min_len

4.ft_word_len_word

Question :- Which search mode uses natural language search as a subroutine?

1.Natural language

2.Boolean mode

3.Query expansion

4.Cross mode

Question :- Which statement is used to access an existing Database?

1.Use

2.use database.name

3.USE databasename;

4.None of the mentioned

Question :- Which storage engine in MySQL provides foreign key support?

1.TRANSACTION

2.InnoDB

3.MyISAM

4.MEMORY

Question :- Which table is used to run a UNION-type query on MyISAM tables?

1.TRADITIONAL

2.MERGE

3.SERVELET

4.UNITE