C170 - Practice Test

Question

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe?

Answer 1

One-to-one

Answer 2

One-to-many

Answer 3

Many-to-many

Answer 4

One-to-one binary

Answer 5

One-to-one binary

Answer 6

One-to-one unary

Answer 7

Many-to-many binary

Answer 8

Many-to-many unary

Answer 9

Unary one-to-one

Answer 10

Unary many-to-many

Answer 11

Binary one-to-one

Answer 12

Binary many-to-many

Answer 13

Ternary one-to-one

Answer 14

Ternary many-to-many

Answer 15

No books are written by an author.

Answer 16

At least one book was written by an author.

Answer 17

One book was written by more than one author.

Answer 18

Only one book was written by one author.

Answer 19

A person attending a meeting

Answer 20

An employee number

Answer 21

A sales meeting

Answer 22

A meeting code

Answer 23

Set-to-Null

Answer 24

The delete is prohibited.

Answer 25

The delete occurs immediately.

Answer 26

A new salesperson is assigned instead.

Answer 27

The lack of a salesperson is flagged for later.

Answer 28

expiration

Answer 29

Move the data from the third column into the first column.

Answer 30

Move the data from the third column into its own table.

Answer 31

Move the data from the first two columns into separate tables.

Answer 32

Move the data from the second column into the third column.

Answer 33

First normal form

Answer 34

Second normal form

Answer 35

Third normal form

Answer 36

Fourth normal form

Answer 37

It is undefined.

Answer 38

It is linked through the office ID.

Answer 39

It is linked through the salesperson ID.

Answer 40

It is indicated by the tables’ adjacency.

Answer 41

IF NOT EXISTS db_name ;

Answer 42

CREATE DATABASE IF NEW db_name ;

Answer 43

CREATE DATABASE IF NOT EXISTS db_name ;

Answer 44

IF NOT EXISTS CREATE DATABASE db_name ;

Answer 45

WHERE PRODCOST=20;

Answer 46

AND PRODCOST=20;

Answer 47

WHERE PRODCOST>=20;

Answer 48

AND PRODCOST>=20;

Answer 49

The associative entity

Answer 50

The rows to be included

Answer 51

A table’s intersection data

Answer 52

A range of included columns

Answer 53

WHERE EMPNUM = 1000+;

Answer 54

WHERE EMPNUM > 1000;

Answer 55

WHERE EMPNUM => 1000;

Answer 56

WHERE EMPNUM >= 1000;

Answer 57

SUM PRODNUM;

Answer 58

COUNT PRODNUM;

Answer 59

ORDER BY PRODNUM;

Answer 60

GROUP BY PRODNUM;

Answer 61

It removes views.

Answer 62

It removes rows from a table.

Answer 63

It removes columns from a table.

Answer 64

It removes columns not named in the column list.

Answer 65

The VALUES list must contain a value for each non-null valued column in the table.

Answer 66

The VALUES list must contain a value for each row in the table.

Answer 67

The INSERT INTO portion of the statement must generate a LOAD DATA statement.

Answer 68

The INSERT INTO portion of the statement must refer to a sampdb database table.

Answer 69

TABLE CUSTOMER

Answer 70

CustomerID

Answer 71

INSERT TABLE … SELECT followed by INSERT INTO … LIKE :

Answer 72

CREATE TABLE … LIKE followed by INSERT INTO … SELECT :

Answer 73

CREATE TABLE … INTO followed by INSERT INTO:

Answer 74

INSERT TABLE … LIKE followed by SELECT:

Answer 75

Adding rows

Answer 76

Dropping indexes

Answer 77

Changing storage space

Answer 78

Changing column data types

Answer 79

TRUNCATE TABLE

Answer 80

DELETE TABLE

Answer 81

REMOVE TABLE

Answer 82

DROP TABLE

Answer 83

To add complexity to encryption techniques

Answer 84

To move complicated security routines to subqueries

Answer 85

To restrict access to persons retrieving and modifying sensitive information

Answer 86

To limit many-to-many relationships between various entities and attributes

Answer 87

The values created by the syntax INSERT INTO tbl_name VALUES(...),(...),... ;

Answer 88

The SELECT privilege for every column referred to elsewhere in the statement

Answer 89

