Posted in RDBMS

Đề thi lý thuyết 1 môn RDBMS

1-
Which of the following statements with reference to Partitioned View is/are NOT TRUE?
[A]
A partitioned view can refer to a particular member table only once in its definition.
———-
[B]
A partitioned view can have only member tables whose indexes are created on computed columns.
———-
[C]
Member tables must have all Primary Key constraints on an identical number of columns
———-


2
A Trigger cannot be fired with the ____ SQL command.
[A]
delete
———-
[B]
drop
———-
[C]
update
———-
[D]
insert
———-
3
While using the CONVERT function, values that are too long for their data type are truncated.
[A]
True
———-
[B]
False
———-
4
Unions combine columns from multiple data tables.
[A]
True
———-
[B]
False
———-
5
Entity integrity is enforced by unique indexes because a unique value exists in each column
[A]
True
———-
[B]
False
———-
6
The TYPE_WARNING attribute specifies a warning message to be sent to the client, if the cursor is implicitly converted from the requested type to another type.
[A]
True
———-
[B]
False
———-
7
The process of refining a database design to ensure data consistency and reduce duplication is known as ___________.
[A]
Normalization
———-
[B]
Data Modeling
———-
[C]
Data Optimizing
———-
8
_____ command is used in Database management system to fetch the common records from two tables.
[A]
Difference
———-
[B]
Intersect
———-
[C]
Union
———-
[D]
Join
———-
9
A stored procedure is a group of T-SQL statements compiled into a single execution plan. (T-F)
10
Both clustered and non-clustered indexes can be unique. (T-F)
11
Is it possible to decrypt the encrypted triggers? (Y-N)
12
Which of these statements are correct with respect to UNION? (Choose all that apply)
[A]
UNION columns of each table in the select statement should have the same data type
———-
[B]
All the select statements should have the same number of rows.
———-
[C]
Column name of each Select statement can be different
———-
[D]
UNIONS can be used to limit the number of rows displayed
———-
13
The global variable @error stores the error number in SQL Server.(T-F)
14
When any transaction in the chain of implicit transactions fails, the entire chain is aborted.(T-F)
15
The ___________ functions are used to return the SQL Server settings
[A]
System
———-
[B]
Server
———-
[C]
User-defined
———-
[D]
SQLServer
———-
16
The _____________ global variable returns the number of qualifying rows that are present in the currently open cursor.
[A]
@@FETCH_STATUS
———-
[B]
@@CURSOR_STATUS
———-
[C]
@@FETCH_ROWS
———-
[D]
@@CURSOR_ROWS
———-
17
Emp_code in an employee table is _______ in an ER diagram.
[A]
an entityset
———-
[B]
an entity
———-
[C]
an attribute
———-
[D]
an attributeset
———-
18
Only the owner of the table can create indexes on the table.(T-F)
19
You have to define a database to control projects and reports at your college. Each student works with a project team which produces a project report. Identify the relationship between the Student and the Project?
[A]
One-to-One
———-
[B]
Many-to-Many
———-
[C]
One-to-Many
———-
[D]
Many-to-One
———-
20
The “Full-Text Search” feature of SQL Server helps you search for ________ data.
[A]
numeric
———-
[B]
character
———-
[C]
alphanumeric
———-

21
Which of the following statements with reference to Triggers is/are TRUE? (Choose all that apply)
[A]
A trigger applies to a single table
———-
[B]
You cannot decrypt an encrypted trigger
———-
[C]
A trigger can apply to many tables
———-
[D]
You can only create a trigger in the current database
———-
22
Which of the following is executed automatically?
[A]
Function
———-
[B]
Anonymous PL/SQL block
———-
[C]
Procedure
———-
[D]
Trigger
———-
23
The ___________ statement is used to exit from a WHILE block.
[A]
Break
———-
[B]
End
———-
[C]
Exit
———-
[D]
Terminate
———-
24
Identify the correct SQL statement to delete the View “Airlines”
[A]
DROP VIEW Airlines
———-
[B]
DELETE VIEW Airlines
———-
[C]
REMOVE VIEW Airlines
———-

