Question 1

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

Accepted Answer

A) True 
 B)False

Question 2

In SQL, all _____ expressions evaluate to true or false.

Accepted Answer

The answer of In SQL, all _____ expressions evaluate to...

Question 3

All SQL commands must be issued on a single line.

Accepted Answer

A) True 
 B)False

Question 4

"_____" means that the names of the relation attributes must be the same and their data types must be alike.

Accepted Answer

The answer of "_____" means that the names of the...

Question 5

A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.

Accepted Answer

The answer of A specialty field in mathematics, known as...

Question 6

The _____ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

Accepted Answer

The answer of The _____ command, coupled with appropriate search...

Question 7

_____ is a relational set operator.

Accepted Answer

A)  EXCEPT 
B)  PLUS 
C)  ALL 
D)  EXISTS 
A)  EXCEPT 
B)  PLUS 
C)  ALL 
D)  EXISTS

Question 8

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

Accepted Answer

A)  outer 
B)  inner 
C)  equi- 
D)  cross 
A)  outer 
B)  inner 
C)  equi- 
D)  cross

Question 9

Which comparison operator indicates a value isnot equal?

Accepted Answer

A)  = 
D)   
A)  = 
D)

Question 10

The syntax for a left outer join is _____.

Accepted Answer

A)  SELECT     column-list
FROM        table1 OUTER JOIN table2 LEFT
WHERE     join-condition 
B)  SELECT     column-list
FROM table1 LEFT [OUTER] JOIN table2
ON join-condition 
C)  SELECT     column-list
WHERE     LEFT table1 = table 
D)  SELECT    column-list
FROM       table1 LEFT table2 [JOIN]
WHERE     join-condition 
A)  SELECT     column-list
FROM        table1 OUTER JOIN table2 LEFT
WHERE     join-condition 
B)  SELECT     column-list
FROM table1 LEFT [OUTER] JOIN table2
ON join-condition 
C)  SELECT     column-list
WHERE     LEFT table1 = table 
D)  SELECT    column-list
FROM       table1 LEFT table2 [JOIN]
WHERE     join-condition

Question 11

Which is a feature of a correlated subquery?

Accepted Answer

A)  The inner subquery executes first. 
B)  The outer subquery initiates the process of execution in a subquery. 
C)  The inner subquery initiates the process of execution in a subquery. 
D)  The outer subquery executes independent of the inner subquery. 
A)  The inner subquery executes first. 
B)  The outer subquery initiates the process of execution in a subquery. 
C)  The inner subquery initiates the process of execution in a subquery. 
D)  The outer subquery executes independent of the inner subquery.

Question 12

The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

Accepted Answer

A)  NVL 
B)  TO_CHAR 
C)  DECODE 
D)  CONVERT 
A)  NVL 
B)  TO_CHAR 
C)  DECODE 
D)  CONVERT

Question 13

Comparison operators cannot be used to place restrictions on character-based attributes.

Accepted Answer

A) True 
 B)False

Question 14

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Accepted Answer

The LIKE special operator is used in con

Question 15

What is a subquery? What is always executed first?

Accepted Answer

A subquery, also known as a ne

Question 16

The basic SQL vocabulary has fewer than _____words.

Accepted Answer

100
one hu

Question 17

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.

Accepted Answer

A)  MON 
B)  MM3 
C)  MONTH 
D)  MM 
A)  MON 
B)  MM3 
C)  MONTH 
D)  MM

Question 18

The ANSI SQL standards are also accepted by the ISO.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)  outer 
B)  left 
C)  inner 
D)  base 
A)  outer 
B)  left 
C)  inner 
D)  base

Question 20

DATE() and SYSDATE are special functions that return today's date in MS Access and _____, respectively.

Accepted Answer

The answer of DATE() and SYSDATE are special functions that...

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

In SQL, all _____ expressions evaluate to true or false.

All SQL commands must be issued on a single line.

"_____" means that the names of the relation attributes must be the same and their data types must be alike.

A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.

The _____ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

_____ is a relational set operator.

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

Which comparison operator indicates a value isnot equal?

The syntax for a left outer join is _____.

Which is a feature of a correlated subquery?

The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

Comparison operators cannot be used to place restrictions on character-based attributes.

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

What is a subquery? What is always executed first?

The basic SQL vocabulary has fewer than _____words.

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.

The ANSI SQL standards are also accepted by the ISO.

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

DATE() and SYSDATE are special functions that return today's date in MS Access and _____, respectively.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data and Nosql

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 7: Introduction to Structured Query Language Sql

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

In SQL, all _____ expressions evaluate to true or false.

All SQL commands must be issued on a single line.

"_____" means that the names of the relation attributes must be the same and their data types must be alike.

A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.

The _____ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

_____ is a relational set operator.

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

Which comparison operator indicates a value isnot equal?

The syntax for a left outer join is _____.

Which is a feature of a correlated subquery?

The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

Comparison operators cannot be used to place restrictions on character-based attributes.

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

What is a subquery? What is always executed first?

The basic SQL vocabulary has fewer than _____words.

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.

The ANSI SQL standards are also accepted by the ISO.

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

DATE() and SYSDATE are special functions that return today's date in MS Access and _____, respectively.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data and Nosql

Database Connectivity and Web Technologies

Database Administration and Security

Filters