> > SQL MCQs > Basic SQL MCQs

Basic SQL MCQ

1. In today's decentralized business world, ________ the most important strategic decisions.

Top managers still primarily make

Middle managers make

Lower-level managers make

Nonmanagerial employees make

Answer

Correct Answer: Top managers still primarily make

Note: This Question is unanswered, help us to find answer for this one

2. Access does not support the ____ data type.

CURRENCY

DECIMAL

INT

CHAR

Answer

Correct Answer: DECIMAL

Note: This Question is unanswered, help us to find answer for this one

3. When using a(n) _____ join, only rows that meet the given criteria are returned.

Three

Outer

Inner

UNION

Answer

Correct Answer: Inner

Note: This Question is unanswered, help us to find answer for this one

4. You can use the ____ command to delete an entire table and its data.

ROLLBACK

DELETE TABLE

DROP TABLE

DELETE

Answer

Correct Answer: DROP TABLE

Note: This Question is unanswered, help us to find answer for this one

5. Use the ____ keyword to enter the computer's date as a data value in the insert command.

SYSDATE

DATE

SYSTEMDATE

COMPDATE

Answer

Correct Answer: SYSDATE

Note: This Question is unanswered, help us to find answer for this one

6. To list all the contents of the product table, you would use ____.

LIST * FROM PRODUCT

SELECT * FROM PRODUCT

DISPLAY * FROM PRODUCT

SELECT ALL FROM PRODUCT

Answer

Correct Answer: SELECT * FROM PRODUCT

Note: This Question is unanswered, help us to find answer for this one

7. The operators =, <, >, <=, >=, and <> are referred to as ____ operators.

Multiple-row

Correlated

Single-row

Multiple column

Answer

Correct Answer: Single-row

Note: This Question is unanswered, help us to find answer for this one

8. In microsoft access, the ____ function displays a value in lowercase letters.

REGULAR

LOWER

LCASE

SMALL. LCASE

Answer

Correct Answer: LCASE

Note: This Question is unanswered, help us to find answer for this one

9. The command to delete a view is ____.

ROLLBACK

DELETE TABLE

DROP TABLE

DELETE

Answer

Correct Answer: DROP TABLE

Note: This Question is unanswered, help us to find answer for this one

10. The maximum width of the number datatype is ____ digits.

255

Answer

Correct Answer: 38

Note: This Question is unanswered, help us to find answer for this one

11. ____ is one of the categories of update anomalies.

Functional dependence

Functional splitting

Inconsistent data

Qualification

Answer

Correct Answer: Inconsistent data

Note: This Question is unanswered, help us to find answer for this one

12. The system catalog is also called the ____.

Data dictionary

Transaction database

System database

Master data table

Answer

Correct Answer: Data dictionary

Note: This Question is unanswered, help us to find answer for this one

13. The ____ special operator is used to check whether an attribute value is null.

NULL

EXISTS

DROP

Answer

Correct Answer: NULL

Note: This Question is unanswered, help us to find answer for this one

14. An index can be created ____.

implicitly

explicitly

only at instance startup

both a and b

Answer

Correct Answer: both a and b

Note: This Question is unanswered, help us to find answer for this one

15. To assign a conditional value, use the ____ function.

Caption

IIF

None of these

Answer

Correct Answer: IIF

Note: This Question is unanswered, help us to find answer for this one

16. The correct data type for the balance column in the customer table is ____.

DECIMAL

SMALLINT

INT

CHAR

Answer

Correct Answer: DECIMAL

Note: This Question is unanswered, help us to find answer for this one

17. The syntax for a left outer join is ____.

SELECT column-list

FROM table1 LEFT OUTER JOIN table2

ON join-condition

Both a and b

Answer

Correct Answer: SELECT column-list

Note: This Question is unanswered, help us to find answer for this one

18. The sql command that lets you select attributes from rows in one or more tables is ____.

INSERT

SELECT

COMMIT

None of these

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

19. The sql command that lets you insert rows into a table is ____.

INSERT

SELECT

COMMIT

None of these

Answer

Correct Answer: INSERT

Note: This Question is unanswered, help us to find answer for this one

20. The sql ________ statement allows you to combine two different tables.

SELECT

JOIN

EXEC

None of these

Answer

Correct Answer: JOIN

Note: This Question is unanswered, help us to find answer for this one

21. Only one ____ constraint can exist for each table.

Pimary key

Foreign key

Both

None

Answer

Correct Answer: Pimary key

Note: This Question is unanswered, help us to find answer for this one

22. Insert into is an example of ________ code.

DDL

DML

DCL

DNL

Answer

Correct Answer: DML

Note: This Question is unanswered, help us to find answer for this one

23. A ____ file is a text file with a .sql extension that contains sql commands.

Script

Excel

Word

Database

Answer

Correct Answer: Script

Note: This Question is unanswered, help us to find answer for this one

24. The syntax for the union query is ____.

Query + query

UNION (query, query)

UNION: query query

Query UNION query

Answer

Correct Answer: Query UNION query

Note: This Question is unanswered, help us to find answer for this one

25. In oracle, the ____ table contains information about the columns within tables.

SYSCOLUMNS

DBA_TAB_COLUMNS

COLUMNS

SHOW_COLUMNS

Answer

Correct Answer: DBA_TAB_COLUMNS

Note: This Question is unanswered, help us to find answer for this one

26. To add data from an existing table to a new table, use a select command in a(n) ____ command.

ROLLBACK

UPDATE

COMMIT

INSERT

Answer

Correct Answer: INSERT

Note: This Question is unanswered, help us to find answer for this one

27. To include all fields in a sql query, use the ____ symbol after the word select.

Asterisk (*)

Statistical

Design View

Structure

Answer

Correct Answer: Asterisk (*)

Note: This Question is unanswered, help us to find answer for this one

28. The sql command ________ defines a logical table from one or more tables or views.

Create table

Alter table

Create view

Create relationship

Answer

Correct Answer: Create view

Note: This Question is unanswered, help us to find answer for this one

29. The sql command ________ adds one or more new columns to a table.

Create table.

Alter table

Create view.

Create relationship

Answer

Correct Answer: Alter table

Note: This Question is unanswered, help us to find answer for this one

30. The basic form of an sql retrieval command is ____.

A --> B

Fact Tables and Dimension Tables

Intersection

SELECT-FROM-WHERE

Answer

Correct Answer: SELECT-FROM-WHERE

Note: This Question is unanswered, help us to find answer for this one

31. The ____ function determines the number of rows in a table.

SUM

Count

Varchar.

INT

Answer

Correct Answer: Count

Note: This Question is unanswered, help us to find answer for this one

32. The ____ function calculates a total of the values in a column.

VARCHAR.

BETWEEN.

SUM.

COUNT

Answer

Correct Answer: SUM.

Note: This Question is unanswered, help us to find answer for this one

33. The ____ data type would be appropriate for a fixed-length field designed to hold a person’s name.

Text

Number

Character

Answer

Correct Answer: Text

Note: This Question is unanswered, help us to find answer for this one

34. The ____ data type stores only the actual character string.

INT

VARCHAR

CHAR

Answer

Correct Answer: VARCHAR

Note: This Question is unanswered, help us to find answer for this one

35. The ____ data type is used to store integers.

INSERT

INT

DROP

DISTINCT

Answer

Correct Answer: INT

Note: This Question is unanswered, help us to find answer for this one

36. The ____ command is used with the alter table command to modify the table by deleting a column.

DROP

DELETE

REMOVE

ERASE

Answer

Correct Answer: DROP

Note: This Question is unanswered, help us to find answer for this one

37. The ____ command is permanent.

SELECT

COMMIT

SAVE

UPDATE

Answer

Correct Answer: COMMIT

Note: This Question is unanswered, help us to find answer for this one

38. The ____ clause lets you group data on a particular column.

Intersect

HAVING

BETWEEN

GROUP BY

Answer

Correct Answer: GROUP BY

Note: This Question is unanswered, help us to find answer for this one

39. The ansi standard defines _____ type(s) of outer join(s)

INNER

Three

CHAR(15)

SYSDATE

Answer

Correct Answer: Three

Note: This Question is unanswered, help us to find answer for this one

40. The action of including only some columns for output while retrieving data is known as ____.

Organizing

Projecting

Drill down

Record

Answer

Correct Answer: Projecting

Note: This Question is unanswered, help us to find answer for this one

41. The ________ keyword is required to use relational operators in a case statement.

True

Not

False

Answer

Correct Answer: Is

Note: This Question is unanswered, help us to find answer for this one

42. The _____ operator could be used in place of minus if the dbms does not support it.

Exists

Union

Not in

Answer

Correct Answer: Not in

Note: This Question is unanswered, help us to find answer for this one

43. The _____ command replaces the ***** in the syntax of the update command, shown above.

SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE, FROM PRODUCT, ORDER BY P_PRICE;

SELECT, FROM, WHERE ;

SET columnname = expression

Performing operations within parentheses

Answer

Correct Answer: SET columnname = expression

Note: This Question is unanswered, help us to find answer for this one

44. The ____ wildcard symbol represents any individual character.

Underscore ( _ )

VARCHAR.

BETWEEN.

COUNT

Answer

Correct Answer: Underscore ( _ )

Note: This Question is unanswered, help us to find answer for this one

45. The ____ operator uses one or more wildcard characters to test for a pattern match.

BETWEEN

Minor

HAVING

Answer

Correct Answer: LIKE

Note: This Question is unanswered, help us to find answer for this one

46. The ____ operator specifies a range of values in a condition.

HAVING

SELECT

BETWEEN

Answer

Correct Answer: BETWEEN

Note: This Question is unanswered, help us to find answer for this one

47. The ____ operator is used to determine whether a condition is present in a subquery.

EXISTS

IS NULL

Subquery

Single-row

Answer

Correct Answer: EXISTS

Note: This Question is unanswered, help us to find answer for this one

48. You indicate the end of a command by typing a ____.

Command line

Varchar

Semicolon

Show columns

Answer

Correct Answer: Semicolon

Note: This Question is unanswered, help us to find answer for this one