A reciprocal level of privilege for every row selected by the SELECT statement

Answer 90

The level of privilege for every column that is part of the base table

Answer 91

VIEW viewprod:

Answer 92

ALTER viewprod AS

Answer 93

WHERE VIEW viewprod IS

Answer 94

CREATE VIEW viewprod AS

Answer 95

ALTER VIEW

Answer 96

CHANGE VIEW

Answer 97

MODIFY VIEW

Answer 98

UPDATE VIEW

Answer 99

The data is discarded.

Answer 100

The view is discarded.

Answer 101

The viewing of data is prohibited.

Answer 102

Unauthorized access to the view is restricted.

Answer 103

Foreign key constraint

Answer 104

Referential delete

Answer 105

Cascaded delete

Answer 106

Dynamic update

Answer 107

PRIMARY KEY = event_id);

Answer 108

PRIMARY KEY (event_id));

Answer 109

(PRIMARY KEY: event_id);

Answer 110

PRIMARY (event_id)'

Answer 111

The primary key value, in parentheses, can be used by a column.

Answer 112

The column, in parentheses, is the primary key for the table.

Answer 113

The foreign key, in parentheses, is linked to the primary key.

Answer 114

The row, in parentheses, can be inserted as the foreign key.

Answer 115

FOREIGN KEY ( customer_name ) REFERENCES table_name ( customer_name )

Answer 116

FOREIGN KEY = customer_name REFERENCES table_name ( customer_name )

Answer 117

FOREIGN KEY ( customer_name ) ( index_columns )

Answer 118

FOREIGN KEY [ table_name ] ( customer_name )

Answer 119

ALTER TABLE child ADD FOREIGN KEY (par_id) REFERENCES parent (par_id) ON DELETE CASCADE;

Answer 120

ALTER TABLE child ADD FOREIGN KEY (par_id) WHERE parent (par_id) ON DELETE CASCADE;

Answer 121

ALTER TABLE child ADD FOREIGN KEY WHERE parent (par_id) ON DELETE CASCADE;

Answer 122

ALTER TABLE child ADD FOREIGN KEY (par_id) ON DELETE CASCADE;

Answer 123

ALTER TABLE 'Salesperson' ADD INDEX 'city_index' (`city`)

Answer 124

CREATE UNIQUE INDEX city_index ON Salesperson (city);

Answer 125

CREATE INDEX city_index USING HASH ON Salesperson (city);

Answer 126

ALTER TABLE 'Salesperson' ADD UNIQUE INDEX 'city_index' (`city`)

Answer 127

Join catalog

Answer 128

Query catalog

Answer 129

Optimizer catalog

Answer 130

Relational catalog

Answer 131

INDEX index_rows (index_name)

Answer 132

INDEX index_name (index_rows)

Answer 133

INDEX index_columns (index_name)

Answer 134

INDEX index_name (index_columns)

Answer 135

ALTER INDEX IDX_NAME ON CUSTOMER(NAME, TELEPHONE);

Answer 136

MODIFY INDEX IDX_NAME BY CUSTOMER(NAME, TELEPHONE);

Answer 137

CHANGE INDEX IDX_NAME BY CUSTOMER(NAME, TELEPHONE);

Answer 138

REPLACE INDEX IDX_NAME ON CUSTOMER(NAME, TELEPHONE);

Answer 139

DROP INDEX PRIMARY KEY tbl_name;

Answer 140

DROP INDEX `PRIMARY` ON tbl_name ;

Answer 141

DROP INDEX `PRIMARY KEY` ON tbl_name;

Answer 142

DROP INDEX WHERE PRIMARY KEY = tbl_name ;

Answer 143

The default delete rule

Answer 144

The restrict delete rule

Answer 145

The cascade delete rule

Answer 146

The set-to-null delete rule

Answer 147

The default delete rule

Answer 148

The restrict delete rule

Answer 149

The cascade delete rule

Answer 150

The set-to-null delete rule

Answer 151

The data to be duplicated

Answer 152

The attributes that are changeable

Answer 153

The row values for two individual columns

Answer 154

The column values for two individual rows

Answer 155

Only the first row in the table is updated.

Answer 156

Every column in the table is updated.

Answer 157

Every row in the table is updated.

Answer 158

Returns an error.