25
In a __________ index, the logical order of the index does not match the physical, stored order of the rows on disk.
[A]
Clustered
———-
[B]
Non-clustered
———-
26
Which of the following statements with respect to Clustered indexes is/are TRUE?
[A]
A clustered index determines the storage order of data in a table.
———-
[B]
A clustered-index only specifies a logical ordering
———-
27
Identify the SELECT statement which returns all the ‘Names’ in the Accounts table containing the alphabet ‘e’, but not as the first letter.
[A]
SELECT Name FROM Accounts WHERE Name LIKE ‘%e’
———-
[B]
SELECT * FROM Accounts WHERE Names LIKE ‘e’
———-
[C]
SELECT * FROM Accounts WHERE Name LIKE ‘&e’
———-
[D]
SELECT * FROM Accounts WHERE Name LIKE ‘%e%’
———-
[E]
SELECT Name FROM Accounts WHERE Name LIKE ‘[^e]%e%’
———-
28
Which type of lock ensures that multiple updates cannot be made to the same resource simultaneously?
[A]
Optimistic Lock
———-
[B]
Exclusive Locks
———-
[C]
Update Locks
———-
29
You need to enable nested triggers to execute the cascade update and delete functions.
30
Identify the correct statement/s.

Statement 1: While building indexes on views, the view can only be based on tables, and cannot reference any views.

Statement 2: The objects referenced in the view must be in the same database as the view.
[A]
Both the Statements are true
———-
[B]
Statement 1 is true
———-
[C]
Statement 2 is true
———-
[D]
Both the Statements are false
———-
31
_________ combine rows from multiple data tables.
[A]
Unions
———-
[B]
Subqueries
———-
32
Following are the types of transactions in SQL Server 2000. (Choose all that apply)
[A]
Implicit transaction
———-
[B]
Explicit transaction
———-
[C]
Autocommit transaction
———-
[D]
Rollback transaction
———-
33
Which of the following is present in the oval symbol in an ERD?
[A]
Entity
———-
[B]
Process
———-
[C]
Attribute
———-
[D]
Data store
———-
34
In a Library Management system, there is a Librarian and many students. In an ERD, what type of relationship would you depict between them?
35
What is an index created on two or more columns called?[A]
composite
———-
[B]
non clustered
———-
[C]
clustered
———-
[D]
mixed
———-
36
The nested subquery needs to be re-evaluated for every iteration of the parent query.(T-F)
37
We can use a subquery as a replacement for a value in the SELECT clause, as a part of WHERE clause. (T-F)
38
Once the table definition has been approved by the end user , the database designer can draw the ERD for the tables (T-F)
39
SQL Server automatically starts explicit transactions.(T-F)
40
Many subqueries can be re-written with _________.
[A]
Unions
———-
[B]
Joins
———-
41
When you attach an INSTEAD OF trigger to a table, it overrides the default action of the triggering statement.(T-F)
42
_________ procedures allow you to dynamically restore and execute a function within a DLL.
[A]
System
———-
[B]
Cursor
———-
[C]
Security
———-
[D]
Extended
———-
43
Partitioned tables are preferable over partition views in most operational environments.
[A]
False
———-
[B]
True
———-
[C]
TRUE: Only when the base tables are empty
———-

44
What do you understand by database design?
[A]
The formal process of analyzing facts about the real world into a structured database model.
———-
[B]
A design sub activity involving the design of the conceptual, logical, and physical structure of one or more databases.

