A view can be deleted using the command __________
1.REMOVE
2.DELETE
3.CLEAR
4.DROP
A view can refer to multiple tables via __________
1.UNION
2.JOIN
3.GROUP
4.SELECT
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
FULLTEXT indexes can be created only for ____________
1.MyISAM
2.InnoDB
3.MEMORY
4.TRANSITION
How many storage engines among the following are transaction-safe?
1.1
2.2
3.3
4.4
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
SELECT on a MERGE table is like _____________
1.UNION ALL
2.UNION
3.UNION DISTINCT
4.JOIN
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
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
The “Mysql command line tool†formats are bounded by _____
1.+-|
2.+-*
3.+-/
4.+-}
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
The property of InnoDB that enforces foreign key relationships stay intact is called _____________
1.atomicity
2.durability
3.consistency
4.referential integrity
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
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
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
What cannot be done on a view?
1.display
2.filter
3.index
4.drop
What does ‘A’ stand for in the ACID property of transactions?
1.Availability
2.Accuracy
3.Adjustability
4.Atomicity
What does ‘C’ stand for in the ACID property of transactions?
1.Compound
2.Concrete
3.Collision
4.Consistency
What is abc in the following MySQL statement?
1.row name
2.column name
3.view
4.database
What is abc in the following SQL statement?
1.column name
2.table name
3.row name
4.database name
What is generally done after the transactions are executed successfully?
1.delete
2.rollback
3.commit
4.update
What is generally done if an error occurs during the transaction?
1.delete
2.rollback
3.commit
4.update
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
What is the command to disable autocommit and launch a transaction?
1.INITIATE TRANSACTION
2.START TRANSACTION
3.DISABLE AUTOCOMMIT
4.TRANSACTION
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
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
What is the value of val2 in the following MySQL statement?
1.previous val1
2.updated val1
3.unchanged
4.val1 + 1
What is x in the following MySQL statement?
1.column name
2.table name
3.server name
4.database name
What is xyz in the following MySQL statement?
1.table
2.column
3.view
4.database
What is xyz in the following SQL statement?
1.column name
2.table name
3.row name
4.database name
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
Which clause is used to remove a foreign key constraint?
1.REMOVE
2.DELETE
3.DROP
4.EXCLUDE
Which clause is used to sort a UNION result as a whole?
1.LIMIT
2.ORDER BY
3.GROUP BY
4.SORT
Which clause names the parent table and the index columns in the table?
1.REFERENCES
2.ON DELETE
3.CONSTRAINT
4.FOREIGN KEY
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
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;
Which command is used on Mysql command line tool to return to window command shell?
1.exit
2.exit;
3.exit()
4.exit();
Which key declares that an index in one table is related to that in another?
1.primary
2.secondary
3.foreign
4.cross
Which keyword in the UPDATE statement is used to assign values to columns?
1.ASSIGN
2.SET
3.MARK
4.GET
Which keyword is used to delete all the rows from the table?
1.TRUNCATE
2.REMOVE
3.DELETE ALL
4.CLEAR
Which keyword is used to search through natural language fulltext?
1.MATCH
2.AGAINST
3.SEARCH
4.FIND
Which keyword is used to specify the foreign key after the table is created?
1.SETUP
2.SET
3.ALTER TABLE
4.SPECIFY
Which keyword used with UNION retains duplicate rows?
1.ALL
2.NARROW
3.STRICT
4.DISTINCT
Which of the following does not support a materialized view?
1.MySQL
2.Oracle
3.PostgreSQL
4.SybaseSQL
Which of these is also known as a virtual table?
1.SCHEMA
2.DATABASE
3.JOIN
4.VIEW
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
Which search mode uses natural language search as a subroutine?
1.Natural language
2.Boolean mode
3.Query expansion
4.Cross mode
Which statement is used to access an existing Database?
1.Use
2.use database.name
3.USE databasename;
4.None of the mentioned
Which storage engine in MySQL provides foreign key support?
1.TRANSACTION
2.InnoDB
3.MyISAM
4.MEMORY
Which table is used to run a UNION-type query on MyISAM tables?
1.TRADITIONAL
2.MERGE
3.SERVELET
4.UNITE