49. You can use the ____ command to create a new table using data in an existing table.

CREATE TABLE

NEW TABLE

UPDATE

ALTER TABLEA) CREATE TABLE

Answer

Correct Answer: CREATE TABLE

Note: This Question is unanswered, help us to find answer for this one

50. You can save the results of a query as a table by including the ____ clause in the query.

Into

COUNT

INSERT

Answer

Correct Answer: Into

Note: This Question is unanswered, help us to find answer for this one

51. You can join tables by using a condition in the ____ clause.

WHERE

FROM

AND

PLUS

Answer

Correct Answer: WHERE

Note: This Question is unanswered, help us to find answer for this one

52. When you use the ____ function, you can use the asterisk (*) to represent any column.

COUNT

WHERE

HAVING

Answer

Correct Answer: COUNT

Note: This Question is unanswered, help us to find answer for this one

53. The _____ command restricts the selection of grouped rows based on a condition.

DISPLAY

HAVING

FROM

CONVERT

Answer

Correct Answer: HAVING

Note: This Question is unanswered, help us to find answer for this one

54. The structure of the table can be displayed with the _________ command:

Dis

Desc and the Describe (*)

Desc

Describe

Answer

Correct Answer: Describe

Note: This Question is unanswered, help us to find answer for this one

55. Sql was developed in the mid-____.

Single quotation marks

Period (.)

1970s

Column

Answer

Correct Answer: 1970s

Note: This Question is unanswered, help us to find answer for this one

56. Sql uses search operators such as ____ to form complex queries.

AND

NOT

All of the above

Answer

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

57. Sql requires the use of the _____ command to enter data into a table.

INSERT

SELECT

COMMIT

NOT NULL

Answer

Correct Answer: INSERT

Note: This Question is unanswered, help us to find answer for this one

58. Sql queries that use exists and not exists are ________.

Normal subqueries

Correlated subqueries

Uncorrelated subqueries

Constraint dependent subqueries

Answer

Correct Answer: Correlated subqueries

Note: This Question is unanswered, help us to find answer for this one

59. Sql links tables together by ________.

The kind of data accessed by the end user

The sequential execution of operations on each record in a large set

Using primary keys and foreign keys

Used to manipulate information in relational databases

Answer

Correct Answer: Using primary keys and foreign keys

Note: This Question is unanswered, help us to find answer for this one

60. Sql is an example of a ________ style of programming language.

XML

Rectangle

Coding

4GL

Answer

Correct Answer: 4GL

Note: This Question is unanswered, help us to find answer for this one

61. Sql ________ statements may change the contents of a database.

Domain constraints

UPDATE, DELETE, INSERT

ClassNotFoundException

A superkey

Answer

Correct Answer: UPDATE, DELETE, INSERT

Note: This Question is unanswered, help us to find answer for this one

62. Popular ____ include access, oracle, db2, mysql, and sql server.

E-R diagrams

DBAs

Data files

DBMS

Answer

Correct Answer: DBMS

Note: This Question is unanswered, help us to find answer for this one

63. Oracle and sql server support the ____ operator but microsoft access does not.

Transaction

INTERSECT

INSERT

GETDATE

Answer

Correct Answer: INTERSECT

Note: This Question is unanswered, help us to find answer for this one

64. Microsoft azure sql is an example of a _________________ database.

Filter data

OLAP

Record

Cloud

Answer

Correct Answer: Cloud

Note: This Question is unanswered, help us to find answer for this one

65. Insert, update, and delete statements can be referred to as ______________ queries.

Alias

Action

Correlation

Foreign

Answer

Correct Answer: Action

Note: This Question is unanswered, help us to find answer for this one

66. In the select clause, you can use the ____ symbol to indicate that you want to include all columns.

COUNT

DECIMAL

Code

Answer

Correct Answer: *

Note: This Question is unanswered, help us to find answer for this one

67. In subquery terminology, the first query in the sql statement is known as the _____ query.

Outer

Inner

OUT

Answer

Correct Answer: Outer

Note: This Question is unanswered, help us to find answer for this one

68. In sql, you use the ____ command to query a database.

SELECT

NOT

COUNT

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

69. In sql, use the ____ data type for variable-length character columns.

TEXT

VARCHAR

VARIABLE

CHARLENGTH

Answer

Correct Answer: VARCHAR

Note: This Question is unanswered, help us to find answer for this one

70. In sql server, you can use the ____ function to obtain today’s date.

SYSDATE

GETDATE()

TODAYS_DATE

CURRENTDATE

Answer

Correct Answer: GETDATE()

Note: This Question is unanswered, help us to find answer for this one

71. In oracle, use the ____ command to display the structure of a table.

HOW TABLE

SHOW LAYOUT

DESCRIBE

DISPLAY LAYOUT

Answer

Correct Answer: DESCRIBE

Note: This Question is unanswered, help us to find answer for this one

72. In oracle, the _____ function converts a date to a character string.

CONVERT()

TO_DATE

TO_CHAR()

TO_STRING

Answer

Correct Answer: TO_CHAR()

Note: This Question is unanswered, help us to find answer for this one

73. In oracle, the ____ table contains information about the tables known to sql.

SP_TABLES

DBA_TABLES

ALL_TABLES

SHOW_TABLES

Answer

Correct Answer: DBA_TABLES

Note: This Question is unanswered, help us to find answer for this one

74. In many languages the case structure is called a ________ statement.

Branch

Jump

Selective

Switch

All of these

Answer

Correct Answer: Switch

Note: This Question is unanswered, help us to find answer for this one

75. In an entity-relationship (e-r) diagram, ____ are used to represent an entity.

Dependency

Lines

Rectangles

Relations

Answer

Correct Answer: Rectangles

Note: This Question is unanswered, help us to find answer for this one

76. In access sql, the ____ is used as a wildcard to represent any individual character.

The subquery query

SELECT-FROM-WHERE

Question Mark (?)

Enclose in square brackets

Answer

Correct Answer: Question Mark (?)

Note: This Question is unanswered, help us to find answer for this one

77. If you have three different transitive dependencies, _____ different determinant(s) exist.

Four

Three

Two

One

Answer

Correct Answer: Three

Note: This Question is unanswered, help us to find answer for this one

78. Commands used to modify data are called ____ commands.

Update

Delete

DML

None of these

Answer

Correct Answer: DML

Note: This Question is unanswered, help us to find answer for this one

79. Columns in a database table contain data with the same _________.

Table

Type

False

Null

Answer

Correct Answer: Type

Note: This Question is unanswered, help us to find answer for this one

80. All join conditions are connected through a(n) _____ logical operator.

AND

Inner

UNION

MON

Answer

Correct Answer: AND

Note: This Question is unanswered, help us to find answer for this one

81. A dbms lets you assign users to ____.

Groups

Relationships

Both

Answer

Correct Answer: Groups

Note: This Question is unanswered, help us to find answer for this one

82. A ________ is a temporary table used in the from clause of an sql query.

Correlated subquery

Derived table

View table

None of these

Answer

Correct Answer: Derived table

Note: This Question is unanswered, help us to find answer for this one

83. A ____ query creates a new table using the query results.

Update

Make-table

Computed

Cartesian

Answer

Correct Answer: Make-table

Note: This Question is unanswered, help us to find answer for this one

84. A ____ is a pointer to a row in the collection of rows retrieved by an sql command.

Cursor

Trigger

Waypoint

Fetchpoint

Answer

Correct Answer: Cursor

Note: This Question is unanswered, help us to find answer for this one

85. All statements in SQL end with:

Semicolon

Colon

Dot

Comma

Answer

Correct Answer: Semicolon

Note: This Question is unanswered, help us to find answer for this one

86. Which of the following is an internet media type for SQL? (check any that apply)

application/sql

application/x-sql

application/ms-sql

application/m-sql

Answer

Correct Answer: application/sql
application/x-sql

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

87. Which of the following is not a comparison operator in SQL?

Answer

Correct Answer: ==

Note: This Question is unanswered, help us to find answer for this one

88.
Which of the following is the correct syntax for writing sub query?

SELECT sub.*

FROM (

SELECT *

FROM abc

WHERE day = 'Friday'

)

WHERE sub.resolution = 'NONE'

SELECT *

FROM (

SELECT *

FROM abc

WHERE day = 'Friday'

)

WHERE resolution = 'NONE'

SELECT sub.*

FROM (

SELECT *

FROM abc

WHERE day = 'Friday'

) sub

WHERE sub.resolution = 'NONE'

Answer

Correct Answer:

SELECT sub.*

FROM (

SELECT *

FROM abc

WHERE day = 'Friday'

) sub

WHERE sub.resolution = 'NONE'

Note: This Question is unanswered, help us to find answer for this one

89. Which of the following can be used with LIKE operator?

Answer

Correct Answer: %

Note: This Question is unanswered, help us to find answer for this one

90. Which statement INSERTS or UPDATES based on the given conditions?

Insert

Merge

Intersect

Select

Answer

Correct Answer: Merge

Note: This Question is unanswered, help us to find answer for this one

91. If a column is defined as decimal(5,2), what does that mean?

A number that has 5 digits before the decimal and 2 digits after the decimal

A number that has 3 digits before the decimal and 2 digits after the decimal

A number that has 2 digits before the decimal and 3 digits after the decimal

A number that has 2 digits before the decimal and 5 digits after the decimal

Answer

Correct Answer: A number that has 3 digits before the decimal and 2 digits after the decimal

Note: This Question is unanswered, help us to find answer for this one

92. Is there a difference between AND and & (ampersand) in SQL?

Ampersand doesn't have support in SQL:2008 standard;

AND priority is higher than &;

AND has lower priority in comparison with ampersand;

There is no difference.

Answer

Correct Answer: AND has lower priority in comparison with ampersand;

Note: This Question is unanswered, help us to find answer for this one

93. Which of the following can you not do with SQL?

Update record in database

Create new databases

Send data from databases

Insert new records to database

Answer

Correct Answer: Send data from databases

Note: This Question is unanswered, help us to find answer for this one

94. Which operator allows you to specify multiple values in a WHERE clause?

INSIDE

