Suljettu

Database tutor

Need a database tutor for my daughter. Teacher need to help on quiz preparation. I will need tutor for 1 month. Here I have attached some sample quiz ques. Give me the answer, if you able to do 100% will easy for me to select you.

Which of the following commands list existing databases in Oracle?

a. LIST DATABASES

b. SHOW DATABASES

c. DISPLAY DATABASES

d. All of the above

e. None of the above

Which command is used to list all columns in MS SQL Server?

a. DESCRIBE

b. SELECT

c. SHOW

d. LIST

e. All of the above

Which of the following does NOT NULL indicate?

a. Column must have a value including zero.

b. Column must have a value including void value.

c. Column must have a value including blank.

d. Column must not be void.

Which of the following is not a valid SQL command?

a. UPDATE

b. SHOW

c. SELECT

d. INSERT

e. All of the above

f. None of the above

Which of the following SQL statement is valid?

a. INSERT INTO SALES_REP VALUES ('25', 'Donna', 'Sanchez');

b. DELETE SALES_REP;

c. DROP TABLE SALES_REP;

d. UPDATE SALES_REP LAST_NAME = 'Austin';

e. All of the above.

f. None of the above.

Which of the following SQL statements is valid for MySQL, Oracle, and MS SQL Server?

a. CREATE TABLE sales_rep (id NUMBER(2), name CHAR (30));

b. CREATE TABLE sales_rep (id CHAR(2), name VARCHAR(30));

c. CREATE TABLE sales_rep (id NUMBER, name VARCHAR2(30));

d. CREATE TABLE sales_rep (id CHAR(2), name CHAR(30));

e. All of the above.

f. None of the above.

Which of the following commands list columns of a table in MS SQL?

a. DESCRIBE

b. DESC

c. EXEC SP_TABLE

d. EXEC SP_COLUMNS

e. All of the above.

f. None of the above.

Taidot: SQL, Oracle, Microsoft SQL Server, Tietokannan hallinto, Tietokantaohjelmointi

Näytä lisää: need database built, need database constructed, database system need trigger, database appears need patching higher level, need database business, skill need database entry, need database project urgently, need database, zencart database appears need patching higher level, cms need database, need database project, need database created company, need database developed, need database iphone, need database cleaning company, pagerank script need database, need database projects

Tietoa työnantajasta:
( 0 arvostelua ) Pleasanton, United States

Projektin tunnus: #31518748

16 freelanceria on tarjonnut keskimäärin $38 tähän työhön

(18 arvostelua)
4.0
aminechafai14072

Here are the answer of your quiz: 1-B ; 2-B ; 3-D ; 4-F ; 5-(A, B and C) ; 6-(B and D) ; 7-D I am myself an experienced professional and trainer. Please reach me over chat to discuss the details and the expectations of Lisää

$50 USD 1 päivässä
(6 arvostelua)
3.8
arunkumarragee

♦ PL/SQL Expert ♦ Database Expert ♦ Immediate Start ♦ I’m a software Engineer with 8+ years experience in DB development. I’m expertise in multiple databases Oracle, MSSQL, PostgreSQL and MYSQL. I would be right person Lisää

$25 USD 1 päivässä
(1 arvostelu)
3.3
(4 arvostelua)
2.4
arunvadakkedath1

Hi, I am full stack developer having 5+yrs experience. I have extensive experience in SQL. I can write complex queries. Ping me to start discussion more detail and start work on it asap. Thanks

$20 USD 7 päivässä
(2 arvostelua)
2.5
Sarikahk

Hi, I have 9 plus years of experience in datawarehousing domain across projects from healthcare and banking domain. Have 9 plus years experience in Informatica tool , and worked on multiple databases like oracle, nete Lisää

$30 USD 7 päivässä
(3 arvostelua)
2.4
Parveenlamba77

Hi There, I am an database development expert I can help you in all above database related questions. I am an IT professional with over 10 years of experience in database design and development. Feel free to contact me Lisää

$25 USD 1 päivässä
(1 arvostelu)
2.0
databasedba

Dear Hiring Manager, I am an Oracle Certified Database Professional (OCP). I have complete masters in computer science. I am a database professional with 15 years’ experience. My background includes Sql, MySQL,PostgrS Lisää

$50 USD 3 päivässä
(4 arvostelua)
2.2
MashoodurRehman1

Database developer I have read your job description and I am pretty sure that I can complete every bit of your requirements. Further details and cost can be discussed in chat

$20 USD 1 päivässä
(0 arvostelua)
0.0
abdullah13af

Hi, I am an expert Online Programming tutor. I've been teaching since 2 years. I teach programming languages, web designing and database management. I would like to be your daughter's tutor and will teach him everythin Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
IzzahSalam11

1) e. None of the above 2) b. SELECT 3) d. Column must not be void. 4) b. SHOW 5) e. All of the above. 6) f. None of the above. 7) f. None of the above. Hi, this is me Izzah, i have mphil degree in Computer science an Lisää

$40 USD 7 päivässä
(0 arvostelua)
0.0
khizaramjad815

Hello. I have my major expertise in SQL, C++, Java & Python. I have already helped many students. You can check my reviews. I have done many projects and have experience of 4+ years. Just check me out. I will complete Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0
mshoaibconsultan

Hi, hope you will fine. thanks for posting project. I have saw your project. I have extensive experienced to programming on Oracle Database SQL, PLSQL, Forms & Reports, Oracle Apex, MySQL, SQL Server. I will work on yo Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
Nafees555

Hi there! Hope you are doing great. I can help you in database concepts and queries. We can do zoom meetings. These questions are very easy. I am an experienced software developer and researcher. I have Bachler in soft Lisää

$10 USD 5 päivässä
(1 arvostelu)
0.0
codesolutionfru

I am working as a Software developer with 4+ experience in a reputed company , i have a good knowledge in MSSQL server . i am not aware of the Oracle . [login to view URL] command is used to list all columns in MS SQL Server? => Lisää

$25 USD 7 päivässä
(0 arvostelua)
0.0
swapnil1028001

Certified Oracle database administrator with 8 plus experience on multiple database including Oracle. I can handle this project with quite ease.

$35 USD 7 päivässä
(0 arvostelua)
0.0