Quiz
SQL
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (54)
1What is an entity?
- AA piece of information about any object that users want to keep track off
- BA property that describes a component of a database
- CA name that identifies either a unique object or a unique class of objects
- DA group of fields within a table that are relevant to a specific object
2Which of the following element of the database table enables you to identify every record in that table?
- AEntity
- BPrimary key
- CForeign key
- DAttribute
3What term is used to represent the minimum number of entity occurrences that can be involved in a relationship?
- AModality
- BCardinality
- CAssociative entity
- DReferential integrity
4What term is used to represent the facts of the column of a table?
- AInstance
- BValue
- CField
- DRecord
5Which of the following statements is true of referential integrity?
- AEvery primary-key value must be equivalent to the primary-key value in an associated table.
- BEvery primary-key value must be equivalent to the foreign-key value in an associated table.
- CEvery foreign-key value must be equivalent to the primary-key value in an associated table.
- DEvery foreign-key value must be equivalent to the foreign-key value in an associated table.
6Which of the following represents the logical view of the entire database?
- ASchema
- BInstance
- CAttribute
- DRelationship
7Which process is used to minimize data redundancy by organizing columns and tables of a relational database?
- ASystem analysis
- BData normalization
- CLogical database design
- DData integration
8What term is used to represent a relationship between tables?
- APrimary key
- BSuper key
- CCandidate key
- DForeign key
9Which technology is used to uniquely identify a person based on biological traits?
- AFingerprint reader
- BMagnetic stripe card
- CPassword
- DBiometric card reader
10Which of the following is designed to prevent unauthorized access, either hardware- or software-based, to or from a private network?
- AAnti-virus software
- BData encryption
- CFirewall
- DSSL technology
11 Which mysql input editing command key is used to delete a word?
- AControl-D
- BDelete
- CEscape D
- DEscape Backspace
12Which of the following is a composite mode?
- APIPES_AS_CONCAT
- BTRADITIONAL
- CSTRICT_ALL_TABLES
- DSTRICT_TRANS_TABLES
13In which of the following SQL modes is the server more obstructive about accepting bad data values?
- ASTRICT_TRANS_TABLES
- BANSI
- CTRADITIONAL
- DANSI_QUOTES
14What is the maximum number of characters allowed to create a database name?
- A8
- B16
- C32
- D64
- E256
15What command is used to modify a column in a table?
- AALTER
- BUPDATE
- CSET
- DDROP
16In SQL, which command is used to change the data type of a column in a table?
- ACHANGE
- BALTER
- CUPDATE
- DMODIFY
17Which operation cannot be performed on the data stored in any DBMS?
- ADELETE
- BALTER
- CINSERT
- DUPDATE
18Which of the following statements is true of DML (data manipulation language)?
- AIt manages data within schema.
- BIt manages transactions to maintain data integrity.
- CIt defines the database structure or schema.
- DIt allows statements to be grouped together into logical transaction.
19Which language is used to define data structure and manage tables?
- ATCL
- BDDL
- CDML
- DDCL
20How many operations are defined for data manipulation language?
- A4
- B3
- C2
- D1
21Which of the following data types has the storage of 8 bytes?
- Abigint
- Btinyint
- Csmallint
- Dint
22In UNIX, which term is used to represent the date 01/01/1970 00:00:00?
- Aspan
- Baeon
- Cstage
- Depoch
23Which SQL mode prevents entry of incomplete date values that have a month or day part of zero?
- ANO_ZERO_IN_DATE
- BNO_ZERO_DATE
- CSTRICT_NO_ZERO_DATE
- DSTRICT_NO_ZERO_IN_DATE
24Which of the following statements is used to remove a table definition with all its specifications such as data, constraints, and so on?
- ADROP TABLE <table_name>
- BDELETE TABLE <table_name>
- CTRUNCATE TABLE <table_name>
- DALTER TABLE <table_name>
25Which SQL function returns the length of a string in byte?
- ASTRING_LENGTH()
- BCHARSET()
- CCHAR_LENGTH()
- DLENGTH()
26Which keyword is used to sort the result-set by one or more columns?
- AORDER BY
- BSORT BY
- CSORT
- DORDER
27Which clause specifies the execution context of the stored routine?
- ADEFINER
- BSQL SECURITY
- CWHERE
- DINVOKER
28Which of the following statements is true of view in regards to SQL?
- AA component that describes instances in a row of a database
- BAn object on which event occurs
- CA function that returns a result from a calculation for use in expressions
- DA virtual table generated by using the SELECT statement on tables
29Which term is associated with a SQL procedure that initiates an action when a table is modified using the INSERT, DELETE, or UPDATE statements?
- AView
- BTrigger
- CRoutine
- DEvent
30Which of the following provides a means to standardize computational operations?
- AStored function
- BStored procedure
- CStored routine
- DStored program
31In a database, which key is designed to uniquely identify all table records?
- APrimary
- BSuper
- CForeign
- DCandidate
32What is a foreign key?
- AA combination of two or more keys that uniquely identifies an entity occurrence
- BA set of attributes that uniquely identifies a tuple within a relation
- CA combination of columns used to establish a link between the data in two tables
- DA set of attributes that uniquely identifies the record without referring to any other data
33Which key accepts both NULL and duplicate values?
- ACandidate
- BSuper
- CForeign
- DPrimary
34Which type of relationship exists between the two entities in the figure?
- ARecursive
- BOne-to-one
- CMany-to-one
- DMany-to-many
35Which of the following keys is referred to as a minimal super key?
- AForeign
- BPrimary
- CComposite
- DCandidate
36Which of the following joins allows you to query data from two or more database tables?
- ARIGHT
- BOUTER
- CINNER
- DLEFT
37 Which of the following methods helps determine the address of each record in a direct file organization?
- APointer
- BComposite index
- CHashing algorithm
- DClustered index
38What term is used to represent the process of choosing the most efficient way to execute a SQL statement?
- AHashing
- BB-tree
- CQuery optimization
- DIndexing
39Which of the following joins returns a null value in place of rows which do not match the join condition from the other table?
- ARIGHT
- BOUTER
- CINNER
- DLEFT
40Which of the following functions maps the group of characters to a value of a certain length?
- AAggregate
- BHash
- CAnalytic
- DConversion
41Which of the following keys is used in SQL for ensuring referential integrity?
- ASuper
- BForeign
- CPrimary
- DAlternate
42Which of the following is not a delete rule?
- ADelete Rule: Cascade
- BDelete Rule: Set-to-Null
- CDelete Rule: No Action
- DDelete Rule: Restrict
43 What is the use of option files in mysql?
- ATo test if a file or directory exists
- BTo store connection parameters
- CTo store user preference settings
- DTo bundle a group of related class files
44What term is used to represent the bulk loader that reads data from a file?
- ACarriage return
- BLOAD DATA
- CLinefeeds
- DOption file
45Consider the following table named Student:
- ASelect * from STUDENT where city == "Boston";
- BSelect * from STUDENT where city="Boston";
- CSelect COUNT(ALL) from STUDENT where city="Boston";
- DSelect * from STUDENT where equals(City, "Boston");
46Which query will sort the list of Employees in the descending order of their age from the table named Employees?
- ASELECT * FROM Employees ORDER BY age DESC;
- BSELECT * FROM Employees ORDER BY DESC age;
- CSELECT * FROM Employees SORT BY DESC age;
- DSELECT * FROM Employees ORDER BY age;
47Which of the following queries retrieves all unique cities from the table given in the image?
- ASELECT City FROM Student;
- BSELECT DISTINCT City FROM TABLE Student;
- CSELECT UNIQUE City FROM Student;
- DSELECT DISTINCT City FROM Student;
48Which of the following queries will display the details of the employees from the table named Employee whose age is between 50 to 60?
- ASELECT * FROM Employee WHERE BETWEEN (Age, 50, 60);
- BSELECT * FROM Employee WHERE age>50 and WHERE age<60;
- CSELECT * FROM Employee WHERE age>50 and <60;
- DSELECT * FROM Employee WHERE age>50 and age<60;
49Which query will allow you to retrieve all records from a database table named Orders where name starts with 'd' to 'p'?
- ASELECT * FROM Orders WHERE name like '[d-p]%';
- BSELECT * FROM Orders WHERE name like '[p-d]%';
- CSELECT ALL FROM Orders WHERE name in '[d-p]%';
- DSELECT * FROM Orders WHERE name in '[d-p]%';
50Which is the correct syntax for applying the UNION clause?
- ASELECT <column_name> FROM UNION (<table_name1>, <table_name2>);
- BSELECT <column_name> FROM <table_name1>
UNION
SELECT <column_name> FROM <table_name2> - CSELECT <column_name> FROM <table_name1> UNION <table_name2>
- DUNION SELECT <column_name> FROM <table_name1>
SELECT <column_name> FROM <table_name2>
51Which of the following subqueries tests whether a value is present in a set of values returned by a subquery?
- AEXISTS
- BNOT EXISTS
- CIN
- DALL
52Which operator identifies the columns that does not contain any record in a table?
- ANOT EXISTS
- BNULL
- CIS NULL
- DAnswer option C is correct.
53Which clause is used to merge results of two or more SELECT statements without returning any duplicate rows?
- AUNION
- BMERGE
- CCONJUNCTION
- DJOIN
54Which join produces the Cartesian product of two tables?
- AOUTER
- BINNER
- CLEFT
- DCROSS
Information
- Description
- 1 SQL Quiz on SQL, created by Andrew Laboisson on 23/02/2016.
- Author
- Andrew Laboisson
- Language
- English
- Views
- 28
- Tags
- Rating
- 4.0 out of 5 · 1 rating Rate this quiz