Answer

Correct Answer: IN

Note: This Question is unanswered, help us to find answer for this one

95. Which of the following is an SQL operator?

DISLIKE

UNFOLLOW

Answer

Correct Answer: LIKE

Note: This Question is unanswered, help us to find answer for this one

96. Which of the following can be used to delete all the data from a table?

EMPTY

DROP

TRUNCATE

Answer

Correct Answer: TRUNCATE

Note: This Question is unanswered, help us to find answer for this one

97.
Suppose you have the following table with columns:
+------+------+------------+--------------------+
| id | name | work_date | salary |
+------+------+------------+--------------------+
| 1 | John | 2016-01-24 | 300 |
To get an output like '1John2016-01-24' which of the following functions can be used?

CONCAT

COMBINE

STRING

Answer

Correct Answer:

CONCAT

Note: This Question is unanswered, help us to find answer for this one

98. Which of the following functions are related to XML? (check any that apply)

PATH

XMLTABLE

DEPTH

XMLPATH

Answer

Correct Answer: XMLTABLE
DEPTH

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

99. Which of the following is the name of ** operator?

Subtraction

Negation

Exponentiation

Multiplication

Answer

Correct Answer: Exponentiation

Note: This Question is unanswered, help us to find answer for this one

100. Transactions, if available, wrap ___ operations.

DDL

DML

DCL

DLL

Answer

Correct Answer: DML

Note: This Question is unanswered, help us to find answer for this one

101.
Consider two tables A and B having only one column each and having these values:
A = [0, 1, 2, 3, 4, 5]
B = [5, 6, 7, 8, 9, 10]
The number of records in result of UNION operator on these tables will be?

Answer

Correct Answer:

Note: This Question is unanswered, help us to find answer for this one

102. Which one of the following is the correct way to delete a column from a table?

table? ALTER TABLE table_name DELETE COLUMN column_name

UPDATE TABLE table_name DROP COLUMN column_name

ALTER TABLE table_name DROP COLUMN column_name

ALTER TABLE table_name REMOVE COLUMN column_name

Answer

Correct Answer: ALTER TABLE table_name DROP COLUMN column_name

Note: This Question is unanswered, help us to find answer for this one

