.


:




:

































 

 

 

 





SELECT , COUNT (*) FROM GROUP BY ?

a) ;

b) ;

c) ;

d) ;

e) , .

 

71. SQL T1 CHAR(10) C5?

a) ADD COLUMN C5 CHAR(10) TO T1;

b) ALTER TABLE T1 ADD C5 CHAR(10);

c) CHANGE TABLE T1 ADD C5 TYPE CHAR(10);

d) APPEND T1 C5 CHAR(10);

e) ADD TABLE T1 COLUMN C5 TYPE CHAR(10);

 

72. ?

a) UPDATE, INSERT, DELETE, SELECT, REFERENCES;

b) CONNECT, RESOURCE, DBA;

c) GRANT, REVOKE, IDENTIFIED BY;

d) ADD, MODIFY, DROP;

 

73. , ?

a) UPDATE, INSERT, DELETE, SELECT, REFERENCES;

b) CONNECT, RESOURCE, DBA;

c) GRANT, REVOKE, IDENTIFIED BY;

d) ADD, MODIFY, DROP;

 

74. Adrian ?

a) Drop table tblCustomers;

b) Delete from tblCustomers where (User=Adrian);

c) Revoke insert, delete on tblCustomers from Adrian;

d) Insert into tblCustomers select * from DelTbl;

 

75. , ?

a) ;

b) ;

c) ;

d) ;

e) .

 

76. , , , ?

a) ;

b) ;

c) ;

d) .

 

77. ?

a) ;

b) ;

c) , ;

d) ;

 

78. Master- ?

a) ;

b) ;

c) ;

d) .

 

79. ( )?

a) Two-Phase Commit (2PC);

b) IP FTP;

c) (RPC-Remote Procedure Call);

d) WAL Write Ahead Log;

e) ROWA Read-Once/ Write-All.

 

80. ?

a) ;

b) ;

c) (primary site);

d) (merge replication).

 

81. ?

a) , ;

b) , ;

c) ;

d) .

 

82. SQL , ?

a) SERIALIZABLE ( );

b) REPEATABLE READ ( );

c) READ COMMITED ( );

d) READ UNCOMMITED ( ).

 

83. SQL , ?

a) SERIALIZABLE ( );

b) REPEATABLE READ ( );

c) READ COMMITED ( );

d) READ UNCOMMITED ( ).

 

84. , , , ?

a) ;

b) ;

c) ;

d) .

 

85. ACID, , , , , ?

a) ;

b) ;

c) ;

d) .

 

86. ACID, ?

a) ;

b) ;

c) ;

d) .

 

87. ACID, , ?

a) ;

b) ;

c) ;

d) .

 

88. ACID, , , ?

a) ;

b) ;

c) ;

d) .

 

89. , , , ?

a) ;

b) ;

c) ;

d) .

 

90. , , .?

a) ;

b) (middleware);

c) ;

 

91. ID ?

a) CREATE TABLE New_User (ID sql_integer Not Null, Passw sql_char Not Null);

b) GRANT CONNECT TO New_User IDENTIFIED BY Passw;

c) SELECT ID, Passw INTO New_User FROM Old_User;

d) REVOKE SELECT ON New_User FROM Old_User.

 

92. WITH GRANT OPTION GRANT ?

a) ;

b) ;

c) ;

d) .

 

93. , - ?

a) ;

b) ;

c) ;

d) .

 

94. , , , , ( - ) - ?

a) ;

b) ;

c) ;

d) , .

 

95. ( )?

a) ;

b) ;

c) ;

d)

 

96. , , - ?

a) ;

b) Two-Phase Commit (2PC);

c) (RPC-Remote Procedure Call);

d) WAL Write Ahead Log;

e) ROWA Read-Once/ Write-All.

 

97. ?

a) ;

b) ;

c) ( );

d) ;

 

98. , , , ?

a) ;

b) ;

c) ;

d) .

 

99. , , ?

a) ;

b) ;

c) ;

d) .

 

100. , , , , ?

a) ;

b) ;

c) ;

d) .





:


: 2015-11-05; !; : 489 |


:

:

.
==> ...

772 - | 736 -


© 2015-2024 lektsii.org - -

: 0.027 .