Question 1

Oracle users can use the Access QBE (query by example) query generator.

Accepted Answer

A) True 
 B)False

Question 2

A(n) _____ character is a symbol that can be used as a general substitute for other characters or commands.

Accepted Answer

The answer of A(n) _____ character is a symbol that...

Question 3

The _____ command defines a default value for a column when no value is given.

Accepted Answer

A)  CHECK 
B)  UNIQUE 
C)  NOT NULL 
D)  DEFAULT 
A)  CHECK 
B)  UNIQUE 
C)  NOT NULL 
D)  DEFAULT

Question 4

The _____ operator could be used in place of EXCEPT (MINUS) if the DBMS does not support it.

Accepted Answer

The answer of The _____ operator could be used in...

Question 5

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

Accepted Answer

A)  CONVERT() 
B)  TO_DATE 
C)  TO_CHAR() 
D)  TO_STRING() 
A)  CONVERT() 
B)  TO_DATE 
C)  TO_CHAR() 
D)  TO_STRING()

Question 6

The conditional LIKE must be used in conjunction with wildcard characters.

Accepted Answer

A) True 
 B)False

Question 7

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

Accepted Answer

A) True 
 B)False

Question 8

A(n) _____, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

Accepted Answer

The answer of A(n) _____, also known as a nested...

Question 9

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Accepted Answer

A)  8 
B)  18 
C)  26 
D)  144 
A)  8 
B)  18 
C)  26 
D)  144

Question 10

Most SQL implementations yield case-insensitive searches.

Accepted Answer

A) True 
 B)False

Question 11

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

Accepted Answer

A)  INSERT 
B)  SELECT 
C)  COMMIT 
D)  UPDATE 
A)  INSERT 
B)  SELECT 
C)  COMMIT 
D)  UPDATE

Question 12

Rows can be grouped into smaller collections quickly and easily using the _____ clause within the SELECT statement.

Accepted Answer

The answer of Rows can be grouped into smaller collections...

Question 13

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

Accepted Answer

A)  SELECT ONLY V_CODE
FROM PRODUCT; 
B)  SELECT UNIQUE V_CODE
FROM PRODUCT; 
C)  SELECT DIFFERENT V_CODE
FROM PRODUCT; 
D)  SELECT DISTINCT V_CODE
FROM PRODUCT; 
A)  SELECT ONLY V_CODE
FROM PRODUCT; 
B)  SELECT UNIQUE V_CODE
FROM PRODUCT; 
C)  SELECT DIFFERENT V_CODE
FROM PRODUCT; 
D)  SELECT DISTINCT V_CODE
FROM PRODUCT;

Question 14

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

Accepted Answer

A)  OF 
B)  USING 
C)  HAS 
D)  JOIN ON 
A)  OF 
B)  USING 
C)  HAS 
D)  JOIN ON

Question 15

An alias cannot be used when a table is required to be joined to itself in a recursive query.

Accepted Answer

A) True 
 B)False

Oracle users can use the Access QBE (query by example) query generator.

A(n) _____ character is a symbol that can be used as a general substitute for other characters or commands.

The _____ command defines a default value for a column when no value is given.

The _____ operator could be used in place of EXCEPT (MINUS) if the DBMS does not support it.

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

The conditional LIKE must be used in conjunction with wildcard characters.

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

A(n) _____, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Most SQL implementations yield case-insensitive searches.

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

Rows can be grouped into smaller collections quickly and easily using the _____ clause within the SELECT statement.

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

An alias cannot be used when a table is required to be joined to itself in a recursive query.

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

Oracle users can use the Access QBE (query by example) query generator.

A(n) _____ character is a symbol that can be used as a general substitute for other characters or commands.

The _____ command defines a default value for a column when no value is given.

The _____ operator could be used in place of EXCEPT (MINUS) if the DBMS does not support it.

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

The conditional LIKE must be used in conjunction with wildcard characters.

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

A(n) _____, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Most SQL implementations yield case-insensitive searches.

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

Rows can be grouped into smaller collections quickly and easily using the _____ clause within the SELECT statement.

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

An alias cannot be used when a table is required to be joined to itself in a recursive query.

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