103.
Suppose a table CUSTOMERS has the following records:
+---+--------+----------+
| ID | CUSTOMER| INCOME |
+----+---------+---------+
| 1 | Roman | 150000 |
| 2 | Andrew | 200000 |
| 3 | Christi | 240000 |
| 4 | Ivan | 240000 |
| 5 | John | 240000 |
| 6 | Ann | 240000 |
+----+---------+---------+`
Which of the following statements will select the customers with income more than 200000? (check any that apply)

SELECT INCOME FROM CUSTOMERS WHERE ID IN (SELECT INCOME FROM CUSTOMERS WHERE INCOME > 200000);

SELECT * FROM CUSTOMERS WHERE ID IN (SELECT ID FROM CUSTOMERS WHERE INCOME > 200000);

SELECT * FROM CUSTOMERS WHERE INCOME IN (SELECT CUSTOMER FROM CUSTOMERS WHERE INCOME > 200000);

SELECT * FROM CUSTOMERS WHERE ID IN (SELECT ID FROM CUSTOMERS WHERE INCOME >= 200001);

Answer

Correct Answer:

SELECT * FROM CUSTOMERS WHERE ID IN (SELECT ID FROM CUSTOMERS WHERE INCOME > 200000);

SELECT * FROM CUSTOMERS WHERE ID IN (SELECT ID FROM CUSTOMERS WHERE INCOME >= 200001);

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

104. If AND and OR are used after WHERE clause ...

DBMS returns an error;

AND has higher priority;

OR has higher priority;

It is necessary to use parentheses for each condition.

Answer

Correct Answer: AND has higher priority;

Note: This Question is unanswered, help us to find answer for this one

105. Which of the following is not a DDL statement?

CREATE TABLE

DROP TABLE

TRUNCATE TABLE

INNER JOIN

Answer

Correct Answer: INNER JOIN

Note: This Question is unanswered, help us to find answer for this one

106. Which of the following SQL commands can use a foreign key constraint? (check any that apply)

CREATE

ALERT

UPDATE

ALTER

Answer

Correct Answer: CREATE
ALTER

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

107. Which of the following SQL commands can be included to sort data?

SORT WITH

SORT BY

ORDER BY

LIST BY

Answer

Correct Answer: ORDER BY

Note: This Question is unanswered, help us to find answer for this one

108.
For a table with the following data:
Name Marks
John 400
Brown 200
Darwin 350
Kamy 250
Which of the following queries will give you names of all students having above average marks?

SELECT name FROM student WHERE marks > (SELECT AVG(marks) FROM student)

SELECT name FROM student WHERE marks > AVG(marks)

SELECT name FROM student WHERE marks > AVG(marks) GROUP BY marks

Answer

Correct Answer:

SELECT name FROM student WHERE marks > (SELECT AVG(marks) FROM student)

Note: This Question is unanswered, help us to find answer for this one

109. Which of the following is not a valid SQL operator?

BETWEEN

EXISTS

ANY

EQUAL

Answer

Correct Answer: EQUAL

Note: This Question is unanswered, help us to find answer for this one

110. Which of the following statements is/are true?

Select and create are DDL commands.

Create and Grant are DCL commands.

Drop and Insert are TCL commands.

Alter and Drop are DDL commands.

Answer

Correct Answer: Alter and Drop are DDL commands.

Note: This Question is unanswered, help us to find answer for this one

111. Which of the following operators can not be used in the 'WHERE' clause?

Answer

Correct Answer: <<

Note: This Question is unanswered, help us to find answer for this one

112. What is the difference between CHAR and VARCHAR data types?

CHAR takes fixed space whereas VARCHAR takes variable space.

CHAR stores data as an array of characters, whereas VARCHAR stores data as strings.

CHAR cannot contain NULL values, wheres VARCHAR can contain NULL values.

CHAR in MySQL is the same as VARCHAR in Oracle.

Answer

Correct Answer: CHAR takes fixed space whereas VARCHAR takes variable space.

Note: This Question is unanswered, help us to find answer for this one

113.
Assuming there are multiple rows in the 'Commission_Agents' table with entries for commission agents from different departments, what is the error in the following query:
SELECT name, department_id, commission_percentage from Commision_Agents
WHERE commission_percentage = (SELECT min(commission_percentage) FROM Commision_Agents GROUP BY department_id);

You cannot use GROUP BY clause in sub-query

An aggregate function cannot be used in sub-query

You cannot use '=' operator as the sub-query is returning multiple results

No error

Answer

Correct Answer:

You cannot use '=' operator as the sub-query is returning multiple results

Note: This Question is unanswered, help us to find answer for this one

114. What keyword is used to filter values obtained by applying aggregate functions in the query results using GROUP BY clause?

FILTER;

WHERE;

HAVING;

None of the above;

Answer

Correct Answer: HAVING;

Note: This Question is unanswered, help us to find answer for this one

115. What does MID() function do?

Returns the middle character.

Extract characters from a text field.

Returns the length of a text field.

Answer

Correct Answer: Extract characters from a text field.

Note: This Question is unanswered, help us to find answer for this one

116. To create a table column which should not accept blank values, which of the following can be used?

NULL

NOT NULL

BLANK

EMPTY

Answer

Correct Answer: NOT NULL

Note: This Question is unanswered, help us to find answer for this one

117. Which of the following is not a DDL command?

ALTER

CREATE

DROP

ALERT

Answer

Correct Answer: ALERT

Note: This Question is unanswered, help us to find answer for this one

118. Which of the following is not a DDL Command?

ALTER

UPDATE

RENAME

DROP

Answer

Correct Answer: UPDATE

Note: This Question is unanswered, help us to find answer for this one

119.
Which of the following command will work as per below statement
"We need to replace a string named "foo" with "bar" in a column having ID <= 4"

UPDATE table_name

SET column_name= REPLACE('foo', 'bar')

WHERE ID <= 4;

UPDATE table_name

SET column_name = REPLACE(column_name, 'bar', 'foo')

WHERE ID <= 4;

UPDATE table_name

SET column_name = REPLACE(column_name, 'foo', 'bar')

WHERE ID <= 4;

Answer

Correct Answer:

UPDATE table_name

SET column_name = REPLACE(column_name, 'foo', 'bar')

WHERE ID <= 4;

Note: This Question is unanswered, help us to find answer for this one

120.
Consider two tables A and B, having only one column each and having these values:
A = [0, 1, 2, 3, 4, 5]
B = [5, 6, 7, 8, 9, 10]
The result of the UNION ALL operator on these tables will be?

[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]

[5]

[0, 1, 2, 3, 4, 5, 5, 6, 7, 8, 9, 10]

None of the above

Answer

Correct Answer:

[0, 1, 2, 3, 4, 5, 5, 6, 7, 8, 9, 10]

Note: This Question is unanswered, help us to find answer for this one

121. To speed up searches in tables we can?

create Index

truncate table

create views

Answer

Correct Answer: create Index

Note: This Question is unanswered, help us to find answer for this one

122. Which of the following clauses can be included in SELECT to fetch 10 records only? (Check all that apply)

LIMIT 10

TOP 10

LIMIT 10 OFFSET 1

ONLY 10

Answer

Correct Answer: LIMIT 10
TOP 10
LIMIT 10 OFFSET 1

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

123. To create a column in a table with a fixed length(n) string, which of the following data type is recommended?

VARCHAR

CHAR

FIXED

STRING

Answer

Correct Answer: CHAR

Note: This Question is unanswered, help us to find answer for this one

124.
For a table with the following columns:
product_id, product_name, supplier_id, price
Which of the following queries will give you the supplier with the maximum average price of products?

SELECT supplier_id, avg(price) FROM Products group by supplier_id having avg(price) in (Select max(avg_price) from (Select avg(price) as avg_price from products group by supplier_id))

SELECT supplier_id, max(avg(price)) FROM Products group by supplier_id

SELECT supplier_id, avg(price) FROM Products group by supplier_id having avg(price) in (Select max(avg_price) from (Select avg(price) as avg_price from products))

SELECT supplier_id, avg(price) FROM Products group by supplier_id having avg(price) in (Select max(avg(price) as avg_price from products group by supplier_id))

Answer

Correct Answer:

SELECT supplier_id, avg(price) FROM Products group by supplier_id having avg(price) in (Select max(avg_price) from (Select avg(price) as avg_price from products group by supplier_id))

Note: This Question is unanswered, help us to find answer for this one

125. Which of the following commands is used to explain access to data?

EXPLAIN PATH

EXPLAIN PLAN

CALL

EXPLAIN ACCESS

Answer

Correct Answer: EXPLAIN PLAN

Note: This Question is unanswered, help us to find answer for this one

126. Which of the following operators can be used to check if a column contains NULL value?

EXISTS

IS NULL

NOT

Answer

Correct Answer: IS NULL

Note: This Question is unanswered, help us to find answer for this one

127. Which query can be used to copy all records from table1 into table2 provided they have the same columns?

CLONE INTO table2 SELECT * FROM table1;

INSERT INTO table1 FROM table2;

INSERT INTO table2 FROM table1;

INSERT INTO table2 SELECT * FROM table1;

Answer

Correct Answer: INSERT INTO table2 SELECT * FROM table1;

Note: This Question is unanswered, help us to find answer for this one

128.
What will be the output of the following query?
SELECT (ROUND(3.5 MOD 4)) from DUAL;

3.5

4.5

Answer

Correct Answer:

Note: This Question is unanswered, help us to find answer for this one

129.
What will be the output of the following query?
SELECT SUBSTRING('987654321', INSTR('foobar', 'o'), 5) from DUAL;

98765

87654

76543

65432

Answer

Correct Answer:

87654

Note: This Question is unanswered, help us to find answer for this one

130. Which of the following is not true about the COMMIT command?

Executing COMMIT without BEGIN TRANSACTION will result in an error.

A COMMIT will end all the transactions that were initiated before it.

A COMMIT will end transaction only in the current session.

COMMIT is opposite of ROLLBACK.

Answer

Correct Answer: A COMMIT will end all the transactions that were initiated before it.

Note: This Question is unanswered, help us to find answer for this one

131. What is the difference between decimal and numeric data types?

decimal - type of numerical data with a fixed precision and scale, numeric - type of numerical data without fixed precision and scale;

numeric - type of numerical data with a fixed precision and scale, decimal - numeric data type without fixed precision and scale;

decimal - numeric data type with a fixed precision and scale, numeric - exact numeric data type with integer precision;

numeric - numeric data type with a fixed precision and scale, decimal - exact numeric data type with integer precision;

There is no difference.

Answer

Correct Answer: There is no difference.

Note: This Question is unanswered, help us to find answer for this one

132. Which of the following is true for creating SQL Views? (check any that apply)

If you have a complex select with lots of joins, you can implement it in a view and simply call the view without need to consider all these joins.

Each user can be given permission to access the database only through a small set of views that contain the specific data the user is authorized to see, thus restricting the user's access to stored data

A view can draw data from several different tables and present it as a single table, turning multi-table queries into single-table queries against the view.

Answer

Correct Answer: If you have a complex select with lots of joins, you can implement it in a view and simply call the view without need to consider all these joins.
Each user can be given permission to access the database only through a small set of views that contain the specific data the user is authorized to see, thus restricting the user's access to stored data
A view can draw data from several different tables and present it as a single table, turning multi-table queries into single-table queries against the view.

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

133.
How would you create a table with one column having Integer precision of 10?

CREATE TABLE table_name

(

column_name1 INTEGER(10),

);

CREATE TABLE table_name

(

column_name1 INT('10'),

);

CREATE TABLE table_name

(

column_name1 DECIMAL(10),

);

CREATE TABLE table_name

(

column_name1 INTEGER('10'),

);

Answer

Correct Answer:

CREATE TABLE table_name

(

column_name1 INTEGER(10),

);

Note: This Question is unanswered, help us to find answer for this one

134.
Consider the following Attendance table which contains an employee attendance record for a company:
EmployeeID (int), LoginTime (time), LogoutTime (time)
Which of these SELECT statements will list the employee ID that has logged-in most recently?

SELECT EmployeeID

FROM Attendance

GROUP BY LoginTime

HAVING MAX(LoginTime)

SELECT TOP 1 a.EmployeeID

FROM Attendance a

WHERE EXISTS (SELECT MAX(b.LoginTime) FROM Attendance b GROUP BY EmployeeID HAVING MAX(b.LoginTime) = a.LoginTime AND a.EmployeeID = b.EmployeeID )

SELECT TOP 1 a.EmployeeID

FROM Attendance a

WHERE a.LoginTime = (SELECT MAX(b.LoginTime) FROM Attendance b)

None of the above

Answer

Correct Answer:

SELECT TOP 1 a.EmployeeID

FROM Attendance a

WHERE a.LoginTime = (SELECT MAX(b.LoginTime) FROM Attendance b)

Note: This Question is unanswered, help us to find answer for this one

135. Referential Integrity means that among relations

A record cannot be deleted if it has any associated data.

A foreign key value is a subset of its primary key.

There are no duplicate values in a primary key.

Answer

Correct Answer: A record cannot be deleted if it has any associated data.

Note: This Question is unanswered, help us to find answer for this one

136. Which of the following only works with GROUP BY clause?

WHERE

ORDER BY

HAVING

None of the above

Answer

Correct Answer: None of the above

Note: This Question is unanswered, help us to find answer for this one

137. After describing the EMPLOYEES table, you discover that the SALARY column has a data type of NUMBER(8,2). Which SALARY value(s) will not be permitted in this column?

SALARY=123456.78

SALARY=12345.678

SALARY=12345678

SALARY=123456

SALARY=12.34

Answer

Correct Answer: SALARY=12345678

Note: This Question is unanswered, help us to find answer for this one

138. How can you improve the execution speed of the following query: Select * from Products Where City like '%gen%'

None of these will improve the execution speed.

Creating a clustered index only on the column City.

Creating a primary key on the City column.

Including City column into a Full-Text Search group.

Answer

Correct Answer: None of these will improve the execution speed.

Note: This Question is unanswered, help us to find answer for this one

139. All the following are properties of the Relational tables expect

Column values are of the different kind.

The sequence of rows is insignificant.

Values are atomic.

Each row is unique.

Answer

Correct Answer: Column values are of the different kind.

Note: This Question is unanswered, help us to find answer for this one

140. Complete the sentence: SELECT animals ______ types WHERE id = 5;

SET

VALUES

WHERE

FROM

Answer

Correct Answer: FROM

Note: This Question is unanswered, help us to find answer for this one

141. What is T/SQL?

It is a proprietary version of SQL developed for Visual Studio.

It is a proprietary version of SQL developed by MySQL.

It is a proprietary version of SQL developed by Microsoft for their SQL Server.

It is a proprietary version of SQL developed by Oracle.

An Open Source Version of SQL.

Answer

Correct Answer: It is a proprietary version of SQL developed by Microsoft for their SQL Server.

Note: This Question is unanswered, help us to find answer for this one

142. How many Oracle installations does it take to execute a query?

One.

Four: three to hold it down, and one to rip its head off.

Three.

Two.

Five.

Answer

Correct Answer: Four: three to hold it down, and one to rip its head off.

Note: This Question is unanswered, help us to find answer for this one

143. what listing does represent a form of SQL

division

multiplication

minus

subtract

addition

Answer

Correct Answer: minus

Note: This Question is unanswered, help us to find answer for this one

144. what keyword below can replace NOT EXIST in SQL

exclude

not equal

not in table

MINUS

Answer

Correct Answer: MINUS

Note: This Question is unanswered, help us to find answer for this one

145. Which of the following cannot be used in a subquery?

SELECT

ORDER BY

INSERT

GROUP BY

Answer

Correct Answer: ORDER BY

Note: This Question is unanswered, help us to find answer for this one

146. How many types of indexes?

Answer

Correct Answer: 2

Note: This Question is unanswered, help us to find answer for this one

147. TRUE/FALSE. All of the SQL language, syntax, and commands are universal across all major database platforms (Oracle, MySQL, and MS-SQL).

False

True

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

148. How to Extract characters from a text field?

UPDATE()

ADD()

MID()

MAX()

BETWEEN()

Answer

Correct Answer: MID()

Note: This Question is unanswered, help us to find answer for this one

149. SELECT dg.* FROM dgpricing dg LEFT OUTER JOIN icitem ic ON dg.Partno = ic.Item What columns does this query return?

Columns from both tables

Columns from dg table

Columns from ic table

None

Answer

Correct Answer: Columns from dg table

Note: This Question is unanswered, help us to find answer for this one

150. SELECT Customers.* FROM Customers LEFT OUTER JOIN Sales ON Customers.CustNo = Sales.CustNo What columns does this query return?

All columns from Customers table

None

All columns from both tables

Only columns from Sales table

All columns from CustNo

Answer

Correct Answer: All columns from Customers table

Note: This Question is unanswered, help us to find answer for this one

151. What is function for adding all the records of a column?

SUM()

ADD()

AVG()

SUBTRACT()

MIN()

Answer

Correct Answer: SUM()

Note: This Question is unanswered, help us to find answer for this one

152. How do you select the first record of a table?

SELECT * FROM dgpricing Where FirstRecord = 1

SELECT * FROM dgpricing WHERE top 1 = 1

SELECT FirstRecord FROM dgpricing

SELECT top 1 * FROM dgpricing

Answer

Correct Answer: SELECT top 1 * FROM dgpricing

Note: This Question is unanswered, help us to find answer for this one

153. What's the difference between "_" and "%" in sql wildcard

% is a substitute for zero or more characters, while _ is a substitute for a single character

% is substitute for only zero character, while _ is for all

_ is a substitute for a multiple characters, while % is a substitute for more characters

Answer

Correct Answer: % is a substitute for zero or more characters, while _ is a substitute for a single character

Note: This Question is unanswered, help us to find answer for this one

154. What is the Difference between Varchar and Char Datatypes in SQL?

Char is Limitless. Varchar has some limitations

Varchar is similar to Char except the declartion.

VarChar is the Variable length strings with the maximum specified limit. Char are Fixed length strings

VarChar is used in the Primary columns and Char used in other columns

Answer

Correct Answer: VarChar is the Variable length strings with the maximum specified limit. Char are Fixed length strings

Note: This Question is unanswered, help us to find answer for this one

155. How to create indexes?

CREATE INDEX index_name ON table_name (column_name)

ADD INDEX index_name ON table_name (column_name)

UPDATE INDEX index_name ON table_name (column_name)

INSERT INDEX index_name ON table_name (column_name)

INDEX index_name ON table_name (column_name)

Answer

Correct Answer: CREATE INDEX index_name ON table_name (column_name)

Note: This Question is unanswered, help us to find answer for this one

156. When an aliases is used to rename a table in a particular SQL statement. The actual table name in the database is also renamed?

True

False

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

157. With SQL, how do you select all the records from a table named "Companys" where the value of the column "Name" ends with an "d"?

SELECT * FROM Companys WHERE Name='d'

SELECT * FROM Companys WHERE Name='%d%'

SELECT * FROM Companys WHERE Name LIKE 'd%'

SELECT * FROM Companys WHERE Name LIKE '%d'

Answer

Correct Answer: SELECT * FROM Companys WHERE Name LIKE '%d'

Note: This Question is unanswered, help us to find answer for this one

158. Other things being equal, which queries are the fastest?

Not relevant.

Queries including correlated subqueries.

Queries including uncorrelated subqueries.

Answer

Correct Answer: Queries including uncorrelated subqueries.

Note: This Question is unanswered, help us to find answer for this one

159. Which statement can be used to encrypt data in SQL?

EncryptData(encryption_key_guid , source_data)

Encrypt(encryption_key_guid, salt, source_data);

Encrypt(encryption_key_guid , source_data)

EncryptByKey(encryption_key_guid, source_data)

Answer

Correct Answer: EncryptByKey(encryption_key_guid, source_data)

Note: This Question is unanswered, help us to find answer for this one

160. When using logical (truth value) operations, how many logical results are there and what are they?

3: True, False and Nothing

3: True, False and Null

2: 1 and 0

3: True, False and Unknown

2: True and False

Answer

Correct Answer: 3: True, False and Unknown

Note: This Question is unanswered, help us to find answer for this one

161. what does the following sql statement do? SELECT TOP(10) WITH TIES Name, Salary FROM Employees ORDER BY Salary DESC

Get the top 10 records with the highest salary, and any record with a Salary that matches any of the 10 records.

Gets the top ten records with a unique salary and any records which match.

throws a syntax error

Get the top 10 records with the highest salary, and any record with a Salary that matches the last result

Answer

Correct Answer: Get the top 10 records with the highest salary, and any record with a Salary that matches the last result

Note: This Question is unanswered, help us to find answer for this one

162. What is executed first in SQL?

FROM

SELECT

TOP

WHERE

Answer

Correct Answer: FROM

Note: This Question is unanswered, help us to find answer for this one

163. What is the equivalent sql statement of following statement? Select sum(column1) a, count(column2) b from TableA where 1=2

Select 0 a, 0 b from TableA

Select sum(1) a, count(2) b from TableA where column1=column2

Select sum(column1) a, count(*) b from TableA

Select sum(*) a, count(*) b from TableA where 1=2

Select sum(column1) a, count(column2) b from TableA where column1=column2

Answer

Correct Answer: Select 0 a, 0 b from TableA

Note: This Question is unanswered, help us to find answer for this one

164. How many TRIGGERS are allowed in MySql table

Answer

Correct Answer: 6

Note: This Question is unanswered, help us to find answer for this one

165. How can you prevent a phantom read?

By changing the isolation level to read committed

By changing the isolation level repeatable read

By changing the isolation level read uncommitted

By changing the isolation level to snapshot or serializable

You can't prevent them

Answer

Correct Answer: By changing the isolation level to snapshot or serializable

Note: This Question is unanswered, help us to find answer for this one

166. Which statement about non-clustered index is true?

A non-clustered index is a special type of index that reorders the way records in the table are physically stored.

In non-clustered index , the logical order of the index always matches the physical stored order of the rows on the disk.

The leaf nodes of a non-clustered index contain the data pages.

The leaf nodes of a non-clustered index contain the index rows.

Answer

Correct Answer: The leaf nodes of a non-clustered index contain the index rows.

Note: This Question is unanswered, help us to find answer for this one

167. Which is the highest isolation level?

Read uncommitted

Serializable

Read committed

Snapshot

Repeatable read

Answer

Correct Answer: Serializable

Note: This Question is unanswered, help us to find answer for this one

168. A recursive CTE would contain which of the following?

Except

Intersect

Union All

Union

Answer

Correct Answer: Union All

Note: This Question is unanswered, help us to find answer for this one

169. What code would find the position of the character 'D' in the string 'ABCDE' - starting at position 1?

PATINDEX('D','ABCDE',1)

VARCHAR(1,'D','ABCDE')

CHARINDEX('D','ABCDE',1)

VARCHAR('ABCDE','D',1)

CHARINDEX('ABCDE','D',1)

Answer

Correct Answer: CHARINDEX('D','ABCDE',1)

Note: This Question is unanswered, help us to find answer for this one

170. How can you insert several records in TABLE1 that already exist in TABLE2?

insert into TABLE1 (FIELD1) values (select FIELD2 from TABLE2)

insert into TABLE1 (FIELD1) select FIELD2 from TABLE2

insert into TABLE1 (FIELD1) values (TABLE2.FIELD2)

insert into TABLE1 (FIELD1) select FIELD2 , FIELD3, FIELD4 from TABLE2

Answer

Correct Answer: insert into TABLE1 (FIELD1) select FIELD2 from TABLE2

Note: This Question is unanswered, help us to find answer for this one

171. What is the difference between a unique key and primary key?

A primary key by default has an index, a unique key does not

They are the same

A primary key can be used as part of a foreign key relationship but a unique key cannot

A unique key will allow NULL values

A unique key can be used as part of a foreign key relationship but a primary key cannot

Answer

Correct Answer: A unique key will allow NULL values

Note: This Question is unanswered, help us to find answer for this one

172. What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()

The mysql_fetch_object() returns the result from the database as an object only.

The mysql_fetch_object() returns the result from the database as a JSON object.

The mysql_fetch_object() returns the result from the database as an object and sets a cursor for the next query.

Answer

Correct Answer: The mysql_fetch_object() returns the result from the database as an object only.

Note: This Question is unanswered, help us to find answer for this one

173. which of the following is NOT a SQL wildcard

[]

Answer

Correct Answer: ~

Note: This Question is unanswered, help us to find answer for this one

174. Which of the following KEYWORDS will return the first NON-NULL value from a list of columns?

COALESCE

NOTNULL

GATHER

PARSENULL

ISNULL

Answer

Correct Answer: COALESCE

Note: This Question is unanswered, help us to find answer for this one

175. Which of the following types of triggers can be used with a view?

After Delete

Before Update

Before Insert

After Update

Instead of Update

Answer

Correct Answer: Instead of Update

Note: This Question is unanswered, help us to find answer for this one

176. What is a collation?

A character encoding for a character data type.

An alphabet for a character data type.

A concatenation of two columns containing characters.

A set of rules that sort and compare characters.

Answer

Correct Answer: A set of rules that sort and compare characters.

Note: This Question is unanswered, help us to find answer for this one

177. How many clustered indexes can a table have?

no limit

128

Answer

Correct Answer: 1

Note: This Question is unanswered, help us to find answer for this one

178. Which of these is not a valid constraint?

CHECK

PRIMARY KEY

NOT NULL

UNIQUE

EXISTS

Answer

Correct Answer: EXISTS

Note: This Question is unanswered, help us to find answer for this one

179. Which is the only proven way to prevent SQL Injection

Use parameters to hold user inputs

There is no proven method

Escape all single quotes in user input

Escape all common SQL reserved words

Answer

Correct Answer: Use parameters to hold user inputs

Note: This Question is unanswered, help us to find answer for this one

180. Which of the following statements about indexes is NOT correct?

Adding additional indexes can result in reduced write speeds.

Adding additional indexes cannot decrease the performance of your database.

Adding additional indexes increases the storage space required for your database.

Adding additional indexes can greatly improve performance in an OLAP environment.

Answer

Correct Answer: Adding additional indexes cannot decrease the performance of your database.

Note: This Question is unanswered, help us to find answer for this one

181. If you INNER JOIN tableA (which has 10 rows) with tableB (which has 5 rows), what is the smallest possible amount of rows that can be returned?

Answer

Correct Answer: 0

Note: This Question is unanswered, help us to find answer for this one

182. Which is the lowest isolation level to ensure dirty reads can not happen

Repeatable read

Read uncommitted

Serializable

Snapshot

Read committed

Answer

Correct Answer: Read committed

Note: This Question is unanswered, help us to find answer for this one

183. Which of the following is a valid isolation level?

Serial

Repeatable Write

Concurrent

Read Commited

Write Committed

Answer

Correct Answer: Read Commited

Note: This Question is unanswered, help us to find answer for this one

184. What is a phantom read?

Phantom reads do not exist

All reads from the data under snapshot is a phantom read

A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection of rows returned by the second query is different from the first.

When values in the data set before the end of the transaction are changed, giving incorrect/wrong data back.

Answer

Correct Answer: A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection of rows returned by the second query is different from the first.

Note: This Question is unanswered, help us to find answer for this one

185. What is the correct syntax for using a CASE statement?

CASE {value/column} WHEN {Boolean Condition} THEN {Value} ELSE CREATE PROCEDURE

CASE {value/column} WHEN {Boolean Condition} THEN {Value} ELSE {Value} END

None of these

CASE {value/column} WHEN {Boolean Condition} THEN {Value} ELSE {Value} END CASE

CASE WHEN {Boolean Condition} END

Answer

Correct Answer: CASE {value/column} WHEN {Boolean Condition} THEN {Value} ELSE {Value} END

Note: This Question is unanswered, help us to find answer for this one

186. Where can we find subquery within another statement?

In the SELECT clause.

In all these clauses.

In the JOIN clause.

In the FROM clause.

In the HAVING clause.

Answer

Correct Answer: In all these clauses.

Note: This Question is unanswered, help us to find answer for this one

187. Which type of join will yield a Cartesian product?

Left Outer Join

Cross Join

Right Outer Join

Full Join

Natural Join

Answer

Correct Answer: Cross Join

Note: This Question is unanswered, help us to find answer for this one

188. Must CASE statements always be indented?

Only when the CASE statement appears in the WHERE clause.

No, but the CASE statement must be in parentheses.

No.

Yes.

Answer

Correct Answer: No.

Note: This Question is unanswered, help us to find answer for this one

189. What is an alternate way of writing the following statement: WHERE "column_name" IN ('value1')

WHERE "column_name" CONTAINS 'value1'

WHERE "column_name" > 'value1'

WHERE "column_name" INCLUDES 'value1'

WHERE "column_name" = 'value1'

WHERE "column_name" < 'value1'

Answer

Correct Answer: WHERE "column_name" = 'value1'

Note: This Question is unanswered, help us to find answer for this one

190. What is the difference between WHERE and HAVING clauses?

HAVING cannot use aggregate function to filter records whereas WHERE can use aggregate function to filter records

None of these

HAVING filter records before the GROUP BY while WHERE filter records after the GROUP BY clause

HAVING filter records after the GROUP BY while WHERE filter records before the GROUP BY clause

Answer

Correct Answer: HAVING filter records after the GROUP BY while WHERE filter records before the GROUP BY clause

Note: This Question is unanswered, help us to find answer for this one

191. What is a common schema name?

database_owner

dba.exe

private.user

dbo

database_administrator

Answer

Correct Answer: dbo

Note: This Question is unanswered, help us to find answer for this one

192. What keyword is used in conjunction with the INNER JOIN keywords to return rows when there is at least one match in both tables?

WHEN

CONNECT

Answer

Correct Answer: ON

Note: This Question is unanswered, help us to find answer for this one

193. Which of the following DROP statements is incorrect?

DROP INDEX

DROP DATABASE

DROP TABLE

DROP ROW

Answer

Correct Answer: DROP ROW

Note: This Question is unanswered, help us to find answer for this one

194. A trigger is a database object that is attached to a table. It is most similar to what other database process?

result set

view

cursor

stored procedure

Answer

Correct Answer: stored procedure

Note: This Question is unanswered, help us to find answer for this one

195. What visual technique is commonly used to format subqueries?

indenting

numbering

color coding

bolding

Answer

Correct Answer: indenting

Note: This Question is unanswered, help us to find answer for this one

196. What of the following is an operator for nonequality?

equal exclamation (=!)

less than greater than (<>)

greater than less than (><)

equal equal (==)

Answer

Correct Answer: less than greater than (<>)

Note: This Question is unanswered, help us to find answer for this one

197. What function returns the highest value in a column?

HIGHEST()

BIGGEST()

MAX()

HIGH()

Answer

Correct Answer: MAX()

Note: This Question is unanswered, help us to find answer for this one

198. What function counts the number of rows in a column?

COUNT()

TOTAL()

ADD()

NUMBER()

Answer

Correct Answer: COUNT()

Note: This Question is unanswered, help us to find answer for this one

199. Which character is used to retrieve all columns of data?

dollar sign ($)

asterisk (*)

pound sign (#)

exclamation (!)

Answer

Correct Answer: asterisk (*)

Note: This Question is unanswered, help us to find answer for this one

200. Which of the following is NOT a basic SQL statement?

INSERT

QUERY

SELECT

DELETE

UPDATE

Answer

Correct Answer: QUERY

Note: This Question is unanswered, help us to find answer for this one

201. Which character is used to end a SQL statement?

semicolon (;)

colon (:)

period (.)

exclamation (!)

Answer

Correct Answer: semicolon (;)

Note: This Question is unanswered, help us to find answer for this one

202. True or False: An ORDER BY clause is optional in a query.

True.

False.

Answer

Correct Answer: True.

Note: This Question is unanswered, help us to find answer for this one

203. Of the following sequences which one is in the correct order?

HAVING | FROM | SELECT | GROUP BY

GROUP BY | FROM | SELECT | HAVING

SELECT | FROM | GROUP BY | HAVING

FROM | GROUP BY | HAVING | SELECT

Answer

Correct Answer: SELECT | FROM | GROUP BY | HAVING

Note: This Question is unanswered, help us to find answer for this one

204. What statement must be placed in the blank space at the beginning of this query in order for it to be valid? ______ Movie.title, COUNT(*) AS Directors FROM Movie JOIN Movie_director ON Movie.isbn = Movie_director.isbn GROUP BY Movie.title

ORDER BY

WHERE

SELECT

FROM

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

205. True or false The ORDER BY keyword is used to sort the result-set by one or more columns.

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

206. What is DDL Stand for?

Data Deprecation Logic

Data Determined Login

Data Distribution Layout

Data Definition Language

Answer

Correct Answer: Data Definition Language

Note: This Question is unanswered, help us to find answer for this one

207. What keyword is used to retrieve table data?

GET

SELECT

FETCH

RETRIEVE

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

208. Which of the following is NOT included as a field in the timestamp data type?

Year

Day

Month

Hour

Century

Answer

Correct Answer: Century

Note: This Question is unanswered, help us to find answer for this one

209. Which command is used to sort retrieved data?

NUMERIC

SORT

ORDER BY

ALPHA

Answer

Correct Answer: ORDER BY

Note: This Question is unanswered, help us to find answer for this one

210. The command to remove rows from a table 'CUSTOMER' is:

UPDATE FROM CUSTOMER ...

DROP FROM CUSTOMER ...

REMOVE FROM CUSTOMER ...

DELETE FROM CUSTOMER WHERE ...

Answer

Correct Answer: DELETE FROM CUSTOMER WHERE ...

Note: This Question is unanswered, help us to find answer for this one

211. True or False: All SQL queries must contain a WHERE clause.

True.

False.

Answer

Correct Answer: False.

Note: This Question is unanswered, help us to find answer for this one

212. What keyword is used to check for no value?

EMPTY

NONE

NULL

VOID

Answer

Correct Answer: NULL

Note: This Question is unanswered, help us to find answer for this one

213. When sorting by multiple columns, which character is used to separate column names?

semicolon (;)

dash (-)

backslash (\)

coma (,)

Answer

Correct Answer: coma (,)

Note: This Question is unanswered, help us to find answer for this one

214. Which of the following is NOT a valid aggregate function?

Avg()

Max()

Round()

Sum()

Min()

Answer

Correct Answer: Round()

Note: This Question is unanswered, help us to find answer for this one

215. Which keyword is used to retrieve only certain rows of data?

RECORD

WHERE

FILTER

ROWS

Answer

Correct Answer: WHERE

Note: This Question is unanswered, help us to find answer for this one

216. Which keyword is used to assign an alias?

ALIAS

RENAME

ASSIGN

Answer

Correct Answer: AS

Note: This Question is unanswered, help us to find answer for this one

217. What function returns the lowest value in a column?

LOWEST()

MIN()

LOW()

SMALLEST()

Answer

Correct Answer: MIN()

Note: This Question is unanswered, help us to find answer for this one

218. The FROM keyword is used to identify which piece of information?

table name

database name

column name

row name

Answer

Correct Answer: table name

Note: This Question is unanswered, help us to find answer for this one

219. The 'JOIN' keyword is used to:

Join two tables in a query operation.

Join two databases in a query operation.

Join two databases together permanently.

Join two tables end-to-end permanently.

Answer

Correct Answer: Join two tables in a query operation.

Note: This Question is unanswered, help us to find answer for this one

220. What is another name for a table row?

record

query

data

view

Answer

Correct Answer: record

Note: This Question is unanswered, help us to find answer for this one

221. What is the definition of a foreign key?

A primary key with a null value.

A field in a relational table that matches the primary key column of another table.

The secondary primary key in a table.

A primary key in a relational table that has a non-numeric value.

Answer

Correct Answer: A field in a relational table that matches the primary key column of another table.

Note: This Question is unanswered, help us to find answer for this one

222. When accessing data from a table which keyword is used immediately before the table name? (Example: SELECT column_name _______ table_name;)

FROM

Answer

Correct Answer: FROM

Note: This Question is unanswered, help us to find answer for this one

223. What does the acronym SQL stand for?

Specified Query Language

Simple Query Language

Structured Query Language

Standard Query Language

Segmented Query Language

Answer

Correct Answer: Structured Query Language

Note: This Question is unanswered, help us to find answer for this one

224. You can add a row using SQL in a database with which of the following?

CREATE

MAKE

ADD

INSERT

Answer

Correct Answer: INSERT

Note: This Question is unanswered, help us to find answer for this one

225. Which aggregate function returns the total of the values in a column?

TOTAL()

ADD()

SUM()

ALL()

Answer

Correct Answer: SUM()

Note: This Question is unanswered, help us to find answer for this one

226. What function is used to remove padded spaces?

PAD()

RPAD()

TRIM()

LPAD()

Answer

Correct Answer: TRIM()

Note: This Question is unanswered, help us to find answer for this one

227. What is the difference between DROP and DELETE.

DELETE removes a row in the table and DROP removes the entire table.

Both delete an entire table.

Both delete a specified row in a table.

DELETE removes an entire table and DROP removes all the rows in the table.

Answer

Correct Answer: DELETE removes a row in the table and DROP removes the entire table.

Note: This Question is unanswered, help us to find answer for this one

228. Which of the following statements can be used to undo a transaction?

UNDO

RESET

REDO

ROLLBACK

Answer

Correct Answer: ROLLBACK

Note: This Question is unanswered, help us to find answer for this one

229. What is one objective of database normalization?

using norm-based ASCII

defining indexes

using multiple tables

reducing redundancy

Answer

Correct Answer: reducing redundancy

Note: This Question is unanswered, help us to find answer for this one

230. =, <>, >, <, >=, <=, BETWEEN, LIKE, and IN are referred to as _____

variables

filters

parameters

operators

Answer

Correct Answer: operators

Note: This Question is unanswered, help us to find answer for this one

231. What does RDBMS mean?

Relational Database Manager System

Rational Database Manager System

Ratio Database Management System

Rational Database Management System

Relational Database Management System

Answer

Correct Answer: Relational Database Management System

Note: This Question is unanswered, help us to find answer for this one

232. Which SQL function or feature returns a single value, calculated from values in a column?

consolidation function

collapse query

aggregate function

bundle feature

Answer

Correct Answer: aggregate function

Note: This Question is unanswered, help us to find answer for this one

233. What is the difference with using IN or equal(=) operator to filter records?

IN operator does not work with subqueries

IN operator filters based on a single value whereas the equal(=) operator may filter on multiple values

The equal(=) operator works with only subqueries

Equal(=) operator filters based on a single value whereas the IN operator may filter on multiple values

Answer

Correct Answer: Equal(=) operator filters based on a single value whereas the IN operator may filter on multiple values

Note: This Question is unanswered, help us to find answer for this one

234. Which keyword is used to sort retrieved data in reverse order?

UPSIDEDOWN

DESC

BACKWARDS

REVERSE

Answer

Correct Answer: DESC

Note: This Question is unanswered, help us to find answer for this one

235. A primary key made up of more than one column is referred to as what kind of key?

spare key

monk key

artificial key

composite key

dynamic key

Answer

Correct Answer: composite key

Note: This Question is unanswered, help us to find answer for this one

236. Which of the following is the correct syntax to update a table?

UPDATE "table name" SET "column name" = <value> WHERE <constraint>;

UPDATE "table name" AND SET "column name" = <value> WHERE <constraint>;

UPDATE "table name" WHERE <constraint> SET "column name" = <value>;

SET "column name" = <value> WHERE <constraint> UPDATE "table name";

Answer

Correct Answer: UPDATE "table name" SET "column name" = <value> WHERE <constraint>;

Note: This Question is unanswered, help us to find answer for this one

237. If tableA is CROSS JOINED to tableB, tableA has 10 rows and tableB has 5 rows, what is the greatest possible size of the result set?

Answer

Correct Answer: 50

Note: This Question is unanswered, help us to find answer for this one

238. What is one of the purposes of normalization?

Eliminate rows

Add primary keys

Eliminate redundancy

Join tables

Fix tables

Answer

Correct Answer: Eliminate redundancy

Note: This Question is unanswered, help us to find answer for this one

239. Which of the following is NOT a language element of SQL?

Expression

Data mining

Clause

Statement

Query

Answer

Correct Answer: Data mining

Note: This Question is unanswered, help us to find answer for this one

240. In SQL what is the meaning of NULL?

no value

Empty string

Answer

Correct Answer: no value

Note: This Question is unanswered, help us to find answer for this one

241. What function calculates a column's average value?

MEAN()

MEDIAN()

AVERAGE()

AVG()

Answer

Correct Answer: AVG()

Note: This Question is unanswered, help us to find answer for this one

242. What term is used to describe the "layout" of a database or the blueprint that outlines the way data is organized into tables?

schema

view

query

program

Answer

Correct Answer: schema

Note: This Question is unanswered, help us to find answer for this one

243. What keyword is used in conjunction with the WHERE clause when creating a subquery?

EMBED

QUERY

SUB

Answer

Correct Answer: IN

Note: This Question is unanswered, help us to find answer for this one

244. What syntax would you use to write a query to select all teams that won either 2, 4, 6 or 8 games?

SELECT team_name FROM teams WHERE team_won LIKE (2, 4, 6, 8)

SELECT team_name FROM teams WHERE team_won MAP (2, 4, 6, 8)

SELECT team_name FROM teams WHERE team_won ON (2, 4, 6, 8)

SELECT team_name FROM teams WHERE team_won IN (2, 4, 6, 8)

Answer

Correct Answer: SELECT team_name FROM teams WHERE team_won IN (2, 4, 6, 8)

Note: This Question is unanswered, help us to find answer for this one

245. How many primary keys can a table have?

at least one, but not more than two

tables cannot have primary keys

between one and five

one

no limit

Answer

Correct Answer: one

Note: This Question is unanswered, help us to find answer for this one

246. What is the name for a query embedded inside another query?

inner join

cartesian join

embedded query

subquery

Answer

Correct Answer: subquery

Note: This Question is unanswered, help us to find answer for this one

247. What is the name of a mechanism used to associate tables within a SELECT statement?

link

join

connection

association

Answer

Correct Answer: join

Note: This Question is unanswered, help us to find answer for this one

248. What keyword is used with aggregate functions to include only unique values in the calculation?

UNIQUE

DISTINCT

SINGLE

NO_DUPLICATES

Answer

Correct Answer: DISTINCT

Note: This Question is unanswered, help us to find answer for this one

249. An asterisk after SELECT can be used to return all ________ of a table.

primary keys

row IDs

null values

foreign keys

columns

Answer

Correct Answer: columns

Note: This Question is unanswered, help us to find answer for this one

250. Which keyword is used more than once in a SQL statement that contains a subquery?

ORDER BY

SELECT

GROUP BY

DISTINCT

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

251. Which of the following names is NOT a SQL based RDBMS?

SQL Server

MySQL

SQLite

MongoDB

Oracle

Answer

Correct Answer: MongoDB

Note: This Question is unanswered, help us to find answer for this one

252. What is the correct syntax to concatenate the contents of one column (col1) to the contents of another column (col2) in a query?

join(col1, col2)

concat(col1, col2)

sql_concat(col1, col2)

col1 + col2

concatenate(col1, col2)

Answer

Correct Answer: concat(col1, col2)

Note: This Question is unanswered, help us to find answer for this one

253. What keyword is used to create a table alias?

NEW_TABLE

ALIAS

NICKNAME

Answer

Correct Answer: AS

Note: This Question is unanswered, help us to find answer for this one

254. The HAVING clause is used in conjunction with (and immediately after) what other clause?

FROM

SELECT

GROUP BY

WHERE

Answer

Correct Answer: GROUP BY

Note: This Question is unanswered, help us to find answer for this one

255. Which of the following are type(s) of DML Triggers?

Instead of Trigger: Instead of Triggers are fired in place of the triggering action such as an insert, update, or delete.

All of these

After Trigger: After triggers execute following the triggering action, such as an insert, update, or delete.

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

256. Which symbol can be used to indicate a "wild card" to substitute for one or more characters when searching for string in a database?

Answer

Correct Answer: %

Note: This Question is unanswered, help us to find answer for this one

257. What happens if you omit the WHERE clause in a SQL DELETE query?

All tables will be deleted.

The entire database will be deleted.

All records will be deleted.

An error message will appear.

Answer

Correct Answer: All records will be deleted.

Note: This Question is unanswered, help us to find answer for this one

258. What keyword is used to check for a range of values?

CONTAINS

BETWEEN

RANGE

WITHIN`

