No Short Description Present
# | Quiz | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1
Discuss
|
SQL Syntax
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
Solution |
||||||||||||
2
Discuss
|
SQL Syntax
Updates that violate __________ are disallowed.
Solution |
||||||||||||
3
Discuss
|
SQL Syntax
What type of statement is this?
Solution |
||||||||||||
4
Discuss
|
SQL Syntax
This command performs which of the following action?
Solution |
||||||||||||
5
Discuss
|
SQL Syntax
To remove a relation from an SQL database, we use the ______ command.
Solution |
||||||||||||
6
Discuss
|
SQL Syntax
An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.
Solution |
||||||||||||
7
Discuss
|
SQL Syntax
The basic datatype char (n) is a _______ length character string and varchar (n) is _______ length character.
Solution |
||||||||||||
8
Discuss
|
SQL Syntax
What type of statement is this?
Solution |
||||||||||||
9
Discuss
|
SQL Syntax
What type of statement is this?
Solution |
||||||||||||
10
Discuss
|
SQL Syntax
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
Solution |
||||||||||||
11
Discuss
|
SQL Syntax
The database administrator who authorizes all the new users, modifies the database and takes grants privilege is
Solution |
||||||||||||
12
Discuss
|
SQL Syntax
Which of the following is used to provide privilege to only a particular attribute?
Solution |
||||||||||||
13
Discuss
|
SQL Syntax
Which of the following statement is used to remove the privilege from the user Amir?
Solution |
||||||||||||
14
Discuss
|
SQL Syntax
Which of the following is used to provide delete authorization to instructor?
Solution |
||||||||||||
15
Discuss
|
SQL Syntax
Which of the following is true regarding views?
Solution |
||||||||||||
16
Discuss
|
SQL Syntax
If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.
Solution |
||||||||||||
17
Discuss
|
SQL Syntax
In the authorization graph, if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct?
Solution |
||||||||||||
18
Discuss
|
SQL Syntax
Which of the following is used to avoid cascading of authorizations from the user?
Solution |
||||||||||||
19
Discuss
|
SQL Datatype
Which of the following statements creates a new table temp instructor that has the same schema as an instructor?
Solution |
||||||||||||
20
Discuss
|
SQL Datatype
In contemporary databases, the top level of the hierarchy consists of _______ each of which can contain ______
Solution |
||||||||||||
21
Discuss
|
SQL Datatype
Which of the following closely resembles Create view?
Solution |
||||||||||||
22
Discuss
|
SQL Datatype
In order to ensure that an instructor’s salary domain allows only values greater than a specified value use:
Solution |
||||||||||||
23
Discuss
|
SQL Datatype
Values of one type can be converted to another domain using which of the following?
Solution |
||||||||||||
24
Discuss
|
SQL Datatype
The user-defined data type can be created using
Solution |
||||||||||||
25
Discuss
|
SQL Datatype
Which of the following is used to store movie and image files?
Solution |
||||||||||||
26
Discuss
|
SQL Datatype
Here which one denotes the relation for which index is created?
Solution |
||||||||||||
27
Discuss
|
SQL Datatype
An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
Solution |
||||||||||||
28
Discuss
|
SQL Datatype
Dates must be specified in the format
Solution |
||||||||||||
29
Discuss
|
SQL Datatype
The SQL database language includes statements for:
Solution |
||||||||||||
30
Discuss
|
SQL Datatype
Which SQL Query is used to remove a table and all its data from the database?
Solution |
||||||||||||
31
Discuss
|
SQL Datatype
A type of query that is placed within a WHERE or HAVING clause of another query is called
Solution |
||||||||||||
32
Discuss
|
How To Download And Install MySql Workbench
To relate one table to another, a _____ in one table is used to point to the primary key in another table
Solution |
||||||||||||
33
Discuss
|
How To Download And Install MySql Workbench
What does SQL stand for?
Solution |
||||||||||||
34
Discuss
|
Drop Database
Fact tables are which of the following?
Solution |
||||||||||||
35
Discuss
|
Drop Database
A snowflake schema is which of the following types of tables?
Solution |
||||||||||||
36
Discuss
|
Drop Database
A goal of data mining includes which of the following?
Solution |
||||||||||||
37
Discuss
|
Drop Database
Primitive operations common to all record management systems include
Solution |
||||||||||||
38
Discuss
|
Drop Database
Each of the data files has a ______ that describe the way the data is stored in the file
Solution |
||||||||||||
39
Discuss
|
Drop Database
After you ______ a record, many data management environments require you to issue a command to save the changes you made
Solution |
||||||||||||
40
Discuss
|
Drop Database
Sort/report generators
Solution |
||||||||||||
41
Discuss
|
Drop Database
An-owner-member set in the CODASYL specifications may have
Solution |
||||||||||||
42
Discuss
|
Drop Database
Which of the following hardware components is the most important to the operation of a database management system?
Solution |
||||||||||||
43
Discuss
|
Use / Select Database
A database application can perform which of the following activities?
Solution |
||||||||||||
44
Discuss
|
Use / Select Database
An enterprise database is which of the following?
Solution |
||||||||||||
45
Discuss
|
Use / Select Database
Legacy data is which of the following?
Solution |
||||||||||||
46
Discuss
|
Use / Select Database
Which of the following is true for a relational database?
Solution |
||||||||||||
47
Discuss
|
Use / Select Database
A shared database should
Solution |
||||||||||||
48
Discuss
|
Use / Select Database
A data warehouse uses
Solution |
||||||||||||
49
Discuss
|
Use / Select Database
A database management system (DBMS) is a
Solution |
||||||||||||
50
Discuss
|
Use / Select Database
An enterprise data model is
Solution |
||||||||||||
51
Discuss
|
Use / Select Database
A data warehouse is which of the following?
Solution |
||||||||||||
52
Discuss
|
Use / Select Database
An operational system is which of the following?
Solution |
||||||||||||
53
Discuss
|
Use / Select Database
The generic two-level data warehouse architecture includes which of the following?
Solution |
||||||||||||
54
Discuss
|
Use / Select Database
The active data warehouse architecture includes which of the following?
Solution |
||||||||||||
55
Discuss
|
Use / Select Database
Reconciled data is which of the following?
Solution |
||||||||||||
56
Discuss
|
Use / Select Database
Transient data is which of the following?
Solution |
||||||||||||
57
Discuss
|
Use / Select Database
The extract process is which of the following?
Solution |
||||||||||||
58
Discuss
|
Use / Select Database
Data scrubbing is which of the following?
Solution |
||||||||||||
59
Discuss
|
Use / Select Database
The load and index are which of the following?
Solution |
||||||||||||
60
Discuss
|
Use / Select Database
Data transformation includes which of the following?
Solution |
||||||||||||
61
Discuss
|
Use / Select Database
A multifield transformation does which of the following?
Solution |
||||||||||||
62
Discuss
|
Use / Select Database
A star schema has what type of relationship between a dimension and fact table?
Solution |
||||||||||||
63
Discuss
|
Alter - Rename Table
Which of these queries will display the table given above?
Solution |
||||||||||||
64
Discuss
|
Alter - Rename Table
Here which of the following displays the unique values of the column?
Solution |
||||||||||||
65
Discuss
|
Alter - Rename Table
The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
Solution |
||||||||||||
66
Discuss
|
Alter - Rename Table
This Query can be replaced by which one of the following?
Solution |
||||||||||||
67
Discuss
|
Alter - Rename Table
Which of the following fields are displayed as output?
Solution |
||||||||||||
68
Discuss
|
Alter - Rename Table
This is the Employee table.
Solution |
||||||||||||
69
Discuss
|
Alter - Rename Table
Which of the following statements contains an error?
Solution |
||||||||||||
70
Discuss
|
Alter - Rename Table
In the given query which of the keyword has to be inserted?
Solution |
||||||||||||
71
Discuss
|
Alter - Rename Table
A Delete command operates on ______ relation.
Solution |
||||||||||||
72
Discuss
|
Alter - Rename Table
The above command
Solution |
||||||||||||
73
Discuss
|
Alter - Rename Table
Which one of the following deletes all the entries but keeps the structure of the relation.
Solution |
||||||||||||
74
Discuss
|
Alter - Add Column
Which of the following is used to insert a tuple from another relation?
Solution |
||||||||||||
75
Discuss
|
Alter - Add Column
Which of the following deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation.
Solution |
||||||||||||
76
Discuss
|
Alter - Add Column
Fill in with correct keyword to update the instructor relation.
Solution |
||||||||||||
77
Discuss
|
Alter - Add Column
_________ are useful in SQL update statements, where they can be used in the set clause.
Solution |
||||||||||||
78
Discuss
|
Alter - Add Column
The problem of ordering the update in multiple updates is avoided using
Solution |
||||||||||||
79
Discuss
|
Alter - Add Column
Which of the following is the correct format for case statements.
Solution |
||||||||||||
80
Discuss
|
Alter - Add Column
Which of the following relation updates all instructors with salary over $100,000 receive a 3 percent raise, whereas all others receive a 5 percent raise.
Solution |
||||||||||||
81
Discuss
|
Drop Table
What is not an advantage of stored procedures?
Solution |
||||||||||||
82
Discuss
|
Drop Table
A reason for using an SQL view to hide columns is
Solution |
||||||||||||
83
Discuss
|
Drop Table
Which of the following is an SQL trigger supported by Oracle?
Solution |
||||||||||||
84
Discuss
|
Drop Table
The SQL ALTER statement can be used to
Solution |
||||||||||||
85
Discuss
|
Drop Table
What SQL structure is used to limit column values of a table?
Solution |
||||||||||||
86
Discuss
|
Drop Table
Which is NOT one of the most common types of SQL CHECK constraints?
Solution |
||||||||||||
87
Discuss
|
Drop Table
What is an advantage of placing computations in SQL views
Solution |
||||||||||||
88
Discuss
|
Drop Table
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain
Solution |
||||||||||||
89
Discuss
|
Drop Table
‘AS’ clause is used in SQL for
Solution |
||||||||||||
90
Discuss
|
Drop Table
The language which has recently become the defacto standard for interfacing application programs with relational database system is
Solution |
||||||||||||
91
Discuss
|
Drop Table
A report generator is used to
Solution |
||||||||||||
92
Discuss
|
Drop Table
Count function in SQL returns the number of
Solution |
||||||||||||
93
Discuss
|
Drop Table
The statement in SQL which allows changing the definition of a table is
Solution |
||||||||||||
94
Discuss
|
Drop Table
Which of the following is correct
Solution |
||||||||||||
95
Discuss
|
Drop Table
Which of the following is a valid SQL type?
Solution |
||||||||||||
96
Discuss
|
Drop Table
Which of the following is an advantage of view?
Solution |
||||||||||||
97
Discuss
|
Drop Table
Which of the following is a legal expression in SQL?
Solution |
||||||||||||
98
Discuss
|
Drop Table
Which of the following is a comparison operator in SQL?
Solution |
||||||||||||
99
Discuss
|
Drop Table
Which one of the following is not true for a view
Solution |
||||||||||||
100
Discuss
|
Drop Table
To delete a particular column in a relation the command used is
Solution |
||||||||||||
101
Discuss
|
Insert Record
The granting and revoking of roles by the user may cause some confusion when that user role is revoked. To overcome the above situation
Solution |
||||||||||||
102
Discuss
|
Insert Record
Which join condition contains an equality operator:
Solution |
||||||||||||
103
Discuss
|
Insert Record
A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
Solution |
||||||||||||
104
Discuss
|
Insert Record
The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.
Solution |
||||||||||||
105
Discuss
|
Insert Record
What are the after triggers?
Solution |
||||||||||||
106
Discuss
|
Insert Record
The variables in the triggers are declared using
Solution |
||||||||||||
107
Discuss
|
Select Record
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
||||||||||||
108
Discuss
|
Select Record
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
||||||||||||
109
Discuss
|
Select Record
A relational database consists of a collection of
Solution |
||||||||||||
110
Discuss
|
Select Record
A ________ in a table represents a relationship among a set of values.
Solution |
||||||||||||
111
Discuss
|
Select Record
The term _______ is used to refer to a row.
Solution |
||||||||||||
112
Discuss
|
Select Record
The term attribute refers to a ___________ of a table.
Solution |
||||||||||||
113
Discuss
|
Select Record
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
||||||||||||
114
Discuss
|
Select Record
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
Solution |
||||||||||||
115
Discuss
|
Select Record
Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
Solution |
||||||||||||
116
Discuss
|
Select Record
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Solution |
||||||||||||
117
Discuss
|
Select Record
A domain is atomic if elements of the domain are considered to be ____________ units.
Solution |
||||||||||||
118
Discuss
|
Select Record
The tuples of the relations can be of ________ order.
Solution |
||||||||||||
119
Discuss
|
Select Record
The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
Solution |
||||||||||||
120
Discuss
|
Select Record
A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
Solution |
||||||||||||
121
Discuss
|
Select Record
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
||||||||||||
122
Discuss
|
Select Record
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Solution |
||||||||||||
123
Discuss
|
Select Record
The _______operation performs a set union of two “similarly structured” tables
Solution |
||||||||||||
124
Discuss
|
Select Record
The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Solution |
||||||||||||
125
Discuss
|
Select Record
The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Solution |
||||||||||||
126
Discuss
|
Select Record
Which one of the following is procedural language?
Solution |
||||||||||||
127
Discuss
|
Select Record
Student(ID, name, dept name, tot_cred)
Solution |
||||||||||||
128
Discuss
|
Select Record
Using which language can a user request information from a database?
Solution |
||||||||||||
129
Discuss
|
Select Record
Which keyword must be used here to rename the field name?
Solution |
||||||||||||
130
Discuss
|
Select Record
In the SQL given above there is an error . Identify the error.
Solution |
||||||||||||
131
Discuss
|
Select Record
Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?
Solution |
||||||||||||
132
Discuss
|
Select Record
’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters.
Solution |
||||||||||||
133
Discuss
|
Select Record
By default, the order by clause lists items in ______ order.
Solution |
||||||||||||
134
Discuss
|
Select Record
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Solution |
||||||||||||
135
Discuss
|
Select Record
This query can be replaced by which of the following ?
Solution |
||||||||||||
136
Discuss
|
Select Record
This query does which of the following operation?
Solution |
||||||||||||
137
Discuss
|
Select Record
In SQL the spaces at the end of the string are removed by _______ function.
Solution |
||||||||||||
138
Discuss
|
Select Record
_____ operator is used for appending two strings.
Solution |
||||||||||||
139
Discuss
|
Select - Count
Which SQL function is used to count the total number of rows in a SQL query?
SolutionCOUNT(*) is used to count the total no. of row including null. |
||||||||||||
140
Discuss
|
Select - Average
Aggregate functions are functions that take a ___________ as input and return a single value.
Solution |
||||||||||||
141
Discuss
|
Select - Average
Which of the following should be used to find the mean of the salary ?
Solution |
||||||||||||
142
Discuss
|
Select - Average
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
Solution |
||||||||||||
143
Discuss
|
Select - Average
All aggregate functions except _____ ignore null values in their input collection.
Solution |
||||||||||||
144
Discuss
|
Select - Average
A Boolean data type that can take values true, false, and________
Solution |
||||||||||||
145
Discuss
|
Select - Average
The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.
Solution |
||||||||||||
146
Discuss
|
Select - Average
Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester.
Solution |
||||||||||||
147
Discuss
|
Select - Average
The phrase “greater than at least one” is represented in SQL by _____
Solution |
||||||||||||
148
Discuss
|
Select - Average
Which of the following is used to find all courses taught in both the Fall 2009 semester and in the Spring 2010 semester .
Solution |
||||||||||||
149
Discuss
|
Select - Average
We can test for the nonexistence of tuples in a subquery by using the _____ construct.
Solution |
||||||||||||
150
Discuss
|
And Operator
The union operation is represented by
Solution |
||||||||||||
151
Discuss
|
And Operator
The intersection operator is used to get the _____ tuples.
Solution |
||||||||||||
152
Discuss
|
And Operator
The union operation automatically __________ unlike the select clause.
Solution |
||||||||||||
153
Discuss
|
And Operator
If we want to retain all duplicates, we must write ________ in place of union.
Solution |
||||||||||||
154
Discuss
|
And Operator
This query display
Solution |
||||||||||||
155
Discuss
|
And Operator
For like predicate which of the following is true.
Solution |
||||||||||||
156
Discuss
|
And Operator
The number of attributes in relation is called as its
Solution |
||||||||||||
157
Discuss
|
And Operator
_____ clause is an additional filter that is applied to the result.
Solution |