NEW
Font size
S
M
L
XL
WorksheetsSQL - preverjanje znanja - 2. pisna naloga - NUB - 4. letnik
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Kateri SQL stavek ustvari uporabnika dijak z geslom n00b?
a)
CREATE USER dijak
IDENTIFIED BY 'n00b';
IDENTIFIED BY 'n00b';
b)
CREATE USER dijak
IDENTIFIED BY PASSWORD 'n00b';
IDENTIFIED BY PASSWORD 'n00b';
c)
CREATE USER n00b
IDENTIFIED BY 'dijak';
IDENTIFIED BY 'dijak';
d)
CREATE USER n00b
IDENTIFIED BY PASSWORD 'dijak';
IDENTIFIED BY PASSWORD 'dijak';
2.
Kateri ukaz dodeli pravice izbranim uporabnikom?
a)
REVOKE
b)
GRANT
c)
CREATE USER
d)
ALL PRIVILEGES
3.
S katerim ukazom spremenimo geslo uporabniku?
a)
CHANGE PASSWORD
b)
PASSWORD
c)
SET PASSWORD
d)
RENAME PASSWORD
4.
S katerim ukazom preimenujemo uporabnika?
a)
CHANGE USER
b)
CREATE USER
c)
SET USER
d)
RENAME USER
5.
Kateri stavek javi napako?
a)
CREATE USER n00b IDENTIFIED BY 'dijak';
b)
REVOKE ALL PRIVILEGES ON test.* FROM vohun@localhost;
c)
REVOKE INSERT,UPDATE,DELETE ON test.* TO vohun@localhost;
d)
SELECT PASSWORD('trgovec');
6.
Katera pravica je pravilna? (ostale javijo napako)
a)
CREATE ROUTINE
b)
DELETE ROW
c)
EXECUTE ROUTINE
d)
CREATE FUNCTION
7.
S katerim ukazom vklopimo samodejno potrjevanje transakcij?
a)
SET autocommit=0;
b)
SET autocommit=1;
c)
SELECT @@autocommit;
d)
SELECT autocommit=1;
8.
Kateri izmed ukazov samodejno potrdi transakcijo?
a)
SAVEPOINT
b)
DELETE
c)
DROP TABLE
d)
ROLLBACK
9.
Katero stikalo za programa mysql in mysqldump ustreza opisu v oklepaju?
a)
-p (vrata oz. port)
b)
-h (naslov strežnika)
c)
-U (uporabniško ime)
d)
-P (geslo)
10.
Kateri ukaz arhivira podatkovni zbirki podjetje in nabava v datoteko baze.sql
a)
mysqldump -u root podjetje nabava > baze.sql
b)
mysqldump -u root --databases podjetje nabava < baze.sql
c)
mysql -u root --databases podjetje nabava > baze.sql
d)
mysqldump -u root --databases podjetje nabava > baze.sql
Reset