Answer

Correct Answer: BETWEEN

Note: This Question is unanswered, help us to find answer for this one

259. What clause is used to sort data and group it?

GROUP

SORT

SORT BY

GROUP BY

Answer

Correct Answer: GROUP BY

Note: This Question is unanswered, help us to find answer for this one

260. True or False? This query is valid the way it is structured. SELECT * FROM Prospects WHERE assignment_type <> 'Team' AND criteria is not null

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

261. The HAVING clause can be used for what purpose?

To be used for filtering based on the outcome of non-aggregate functions.

To verify that at database connection is available.

To validate a constraint.

To be used for filtering based on the outcome of aggregate functions.

Answer

Correct Answer: To be used for filtering based on the outcome of aggregate functions.

Note: This Question is unanswered, help us to find answer for this one

262. What is the term for a set of data elements (values) organized using rows and columns?

index

query

program

table

Answer

Correct Answer: table

Note: This Question is unanswered, help us to find answer for this one

263. What is the term for a column (or set of columns) whose values uniquely identify every row in a table?

unique identifier

primary key

secondary key

foreign key

Answer

Correct Answer: primary key

Note: This Question is unanswered, help us to find answer for this one

264. What character is used to connect a table name with a column name to create a fully qualified column name?

dot (.)

dash (-)