Answer 159

Omitting the WHERE clause from a DELETE statement

Answer 160

Adding an ALL statement to a DELETE statement

Answer 161

Omitting the table name in a DELETE statement

Answer 162

Adding an asterisk to a DELETE statement

Answer 163

To retrieve data

Answer 164

To update data

Answer 165

To delete data

Answer 166

To index data

Answer 167

SELECT * FROM Owners;

Answer 168

SELECT ALL FROM Owners;

Answer 169

RETRIEVE COMPLETE FROM Owners;

Answer 170

RETRIEVE ALL COLUMNS FROM Owners;

Answer 171

SELECT COUNT(DISTINCT city) FROM recordcompany;

Answer 172

GROUP BY *(DISTINCT city) FROM recordcompany;

Answer 173

SELECT DISTINCT city FROM recordcompany;

Answer 174

GROUP BY(city) FROM recordcompany;

Answer 175

Sorting rows in ascending order

Answer 176

Sorting rows in descending order

Answer 177

Sorting columns in ascending order

Answer 178

Sorting columns in descending order

Answer 179

SELECT MOVIE, YEAR FROM MOVIE BY TITLE;

Answer 180

SELECT MOVIE, TOTAL FROM MOVIE BY TITLE;

Answer 181

SELECT MOVIE, TITLE FROM MOVIE BY MOVIE YEAR;

Answer 182

SELECT YEAR, TITLE FROM MOVIE GROUP BY YEAR;

Answer 183

Records are dropped from the results where a match is found between Table 1 and Table 2.

Answer 184

All Table 1 results are returned, regardless of whether a match is found in Table 2.

Answer 185

Results are only returned where a match is found between Table 1 and Table 2.

Answer 186

Table 1 results are prioritized where a match with Table 2 exists.

Answer 187

INNER JOIN

Answer 188

OUTER JOIN

Answer 189

It selects the rows in Table 1 numbered the same as Table 2.

Answer 190

It selects only the rows in Table 1 that are the same as Table 2.

Answer 191

It selects all of the rows in Table 1 and the matching rows in Table 2.

Answer 192

It selects the rows in both Tables that have numerical data that is left-aligned.

Answer 193

COUNT(*) counts every column selected, and COUNT(col_name) counts only columns with alphabetical names.

Answer 194

COUNT(*) counts every column selected, and COUNT(col_name) counts only non-null values.

Answer 195

COUNT(*) counts every row selected, and COUNT(col_name) counts only non-null values.

Answer 196

COUNT(*) counts every row selected, and COUNT(col_name) counts every column selected.

Answer 197

A row subquery returns a table with two rows in two columns.

Answer 198

A row subquery returns multiple rows of one or more values.

Answer 199

A row subquery returns a table with one row in one column.

Answer 200

A row subquery returns a single row of one or more values.

Answer 201

(FIND SPNUM

Answer 202

(SELECT SPNUM

Answer 203

(SUBQUERY SPNUM

	Creado por Craig Willey hace más de 5 años

Siguiente

C170 - Practice Test

Descripción

Resumen del Recurso

Pregunta 1

Pregunta 2

Pregunta 3

Pregunta 4

Pregunta 5

Pregunta 6

Pregunta 7

Pregunta 8

Pregunta 9

Pregunta 10

Pregunta 11

Pregunta 12

Pregunta 13

Pregunta 14

Pregunta 15

Pregunta 16

Pregunta 17

Pregunta 18

Pregunta 19

Pregunta 20

Pregunta 21

Pregunta 22

Pregunta 23

Pregunta 24

Pregunta 25

Pregunta 26

Pregunta 27

Pregunta 28

Pregunta 29

Pregunta 30

Pregunta 31

Pregunta 32

Pregunta 33

Pregunta 34

Pregunta 35

Pregunta 36

Pregunta 37

Pregunta 38

Pregunta 39

Pregunta 40

Pregunta 41

Pregunta 42

Pregunta 43

Pregunta 44

Pregunta 45

Pregunta 46

Pregunta 47

Pregunta 48

Pregunta 49

Pregunta 50

Pregunta 51

Pregunta 52

Pregunta 53

Pregunta 54

Pregunta 55

Pregunta 56

Pregunta 57

Pregunta 58

Similar