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) .