———-
[C]
The process of planning and structuring data objects along with the relationships among them (if any) within a database
———-
[D]
All of the others
———-
45
In SQL Server 2000, you can embed a stored procedure in the template and execute it without displaying its name in the URL.(T F)
46
Statement 1: Indexed view is supported by SQL Server Enterprise Edition.
Statement 2: Indexed views improve the performance of complex queries.
[A]
Both the statements are true
———-
[B]
Only Statement 1 is true
———-
[C]
Only Statement 2 is true
———-
[D]
Both the statements are false
———-
47
You can use the __________ statement to modify a view.
[A]
MODIFY
———-
[B]
ALTER
———-
[C]
CHANGE
———-
48
By default, only the owner of the database has the permission to create a trigger. This permission is transferable.
[A]
True
———-
[B]
False
———-
49
Which one of the followings system stored procedure will you use to display a list of triggers in the current database?
[A]
sp_helptrigger
———-
[B]
sp_help
———-
[C]
sp_configure
———-
50
______________ is the process of removing the redundancies form the incoming data.
[A]
Normalization
———-
[B]
Referential Integrity
———-
[C]
Creating Constraints
———-
51
Views help to filter data as well as restrict data access.(T_F)
52
State the output of FLOOR(66.5)
[A]
1
———-
[B]
66
———-
[C]
67
———-
[D]
-1
———-
53
Which of the following describes a SQL Server batch? (Choose all that apply)
[A]
Compiled into a single unit.
———-
[B]
Executed in a single transaction.
———-
[C]
Executed as individual statements.
———-
[D]
Compiled as individual statements.
———-
[E]
Executed as a single unit.
———-
[F]
A group of SQL statements.
———-
54
State the output of POWER(6, 2)
[A]
36
———-
[B]
3
———-
[C]
12
———-
[D]
4
———-
55
Once the transaction is committed, it cannot be rolled back.(T-F)
56
The SELECT statement can be used to populate the result of a query into another table.(T -F)
57
One of the drawbacks of Normalization is that the CPU time required to resolve complex join queries is very high.(T -F)
58
Views are dropped when corresponding table/s is/are dropped.(T -F)
59
An ___________ transaction defines the start as well as the end of a transaction.
[A]
Explicit
———-
[B]
Implicit
———-
[C]
Autocommit
———-
60
The TEXTPTR() function returns the result in the ________ format.
[A]
varbinary
———-
[B]
binary
———-
[C]
image
———-
61
In stored procedures, the default return code value is ________, which indicates successful execution of the stored procedure
[A]
Yes
———-
[B]
True
———-
[C]
1
———-
[D]
0
———-
62
There is a table Student, which has a field studentname containing names of students. Identify the wildcard used to retrieve names of students, which don’t start within the range of e-g.
[A]
[e-g]%
———-
[B]
[^e-g]%
———-
[C]
[e^g]%
———-
[D]
[efg]%
———-
[E]
[^efg]%
———-
63
What is the return type of the query given below?
SELECT SIGN(0)
[A]
1
———-
[B]
0
———-
[C]
-1
———-
64
The _______ function in SQL Server returns the current date.
[A]
now()
———-
[B]
getdate()
———-
[C]
date()
———-
[D]
currentdate()
———-
65
The __________ option prevents the user from viewing the text of the trigger.
[A]
WITH ENCRYPTION
———-
[B]
WITH CIPHERTEXT
———-
[C]
WITH SECURITY
———-
[D]
WITH UNICODE
———-
66
Only the System Administrator can enable or disable nested triggers. (T-F)
67
Which property ensures that all the transactions have been completed successfully?
[A]
Consistent
———-
[B]
Atomicity
———-
[C]
Isolated
———-
[D]
Durable
———-
68
Primary Key constraint creates clustered indexes automatically, if a clustered index does not exist on the table(T-F)
69
In the syntax given below,
SET DEADLOCK_PRIORITY { LOW | NORMAL | @deadlock_var }
@deadlock_var is a character variable which specifies :
[A]
The deadlock-handling method
———-
[B]
The session is returned to the default deadlock-handling method
———-
[C]
A deadlock situation
———-
[D]
None of the above
———-
70
What is the return type of a stored procedure in SQL Server 2000?
[A]
Character
———-
[B]
Integer
———-
[C]
Boolean
———-
71
You can use the __________ system stored procedure to enable or disable the nesting of triggers.
[A]
sp_configure
———-
[B]
sp_trigger
———-
[C]
sp_start_job
———-
[D]
sp_help
———-
72
State the result of the following FETCH statement, if the cursor is just opened.

FETCH ABSOLUTE -3 From Airlinescursor.
[A]
It will fetch the 3rd row in the cursor.
———-
[B]
It will fetch the 3rd row from the previously fetched row
———-
[C]
It will fetch the 3rd row before the last row in the cursor.
———-
[D]
It will fetch the 3rd row before the previously fetched row
———-
73
In an ERD, ________ is a person, place, thing, object, event or even a concept that can be distinctly identified.
[A]
Attribute
———-
[B]
Entity
———-
[C]
Relationship
———-

Tác giả:

Thích thì chiều sao phải xoắn :))

Gửi phản hồi

Mời bạn điền thông tin vào ô dưới đây hoặc kích vào một biểu tượng để đăng nhập:

WordPress.com Logo

Bạn đang bình luận bằng tài khoản WordPress.com Log Out / Thay đổi )

Twitter picture

Bạn đang bình luận bằng tài khoản Twitter Log Out / Thay đổi )

Facebook photo

Bạn đang bình luận bằng tài khoản Facebook Log Out / Thay đổi )

Google+ photo

Bạn đang bình luận bằng tài khoản Google+ Log Out / Thay đổi )

Connecting to %s