plus (+)

underscore (_)

Answer

Correct Answer: dot (.)

Note: This Question is unanswered, help us to find answer for this one

265. The DDL term "DROP" does what?

Modifies the structure of an existing object in various ways.

Moves data from one table down to the next.

Deletes all data from a table in a very fast way, deleting the data inside the table and not the table itself.

Eliminates errors from the current table.

Deletes a database, table, index or column.

Answer

Correct Answer: Deletes a database, table, index or column.

Note: This Question is unanswered, help us to find answer for this one

266. SELECT * FROM tablea, tableb WHERE tablea.DepartmentID = tableb.DepartmentID; Which of these keywords will have the same effect as the above query?

Cross Join

Full Outer Join

Right Outer Join

Left Outer Join

Inner Join

Answer

Correct Answer: Inner Join

Note: This Question is unanswered, help us to find answer for this one

267. Which statement can be used to repeat the execution of a code block as long as a specified condition returns TRUE?

SIGNAL statement

SELECT statement

WHILE statement

GOTO statement

SUBQUERY statement

Answer

Correct Answer: WHILE statement

Note: This Question is unanswered, help us to find answer for this one

268. How do you select a column named "FirstName" from a table named "Persons"?

SELECT FirstName FROM Persons;

SELECT * FROM Persons where FirstName = Persons;

