Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

70-761 > Introduction > Flashcards

Introduction Flashcards

1
Q

What does SQL stand for?

A

Structured Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

what does SSMS stand for

A

SQL server management studio

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

In order from first to last, what is the order of the main SQL query clauses as keyed-in?

A 
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

In order from first to last, what are the phases of logical query processing?

A 
FROM
WHERE
GROUP BY
HAVING
SELECT
ORDER BY
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

The JOIN clause is part of which main phase?

A

FROM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does RDBMS stand for?

A

relational database management system, This is the basis for SQL and all modern databases. The data in an RDBMS is stored in tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a column?

A

a vertical entity in a table that contains data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a table?

A

a table is a collection of related data entries stored within a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a record/row?

A

a record/row is an individual entry that exists in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a result set?

A

the results returned from a SELECT query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

what are syntax?

A

the structure of statements in a computer language, Eg SELECT or FROM.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

what does .dbo stand for?

A

Database order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which SQL statement is used to extract data from a database

A

SELECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which SQL statement is used to update data in a database?

A

UPDATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which SQL statement is used to delete data from a database?

A

DELETE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which SQL statement is used to insert new data in a database?

A

INSERT INTO

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

A

True

18
Q

Which SQL statement is used to return only different values?

A

SELECT DISTINCT

19
Q

Which SQL keyword is used to sort the result-set?

A

ORDER BY

20
Q

What is the most common type of join?

A

INNER JOIN

21
Q

Which operator is used to select values within a range?

A

BETWEEN

22
Q

The NOT NULL constraint enforces a column to not accept empty values.

A

True

23
Q

Which operator is used to search for a specified pattern in a column?

A

LIKE

24
Q

A table can have more than one primary key, True or false?

A

FALSE

25
Q

What is the integrity constraint as a rule?

A

every table must have a primary key and that the column(s) chosen to be the primary key should be unique and not NULL

26
Q

Which of the statements are true about primary key ?

  1. Most uniquely identify the row
  2. Cannot have NULL values
  3. Should not change over time
  4. All the above
A
  1. All of the above
27
Q

An alternative name that you assign to the table in the query’s FROM clause

  1. Query
  2. Table Alias
  3. Single-row Functions
A
  1. Table Alias
28
Q

Built-in functions that return a single result for each row of data retrieved

  1. Single-row functions
  2. Search condition
  3. Table alias
A
  1. Single-row functions
29
Q

Removes all of a table’s data without saving any rollback information

  1. Roll back
  2. Truncate
  3. Single-row functions
A
  1. Truncate
30
Q

A query that joins a table to itself

  1. outer join
  2. Self-join
  3. inner join
A
  1. self-join
31
Q

Contains current date and time

  1. single-row functions
  2. savepoint
  3. SYSDATE pseudocolumn
A
  1. SYSDATE pseudocolumn
32
Q

A series of action queries that represent a logical unit of work

  1. Query
  2. Single Row function
  3. Transaction
A
  1. Transaction
33
Q

Combines multiple search conditions using the AND, OR, and NOT logical operators

  1. Nested query
  2. Complex search condition
  3. Group function
A
  1. Complex search condition
34
Q

A main query and one or more subqueries

  1. Pseudocolumn
  2. Nested query
  3. Nested subquery
A
  1. Nested query
35
Q

A bookmark that designates the beginning of an individual section of a transaction

  1. Search condition
  2. truncate
  3. savepoint
A
  1. savepoint
36
Q

A structure that contains information identifying the LOB data type and points to the alternate memory location

  1. Pagesize
  2. Linesize
  3. LOB locator
A
  1. LOB locator
37
Q

A DML command that allows database users to view database data

  1. Pseudocolumn
  2. Transaction
  3. Query
A
  1. Query
38
Q

A DML command that inserts, updates, or deletes database data

  1. Alias
  2. Inner Join
  3. Action query
A
  1. Action query
39
Q

An alternative name for a query column

  1. Alias
  2. Action query
  3. LOB locator
A
  1. Alias
40
Q

Acts like a column in a database table, but is actually a command that returns a specific value

  1. table alias
  2. search condition
  3. Pseudocolumn
A
  1. Pseudocolumn
41
Q

An expression that seeks to match specific table records

  1. LOB locator
  2. search condition
  3. nested query
A
  1. search condition

70-761 (12 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions