SQL/SQL MCQ SET 16 Sample Test,Sample questions

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


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL – Basics
  20. MCQ | SQL – Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!