SELECT * FROM Persons where Persons = FirstName;

SELECT First_Name FROM Persons;

Answer

Correct Answer: SELECT FirstName FROM Persons;

Note: This Question is unanswered, help us to find answer for this one

269. Which will select the `name` of 'John' from the 'Person' table where `num_friends` is greater than 1?

SELECT * FROM Person WHERE num_friends MORE THAN 1 AND name = 'John'

SELECT "John" as 'name' FROM `Person` WHERE `num_friends` > 1

SELECT name FROM Person WHERE num_friends > 1 AND name = 'John'

SELECT CONCAT(firstname, lastname) FROM Person WHERE num_friends > 1 AND name = "John"

Answer

Correct Answer: SELECT name FROM Person WHERE num_friends > 1 AND name = 'John'

Note: This Question is unanswered, help us to find answer for this one

270. Which of the following is NOT true about a primary key constraints?

The value of a primary key constraint uniquely identifies each record in a table.

Primary keys must contain unique values.

A primary key column cannot contain NULL values.

For every primary key there must be a foreign key.

Answer

Correct Answer: For every primary key there must be a foreign key.

Note: This Question is unanswered, help us to find answer for this one

271. What data is this statement trying to query from the Customers Table? SELECT * FROM Customers WHERE City LIKE '[!bsp]%'

