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