Customers in cities containing any combination of the letters "b" and "s" and "p."

Customers in cities starting with "bsp."

Customers in cities ending with "b" or "s" or "p."

Customers in cities starting with "b" or "s" or "p."

Customers in cities NOT starting with "b" or "s" or "p."

Answer

Correct Answer: Customers in cities NOT starting with "b" or "s" or "p."

Note: This Question is unanswered, help us to find answer for this one

272. Which clause indicates the table(s) from which data is to be retrieved?

FROM

WHERE

HAVING

GROUP BY

SELECT

Answer

Correct Answer: FROM

Note: This Question is unanswered, help us to find answer for this one

273. Suppose table A has 5 rows and table B has 6 rows. You perform a cross join on these two tables. How many rows will it have?

Answer

Correct Answer: 30

Note: This Question is unanswered, help us to find answer for this one

274. What is the function that combines two strings and returns the combined string?

JOIN()

CONCAT()

COMBINE()

CONCATENATE()

GROUP()

Answer

Correct Answer: CONCAT()

Note: This Question is unanswered, help us to find answer for this one

275. Which of these is NOT a valid data type for a character string?

CHAR

TEXTCHAR

NVARCHAR

NCHAR

VARCHAR

Answer

Correct Answer: TEXTCHAR

Note: This Question is unanswered, help us to find answer for this one

276. What KEYWORD is used to filter groups?

HAVING

SORT

GROUPS

MINIMIZE

FILTER

Answer

Correct Answer: HAVING

Note: This Question is unanswered, help us to find answer for this one

277. What is the default join type if omitted?

OUTER

FULL

INNER

FADE

CROSS

Answer

Correct Answer: INNER

Note: This Question is unanswered, help us to find answer for this one

278. Which statement removes all rows from the "orders" table without removing the table structure?

DROP TABLE orders

SANITIZE orders

TRUNCATE orders

REMOVE ROWS FROM orders

Answer

Correct Answer: TRUNCATE orders

Note: This Question is unanswered, help us to find answer for this one

279. Which of the following query will return PERSON first_name from table PERSON with last_name field null?

SELECT first_name FROM PERSON WHERE last_name = NULL

SELECT first_name FROM PERSON WHERE EXISTS NULL last_name

SELECT first_name FROM PERSON WHERE last_name IS NULL

SELECT first_name FROM PERSON WHERE last_name AS NULL

Answer

Correct Answer: SELECT first_name FROM PERSON WHERE last_name IS NULL

Note: This Question is unanswered, help us to find answer for this one

280. What is PL/SQL?

It is a proprietary version of SQL used by Oracle

It is a proprietary version of SQL developed by MySQL

It is a proprietary version of SQL developed for Visual Studio

It is a proprietary version of SQL developed by Microsoft

An open source version of SQL

Answer

Correct Answer: It is a proprietary version of SQL used by Oracle

Note: This Question is unanswered, help us to find answer for this one

281. This example illustrates use of the FULL JOIN action. Which clauses must fill the three blanks for the query to be valid? _______ e1."Event_Name", v2."Venue" FROM "events" e1 _ "venues" v2 ON (e1."VenueNo" = v2."VenueNo") _ e1."Event_Name" ASC, v2."Venue" ASC

GROUP BY, FULL OUTER JOIN, ORDER BY

HAVING, WHERE, ORDER BY

WHERE, FULL OUTER JOIN, HAVING

SELECT, OUTER JOIN, GROUP BY

SELECT, FULL OUTER JOIN, ORDER BY

Answer

Correct Answer: SELECT, FULL OUTER JOIN, ORDER BY

Note: This Question is unanswered, help us to find answer for this one

282. What is the result of "select * from table where 1"

Return the first row from table

Return all the rows from table

Answer

Correct Answer: Return all the rows from table

Note: This Question is unanswered, help us to find answer for this one

283. Choose correct clause: SELECT CountryCode, COUNT() FROM City GROUP BY CountryCode _____ COUNT() > 20;

HAVING

ORDER BY

LIMIT

WHERE

SELECT

Answer

Correct Answer: HAVING

Note: This Question is unanswered, help us to find answer for this one

284. Which does not describe a database element?

organic list

index

stored procedure

table schema

tuple

Answer

Correct Answer: organic list

Note: This Question is unanswered, help us to find answer for this one

285. Indexes can be created on existing tables so that information can be retrieved more quickly. Specifically, what are indexes created on?

null values

columns

rows

duplicate values

Answer

Correct Answer: columns

Note: This Question is unanswered, help us to find answer for this one

286. What keyword is used with aggregate functions to include every value in the calculation?

TOTAL

DUPLICATES_ALLOWED

EVERY

ALL

Answer

Correct Answer: ALL

Note: This Question is unanswered, help us to find answer for this one

287. The UNION ALL operator performs which of the following actions?

Returns the output from the query before and the query after the operator excluding duplicates.

Returns the output from the query before and the query after the operator including duplicates.

Concatenates all of the columns in the table specified with an optional user defined delimiter between.

Joins all of the tables that have a primary or foreign key relationship to the specified table.

Answer

Correct Answer: Returns the output from the query before and the query after the operator including duplicates.

Note: This Question is unanswered, help us to find answer for this one

288. Which of the following is NOT an explicit data type reference?

null

float

smallint

integer

character

Answer

Correct Answer: null

Note: This Question is unanswered, help us to find answer for this one

289. UNION ALL is different from a UNION command in that...

UNION ALL is an invalid command

UNION ALL will only select distinct values

UNION ALL will not eliminate duplicate rows

UNION ALL will include null values

Answer

Correct Answer: UNION ALL will not eliminate duplicate rows

Note: This Question is unanswered, help us to find answer for this one

290. What is the name of a result that returns all the rows in all the tables listed in the query?

Cartesian product

primary key

table constraint

mega join

null value

Answer

Correct Answer: Cartesian product

Note: This Question is unanswered, help us to find answer for this one

291. Which wildcard character means "match any number of occurrences of any character"?

percent (%)

at (@)

ampersand (&)

asterisk (*)

Answer

Correct Answer: percent (%)

Note: This Question is unanswered, help us to find answer for this one

292. What records would the result set of this query include? SELECT * FROM tableA LEFT OUTER JOIN tableB ON tableA.key = tableB.key

0 or more records from tableA; all records from tableB

All records from tableA; all records from tableB

All records from tableA; 0 or more records from tableB

Only records where key is in both tableA and tableB

Answer

Correct Answer: All records from tableA; 0 or more records from tableB

Note: This Question is unanswered, help us to find answer for this one

293. What is the correct procedure to create and use a cursor?

Declare cursor > Open cursor > Fetch row from the cursor > Process fetched row > Close cursor > Deallocate cursor

Declare cursor > Open cursor > Fetch row from the cursor > Process fetched row > Deallocate cursor > Close cursor

Open cursor > Fetch row from the cursor > Process fetched row > Close cursor > Deallocate cursor

Open cursor > Fetch row from the cursor > Process fetched row > Deallocate cursor > Close cursor

Answer

Correct Answer: Declare cursor > Open cursor > Fetch row from the cursor > Process fetched row > Close cursor > Deallocate cursor

Note: This Question is unanswered, help us to find answer for this one

294. What is the proper syntax of the keyword LIMIT to display 5 results after starting at record 4?

LIMIT 4, 5

LIMIT 0, 4

LIMIT 5, 4

LIMIT 0, 5

Answer

Correct Answer: LIMIT 4, 5

Note: This Question is unanswered, help us to find answer for this one

295. Which is the correct order for a proper SQL query?

SELECT, FROM, WHERE, HAVING, ORDER BY, GROUP BY

SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY

SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING

SELECT, FROM, GROUP BY, HAVING, ORDER BY, WHERE

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Answer

Correct Answer: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Note: This Question is unanswered, help us to find answer for this one

296. What is the first query to run in a statement that contains subqueries?

outermost

last

innermost

first

Answer

Correct Answer: innermost

Note: This Question is unanswered, help us to find answer for this one

297. If a foreign key constraint is violated, the default action taken by the DBMS is what?

It is not possible to violate a foreign key constraint. The modification is rejected

The DBMS throw an error but implements the violated changes

The value is cascaded

The value is set to NULL

Answer

Correct Answer: It is not possible to violate a foreign key constraint. The modification is rejected

Note: This Question is unanswered, help us to find answer for this one

298. Where is the GROUP BY clause placed in the sequence of statements?

before FROM

before ORDER BY

before SELECT

before WHERE

Answer

Correct Answer: before ORDER BY

Note: This Question is unanswered, help us to find answer for this one

299. What is the name of the category of functions used to summarize data?

grouping

primary

summary

aggregate

Answer

Correct Answer: aggregate

Note: This Question is unanswered, help us to find answer for this one

300. What is the typical filename extension of a SQL file?

.dataquery

.sql

.sequel

.query

Answer

Correct Answer: .sql

Note: This Question is unanswered, help us to find answer for this one

SQL MCQs | Topic-wise

MCQ on Basic SQL

General SQL MCQs

SQL Subjects

More Resources

SQL MCQ

SQL Skill Assessment

SQL PDF

Related MCQs

Swift MCQs

Symfony2 MCQs

System Analysis MCQs

System Programming MCQs

TCP/IP MCQs